BEGIN
      -- Find Date Track Mode
      -- --------------------------------
        dt_api.find_dt_upd_modes
        (     p_effective_date                  => TO_DATE('12-JUN-2011'),
              p_base_table_name            => 'PER_ALL_ASSIGNMENTS_F',
              p_base_key_column          => 'ASSIGNMENT_ID',
              p_base_key_value              => ln_assignment_id,
              -- Output data elements
              -- --------------------------------
             p_correction                           => lb_correction,
             p_update                                => lb_update,
             p_update_override              => lb_update_override,
             p_update_change_insert   => lb_update_change_insert
       );

 
   IF ( lb_update_override = TRUE OR lb_update_change_insert = TRUE )
   THEN
      -- UPDATE_OVERRIDE
      -- ---------------------------------
      lc_dt_ud_mode := 'UPDATE_OVERRIDE';
   END IF;

   IF ( lb_correction = TRUE )
   THEN
      -- CORRECTION
      -- ----------------------
      lc_dt_ud_mode := 'CORRECTION';
   END IF;

   IF ( lb_update = TRUE )
   THEN
      -- UPDATE
      -- --------------
      lc_dt_ud_mode := 'UPDATE';
   END IF;
 
   -- Create Employee State Tax Rule
   -- -----------------------------------------------
    pay_state_tax_rule_api.create_state_tax_rule
    (    -- Input Parameters
         -- --------------------------
         p_effective_date                         => TO_DATE('15-JUN-2011'),
         p_default_flag                            => 'Y',
         p_assignment_id                      => 33561,
         p_state_code                               => '05',
         -- Output Parameters
         -- ----------------------------
        p_emp_state_tax_rule_id        => ln_emp_state_tax_rule_id,
        p_object_version_number       => ln_object_version_number,
        p_effective_start_date               => ld_effective_start_date,
        p_effective_end_date                => ld_effective_end_date
  );
 
 COMMIT;

EXCEPTION
          WHEN OTHERS THEN
                       ROLLBACK;
                        dbms_output.put_line(SQLERRM);
END;
/

SHOW ERR;