177: lv_report_category :=p_format;
178: lv_year:=to_char(ld_Quater_start_date,'YYYY');
179: lv_reporting_quarter:=to_char(ld_Quater_end_date,'MMYYYY');
180:
181: SELECT pay_payroll_actions_s.nextval
182: INTO ln_locking_action_id
183: FROM dual;
184:
185: /*g_payroll_action_id:=ln_locking_action_id;*/
720: lv_report_category :=p_format;
721: lv_year:=to_char(ld_Month_start_date,'YYYY');
722: lv_reporting_month:=to_char(ld_Month_end_date,'MMYYYY');
723:
724: SELECT pay_payroll_actions_s.nextval
725: INTO ln_locking_action_id
726: FROM dual;
727:
728: /*g_payroll_action_id:=ln_locking_action_id;*/