4: g_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
5: g_action_effective_date DATE;
6: g_action_type VARCHAR2(50);
7: g_asgrun_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
8: g_ext_dtl_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
9: g_person_id per_all_assignments_f.person_id%TYPE;
10: g_retro_ptp_count NUMBER := 0;
11: g_debug BOOLEAN := FALSE;
12: g_legislation_code per_business_groups.legislation_code%TYPE;
109: TYPE t_retro_hires IS TABLE OF retro_hires INDEX BY BINARY_INTEGER;
110: g_retro_hires t_retro_hires;
111:
112: --Extract Records
113: TYPE ben_ext_rcds IS RECORD
114: (record_number Varchar2(3)
115: ,record_seqnum ben_ext_rcd_in_file.seq_num%TYPE
116: ,hide_flag ben_ext_rcd_in_file.hide_flag%TYPE
117: ,ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE
111:
112: --Extract Records
113: TYPE ben_ext_rcds IS RECORD
114: (record_number Varchar2(3)
115: ,record_seqnum ben_ext_rcd_in_file.seq_num%TYPE
116: ,hide_flag ben_ext_rcd_in_file.hide_flag%TYPE
117: ,ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE
118: ,rcd_type_cd ben_ext_rcd.rcd_type_cd%TYPE
119: );
112: --Extract Records
113: TYPE ben_ext_rcds IS RECORD
114: (record_number Varchar2(3)
115: ,record_seqnum ben_ext_rcd_in_file.seq_num%TYPE
116: ,hide_flag ben_ext_rcd_in_file.hide_flag%TYPE
117: ,ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE
118: ,rcd_type_cd ben_ext_rcd.rcd_type_cd%TYPE
119: );
120: TYPE t_g_ext_rcds IS TABLE OF ben_ext_rcds INDEX BY Binary_Integer;
113: TYPE ben_ext_rcds IS RECORD
114: (record_number Varchar2(3)
115: ,record_seqnum ben_ext_rcd_in_file.seq_num%TYPE
116: ,hide_flag ben_ext_rcd_in_file.hide_flag%TYPE
117: ,ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE
118: ,rcd_type_cd ben_ext_rcd.rcd_type_cd%TYPE
119: );
120: TYPE t_g_ext_rcds IS TABLE OF ben_ext_rcds INDEX BY Binary_Integer;
121: g_ext_rcds t_g_ext_rcds;
114: (record_number Varchar2(3)
115: ,record_seqnum ben_ext_rcd_in_file.seq_num%TYPE
116: ,hide_flag ben_ext_rcd_in_file.hide_flag%TYPE
117: ,ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE
118: ,rcd_type_cd ben_ext_rcd.rcd_type_cd%TYPE
119: );
120: TYPE t_g_ext_rcds IS TABLE OF ben_ext_rcds INDEX BY Binary_Integer;
121: g_ext_rcds t_g_ext_rcds;
122:
116: ,hide_flag ben_ext_rcd_in_file.hide_flag%TYPE
117: ,ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE
118: ,rcd_type_cd ben_ext_rcd.rcd_type_cd%TYPE
119: );
120: TYPE t_g_ext_rcds IS TABLE OF ben_ext_rcds INDEX BY Binary_Integer;
121: g_ext_rcds t_g_ext_rcds;
122:
123: --Balance Details
124: TYPE balance_details IS RECORD
130: g_balance_detls t_balance_details;
131:
132: --Record ID s with Seq numbers
133: TYPE rcd_dtls IS RECORD
134: ( ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE
135: );
136: TYPE t_rcd_dtls IS TABLE OF rcd_dtls INDEX BY Binary_Integer;
137: g_rcd_dtls t_rcd_dtls;
138: g_retro_rcd t_rcd_dtls;