39: TYPE t_extract_params IS TABLE OF extract_params INDEX BY Binary_Integer;
40: g_extract_params t_extract_params;
41:
42: TYPE ele_details IS RECORD
43: (input_name pay_input_values_f.NAME%TYPE
44: ,Pay_Value_Id pay_input_values_f.input_value_id%TYPE
45: ,input_value_id pay_input_values_f.input_value_id%TYPE
46: ,information_category pay_element_types_f.element_information_category%TYPE
47: ,pretax_category pay_element_types_f.element_information1%TYPE
40: g_extract_params t_extract_params;
41:
42: TYPE ele_details IS RECORD
43: (input_name pay_input_values_f.NAME%TYPE
44: ,Pay_Value_Id pay_input_values_f.input_value_id%TYPE
45: ,input_value_id pay_input_values_f.input_value_id%TYPE
46: ,information_category pay_element_types_f.element_information_category%TYPE
47: ,pretax_category pay_element_types_f.element_information1%TYPE
48: ,primary_balance_id pay_balance_types.balance_type_id%TYPE
41:
42: TYPE ele_details IS RECORD
43: (input_name pay_input_values_f.NAME%TYPE
44: ,Pay_Value_Id pay_input_values_f.input_value_id%TYPE
45: ,input_value_id pay_input_values_f.input_value_id%TYPE
46: ,information_category pay_element_types_f.element_information_category%TYPE
47: ,pretax_category pay_element_types_f.element_information1%TYPE
48: ,primary_balance_id pay_balance_types.balance_type_id%TYPE
49: ,primary_balance_name pay_balance_types.balance_name%TYPE
47: ,pretax_category pay_element_types_f.element_information1%TYPE
48: ,primary_balance_id pay_balance_types.balance_type_id%TYPE
49: ,primary_balance_name pay_balance_types.balance_name%TYPE
50: ,CatchUp_ele_type_id pay_element_types_f.element_type_id%TYPE
51: ,CatchUp_ipv_id pay_input_values_f.input_value_id%TYPE
52: ,CatchUp_Balance_id pay_balance_types.balance_type_id%TYPE
53: ,Roth_Element Varchar2(90)
54: ,Roth_ele_type_id pay_element_types_f.element_type_id%TYPE
55: ,Roth_ipv_id pay_input_values_f.input_value_id%TYPE
51: ,CatchUp_ipv_id pay_input_values_f.input_value_id%TYPE
52: ,CatchUp_Balance_id pay_balance_types.balance_type_id%TYPE
53: ,Roth_Element Varchar2(90)
54: ,Roth_ele_type_id pay_element_types_f.element_type_id%TYPE
55: ,Roth_ipv_id pay_input_values_f.input_value_id%TYPE
56: ,Roth_balance_id pay_balance_types.balance_type_id%TYPE
57: ,AT_ele_type_id pay_element_types_f.element_type_id%TYPE
58: ,AT_ipv_id pay_input_values_f.input_value_id%TYPE
59: ,AT_balance_id pay_balance_types.balance_type_id%TYPE
54: ,Roth_ele_type_id pay_element_types_f.element_type_id%TYPE
55: ,Roth_ipv_id pay_input_values_f.input_value_id%TYPE
56: ,Roth_balance_id pay_balance_types.balance_type_id%TYPE
57: ,AT_ele_type_id pay_element_types_f.element_type_id%TYPE
58: ,AT_ipv_id pay_input_values_f.input_value_id%TYPE
59: ,AT_balance_id pay_balance_types.balance_type_id%TYPE
60: ,ATER_Element Varchar2(90)
61: ,ATER_Element_id pay_element_types_f.element_type_id%TYPE
62: ,ATER_Balance_id pay_balance_types.balance_type_id%TYPE
90: g_primary_assig t_assig_details;
91:
92: TYPE ele_count_details IS RECORD
93: (ele_Count Number
94: ,input_value_id pay_input_values_f.input_value_id%TYPE
95: ,assignment_action_id pay_assignment_actions.assignment_action_id%TYPE
96: ,ele_type_id pay_element_types_f.element_type_id%TYPE
97: );
98: g_AfterTax ele_count_details;
120:
121:
122: TYPE eleinv_details IS RECORD
123: ( element_name pay_element_types_f.element_name%TYPE
124: ,input_name pay_input_values_f.NAME%TYPE
125: ,element_type_id pay_element_types_f.element_type_id%TYPE
126: ,input_value_id pay_input_values_f.input_value_id%TYPE
127: );
128: TYPE t_eleinv_details IS TABLE OF eleinv_details INDEX BY Binary_Integer;
122: TYPE eleinv_details IS RECORD
123: ( element_name pay_element_types_f.element_name%TYPE
124: ,input_name pay_input_values_f.NAME%TYPE
125: ,element_type_id pay_element_types_f.element_type_id%TYPE
126: ,input_value_id pay_input_values_f.input_value_id%TYPE
127: );
128: TYPE t_eleinv_details IS TABLE OF eleinv_details INDEX BY Binary_Integer;
129: g_element_input_dets t_eleinv_details;
130: