[Home] [Help]
50: l_report_param_val varchar2(30);
51:
52: BEGIN
53:
54: g_debug := hr_utility.debug_enabled;
55:
56: BEGIN
57:
58: open csr_action_parameter;
69: --
70: IF l_action_param_val = 'Y' AND l_report_param_val = 'Y' THEN
71: l_return := TRUE;
72: IF g_debug THEN
73: hr_utility.set_location('Range Person = True',1);
74: END IF;
75: ELSE
76: l_return := FALSE;
77: END IF;
105:
106: begin
107:
108: IF g_debug THEN
109: hr_utility.trace('Entering:' || g_package || 'get_au_rec_balances');
110: hr_utility.trace('Assignment action id value ===>' || p_assignment_action_id);
111: END IF;
112:
113: /* Call to this function below implements Batch Balance Retrieval for better performance */
106: begin
107:
108: IF g_debug THEN
109: hr_utility.trace('Entering:' || g_package || 'get_au_rec_balances');
110: hr_utility.trace('Assignment action id value ===>' || p_assignment_action_id);
111: END IF;
112:
113: /* Call to this function below implements Batch Balance Retrieval for better performance */
114:
125: /* pay_balance_pkg.get_value ( p_assignment_action_id => p_assignment_action_id
126: , p_defined_balance_lst => g_balance_value_tab );*/
127:
128: IF g_debug THEN
129: hr_utility.trace('Balance values for RUN dimension');
130: hr_utility.trace('-------------------------------------');
131: hr_utility.trace('Earnings_Total ===>' || g_result_table(1).balance_value);
132: hr_utility.trace('Direct Payments ===>' || g_result_table(2).balance_value);
133: hr_utility.trace('Termination_Payments ===>' || g_result_table(3).balance_value);
126: , p_defined_balance_lst => g_balance_value_tab );*/
127:
128: IF g_debug THEN
129: hr_utility.trace('Balance values for RUN dimension');
130: hr_utility.trace('-------------------------------------');
131: hr_utility.trace('Earnings_Total ===>' || g_result_table(1).balance_value);
132: hr_utility.trace('Direct Payments ===>' || g_result_table(2).balance_value);
133: hr_utility.trace('Termination_Payments ===>' || g_result_table(3).balance_value);
134: hr_utility.trace('Involuntary Deductions===>' || g_result_table(4).balance_value);
127:
128: IF g_debug THEN
129: hr_utility.trace('Balance values for RUN dimension');
130: hr_utility.trace('-------------------------------------');
131: hr_utility.trace('Earnings_Total ===>' || g_result_table(1).balance_value);
132: hr_utility.trace('Direct Payments ===>' || g_result_table(2).balance_value);
133: hr_utility.trace('Termination_Payments ===>' || g_result_table(3).balance_value);
134: hr_utility.trace('Involuntary Deductions===>' || g_result_table(4).balance_value);
135: hr_utility.trace('Pre Tax Deductions ===>' || g_result_table(5).balance_value);
128: IF g_debug THEN
129: hr_utility.trace('Balance values for RUN dimension');
130: hr_utility.trace('-------------------------------------');
131: hr_utility.trace('Earnings_Total ===>' || g_result_table(1).balance_value);
132: hr_utility.trace('Direct Payments ===>' || g_result_table(2).balance_value);
133: hr_utility.trace('Termination_Payments ===>' || g_result_table(3).balance_value);
134: hr_utility.trace('Involuntary Deductions===>' || g_result_table(4).balance_value);
135: hr_utility.trace('Pre Tax Deductions ===>' || g_result_table(5).balance_value);
136: hr_utility.trace('Termination Deductions===>' || g_result_table(6).balance_value);
129: hr_utility.trace('Balance values for RUN dimension');
130: hr_utility.trace('-------------------------------------');
131: hr_utility.trace('Earnings_Total ===>' || g_result_table(1).balance_value);
132: hr_utility.trace('Direct Payments ===>' || g_result_table(2).balance_value);
133: hr_utility.trace('Termination_Payments ===>' || g_result_table(3).balance_value);
134: hr_utility.trace('Involuntary Deductions===>' || g_result_table(4).balance_value);
135: hr_utility.trace('Pre Tax Deductions ===>' || g_result_table(5).balance_value);
136: hr_utility.trace('Termination Deductions===>' || g_result_table(6).balance_value);
137: hr_utility.trace('Voluntary Deductions ===>' || g_result_table(7).balance_value);
130: hr_utility.trace('-------------------------------------');
131: hr_utility.trace('Earnings_Total ===>' || g_result_table(1).balance_value);
132: hr_utility.trace('Direct Payments ===>' || g_result_table(2).balance_value);
133: hr_utility.trace('Termination_Payments ===>' || g_result_table(3).balance_value);
134: hr_utility.trace('Involuntary Deductions===>' || g_result_table(4).balance_value);
135: hr_utility.trace('Pre Tax Deductions ===>' || g_result_table(5).balance_value);
136: hr_utility.trace('Termination Deductions===>' || g_result_table(6).balance_value);
137: hr_utility.trace('Voluntary Deductions ===>' || g_result_table(7).balance_value);
138: hr_utility.trace('Total_Tax_Deduction ===>' || g_result_table(8).balance_value);
131: hr_utility.trace('Earnings_Total ===>' || g_result_table(1).balance_value);
132: hr_utility.trace('Direct Payments ===>' || g_result_table(2).balance_value);
133: hr_utility.trace('Termination_Payments ===>' || g_result_table(3).balance_value);
134: hr_utility.trace('Involuntary Deductions===>' || g_result_table(4).balance_value);
135: hr_utility.trace('Pre Tax Deductions ===>' || g_result_table(5).balance_value);
136: hr_utility.trace('Termination Deductions===>' || g_result_table(6).balance_value);
137: hr_utility.trace('Voluntary Deductions ===>' || g_result_table(7).balance_value);
138: hr_utility.trace('Total_Tax_Deduction ===>' || g_result_table(8).balance_value);
139: hr_utility.trace('Earnings_Non_Taxable ===>' || g_result_table(9).balance_value);
132: hr_utility.trace('Direct Payments ===>' || g_result_table(2).balance_value);
133: hr_utility.trace('Termination_Payments ===>' || g_result_table(3).balance_value);
134: hr_utility.trace('Involuntary Deductions===>' || g_result_table(4).balance_value);
135: hr_utility.trace('Pre Tax Deductions ===>' || g_result_table(5).balance_value);
136: hr_utility.trace('Termination Deductions===>' || g_result_table(6).balance_value);
137: hr_utility.trace('Voluntary Deductions ===>' || g_result_table(7).balance_value);
138: hr_utility.trace('Total_Tax_Deduction ===>' || g_result_table(8).balance_value);
139: hr_utility.trace('Earnings_Non_Taxable ===>' || g_result_table(9).balance_value);
140: hr_utility.trace('Employer_Charges ===>' || g_result_table(10).balance_value);
133: hr_utility.trace('Termination_Payments ===>' || g_result_table(3).balance_value);
134: hr_utility.trace('Involuntary Deductions===>' || g_result_table(4).balance_value);
135: hr_utility.trace('Pre Tax Deductions ===>' || g_result_table(5).balance_value);
136: hr_utility.trace('Termination Deductions===>' || g_result_table(6).balance_value);
137: hr_utility.trace('Voluntary Deductions ===>' || g_result_table(7).balance_value);
138: hr_utility.trace('Total_Tax_Deduction ===>' || g_result_table(8).balance_value);
139: hr_utility.trace('Earnings_Non_Taxable ===>' || g_result_table(9).balance_value);
140: hr_utility.trace('Employer_Charges ===>' || g_result_table(10).balance_value);
141: END IF;
134: hr_utility.trace('Involuntary Deductions===>' || g_result_table(4).balance_value);
135: hr_utility.trace('Pre Tax Deductions ===>' || g_result_table(5).balance_value);
136: hr_utility.trace('Termination Deductions===>' || g_result_table(6).balance_value);
137: hr_utility.trace('Voluntary Deductions ===>' || g_result_table(7).balance_value);
138: hr_utility.trace('Total_Tax_Deduction ===>' || g_result_table(8).balance_value);
139: hr_utility.trace('Earnings_Non_Taxable ===>' || g_result_table(9).balance_value);
140: hr_utility.trace('Employer_Charges ===>' || g_result_table(10).balance_value);
141: END IF;
142:
135: hr_utility.trace('Pre Tax Deductions ===>' || g_result_table(5).balance_value);
136: hr_utility.trace('Termination Deductions===>' || g_result_table(6).balance_value);
137: hr_utility.trace('Voluntary Deductions ===>' || g_result_table(7).balance_value);
138: hr_utility.trace('Total_Tax_Deduction ===>' || g_result_table(8).balance_value);
139: hr_utility.trace('Earnings_Non_Taxable ===>' || g_result_table(9).balance_value);
140: hr_utility.trace('Employer_Charges ===>' || g_result_table(10).balance_value);
141: END IF;
142:
143: /* Bug 3953706 - Modified calculation of Earnings and deductions as given below:
136: hr_utility.trace('Termination Deductions===>' || g_result_table(6).balance_value);
137: hr_utility.trace('Voluntary Deductions ===>' || g_result_table(7).balance_value);
138: hr_utility.trace('Total_Tax_Deduction ===>' || g_result_table(8).balance_value);
139: hr_utility.trace('Earnings_Non_Taxable ===>' || g_result_table(9).balance_value);
140: hr_utility.trace('Employer_Charges ===>' || g_result_table(10).balance_value);
141: END IF;
142:
143: /* Bug 3953706 - Modified calculation of Earnings and deductions as given below:
144: Calculations :-
183: END IF;
184: /* end bug8682256 */
185:
186: IF g_debug THEN
187: hr_utility.trace('p_taxable_earnings ===>' || p_taxable_earnings);
188: hr_utility.trace('p_non_taxable_earnings ===>' || p_non_taxable_earnings);
189: hr_utility.trace('p_deductions ===>' || p_deductions);
190: hr_utility.trace('p_tax ===>' || p_tax);
191: hr_utility.trace('p_net_payment ===>' || p_net_payment);
184: /* end bug8682256 */
185:
186: IF g_debug THEN
187: hr_utility.trace('p_taxable_earnings ===>' || p_taxable_earnings);
188: hr_utility.trace('p_non_taxable_earnings ===>' || p_non_taxable_earnings);
189: hr_utility.trace('p_deductions ===>' || p_deductions);
190: hr_utility.trace('p_tax ===>' || p_tax);
191: hr_utility.trace('p_net_payment ===>' || p_net_payment);
192: hr_utility.trace('p_employer_charges ===>' || p_employer_charges);
185:
186: IF g_debug THEN
187: hr_utility.trace('p_taxable_earnings ===>' || p_taxable_earnings);
188: hr_utility.trace('p_non_taxable_earnings ===>' || p_non_taxable_earnings);
189: hr_utility.trace('p_deductions ===>' || p_deductions);
190: hr_utility.trace('p_tax ===>' || p_tax);
191: hr_utility.trace('p_net_payment ===>' || p_net_payment);
192: hr_utility.trace('p_employer_charges ===>' || p_employer_charges);
193: hr_utility.trace('p_gross_earnings ===>' || p_gross_earnings);
186: IF g_debug THEN
187: hr_utility.trace('p_taxable_earnings ===>' || p_taxable_earnings);
188: hr_utility.trace('p_non_taxable_earnings ===>' || p_non_taxable_earnings);
189: hr_utility.trace('p_deductions ===>' || p_deductions);
190: hr_utility.trace('p_tax ===>' || p_tax);
191: hr_utility.trace('p_net_payment ===>' || p_net_payment);
192: hr_utility.trace('p_employer_charges ===>' || p_employer_charges);
193: hr_utility.trace('p_gross_earnings ===>' || p_gross_earnings);
194: hr_utility.trace('p_pre_tax_deduction ===>' || p_pre_tax_deductions);
187: hr_utility.trace('p_taxable_earnings ===>' || p_taxable_earnings);
188: hr_utility.trace('p_non_taxable_earnings ===>' || p_non_taxable_earnings);
189: hr_utility.trace('p_deductions ===>' || p_deductions);
190: hr_utility.trace('p_tax ===>' || p_tax);
191: hr_utility.trace('p_net_payment ===>' || p_net_payment);
192: hr_utility.trace('p_employer_charges ===>' || p_employer_charges);
193: hr_utility.trace('p_gross_earnings ===>' || p_gross_earnings);
194: hr_utility.trace('p_pre_tax_deduction ===>' || p_pre_tax_deductions);
195: hr_utility.trace('p_direct_payments ===>' || p_direct_payments);
188: hr_utility.trace('p_non_taxable_earnings ===>' || p_non_taxable_earnings);
189: hr_utility.trace('p_deductions ===>' || p_deductions);
190: hr_utility.trace('p_tax ===>' || p_tax);
191: hr_utility.trace('p_net_payment ===>' || p_net_payment);
192: hr_utility.trace('p_employer_charges ===>' || p_employer_charges);
193: hr_utility.trace('p_gross_earnings ===>' || p_gross_earnings);
194: hr_utility.trace('p_pre_tax_deduction ===>' || p_pre_tax_deductions);
195: hr_utility.trace('p_direct_payments ===>' || p_direct_payments);
196: END IF;
189: hr_utility.trace('p_deductions ===>' || p_deductions);
190: hr_utility.trace('p_tax ===>' || p_tax);
191: hr_utility.trace('p_net_payment ===>' || p_net_payment);
192: hr_utility.trace('p_employer_charges ===>' || p_employer_charges);
193: hr_utility.trace('p_gross_earnings ===>' || p_gross_earnings);
194: hr_utility.trace('p_pre_tax_deduction ===>' || p_pre_tax_deductions);
195: hr_utility.trace('p_direct_payments ===>' || p_direct_payments);
196: END IF;
197:
190: hr_utility.trace('p_tax ===>' || p_tax);
191: hr_utility.trace('p_net_payment ===>' || p_net_payment);
192: hr_utility.trace('p_employer_charges ===>' || p_employer_charges);
193: hr_utility.trace('p_gross_earnings ===>' || p_gross_earnings);
194: hr_utility.trace('p_pre_tax_deduction ===>' || p_pre_tax_deductions);
195: hr_utility.trace('p_direct_payments ===>' || p_direct_payments);
196: END IF;
197:
198:
191: hr_utility.trace('p_net_payment ===>' || p_net_payment);
192: hr_utility.trace('p_employer_charges ===>' || p_employer_charges);
193: hr_utility.trace('p_gross_earnings ===>' || p_gross_earnings);
194: hr_utility.trace('p_pre_tax_deduction ===>' || p_pre_tax_deductions);
195: hr_utility.trace('p_direct_payments ===>' || p_direct_payments);
196: END IF;
197:
198:
199: end get_au_rec_balances;
224:
225: begin
226:
227: IF g_debug THEN
228: hr_utility.trace('Entering:' || g_package || 'get_ytd_au_rec_balances');
229: hr_utility.trace('Assignment action id value ===>' || p_assignment_action_id);
230: END IF;
231:
232: /* Call to this function below implements Batch Balance Retrieval for better performance */
225: begin
226:
227: IF g_debug THEN
228: hr_utility.trace('Entering:' || g_package || 'get_ytd_au_rec_balances');
229: hr_utility.trace('Assignment action id value ===>' || p_assignment_action_id);
230: END IF;
231:
232: /* Call to this function below implements Batch Balance Retrieval for better performance */
233:
244: /* pay_balance_pkg.get_value ( p_assignment_action_id => p_assignment_action_id
245: , p_defined_balance_lst => g_balance_value_tab );*/
246:
247: IF g_debug THEN
248: hr_utility.trace('Balance values for YTD dimension');
249: hr_utility.trace('-------------------------------------');
250: hr_utility.trace('Earnings_Total ===>' || g_result_table(1).balance_value);
251: hr_utility.trace('Direct Payments ===>' || g_result_table(2).balance_value);
252: hr_utility.trace('Termination_Payments ===>' || g_result_table(3).balance_value);
245: , p_defined_balance_lst => g_balance_value_tab );*/
246:
247: IF g_debug THEN
248: hr_utility.trace('Balance values for YTD dimension');
249: hr_utility.trace('-------------------------------------');
250: hr_utility.trace('Earnings_Total ===>' || g_result_table(1).balance_value);
251: hr_utility.trace('Direct Payments ===>' || g_result_table(2).balance_value);
252: hr_utility.trace('Termination_Payments ===>' || g_result_table(3).balance_value);
253: hr_utility.trace('Involuntary Deductions===>' || g_result_table(4).balance_value);
246:
247: IF g_debug THEN
248: hr_utility.trace('Balance values for YTD dimension');
249: hr_utility.trace('-------------------------------------');
250: hr_utility.trace('Earnings_Total ===>' || g_result_table(1).balance_value);
251: hr_utility.trace('Direct Payments ===>' || g_result_table(2).balance_value);
252: hr_utility.trace('Termination_Payments ===>' || g_result_table(3).balance_value);
253: hr_utility.trace('Involuntary Deductions===>' || g_result_table(4).balance_value);
254: hr_utility.trace('Pre Tax Deductions ===>' || g_result_table(5).balance_value);
247: IF g_debug THEN
248: hr_utility.trace('Balance values for YTD dimension');
249: hr_utility.trace('-------------------------------------');
250: hr_utility.trace('Earnings_Total ===>' || g_result_table(1).balance_value);
251: hr_utility.trace('Direct Payments ===>' || g_result_table(2).balance_value);
252: hr_utility.trace('Termination_Payments ===>' || g_result_table(3).balance_value);
253: hr_utility.trace('Involuntary Deductions===>' || g_result_table(4).balance_value);
254: hr_utility.trace('Pre Tax Deductions ===>' || g_result_table(5).balance_value);
255: hr_utility.trace('Termination Deductions===>' || g_result_table(6).balance_value);
248: hr_utility.trace('Balance values for YTD dimension');
249: hr_utility.trace('-------------------------------------');
250: hr_utility.trace('Earnings_Total ===>' || g_result_table(1).balance_value);
251: hr_utility.trace('Direct Payments ===>' || g_result_table(2).balance_value);
252: hr_utility.trace('Termination_Payments ===>' || g_result_table(3).balance_value);
253: hr_utility.trace('Involuntary Deductions===>' || g_result_table(4).balance_value);
254: hr_utility.trace('Pre Tax Deductions ===>' || g_result_table(5).balance_value);
255: hr_utility.trace('Termination Deductions===>' || g_result_table(6).balance_value);
256: hr_utility.trace('Voluntary Deductions ===>' || g_result_table(7).balance_value);
249: hr_utility.trace('-------------------------------------');
250: hr_utility.trace('Earnings_Total ===>' || g_result_table(1).balance_value);
251: hr_utility.trace('Direct Payments ===>' || g_result_table(2).balance_value);
252: hr_utility.trace('Termination_Payments ===>' || g_result_table(3).balance_value);
253: hr_utility.trace('Involuntary Deductions===>' || g_result_table(4).balance_value);
254: hr_utility.trace('Pre Tax Deductions ===>' || g_result_table(5).balance_value);
255: hr_utility.trace('Termination Deductions===>' || g_result_table(6).balance_value);
256: hr_utility.trace('Voluntary Deductions ===>' || g_result_table(7).balance_value);
257: hr_utility.trace('Total_Tax_Deduction ===>' || g_result_table(8).balance_value);
250: hr_utility.trace('Earnings_Total ===>' || g_result_table(1).balance_value);
251: hr_utility.trace('Direct Payments ===>' || g_result_table(2).balance_value);
252: hr_utility.trace('Termination_Payments ===>' || g_result_table(3).balance_value);
253: hr_utility.trace('Involuntary Deductions===>' || g_result_table(4).balance_value);
254: hr_utility.trace('Pre Tax Deductions ===>' || g_result_table(5).balance_value);
255: hr_utility.trace('Termination Deductions===>' || g_result_table(6).balance_value);
256: hr_utility.trace('Voluntary Deductions ===>' || g_result_table(7).balance_value);
257: hr_utility.trace('Total_Tax_Deduction ===>' || g_result_table(8).balance_value);
258: hr_utility.trace('Earnings_Non_Taxable ===>' || g_result_table(9).balance_value);
251: hr_utility.trace('Direct Payments ===>' || g_result_table(2).balance_value);
252: hr_utility.trace('Termination_Payments ===>' || g_result_table(3).balance_value);
253: hr_utility.trace('Involuntary Deductions===>' || g_result_table(4).balance_value);
254: hr_utility.trace('Pre Tax Deductions ===>' || g_result_table(5).balance_value);
255: hr_utility.trace('Termination Deductions===>' || g_result_table(6).balance_value);
256: hr_utility.trace('Voluntary Deductions ===>' || g_result_table(7).balance_value);
257: hr_utility.trace('Total_Tax_Deduction ===>' || g_result_table(8).balance_value);
258: hr_utility.trace('Earnings_Non_Taxable ===>' || g_result_table(9).balance_value);
259: hr_utility.trace('Employer_Charges ===>' || g_result_table(10).balance_value);
252: hr_utility.trace('Termination_Payments ===>' || g_result_table(3).balance_value);
253: hr_utility.trace('Involuntary Deductions===>' || g_result_table(4).balance_value);
254: hr_utility.trace('Pre Tax Deductions ===>' || g_result_table(5).balance_value);
255: hr_utility.trace('Termination Deductions===>' || g_result_table(6).balance_value);
256: hr_utility.trace('Voluntary Deductions ===>' || g_result_table(7).balance_value);
257: hr_utility.trace('Total_Tax_Deduction ===>' || g_result_table(8).balance_value);
258: hr_utility.trace('Earnings_Non_Taxable ===>' || g_result_table(9).balance_value);
259: hr_utility.trace('Employer_Charges ===>' || g_result_table(10).balance_value);
260: END IF;
253: hr_utility.trace('Involuntary Deductions===>' || g_result_table(4).balance_value);
254: hr_utility.trace('Pre Tax Deductions ===>' || g_result_table(5).balance_value);
255: hr_utility.trace('Termination Deductions===>' || g_result_table(6).balance_value);
256: hr_utility.trace('Voluntary Deductions ===>' || g_result_table(7).balance_value);
257: hr_utility.trace('Total_Tax_Deduction ===>' || g_result_table(8).balance_value);
258: hr_utility.trace('Earnings_Non_Taxable ===>' || g_result_table(9).balance_value);
259: hr_utility.trace('Employer_Charges ===>' || g_result_table(10).balance_value);
260: END IF;
261:
254: hr_utility.trace('Pre Tax Deductions ===>' || g_result_table(5).balance_value);
255: hr_utility.trace('Termination Deductions===>' || g_result_table(6).balance_value);
256: hr_utility.trace('Voluntary Deductions ===>' || g_result_table(7).balance_value);
257: hr_utility.trace('Total_Tax_Deduction ===>' || g_result_table(8).balance_value);
258: hr_utility.trace('Earnings_Non_Taxable ===>' || g_result_table(9).balance_value);
259: hr_utility.trace('Employer_Charges ===>' || g_result_table(10).balance_value);
260: END IF;
261:
262: /* Bug 3953706 - Modified calculation of Earnings and deductions as given below:
255: hr_utility.trace('Termination Deductions===>' || g_result_table(6).balance_value);
256: hr_utility.trace('Voluntary Deductions ===>' || g_result_table(7).balance_value);
257: hr_utility.trace('Total_Tax_Deduction ===>' || g_result_table(8).balance_value);
258: hr_utility.trace('Earnings_Non_Taxable ===>' || g_result_table(9).balance_value);
259: hr_utility.trace('Employer_Charges ===>' || g_result_table(10).balance_value);
260: END IF;
261:
262: /* Bug 3953706 - Modified calculation of Earnings and deductions as given below:
263: Calculations :-
300: END IF;
301: /* end bug8682256 */
302:
303: IF g_debug THEN
304: hr_utility.trace('p_ytd_taxable_earnings ===>' || p_ytd_taxable_earnings);
305: hr_utility.trace('p_ytd_non_taxable_earnings ===>' || p_ytd_non_taxable_earnings);
306: hr_utility.trace('p_ytd_deductions ===>' || p_ytd_deductions);
307: hr_utility.trace('p_ytd_tax ===>' || p_ytd_tax);
308: hr_utility.trace('p_ytd_net_payment ===>' || p_ytd_net_payment);
301: /* end bug8682256 */
302:
303: IF g_debug THEN
304: hr_utility.trace('p_ytd_taxable_earnings ===>' || p_ytd_taxable_earnings);
305: hr_utility.trace('p_ytd_non_taxable_earnings ===>' || p_ytd_non_taxable_earnings);
306: hr_utility.trace('p_ytd_deductions ===>' || p_ytd_deductions);
307: hr_utility.trace('p_ytd_tax ===>' || p_ytd_tax);
308: hr_utility.trace('p_ytd_net_payment ===>' || p_ytd_net_payment);
309: hr_utility.trace('p_ytd_employer_charges ===>' || p_ytd_employer_charges);
302:
303: IF g_debug THEN
304: hr_utility.trace('p_ytd_taxable_earnings ===>' || p_ytd_taxable_earnings);
305: hr_utility.trace('p_ytd_non_taxable_earnings ===>' || p_ytd_non_taxable_earnings);
306: hr_utility.trace('p_ytd_deductions ===>' || p_ytd_deductions);
307: hr_utility.trace('p_ytd_tax ===>' || p_ytd_tax);
308: hr_utility.trace('p_ytd_net_payment ===>' || p_ytd_net_payment);
309: hr_utility.trace('p_ytd_employer_charges ===>' || p_ytd_employer_charges);
310: hr_utility.trace('p_ytd_gross_earnings ===>' || p_ytd_gross_earnings);
303: IF g_debug THEN
304: hr_utility.trace('p_ytd_taxable_earnings ===>' || p_ytd_taxable_earnings);
305: hr_utility.trace('p_ytd_non_taxable_earnings ===>' || p_ytd_non_taxable_earnings);
306: hr_utility.trace('p_ytd_deductions ===>' || p_ytd_deductions);
307: hr_utility.trace('p_ytd_tax ===>' || p_ytd_tax);
308: hr_utility.trace('p_ytd_net_payment ===>' || p_ytd_net_payment);
309: hr_utility.trace('p_ytd_employer_charges ===>' || p_ytd_employer_charges);
310: hr_utility.trace('p_ytd_gross_earnings ===>' || p_ytd_gross_earnings);
311: hr_utility.trace('p_ytd_pre_tax_deduction ===>' || p_ytd_pre_tax_deductions);
304: hr_utility.trace('p_ytd_taxable_earnings ===>' || p_ytd_taxable_earnings);
305: hr_utility.trace('p_ytd_non_taxable_earnings ===>' || p_ytd_non_taxable_earnings);
306: hr_utility.trace('p_ytd_deductions ===>' || p_ytd_deductions);
307: hr_utility.trace('p_ytd_tax ===>' || p_ytd_tax);
308: hr_utility.trace('p_ytd_net_payment ===>' || p_ytd_net_payment);
309: hr_utility.trace('p_ytd_employer_charges ===>' || p_ytd_employer_charges);
310: hr_utility.trace('p_ytd_gross_earnings ===>' || p_ytd_gross_earnings);
311: hr_utility.trace('p_ytd_pre_tax_deduction ===>' || p_ytd_pre_tax_deductions);
312: hr_utility.trace('p_ytd_direct_payments ===>' || p_ytd_direct_payments);
305: hr_utility.trace('p_ytd_non_taxable_earnings ===>' || p_ytd_non_taxable_earnings);
306: hr_utility.trace('p_ytd_deductions ===>' || p_ytd_deductions);
307: hr_utility.trace('p_ytd_tax ===>' || p_ytd_tax);
308: hr_utility.trace('p_ytd_net_payment ===>' || p_ytd_net_payment);
309: hr_utility.trace('p_ytd_employer_charges ===>' || p_ytd_employer_charges);
310: hr_utility.trace('p_ytd_gross_earnings ===>' || p_ytd_gross_earnings);
311: hr_utility.trace('p_ytd_pre_tax_deduction ===>' || p_ytd_pre_tax_deductions);
312: hr_utility.trace('p_ytd_direct_payments ===>' || p_ytd_direct_payments);
313: END IF;
306: hr_utility.trace('p_ytd_deductions ===>' || p_ytd_deductions);
307: hr_utility.trace('p_ytd_tax ===>' || p_ytd_tax);
308: hr_utility.trace('p_ytd_net_payment ===>' || p_ytd_net_payment);
309: hr_utility.trace('p_ytd_employer_charges ===>' || p_ytd_employer_charges);
310: hr_utility.trace('p_ytd_gross_earnings ===>' || p_ytd_gross_earnings);
311: hr_utility.trace('p_ytd_pre_tax_deduction ===>' || p_ytd_pre_tax_deductions);
312: hr_utility.trace('p_ytd_direct_payments ===>' || p_ytd_direct_payments);
313: END IF;
314:
307: hr_utility.trace('p_ytd_tax ===>' || p_ytd_tax);
308: hr_utility.trace('p_ytd_net_payment ===>' || p_ytd_net_payment);
309: hr_utility.trace('p_ytd_employer_charges ===>' || p_ytd_employer_charges);
310: hr_utility.trace('p_ytd_gross_earnings ===>' || p_ytd_gross_earnings);
311: hr_utility.trace('p_ytd_pre_tax_deduction ===>' || p_ytd_pre_tax_deductions);
312: hr_utility.trace('p_ytd_direct_payments ===>' || p_ytd_direct_payments);
313: END IF;
314:
315: end get_ytd_au_rec_balances;
308: hr_utility.trace('p_ytd_net_payment ===>' || p_ytd_net_payment);
309: hr_utility.trace('p_ytd_employer_charges ===>' || p_ytd_employer_charges);
310: hr_utility.trace('p_ytd_gross_earnings ===>' || p_ytd_gross_earnings);
311: hr_utility.trace('p_ytd_pre_tax_deduction ===>' || p_ytd_pre_tax_deductions);
312: hr_utility.trace('p_ytd_direct_payments ===>' || p_ytd_direct_payments);
313: END IF;
314:
315: end get_ytd_au_rec_balances;
316:
345:
346: BEGIN
347:
348: IF g_debug THEN
349: hr_utility.trace('Entering:' || g_package || 'populate_defined_balance_ids');
350: hr_utility.trace('Parameter p_ytd_totals value ===>' || p_ytd_totals);
351: END IF;
352:
353: g_balance_value_tab.delete;
346: BEGIN
347:
348: IF g_debug THEN
349: hr_utility.trace('Entering:' || g_package || 'populate_defined_balance_ids');
350: hr_utility.trace('Parameter p_ytd_totals value ===>' || p_ytd_totals);
351: END IF;
352:
353: g_balance_value_tab.delete;
354:
385: g_balance_value_tab(csr_rec.sort_index).defined_balance_id := csr_rec.defined_balance_id;
386: END LOOP;
387:
388: IF g_debug THEN
389: hr_utility.trace('Defined Balance ids for RUN dimension');
390: hr_utility.trace('-------------------------------------');
391: hr_utility.trace('Earnings_Total ===>' || g_balance_value_tab(1).defined_balance_id);
392: hr_utility.trace('Direct Payments ===>' || g_balance_value_tab(2).defined_balance_id);
393: hr_utility.trace('Termination_Payments ===>' || g_balance_value_tab(3).defined_balance_id);
386: END LOOP;
387:
388: IF g_debug THEN
389: hr_utility.trace('Defined Balance ids for RUN dimension');
390: hr_utility.trace('-------------------------------------');
391: hr_utility.trace('Earnings_Total ===>' || g_balance_value_tab(1).defined_balance_id);
392: hr_utility.trace('Direct Payments ===>' || g_balance_value_tab(2).defined_balance_id);
393: hr_utility.trace('Termination_Payments ===>' || g_balance_value_tab(3).defined_balance_id);
394: hr_utility.trace('Involuntary Deductions===>' || g_balance_value_tab(4).defined_balance_id);
387:
388: IF g_debug THEN
389: hr_utility.trace('Defined Balance ids for RUN dimension');
390: hr_utility.trace('-------------------------------------');
391: hr_utility.trace('Earnings_Total ===>' || g_balance_value_tab(1).defined_balance_id);
392: hr_utility.trace('Direct Payments ===>' || g_balance_value_tab(2).defined_balance_id);
393: hr_utility.trace('Termination_Payments ===>' || g_balance_value_tab(3).defined_balance_id);
394: hr_utility.trace('Involuntary Deductions===>' || g_balance_value_tab(4).defined_balance_id);
395: hr_utility.trace('Pre Tax Deductions ===>' || g_balance_value_tab(5).defined_balance_id);
388: IF g_debug THEN
389: hr_utility.trace('Defined Balance ids for RUN dimension');
390: hr_utility.trace('-------------------------------------');
391: hr_utility.trace('Earnings_Total ===>' || g_balance_value_tab(1).defined_balance_id);
392: hr_utility.trace('Direct Payments ===>' || g_balance_value_tab(2).defined_balance_id);
393: hr_utility.trace('Termination_Payments ===>' || g_balance_value_tab(3).defined_balance_id);
394: hr_utility.trace('Involuntary Deductions===>' || g_balance_value_tab(4).defined_balance_id);
395: hr_utility.trace('Pre Tax Deductions ===>' || g_balance_value_tab(5).defined_balance_id);
396: hr_utility.trace('Termination Deductions===>' || g_balance_value_tab(6).defined_balance_id);
389: hr_utility.trace('Defined Balance ids for RUN dimension');
390: hr_utility.trace('-------------------------------------');
391: hr_utility.trace('Earnings_Total ===>' || g_balance_value_tab(1).defined_balance_id);
392: hr_utility.trace('Direct Payments ===>' || g_balance_value_tab(2).defined_balance_id);
393: hr_utility.trace('Termination_Payments ===>' || g_balance_value_tab(3).defined_balance_id);
394: hr_utility.trace('Involuntary Deductions===>' || g_balance_value_tab(4).defined_balance_id);
395: hr_utility.trace('Pre Tax Deductions ===>' || g_balance_value_tab(5).defined_balance_id);
396: hr_utility.trace('Termination Deductions===>' || g_balance_value_tab(6).defined_balance_id);
397: hr_utility.trace('Voluntary Deductions ===>' || g_balance_value_tab(7).defined_balance_id);
390: hr_utility.trace('-------------------------------------');
391: hr_utility.trace('Earnings_Total ===>' || g_balance_value_tab(1).defined_balance_id);
392: hr_utility.trace('Direct Payments ===>' || g_balance_value_tab(2).defined_balance_id);
393: hr_utility.trace('Termination_Payments ===>' || g_balance_value_tab(3).defined_balance_id);
394: hr_utility.trace('Involuntary Deductions===>' || g_balance_value_tab(4).defined_balance_id);
395: hr_utility.trace('Pre Tax Deductions ===>' || g_balance_value_tab(5).defined_balance_id);
396: hr_utility.trace('Termination Deductions===>' || g_balance_value_tab(6).defined_balance_id);
397: hr_utility.trace('Voluntary Deductions ===>' || g_balance_value_tab(7).defined_balance_id);
398: hr_utility.trace('Total_Tax_Deduction ===>' || g_balance_value_tab(8).defined_balance_id);
391: hr_utility.trace('Earnings_Total ===>' || g_balance_value_tab(1).defined_balance_id);
392: hr_utility.trace('Direct Payments ===>' || g_balance_value_tab(2).defined_balance_id);
393: hr_utility.trace('Termination_Payments ===>' || g_balance_value_tab(3).defined_balance_id);
394: hr_utility.trace('Involuntary Deductions===>' || g_balance_value_tab(4).defined_balance_id);
395: hr_utility.trace('Pre Tax Deductions ===>' || g_balance_value_tab(5).defined_balance_id);
396: hr_utility.trace('Termination Deductions===>' || g_balance_value_tab(6).defined_balance_id);
397: hr_utility.trace('Voluntary Deductions ===>' || g_balance_value_tab(7).defined_balance_id);
398: hr_utility.trace('Total_Tax_Deduction ===>' || g_balance_value_tab(8).defined_balance_id);
399: hr_utility.trace('Earnings_Non_Taxable ===>' || g_balance_value_tab(9).defined_balance_id);
392: hr_utility.trace('Direct Payments ===>' || g_balance_value_tab(2).defined_balance_id);
393: hr_utility.trace('Termination_Payments ===>' || g_balance_value_tab(3).defined_balance_id);
394: hr_utility.trace('Involuntary Deductions===>' || g_balance_value_tab(4).defined_balance_id);
395: hr_utility.trace('Pre Tax Deductions ===>' || g_balance_value_tab(5).defined_balance_id);
396: hr_utility.trace('Termination Deductions===>' || g_balance_value_tab(6).defined_balance_id);
397: hr_utility.trace('Voluntary Deductions ===>' || g_balance_value_tab(7).defined_balance_id);
398: hr_utility.trace('Total_Tax_Deduction ===>' || g_balance_value_tab(8).defined_balance_id);
399: hr_utility.trace('Earnings_Non_Taxable ===>' || g_balance_value_tab(9).defined_balance_id);
400: hr_utility.trace('Employer_Charges ===>' || g_balance_value_tab(10).defined_balance_id);
393: hr_utility.trace('Termination_Payments ===>' || g_balance_value_tab(3).defined_balance_id);
394: hr_utility.trace('Involuntary Deductions===>' || g_balance_value_tab(4).defined_balance_id);
395: hr_utility.trace('Pre Tax Deductions ===>' || g_balance_value_tab(5).defined_balance_id);
396: hr_utility.trace('Termination Deductions===>' || g_balance_value_tab(6).defined_balance_id);
397: hr_utility.trace('Voluntary Deductions ===>' || g_balance_value_tab(7).defined_balance_id);
398: hr_utility.trace('Total_Tax_Deduction ===>' || g_balance_value_tab(8).defined_balance_id);
399: hr_utility.trace('Earnings_Non_Taxable ===>' || g_balance_value_tab(9).defined_balance_id);
400: hr_utility.trace('Employer_Charges ===>' || g_balance_value_tab(10).defined_balance_id);
401: END IF;
394: hr_utility.trace('Involuntary Deductions===>' || g_balance_value_tab(4).defined_balance_id);
395: hr_utility.trace('Pre Tax Deductions ===>' || g_balance_value_tab(5).defined_balance_id);
396: hr_utility.trace('Termination Deductions===>' || g_balance_value_tab(6).defined_balance_id);
397: hr_utility.trace('Voluntary Deductions ===>' || g_balance_value_tab(7).defined_balance_id);
398: hr_utility.trace('Total_Tax_Deduction ===>' || g_balance_value_tab(8).defined_balance_id);
399: hr_utility.trace('Earnings_Non_Taxable ===>' || g_balance_value_tab(9).defined_balance_id);
400: hr_utility.trace('Employer_Charges ===>' || g_balance_value_tab(10).defined_balance_id);
401: END IF;
402:
395: hr_utility.trace('Pre Tax Deductions ===>' || g_balance_value_tab(5).defined_balance_id);
396: hr_utility.trace('Termination Deductions===>' || g_balance_value_tab(6).defined_balance_id);
397: hr_utility.trace('Voluntary Deductions ===>' || g_balance_value_tab(7).defined_balance_id);
398: hr_utility.trace('Total_Tax_Deduction ===>' || g_balance_value_tab(8).defined_balance_id);
399: hr_utility.trace('Earnings_Non_Taxable ===>' || g_balance_value_tab(9).defined_balance_id);
400: hr_utility.trace('Employer_Charges ===>' || g_balance_value_tab(10).defined_balance_id);
401: END IF;
402:
403: IF (p_ytd_totals = 'Y') THEN
396: hr_utility.trace('Termination Deductions===>' || g_balance_value_tab(6).defined_balance_id);
397: hr_utility.trace('Voluntary Deductions ===>' || g_balance_value_tab(7).defined_balance_id);
398: hr_utility.trace('Total_Tax_Deduction ===>' || g_balance_value_tab(8).defined_balance_id);
399: hr_utility.trace('Earnings_Non_Taxable ===>' || g_balance_value_tab(9).defined_balance_id);
400: hr_utility.trace('Employer_Charges ===>' || g_balance_value_tab(10).defined_balance_id);
401: END IF;
402:
403: IF (p_ytd_totals = 'Y') THEN
404:
407: g_ytd_balance_value_tab(csr_rec.sort_index).defined_balance_id := csr_rec.defined_balance_id; /*Bug 4040688*/
408: END LOOP;
409:
410: IF g_debug THEN
411: hr_utility.trace('Defined Balance ids for YTD dimension');
412: hr_utility.trace('-------------------------------------');
413: hr_utility.trace('Earnings_Total ===>' || g_ytd_balance_value_tab(1).defined_balance_id);
414: hr_utility.trace('Direct Payments ===>' || g_ytd_balance_value_tab(2).defined_balance_id);
415: hr_utility.trace('Termination_Payments ===>' || g_ytd_balance_value_tab(3).defined_balance_id);
408: END LOOP;
409:
410: IF g_debug THEN
411: hr_utility.trace('Defined Balance ids for YTD dimension');
412: hr_utility.trace('-------------------------------------');
413: hr_utility.trace('Earnings_Total ===>' || g_ytd_balance_value_tab(1).defined_balance_id);
414: hr_utility.trace('Direct Payments ===>' || g_ytd_balance_value_tab(2).defined_balance_id);
415: hr_utility.trace('Termination_Payments ===>' || g_ytd_balance_value_tab(3).defined_balance_id);
416: hr_utility.trace('Involuntary Deductions===>' || g_ytd_balance_value_tab(4).defined_balance_id);
409:
410: IF g_debug THEN
411: hr_utility.trace('Defined Balance ids for YTD dimension');
412: hr_utility.trace('-------------------------------------');
413: hr_utility.trace('Earnings_Total ===>' || g_ytd_balance_value_tab(1).defined_balance_id);
414: hr_utility.trace('Direct Payments ===>' || g_ytd_balance_value_tab(2).defined_balance_id);
415: hr_utility.trace('Termination_Payments ===>' || g_ytd_balance_value_tab(3).defined_balance_id);
416: hr_utility.trace('Involuntary Deductions===>' || g_ytd_balance_value_tab(4).defined_balance_id);
417: hr_utility.trace('Pre Tax Deductions ===>' || g_ytd_balance_value_tab(5).defined_balance_id);
410: IF g_debug THEN
411: hr_utility.trace('Defined Balance ids for YTD dimension');
412: hr_utility.trace('-------------------------------------');
413: hr_utility.trace('Earnings_Total ===>' || g_ytd_balance_value_tab(1).defined_balance_id);
414: hr_utility.trace('Direct Payments ===>' || g_ytd_balance_value_tab(2).defined_balance_id);
415: hr_utility.trace('Termination_Payments ===>' || g_ytd_balance_value_tab(3).defined_balance_id);
416: hr_utility.trace('Involuntary Deductions===>' || g_ytd_balance_value_tab(4).defined_balance_id);
417: hr_utility.trace('Pre Tax Deductions ===>' || g_ytd_balance_value_tab(5).defined_balance_id);
418: hr_utility.trace('Termination Deductions===>' || g_ytd_balance_value_tab(6).defined_balance_id);
411: hr_utility.trace('Defined Balance ids for YTD dimension');
412: hr_utility.trace('-------------------------------------');
413: hr_utility.trace('Earnings_Total ===>' || g_ytd_balance_value_tab(1).defined_balance_id);
414: hr_utility.trace('Direct Payments ===>' || g_ytd_balance_value_tab(2).defined_balance_id);
415: hr_utility.trace('Termination_Payments ===>' || g_ytd_balance_value_tab(3).defined_balance_id);
416: hr_utility.trace('Involuntary Deductions===>' || g_ytd_balance_value_tab(4).defined_balance_id);
417: hr_utility.trace('Pre Tax Deductions ===>' || g_ytd_balance_value_tab(5).defined_balance_id);
418: hr_utility.trace('Termination Deductions===>' || g_ytd_balance_value_tab(6).defined_balance_id);
419: hr_utility.trace('Voluntary Deductionsn ===>' || g_ytd_balance_value_tab(7).defined_balance_id);
412: hr_utility.trace('-------------------------------------');
413: hr_utility.trace('Earnings_Total ===>' || g_ytd_balance_value_tab(1).defined_balance_id);
414: hr_utility.trace('Direct Payments ===>' || g_ytd_balance_value_tab(2).defined_balance_id);
415: hr_utility.trace('Termination_Payments ===>' || g_ytd_balance_value_tab(3).defined_balance_id);
416: hr_utility.trace('Involuntary Deductions===>' || g_ytd_balance_value_tab(4).defined_balance_id);
417: hr_utility.trace('Pre Tax Deductions ===>' || g_ytd_balance_value_tab(5).defined_balance_id);
418: hr_utility.trace('Termination Deductions===>' || g_ytd_balance_value_tab(6).defined_balance_id);
419: hr_utility.trace('Voluntary Deductionsn ===>' || g_ytd_balance_value_tab(7).defined_balance_id);
420: hr_utility.trace('Total_Tax_Deduction ===>' || g_ytd_balance_value_tab(8).defined_balance_id);
413: hr_utility.trace('Earnings_Total ===>' || g_ytd_balance_value_tab(1).defined_balance_id);
414: hr_utility.trace('Direct Payments ===>' || g_ytd_balance_value_tab(2).defined_balance_id);
415: hr_utility.trace('Termination_Payments ===>' || g_ytd_balance_value_tab(3).defined_balance_id);
416: hr_utility.trace('Involuntary Deductions===>' || g_ytd_balance_value_tab(4).defined_balance_id);
417: hr_utility.trace('Pre Tax Deductions ===>' || g_ytd_balance_value_tab(5).defined_balance_id);
418: hr_utility.trace('Termination Deductions===>' || g_ytd_balance_value_tab(6).defined_balance_id);
419: hr_utility.trace('Voluntary Deductionsn ===>' || g_ytd_balance_value_tab(7).defined_balance_id);
420: hr_utility.trace('Total_Tax_Deduction ===>' || g_ytd_balance_value_tab(8).defined_balance_id);
421: hr_utility.trace('Earnings_Non_Taxable ===>' || g_ytd_balance_value_tab(9).defined_balance_id);
414: hr_utility.trace('Direct Payments ===>' || g_ytd_balance_value_tab(2).defined_balance_id);
415: hr_utility.trace('Termination_Payments ===>' || g_ytd_balance_value_tab(3).defined_balance_id);
416: hr_utility.trace('Involuntary Deductions===>' || g_ytd_balance_value_tab(4).defined_balance_id);
417: hr_utility.trace('Pre Tax Deductions ===>' || g_ytd_balance_value_tab(5).defined_balance_id);
418: hr_utility.trace('Termination Deductions===>' || g_ytd_balance_value_tab(6).defined_balance_id);
419: hr_utility.trace('Voluntary Deductionsn ===>' || g_ytd_balance_value_tab(7).defined_balance_id);
420: hr_utility.trace('Total_Tax_Deduction ===>' || g_ytd_balance_value_tab(8).defined_balance_id);
421: hr_utility.trace('Earnings_Non_Taxable ===>' || g_ytd_balance_value_tab(9).defined_balance_id);
422: hr_utility.trace('Employer_Charges ===>' || g_ytd_balance_value_tab(10).defined_balance_id);
415: hr_utility.trace('Termination_Payments ===>' || g_ytd_balance_value_tab(3).defined_balance_id);
416: hr_utility.trace('Involuntary Deductions===>' || g_ytd_balance_value_tab(4).defined_balance_id);
417: hr_utility.trace('Pre Tax Deductions ===>' || g_ytd_balance_value_tab(5).defined_balance_id);
418: hr_utility.trace('Termination Deductions===>' || g_ytd_balance_value_tab(6).defined_balance_id);
419: hr_utility.trace('Voluntary Deductionsn ===>' || g_ytd_balance_value_tab(7).defined_balance_id);
420: hr_utility.trace('Total_Tax_Deduction ===>' || g_ytd_balance_value_tab(8).defined_balance_id);
421: hr_utility.trace('Earnings_Non_Taxable ===>' || g_ytd_balance_value_tab(9).defined_balance_id);
422: hr_utility.trace('Employer_Charges ===>' || g_ytd_balance_value_tab(10).defined_balance_id);
423: END IF;
416: hr_utility.trace('Involuntary Deductions===>' || g_ytd_balance_value_tab(4).defined_balance_id);
417: hr_utility.trace('Pre Tax Deductions ===>' || g_ytd_balance_value_tab(5).defined_balance_id);
418: hr_utility.trace('Termination Deductions===>' || g_ytd_balance_value_tab(6).defined_balance_id);
419: hr_utility.trace('Voluntary Deductionsn ===>' || g_ytd_balance_value_tab(7).defined_balance_id);
420: hr_utility.trace('Total_Tax_Deduction ===>' || g_ytd_balance_value_tab(8).defined_balance_id);
421: hr_utility.trace('Earnings_Non_Taxable ===>' || g_ytd_balance_value_tab(9).defined_balance_id);
422: hr_utility.trace('Employer_Charges ===>' || g_ytd_balance_value_tab(10).defined_balance_id);
423: END IF;
424:
417: hr_utility.trace('Pre Tax Deductions ===>' || g_ytd_balance_value_tab(5).defined_balance_id);
418: hr_utility.trace('Termination Deductions===>' || g_ytd_balance_value_tab(6).defined_balance_id);
419: hr_utility.trace('Voluntary Deductionsn ===>' || g_ytd_balance_value_tab(7).defined_balance_id);
420: hr_utility.trace('Total_Tax_Deduction ===>' || g_ytd_balance_value_tab(8).defined_balance_id);
421: hr_utility.trace('Earnings_Non_Taxable ===>' || g_ytd_balance_value_tab(9).defined_balance_id);
422: hr_utility.trace('Employer_Charges ===>' || g_ytd_balance_value_tab(10).defined_balance_id);
423: END IF;
424:
425: END IF;
418: hr_utility.trace('Termination Deductions===>' || g_ytd_balance_value_tab(6).defined_balance_id);
419: hr_utility.trace('Voluntary Deductionsn ===>' || g_ytd_balance_value_tab(7).defined_balance_id);
420: hr_utility.trace('Total_Tax_Deduction ===>' || g_ytd_balance_value_tab(8).defined_balance_id);
421: hr_utility.trace('Earnings_Non_Taxable ===>' || g_ytd_balance_value_tab(9).defined_balance_id);
422: hr_utility.trace('Employer_Charges ===>' || g_ytd_balance_value_tab(10).defined_balance_id);
423: END IF;
424:
425: END IF;
426:
443: l_procedure varchar2(200) ;
444:
445: begin
446:
447: g_debug :=hr_utility.debug_enabled ;
448:
449: if g_debug then
450: l_procedure := g_package||'range_code';
451: hr_utility.set_location('Entering '||l_procedure,1);
447: g_debug :=hr_utility.debug_enabled ;
448:
449: if g_debug then
450: l_procedure := g_package||'range_code';
451: hr_utility.set_location('Entering '||l_procedure,1);
452: end if ;
453:
454: -- Archive the payroll action level data and EIT defintions.
455: -- sql string to SELECT a range of assignments eligible for archival.
460: ' and p.business_group_id = pa.business_group_id' ||
461: ' order by p.person_id';
462:
463: if g_debug then
464: hr_utility.set_location('Leaving '||l_procedure,1000);
465: end if;
466:
467: end range_code;
468:
516: /*Bug 4132149 - Modification ends here */
517:
518: begin
519:
520: g_debug :=hr_utility.debug_enabled ;
521: if g_debug then
522: g_package := 'pay_au_reconciliation_pkg.' ;
523: l_procedure := g_package||'initialization_code';
524: hr_utility.set_location('Entering '||l_procedure,1);
520: g_debug :=hr_utility.debug_enabled ;
521: if g_debug then
522: g_package := 'pay_au_reconciliation_pkg.' ;
523: l_procedure := g_package||'initialization_code';
524: hr_utility.set_location('Entering '||l_procedure,1);
525: end if;
526:
527: /*Bug 4132149 - Modification begins here */
528:
538: CLOSE csr_params;
539:
540:
541: if g_debug then
542: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
543: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
544: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
545: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
546: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
539:
540:
541: if g_debug then
542: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
543: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
544: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
545: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
546: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
547: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
540:
541: if g_debug then
542: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
543: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
544: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
545: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
546: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
547: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
548: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
541: if g_debug then
542: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
543: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
544: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
545: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
546: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
547: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
548: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
549: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
542: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
543: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
544: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
545: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
546: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
547: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
548: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
549: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
550: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
543: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
544: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
545: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
546: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
547: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
548: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
549: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
550: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
551: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
544: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
545: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
546: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
547: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
548: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
549: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
550: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
551: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
552: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
545: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
546: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
547: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
548: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
549: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
550: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
551: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
552: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
553: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
546: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
547: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
548: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
549: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
550: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
551: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
552: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
553: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
554: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
547: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
548: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
549: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
550: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
551: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
552: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
553: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
554: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
555: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
548: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
549: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
550: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
551: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
552: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
553: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
554: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
555: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
556: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30);/*Bug# 4142159*/
549: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
550: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
551: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
552: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
553: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
554: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
555: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
556: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30);/*Bug# 4142159*/
557: end if;
550: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
551: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
552: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
553: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
554: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
555: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
556: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30);/*Bug# 4142159*/
557: end if;
558:
551: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
552: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
553: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
554: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
555: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
556: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30);/*Bug# 4142159*/
557: end if;
558:
559:
552: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
553: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
554: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
555: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
556: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30);/*Bug# 4142159*/
557: end if;
558:
559:
560: g_business_group_id := g_parameters.business_group_id ;
583: /*Bug 4132149 - Modification ends here */
584:
585: pay_au_reconciliation_pkg.populate_defined_balance_ids('Y',g_parameters.legal_employer);
586: if g_debug then
587: hr_utility.set_location('Leaving '||l_procedure,1000);
588: end if;
589:
590: exception
591: when others then
588: end if;
589:
590: exception
591: when others then
592: hr_utility.set_location('Error in '||l_procedure,999999);
593: raise;
594: end initialization_code;
595:
596: --------------------------------------------------------------------+
1691:
1692:
1693: begin
1694: i := 1;
1695: g_debug :=hr_utility.debug_enabled ;
1696: if g_debug then
1697: g_package := 'pay_au_reconciliation_pkg.' ;
1698: l_procedure := g_package||'assignment_action_code';
1699: hr_utility.set_location('Entering ' || l_procedure,1);
1695: g_debug :=hr_utility.debug_enabled ;
1696: if g_debug then
1697: g_package := 'pay_au_reconciliation_pkg.' ;
1698: l_procedure := g_package||'assignment_action_code';
1699: hr_utility.set_location('Entering ' || l_procedure,1);
1700: hr_utility.set_location('Entering assignment_Action_code',302);
1701: end if;
1702:
1703: -- initialization_code to to set the global tables for EIT
1696: if g_debug then
1697: g_package := 'pay_au_reconciliation_pkg.' ;
1698: l_procedure := g_package||'assignment_action_code';
1699: hr_utility.set_location('Entering ' || l_procedure,1);
1700: hr_utility.set_location('Entering assignment_Action_code',302);
1701: end if;
1702:
1703: -- initialization_code to to set the global tables for EIT
1704: -- that will be used by each thread in multi-threading.
1712: CLOSE csr_params;
1713:
1714:
1715: if g_debug then
1716: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
1717: hr_utility.set_location('p_start_person..............= ' || p_start_person,30);
1718: hr_utility.set_location('p_end_person................= ' || p_end_person,30);
1719: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
1720: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
1713:
1714:
1715: if g_debug then
1716: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
1717: hr_utility.set_location('p_start_person..............= ' || p_start_person,30);
1718: hr_utility.set_location('p_end_person................= ' || p_end_person,30);
1719: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
1720: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
1721: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
1714:
1715: if g_debug then
1716: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
1717: hr_utility.set_location('p_start_person..............= ' || p_start_person,30);
1718: hr_utility.set_location('p_end_person................= ' || p_end_person,30);
1719: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
1720: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
1721: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
1722: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
1715: if g_debug then
1716: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
1717: hr_utility.set_location('p_start_person..............= ' || p_start_person,30);
1718: hr_utility.set_location('p_end_person................= ' || p_end_person,30);
1719: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
1720: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
1721: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
1722: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
1723: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
1716: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
1717: hr_utility.set_location('p_start_person..............= ' || p_start_person,30);
1718: hr_utility.set_location('p_end_person................= ' || p_end_person,30);
1719: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
1720: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
1721: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
1722: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
1723: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
1724: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
1717: hr_utility.set_location('p_start_person..............= ' || p_start_person,30);
1718: hr_utility.set_location('p_end_person................= ' || p_end_person,30);
1719: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
1720: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
1721: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
1722: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
1723: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
1724: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
1725: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
1718: hr_utility.set_location('p_end_person................= ' || p_end_person,30);
1719: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
1720: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
1721: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
1722: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
1723: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
1724: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
1725: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
1726: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
1719: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
1720: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
1721: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
1722: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
1723: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
1724: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
1725: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
1726: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
1727: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
1720: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
1721: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
1722: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
1723: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
1724: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
1725: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
1726: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
1727: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
1728: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
1721: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
1722: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
1723: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
1724: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
1725: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
1726: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
1727: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
1728: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
1729: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
1722: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
1723: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
1724: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
1725: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
1726: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
1727: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
1728: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
1729: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
1730: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
1723: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
1724: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
1725: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
1726: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
1727: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
1728: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
1729: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
1730: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
1731: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
1724: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
1725: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
1726: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
1727: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
1728: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
1729: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
1730: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
1731: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
1732: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30);/*Bug# 4142159*/
1725: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
1726: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
1727: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
1728: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
1729: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
1730: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
1731: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
1732: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30);/*Bug# 4142159*/
1733: end if;
1726: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
1727: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
1728: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
1729: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
1730: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
1731: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
1732: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30);/*Bug# 4142159*/
1733: end if;
1734:
1727: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
1728: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
1729: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
1730: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
1731: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
1732: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30);/*Bug# 4142159*/
1733: end if;
1734:
1735:
1728: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
1729: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
1730: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
1731: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
1732: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30);/*Bug# 4142159*/
1733: end if;
1734:
1735:
1736: g_business_group_id := g_parameters.business_group_id ;
1763: then
1764: if g_parameters.start_date is not null and g_parameters.end_date is not null
1765: then
1766: IF g_debug THEN
1767: hr_utility.set_location('Using Range Person Cursor for fetching assignments',30);
1768: END IF;
1769: FOR csr_rec in rg_csr_assignment_org_period(p_payroll_action_id,
1770: p_chunk,
1771: g_parameters.employee_type,
1779: close csr_next_action_id;
1780:
1781: if g_debug then
1782:
1783: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1784: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1785: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1786: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1787:
1780:
1781: if g_debug then
1782:
1783: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1784: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1785: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1786: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1787:
1788: end if;
1781: if g_debug then
1782:
1783: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1784: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1785: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1786: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1787:
1788: end if;
1789:
1782:
1783: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1784: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1785: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1786: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1787:
1788: end if;
1789:
1790:
1822:
1823:
1824: END LOOP;/* Loop 1 */
1825: if g_debug then
1826: hr_utility.set_location('Leaving............Loop1 Org+Period....' || l_procedure,1000);
1827: end if;
1828:
1829: else
1830: IF g_debug THEN
1827: end if;
1828:
1829: else
1830: IF g_debug THEN
1831: hr_utility.set_location('Using Range Person Cursor for fetching assignments',30);
1832: END IF;
1833: FOR csr_rec in rg_csr_assignment_org_run(p_payroll_action_id,
1834: p_chunk,
1835: g_parameters.employee_type,
1842: fetch csr_next_action_id into l_next_assignment_action_id;
1843: close csr_next_action_id;
1844:
1845: if g_debug then
1846: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1847: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1848: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1849: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1850: end if;
1843: close csr_next_action_id;
1844:
1845: if g_debug then
1846: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1847: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1848: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1849: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1850: end if;
1851:
1844:
1845: if g_debug then
1846: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1847: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1848: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1849: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1850: end if;
1851:
1852: -- Create the archive assignment actions
1845: if g_debug then
1846: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1847: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1848: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1849: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1850: end if;
1851:
1852: -- Create the archive assignment actions
1853: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1881:
1882:
1883: END LOOP; /* Loop 2 */
1884: if g_debug then
1885: hr_utility.set_location('Leaving............Loop2 ,Org + Run....' || l_procedure,1000);
1886: end if;
1887: end if; /* End of Inner Organization */
1888: else /* Not Org,check for others */
1889:
1891: then
1892: if g_parameters.start_date is not null and g_parameters.end_date is not null
1893: then
1894: IF g_debug THEN
1895: hr_utility.set_location('Using Range Person Cursor for fetching assignments',30);
1896: END IF;
1897: FOR csr_rec in rg_csr_assignment_legal_period(p_payroll_action_id,
1898: p_chunk,
1899: g_parameters.employee_type,
1908: open csr_next_action_id;
1909: fetch csr_next_action_id into l_next_assignment_action_id;
1910: close csr_next_action_id;
1911: if g_debug then
1912: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1913: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1914: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1915: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1916: end if;
1909: fetch csr_next_action_id into l_next_assignment_action_id;
1910: close csr_next_action_id;
1911: if g_debug then
1912: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1913: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1914: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1915: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1916: end if;
1917:
1910: close csr_next_action_id;
1911: if g_debug then
1912: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1913: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1914: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1915: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1916: end if;
1917:
1918: -- Create the archive assignment actions
1911: if g_debug then
1912: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1913: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1914: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1915: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1916: end if;
1917:
1918: -- Create the archive assignment actions
1919: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1947:
1948: END IF;
1949: END LOOP;/* Loop 3 */
1950: if g_debug then
1951: hr_utility.set_location('Leaving............Loop3.Legal Emp + period...' || l_procedure,1000);
1952: end if;
1953:
1954: else
1955: IF g_debug THEN
1952: end if;
1953:
1954: else
1955: IF g_debug THEN
1956: hr_utility.set_location('Using Range Person Cursor for fetching assignments',30);
1957: END IF;
1958: FOR csr_rec in rg_csr_assignment_legal_run(p_payroll_action_id,
1959: p_chunk,
1960: g_parameters.employee_type,
1970: fetch csr_next_action_id into l_next_assignment_action_id;
1971: close csr_next_action_id;
1972:
1973: if g_debug then
1974: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1975: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1976: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1977: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1978: end if;
1971: close csr_next_action_id;
1972:
1973: if g_debug then
1974: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1975: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1976: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1977: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1978: end if;
1979:
1972:
1973: if g_debug then
1974: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1975: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1976: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1977: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1978: end if;
1979:
1980: -- Create the archive assignment actions
1973: if g_debug then
1974: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1975: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1976: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1977: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1978: end if;
1979:
1980: -- Create the archive assignment actions
1981: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
2009:
2010: END IF;
2011: END LOOP; /* Loop 4 */
2012: if g_debug then
2013: hr_utility.set_location('Leaving............Loop4.Legal Emp + Run...' || l_procedure,1000);
2014: end if;
2015: end if; /* End of Inner Legal Employer */
2016: else /* Not Org,Legal Emp Check others */
2017:
2019: then
2020: if g_parameters.start_date is not null and g_parameters.end_date is not null
2021: then
2022: IF g_debug THEN
2023: hr_utility.set_location('Using Range Person Cursor for fetching assignments',30);
2024: END IF;
2025: FOR csr_rec in rg_assignment_payroll_period(p_payroll_action_id,
2026: p_chunk,
2027: g_parameters.employee_type,
2034: fetch csr_next_action_id into l_next_assignment_action_id;
2035: close csr_next_action_id;
2036:
2037: if g_debug then
2038: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2039: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2040: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2041: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2042: end if;
2035: close csr_next_action_id;
2036:
2037: if g_debug then
2038: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2039: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2040: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2041: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2042: end if;
2043:
2036:
2037: if g_debug then
2038: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2039: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2040: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2041: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2042: end if;
2043:
2044: -- Create the archive assignment actions
2037: if g_debug then
2038: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2039: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2040: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2041: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2042: end if;
2043:
2044: -- Create the archive assignment actions
2045: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
2074:
2075: END LOOP;/* Loop 5 */
2076:
2077: if g_debug then
2078: hr_utility.set_location('Leaving............Loop5 Payroll + Period....' || l_procedure,1000);
2079: end if;
2080:
2081: else
2082: IF g_debug THEN
2079: end if;
2080:
2081: else
2082: IF g_debug THEN
2083: hr_utility.set_location('Using Range Person Cursor for fetching assignments',30);
2084: END IF;
2085: FOR csr_rec in rg_csr_assignment_payroll_run(p_payroll_action_id,
2086: p_chunk,
2087: g_parameters.employee_type,
2094: fetch csr_next_action_id into l_next_assignment_action_id;
2095: close csr_next_action_id;
2096:
2097: if g_debug then
2098: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2099: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2100: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2101: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2102: end if;
2095: close csr_next_action_id;
2096:
2097: if g_debug then
2098: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2099: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2100: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2101: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2102: end if;
2103:
2096:
2097: if g_debug then
2098: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2099: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2100: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2101: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2102: end if;
2103:
2104: -- Create the archive assignment actions
2097: if g_debug then
2098: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2099: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2100: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2101: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2102: end if;
2103:
2104: -- Create the archive assignment actions
2105: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
2133:
2134:
2135: END LOOP; /* Loop 6 */
2136: if g_debug then
2137: hr_utility.set_location('Leaving............Loop6 Payroll+ Run....' || l_procedure,1000);
2138: end if;
2139: end if; /* End of Inner Payroll */
2140: else /* Not Org,Legal,Payroll check others */
2141:
2143: then
2144: if g_parameters.start_date is not null and g_parameters.end_date is not null
2145: then
2146: IF g_debug THEN
2147: hr_utility.set_location('Using Range Person Cursor for fetching assignments',30);
2148: END IF;
2149: FOR csr_rec in rg_csr_assignment_period(p_payroll_action_id,
2150: p_chunk,
2151: g_parameters.employee_type,
2158: fetch csr_next_action_id into l_next_assignment_action_id;
2159: close csr_next_action_id;
2160:
2161: if g_debug then
2162: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2163: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2164: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2165: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2166: end if;
2159: close csr_next_action_id;
2160:
2161: if g_debug then
2162: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2163: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2164: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2165: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2166: end if;
2167:
2160:
2161: if g_debug then
2162: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2163: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2164: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2165: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2166: end if;
2167:
2168: -- Create the archive assignment actions
2161: if g_debug then
2162: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2163: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2164: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2165: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2166: end if;
2167:
2168: -- Create the archive assignment actions
2169: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
2197:
2198:
2199: END LOOP;/* Loop 7 */
2200: if g_debug then
2201: hr_utility.set_location('Leaving............Loop7. Asg + Period...' || l_procedure,1000);
2202: end if;
2203:
2204: else
2205: IF g_debug THEN
2202: end if;
2203:
2204: else
2205: IF g_debug THEN
2206: hr_utility.set_location('Using Range Person Cursor for fetching assignments',30);
2207: END IF;
2208: FOR csr_rec in rg_csr_assignment_run(p_payroll_action_id,
2209: p_chunk,
2210: g_parameters.employee_type,
2217: fetch csr_next_action_id into l_next_assignment_action_id;
2218: close csr_next_action_id;
2219:
2220: if g_debug then
2221: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2222: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2223: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2224: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2225: end if;
2218: close csr_next_action_id;
2219:
2220: if g_debug then
2221: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2222: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2223: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2224: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2225: end if;
2226:
2219:
2220: if g_debug then
2221: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2222: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2223: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2224: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2225: end if;
2226:
2227: -- Create the archive assignment actions
2220: if g_debug then
2221: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2222: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2223: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2224: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2225: end if;
2226:
2227: -- Create the archive assignment actions
2228: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
2256:
2257:
2258: END LOOP; /* Loop 8 */
2259: if g_debug then
2260: hr_utility.set_location('Leaving............Loop8.Asg + Run...' || l_procedure,1000);
2261: end if;
2262: end if; /* End of Inner Assignment */
2263:
2264: else
2267:
2268: if g_parameters.start_date is not null and g_parameters.end_date is not null
2269: then
2270: IF g_debug THEN
2271: hr_utility.set_location('Using Range Person Cursor for fetching assignments',30);
2272: END IF;
2273: FOR csr_rec in rg_assignment_default_period(p_payroll_action_id,
2274: p_chunk,
2275: g_parameters.employee_type,
2281: fetch csr_next_action_id into l_next_assignment_action_id;
2282: close csr_next_action_id;
2283:
2284: if g_debug then
2285: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2286: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2287: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2288: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2289: end if;
2282: close csr_next_action_id;
2283:
2284: if g_debug then
2285: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2286: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2287: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2288: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2289: end if;
2290:
2283:
2284: if g_debug then
2285: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2286: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2287: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2288: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2289: end if;
2290:
2291: -- Create the archive assignment actions
2284: if g_debug then
2285: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2286: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2287: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2288: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2289: end if;
2290:
2291: -- Create the archive assignment actions
2292: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
2320:
2321:
2322: END LOOP;/* Loop 9 */
2323: if g_debug then
2324: hr_utility.set_location('Leaving............Loop9..Default + Period..' || l_procedure,1000);
2325: end if;
2326:
2327: else
2328: IF g_debug THEN
2325: end if;
2326:
2327: else
2328: IF g_debug THEN
2329: hr_utility.set_location('Using Range Person Cursor for fetching assignments',30);
2330: END IF;
2331: FOR csr_rec in rg_csr_assignment_default_run(p_payroll_action_id,
2332: p_chunk,
2333: g_parameters.employee_type,
2339: fetch csr_next_action_id into l_next_assignment_action_id;
2340: close csr_next_action_id;
2341:
2342: if g_debug then
2343: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2344: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2345: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2346: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2347: end if;
2340: close csr_next_action_id;
2341:
2342: if g_debug then
2343: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2344: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2345: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2346: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2347: end if;
2348:
2341:
2342: if g_debug then
2343: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2344: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2345: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2346: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2347: end if;
2348:
2349: -- Create the archive assignment actions
2342: if g_debug then
2343: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2344: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2345: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2346: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2347: end if;
2348:
2349: -- Create the archive assignment actions
2350: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
2378:
2379:
2380: END LOOP; /* Loop 10 */
2381: if g_debug then
2382: hr_utility.set_location('Leaving............Loop10 Default + Run....' || l_procedure,1000);
2383: end if;
2384: end if; /* End of Inner Default */
2385:
2386:
2409: close csr_next_action_id;
2410:
2411: if g_debug then
2412:
2413: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2414: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2415: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2416: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2417:
2410:
2411: if g_debug then
2412:
2413: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2414: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2415: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2416: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2417:
2418: end if;
2411: if g_debug then
2412:
2413: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2414: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2415: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2416: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2417:
2418: end if;
2419:
2412:
2413: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2414: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2415: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2416: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2417:
2418: end if;
2419:
2420:
2452:
2453:
2454: END LOOP;/* Loop 1 */
2455: if g_debug then
2456: hr_utility.set_location('Leaving............Loop1 Org+Period....' || l_procedure,1000);
2457: end if;
2458:
2459: else
2460: FOR csr_rec in csr_assignment_org_run(p_payroll_action_id,
2470: fetch csr_next_action_id into l_next_assignment_action_id;
2471: close csr_next_action_id;
2472:
2473: if g_debug then
2474: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2475: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2476: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2477: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2478: end if;
2471: close csr_next_action_id;
2472:
2473: if g_debug then
2474: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2475: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2476: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2477: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2478: end if;
2479:
2472:
2473: if g_debug then
2474: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2475: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2476: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2477: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2478: end if;
2479:
2480: -- Create the archive assignment actions
2473: if g_debug then
2474: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2475: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2476: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2477: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2478: end if;
2479:
2480: -- Create the archive assignment actions
2481: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
2509:
2510:
2511: END LOOP; /* Loop 2 */
2512: if g_debug then
2513: hr_utility.set_location('Leaving............Loop2 ,Org + Run....' || l_procedure,1000);
2514: end if;
2515: end if; /* End of Inner Organization */
2516: else /* Not Org,check for others */
2517:
2534: open csr_next_action_id;
2535: fetch csr_next_action_id into l_next_assignment_action_id;
2536: close csr_next_action_id;
2537: if g_debug then
2538: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2539: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2540: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2541: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2542: end if;
2535: fetch csr_next_action_id into l_next_assignment_action_id;
2536: close csr_next_action_id;
2537: if g_debug then
2538: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2539: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2540: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2541: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2542: end if;
2543:
2536: close csr_next_action_id;
2537: if g_debug then
2538: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2539: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2540: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2541: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2542: end if;
2543:
2544: -- Create the archive assignment actions
2537: if g_debug then
2538: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2539: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2540: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2541: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2542: end if;
2543:
2544: -- Create the archive assignment actions
2545: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
2573:
2574: END IF;
2575: END LOOP;/* Loop 3 */
2576: if g_debug then
2577: hr_utility.set_location('Leaving............Loop3.Legal Emp + period...' || l_procedure,1000);
2578: end if;
2579:
2580: else
2581: FOR csr_rec in csr_assignment_legal_run(p_payroll_action_id,
2594: fetch csr_next_action_id into l_next_assignment_action_id;
2595: close csr_next_action_id;
2596:
2597: if g_debug then
2598: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2599: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2600: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2601: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2602: end if;
2595: close csr_next_action_id;
2596:
2597: if g_debug then
2598: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2599: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2600: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2601: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2602: end if;
2603:
2596:
2597: if g_debug then
2598: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2599: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2600: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2601: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2602: end if;
2603:
2604: -- Create the archive assignment actions
2597: if g_debug then
2598: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2599: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2600: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2601: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2602: end if;
2603:
2604: -- Create the archive assignment actions
2605: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
2633:
2634: END IF;
2635: END LOOP; /* Loop 4 */
2636: if g_debug then
2637: hr_utility.set_location('Leaving............Loop4.Legal Emp + Run...' || l_procedure,1000);
2638: end if;
2639: end if; /* End of Inner Legal Employer */
2640: else /* Not Org,Legal Emp Check others */
2641:
2656: fetch csr_next_action_id into l_next_assignment_action_id;
2657: close csr_next_action_id;
2658:
2659: if g_debug then
2660: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2661: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2662: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2663: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2664: end if;
2657: close csr_next_action_id;
2658:
2659: if g_debug then
2660: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2661: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2662: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2663: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2664: end if;
2665:
2658:
2659: if g_debug then
2660: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2661: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2662: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2663: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2664: end if;
2665:
2666: -- Create the archive assignment actions
2659: if g_debug then
2660: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2661: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2662: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2663: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2664: end if;
2665:
2666: -- Create the archive assignment actions
2667: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
2696:
2697: END LOOP;/* Loop 5 */
2698:
2699: if g_debug then
2700: hr_utility.set_location('Leaving............Loop5 Payroll + Period....' || l_procedure,1000);
2701: end if;
2702:
2703: else
2704: FOR csr_rec in csr_assignment_payroll_run(p_payroll_action_id,
2714: fetch csr_next_action_id into l_next_assignment_action_id;
2715: close csr_next_action_id;
2716:
2717: if g_debug then
2718: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2719: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2720: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2721: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2722: end if;
2715: close csr_next_action_id;
2716:
2717: if g_debug then
2718: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2719: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2720: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2721: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2722: end if;
2723:
2716:
2717: if g_debug then
2718: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2719: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2720: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2721: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2722: end if;
2723:
2724: -- Create the archive assignment actions
2717: if g_debug then
2718: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2719: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2720: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2721: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2722: end if;
2723:
2724: -- Create the archive assignment actions
2725: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
2753:
2754:
2755: END LOOP; /* Loop 6 */
2756: if g_debug then
2757: hr_utility.set_location('Leaving............Loop6 Payroll+ Run....' || l_procedure,1000);
2758: end if;
2759: end if; /* End of Inner Payroll */
2760: else /* Not Org,Legal,Payroll check others */
2761:
2776: fetch csr_next_action_id into l_next_assignment_action_id;
2777: close csr_next_action_id;
2778:
2779: if g_debug then
2780: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2781: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2782: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2783: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2784: end if;
2777: close csr_next_action_id;
2778:
2779: if g_debug then
2780: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2781: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2782: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2783: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2784: end if;
2785:
2778:
2779: if g_debug then
2780: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2781: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2782: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2783: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2784: end if;
2785:
2786: -- Create the archive assignment actions
2779: if g_debug then
2780: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2781: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2782: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2783: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2784: end if;
2785:
2786: -- Create the archive assignment actions
2787: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
2815:
2816:
2817: END LOOP;/* Loop 7 */
2818: if g_debug then
2819: hr_utility.set_location('Leaving............Loop7. Asg + Period...' || l_procedure,1000);
2820: end if;
2821:
2822: else
2823: FOR csr_rec in csr_assignment_run(p_payroll_action_id,
2833: fetch csr_next_action_id into l_next_assignment_action_id;
2834: close csr_next_action_id;
2835:
2836: if g_debug then
2837: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2838: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2839: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2840: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2841: end if;
2834: close csr_next_action_id;
2835:
2836: if g_debug then
2837: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2838: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2839: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2840: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2841: end if;
2842:
2835:
2836: if g_debug then
2837: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2838: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2839: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2840: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2841: end if;
2842:
2843: -- Create the archive assignment actions
2836: if g_debug then
2837: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2838: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2839: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2840: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2841: end if;
2842:
2843: -- Create the archive assignment actions
2844: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
2872:
2873:
2874: END LOOP; /* Loop 8 */
2875: if g_debug then
2876: hr_utility.set_location('Leaving............Loop8.Asg + Run...' || l_procedure,1000);
2877: end if;
2878: end if; /* End of Inner Assignment */
2879:
2880: else
2895: fetch csr_next_action_id into l_next_assignment_action_id;
2896: close csr_next_action_id;
2897:
2898: if g_debug then
2899: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2900: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2901: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2902: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2903: end if;
2896: close csr_next_action_id;
2897:
2898: if g_debug then
2899: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2900: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2901: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2902: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2903: end if;
2904:
2897:
2898: if g_debug then
2899: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2900: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2901: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2902: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2903: end if;
2904:
2905: -- Create the archive assignment actions
2898: if g_debug then
2899: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2900: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2901: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2902: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2903: end if;
2904:
2905: -- Create the archive assignment actions
2906: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
2934:
2935:
2936: END LOOP;/* Loop 9 */
2937: if g_debug then
2938: hr_utility.set_location('Leaving............Loop9..Default + Period..' || l_procedure,1000);
2939: end if;
2940:
2941: else
2942: FOR csr_rec in csr_assignment_default_run(p_payroll_action_id,
2951: fetch csr_next_action_id into l_next_assignment_action_id;
2952: close csr_next_action_id;
2953:
2954: if g_debug then
2955: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2956: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2957: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2958: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2959: end if;
2952: close csr_next_action_id;
2953:
2954: if g_debug then
2955: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2956: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2957: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2958: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2959: end if;
2960:
2953:
2954: if g_debug then
2955: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2956: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2957: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2958: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2959: end if;
2960:
2961: -- Create the archive assignment actions
2954: if g_debug then
2955: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2956: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2957: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2958: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2959: end if;
2960:
2961: -- Create the archive assignment actions
2962: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
2990:
2991:
2992: END LOOP; /* Loop 10 */
2993: if g_debug then
2994: hr_utility.set_location('Leaving............Loop10 Default + Run....' || l_procedure,1000);
2995: end if;
2996: end if; /* End of Inner Default */
2997:
2998:
3004: END IF;
3005:
3006: exception
3007: when others then
3008: hr_utility.set_location('Error in '||l_procedure,999999);
3009: raise;
3010: end assignment_action_code;
3011:
3012: procedure archive_code
3156: l_payroll_name pay_payrolls_f.payroll_name%type; /*Bug 4688800*/
3157:
3158: begin
3159:
3160: g_debug :=hr_utility.debug_enabled ;
3161:
3162: l_YTD_GROSS_EARNINGS := 0;
3163: l_YTD_NON_TAXABLE_EARNINGS := 0;
3164: l_YTD_PRE_TAX_DEDUCTIONS := 0;
3171:
3172: if g_debug then
3173: g_package := 'pay_au_reconciliation_pkg.' ;
3174: l_procedure := g_package||'archive_code';
3175: hr_utility.set_location('Entering '||l_procedure,1);
3176: hr_utility.set_location('p_assignment_action_id......= '|| p_assignment_action_id,10);
3177: hr_utility.set_location('p_effective_date............= '|| to_char(p_effective_date,'DD-MON-YYYY'),10);
3178: end if;
3179:
3172: if g_debug then
3173: g_package := 'pay_au_reconciliation_pkg.' ;
3174: l_procedure := g_package||'archive_code';
3175: hr_utility.set_location('Entering '||l_procedure,1);
3176: hr_utility.set_location('p_assignment_action_id......= '|| p_assignment_action_id,10);
3177: hr_utility.set_location('p_effective_date............= '|| to_char(p_effective_date,'DD-MON-YYYY'),10);
3178: end if;
3179:
3180: OPEN csr_get_data(p_assignment_action_id);
3173: g_package := 'pay_au_reconciliation_pkg.' ;
3174: l_procedure := g_package||'archive_code';
3175: hr_utility.set_location('Entering '||l_procedure,1);
3176: hr_utility.set_location('p_assignment_action_id......= '|| p_assignment_action_id,10);
3177: hr_utility.set_location('p_effective_date............= '|| to_char(p_effective_date,'DD-MON-YYYY'),10);
3178: end if;
3179:
3180: OPEN csr_get_data(p_assignment_action_id);
3181: FETCH csr_get_data into l_ass_act_id, l_tax_unit_id, l_assignment_id,l_action_sequence;
3181: FETCH csr_get_data into l_ass_act_id, l_tax_unit_id, l_assignment_id,l_action_sequence;
3182: CLOSE csr_get_data;
3183:
3184: if g_debug then
3185: hr_utility.set_location('l_ass_act_id......= '|| l_ass_act_id,10);
3186: hr_utility.set_location('l_tax_unit_id............= '|| l_tax_unit_id,10);
3187: hr_utility.set_location('l_assignment_id......= '|| l_assignment_id,10);
3188: end if;
3189:
3182: CLOSE csr_get_data;
3183:
3184: if g_debug then
3185: hr_utility.set_location('l_ass_act_id......= '|| l_ass_act_id,10);
3186: hr_utility.set_location('l_tax_unit_id............= '|| l_tax_unit_id,10);
3187: hr_utility.set_location('l_assignment_id......= '|| l_assignment_id,10);
3188: end if;
3189:
3190: FOR csr_rec in c_employee_details(g_business_group_id,l_assignment_id,g_end_date,g_start_date) --Bug#3662449
3183:
3184: if g_debug then
3185: hr_utility.set_location('l_ass_act_id......= '|| l_ass_act_id,10);
3186: hr_utility.set_location('l_tax_unit_id............= '|| l_tax_unit_id,10);
3187: hr_utility.set_location('l_assignment_id......= '|| l_assignment_id,10);
3188: end if;
3189:
3190: FOR csr_rec in c_employee_details(g_business_group_id,l_assignment_id,g_end_date,g_start_date) --Bug#3662449
3191: LOOP
3190: FOR csr_rec in c_employee_details(g_business_group_id,l_assignment_id,g_end_date,g_start_date) --Bug#3662449
3191: LOOP
3192:
3193: if g_debug then
3194: hr_utility.set_location('csr_rec.full_name............= '|| csr_rec.full_name,10);
3195: end if;
3196:
3197:
3198: IF (NVL(g_prev_assignment_id,0) <> csr_rec.assignment_id) THEN
3429:
3430: Begin
3431: l_count :=0;
3432: ps_request_id :=-1;
3433: g_debug :=hr_utility.debug_enabled ;
3434:
3435:
3436: if g_debug then
3437: g_package := 'pay_au_reconciliation_pkg.' ;
3435:
3436: if g_debug then
3437: g_package := 'pay_au_reconciliation_pkg.' ;
3438: l_procedure := g_package||' spawn_archive_reports';
3439: hr_utility.set_location('Entering '||l_procedure,999);
3440: end if;
3441:
3442: -- Set User Parameters for Report.
3443:
3450: ,l_parameters.end_date
3451: ,l_parameters.period_end_date);
3452:
3453: if g_debug then
3454: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,0);
3455: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,1);
3456: hr_utility.set_location('in org_id '||l_parameters.org_id,2);
3457: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
3458: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
3451: ,l_parameters.period_end_date);
3452:
3453: if g_debug then
3454: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,0);
3455: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,1);
3456: hr_utility.set_location('in org_id '||l_parameters.org_id,2);
3457: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
3458: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
3459: hr_utility.set_location('in archive start date '||to_char(l_parameters.start_date,'YYYY/MM/DD'),5);
3452:
3453: if g_debug then
3454: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,0);
3455: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,1);
3456: hr_utility.set_location('in org_id '||l_parameters.org_id,2);
3457: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
3458: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
3459: hr_utility.set_location('in archive start date '||to_char(l_parameters.start_date,'YYYY/MM/DD'),5);
3460: hr_utility.set_location('in archive end date '||to_char(l_parameters.end_date,'YYYY/MM/DD'),6);
3453: if g_debug then
3454: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,0);
3455: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,1);
3456: hr_utility.set_location('in org_id '||l_parameters.org_id,2);
3457: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
3458: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
3459: hr_utility.set_location('in archive start date '||to_char(l_parameters.start_date,'YYYY/MM/DD'),5);
3460: hr_utility.set_location('in archive end date '||to_char(l_parameters.end_date,'YYYY/MM/DD'),6);
3461: hr_utility.set_location('in pact_id '||l_parameters.pact_id,7);
3454: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,0);
3455: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,1);
3456: hr_utility.set_location('in org_id '||l_parameters.org_id,2);
3457: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
3458: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
3459: hr_utility.set_location('in archive start date '||to_char(l_parameters.start_date,'YYYY/MM/DD'),5);
3460: hr_utility.set_location('in archive end date '||to_char(l_parameters.end_date,'YYYY/MM/DD'),6);
3461: hr_utility.set_location('in pact_id '||l_parameters.pact_id,7);
3462: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
3455: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,1);
3456: hr_utility.set_location('in org_id '||l_parameters.org_id,2);
3457: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
3458: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
3459: hr_utility.set_location('in archive start date '||to_char(l_parameters.start_date,'YYYY/MM/DD'),5);
3460: hr_utility.set_location('in archive end date '||to_char(l_parameters.end_date,'YYYY/MM/DD'),6);
3461: hr_utility.set_location('in pact_id '||l_parameters.pact_id,7);
3462: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
3463: hr_utility.set_location('in PERIOD END DATE '||to_char(l_parameters.period_end_date,'YYYY/MM/DD'),9);
3456: hr_utility.set_location('in org_id '||l_parameters.org_id,2);
3457: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
3458: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
3459: hr_utility.set_location('in archive start date '||to_char(l_parameters.start_date,'YYYY/MM/DD'),5);
3460: hr_utility.set_location('in archive end date '||to_char(l_parameters.end_date,'YYYY/MM/DD'),6);
3461: hr_utility.set_location('in pact_id '||l_parameters.pact_id,7);
3462: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
3463: hr_utility.set_location('in PERIOD END DATE '||to_char(l_parameters.period_end_date,'YYYY/MM/DD'),9);
3464: hr_utility.set_location('in YTD totals '||l_parameters.ytd_totals,10);
3457: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
3458: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
3459: hr_utility.set_location('in archive start date '||to_char(l_parameters.start_date,'YYYY/MM/DD'),5);
3460: hr_utility.set_location('in archive end date '||to_char(l_parameters.end_date,'YYYY/MM/DD'),6);
3461: hr_utility.set_location('in pact_id '||l_parameters.pact_id,7);
3462: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
3463: hr_utility.set_location('in PERIOD END DATE '||to_char(l_parameters.period_end_date,'YYYY/MM/DD'),9);
3464: hr_utility.set_location('in YTD totals '||l_parameters.ytd_totals,10);
3465: hr_utility.set_location('in zero records'||l_parameters.zero_records,11);
3458: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
3459: hr_utility.set_location('in archive start date '||to_char(l_parameters.start_date,'YYYY/MM/DD'),5);
3460: hr_utility.set_location('in archive end date '||to_char(l_parameters.end_date,'YYYY/MM/DD'),6);
3461: hr_utility.set_location('in pact_id '||l_parameters.pact_id,7);
3462: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
3463: hr_utility.set_location('in PERIOD END DATE '||to_char(l_parameters.period_end_date,'YYYY/MM/DD'),9);
3464: hr_utility.set_location('in YTD totals '||l_parameters.ytd_totals,10);
3465: hr_utility.set_location('in zero records'||l_parameters.zero_records,11);
3466: hr_utility.set_location('in Negative records'||l_parameters.negative_records,12);
3459: hr_utility.set_location('in archive start date '||to_char(l_parameters.start_date,'YYYY/MM/DD'),5);
3460: hr_utility.set_location('in archive end date '||to_char(l_parameters.end_date,'YYYY/MM/DD'),6);
3461: hr_utility.set_location('in pact_id '||l_parameters.pact_id,7);
3462: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
3463: hr_utility.set_location('in PERIOD END DATE '||to_char(l_parameters.period_end_date,'YYYY/MM/DD'),9);
3464: hr_utility.set_location('in YTD totals '||l_parameters.ytd_totals,10);
3465: hr_utility.set_location('in zero records'||l_parameters.zero_records,11);
3466: hr_utility.set_location('in Negative records'||l_parameters.negative_records,12);
3467: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
3460: hr_utility.set_location('in archive end date '||to_char(l_parameters.end_date,'YYYY/MM/DD'),6);
3461: hr_utility.set_location('in pact_id '||l_parameters.pact_id,7);
3462: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
3463: hr_utility.set_location('in PERIOD END DATE '||to_char(l_parameters.period_end_date,'YYYY/MM/DD'),9);
3464: hr_utility.set_location('in YTD totals '||l_parameters.ytd_totals,10);
3465: hr_utility.set_location('in zero records'||l_parameters.zero_records,11);
3466: hr_utility.set_location('in Negative records'||l_parameters.negative_records,12);
3467: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
3468: hr_utility.set_location('in sort order 1'||l_parameters.sort_order_1,15);
3461: hr_utility.set_location('in pact_id '||l_parameters.pact_id,7);
3462: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
3463: hr_utility.set_location('in PERIOD END DATE '||to_char(l_parameters.period_end_date,'YYYY/MM/DD'),9);
3464: hr_utility.set_location('in YTD totals '||l_parameters.ytd_totals,10);
3465: hr_utility.set_location('in zero records'||l_parameters.zero_records,11);
3466: hr_utility.set_location('in Negative records'||l_parameters.negative_records,12);
3467: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
3468: hr_utility.set_location('in sort order 1'||l_parameters.sort_order_1,15);
3469: hr_utility.set_location('in sort order 2'||l_parameters.sort_order_2,16);
3462: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
3463: hr_utility.set_location('in PERIOD END DATE '||to_char(l_parameters.period_end_date,'YYYY/MM/DD'),9);
3464: hr_utility.set_location('in YTD totals '||l_parameters.ytd_totals,10);
3465: hr_utility.set_location('in zero records'||l_parameters.zero_records,11);
3466: hr_utility.set_location('in Negative records'||l_parameters.negative_records,12);
3467: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
3468: hr_utility.set_location('in sort order 1'||l_parameters.sort_order_1,15);
3469: hr_utility.set_location('in sort order 2'||l_parameters.sort_order_2,16);
3470: hr_utility.set_location('in sort order 3'||l_parameters.sort_order_3,17);
3463: hr_utility.set_location('in PERIOD END DATE '||to_char(l_parameters.period_end_date,'YYYY/MM/DD'),9);
3464: hr_utility.set_location('in YTD totals '||l_parameters.ytd_totals,10);
3465: hr_utility.set_location('in zero records'||l_parameters.zero_records,11);
3466: hr_utility.set_location('in Negative records'||l_parameters.negative_records,12);
3467: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
3468: hr_utility.set_location('in sort order 1'||l_parameters.sort_order_1,15);
3469: hr_utility.set_location('in sort order 2'||l_parameters.sort_order_2,16);
3470: hr_utility.set_location('in sort order 3'||l_parameters.sort_order_3,17);
3471: hr_utility.set_location('in sort order 4'||l_parameters.sort_order_4,18);
3464: hr_utility.set_location('in YTD totals '||l_parameters.ytd_totals,10);
3465: hr_utility.set_location('in zero records'||l_parameters.zero_records,11);
3466: hr_utility.set_location('in Negative records'||l_parameters.negative_records,12);
3467: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
3468: hr_utility.set_location('in sort order 1'||l_parameters.sort_order_1,15);
3469: hr_utility.set_location('in sort order 2'||l_parameters.sort_order_2,16);
3470: hr_utility.set_location('in sort order 3'||l_parameters.sort_order_3,17);
3471: hr_utility.set_location('in sort order 4'||l_parameters.sort_order_4,18);
3472: hr_utility.set_location('in delete action'||l_parameters.delete_actions,19); /*Bug# 4142159*/
3465: hr_utility.set_location('in zero records'||l_parameters.zero_records,11);
3466: hr_utility.set_location('in Negative records'||l_parameters.negative_records,12);
3467: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
3468: hr_utility.set_location('in sort order 1'||l_parameters.sort_order_1,15);
3469: hr_utility.set_location('in sort order 2'||l_parameters.sort_order_2,16);
3470: hr_utility.set_location('in sort order 3'||l_parameters.sort_order_3,17);
3471: hr_utility.set_location('in sort order 4'||l_parameters.sort_order_4,18);
3472: hr_utility.set_location('in delete action'||l_parameters.delete_actions,19); /*Bug# 4142159*/
3473: hr_utility.set_location('in Output Type '||l_parameters.output_type,20); /*Bug# 4947424*/
3466: hr_utility.set_location('in Negative records'||l_parameters.negative_records,12);
3467: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
3468: hr_utility.set_location('in sort order 1'||l_parameters.sort_order_1,15);
3469: hr_utility.set_location('in sort order 2'||l_parameters.sort_order_2,16);
3470: hr_utility.set_location('in sort order 3'||l_parameters.sort_order_3,17);
3471: hr_utility.set_location('in sort order 4'||l_parameters.sort_order_4,18);
3472: hr_utility.set_location('in delete action'||l_parameters.delete_actions,19); /*Bug# 4142159*/
3473: hr_utility.set_location('in Output Type '||l_parameters.output_type,20); /*Bug# 4947424*/
3474: end if;
3467: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
3468: hr_utility.set_location('in sort order 1'||l_parameters.sort_order_1,15);
3469: hr_utility.set_location('in sort order 2'||l_parameters.sort_order_2,16);
3470: hr_utility.set_location('in sort order 3'||l_parameters.sort_order_3,17);
3471: hr_utility.set_location('in sort order 4'||l_parameters.sort_order_4,18);
3472: hr_utility.set_location('in delete action'||l_parameters.delete_actions,19); /*Bug# 4142159*/
3473: hr_utility.set_location('in Output Type '||l_parameters.output_type,20); /*Bug# 4947424*/
3474: end if;
3475:
3468: hr_utility.set_location('in sort order 1'||l_parameters.sort_order_1,15);
3469: hr_utility.set_location('in sort order 2'||l_parameters.sort_order_2,16);
3470: hr_utility.set_location('in sort order 3'||l_parameters.sort_order_3,17);
3471: hr_utility.set_location('in sort order 4'||l_parameters.sort_order_4,18);
3472: hr_utility.set_location('in delete action'||l_parameters.delete_actions,19); /*Bug# 4142159*/
3473: hr_utility.set_location('in Output Type '||l_parameters.output_type,20); /*Bug# 4947424*/
3474: end if;
3475:
3476: if g_debug then
3469: hr_utility.set_location('in sort order 2'||l_parameters.sort_order_2,16);
3470: hr_utility.set_location('in sort order 3'||l_parameters.sort_order_3,17);
3471: hr_utility.set_location('in sort order 4'||l_parameters.sort_order_4,18);
3472: hr_utility.set_location('in delete action'||l_parameters.delete_actions,19); /*Bug# 4142159*/
3473: hr_utility.set_location('in Output Type '||l_parameters.output_type,20); /*Bug# 4947424*/
3474: end if;
3475:
3476: if g_debug then
3477: hr_utility.set_location('Afer payroll action ' || p_payroll_action_id , 125);
3473: hr_utility.set_location('in Output Type '||l_parameters.output_type,20); /*Bug# 4947424*/
3474: end if;
3475:
3476: if g_debug then
3477: hr_utility.set_location('Afer payroll action ' || p_payroll_action_id , 125);
3478:
3479: hr_utility.set_location('Before calling report',24);
3480: end if;
3481:
3475:
3476: if g_debug then
3477: hr_utility.set_location('Afer payroll action ' || p_payroll_action_id , 125);
3478:
3479: hr_utility.set_location('Before calling report',24);
3480: end if;
3481:
3482: OPEN csr_get_print_options(p_payroll_action_id);
3483: FETCH csr_get_print_options INTO rec_print_options;
3493: save_output => hr_general.char_to_bool(rec_print_options.save_output),
3494: print_together => l_print_together);
3495: -- Submit report
3496: if g_debug then
3497: hr_utility.set_location('payroll_action id '|| p_payroll_action_id,25);
3498: end if;
3499:
3500: /* Bug 4947424 - Check for Report Output Type and choose appropriate
3501: concurrent program to submit
3550: NULL, NULL, NULL, NULL, NULL, NULL,
3551: NULL, NULL, NULL, NULL
3552: );
3553: if g_debug then
3554: hr_utility.set_location('After calling report',24);
3555: end if;
3556:
3557: end spawn_archive_reports;
3558:
3566:
3567: begin
3568:
3569: IF g_debug THEN
3570: hr_utility.trace('Entering:' || g_package || 'check_report_parameters');
3571: END IF;
3572:
3573: if p_start_date is not null and p_end_date is null then
3574: raise e_bad_end_date;
3581:
3582: exception
3583: when e_bad_end_date
3584: then
3585: hr_utility.set_message(801, 'HR_AU_REC_MISSING_END_DATE');
3586: hr_utility.raise_error;
3587: when e_bad_combination_date
3588: then
3589: hr_utility.set_message(801, 'HR_AU_REC_COMBINATION_DATES');
3582: exception
3583: when e_bad_end_date
3584: then
3585: hr_utility.set_message(801, 'HR_AU_REC_MISSING_END_DATE');
3586: hr_utility.raise_error;
3587: when e_bad_combination_date
3588: then
3589: hr_utility.set_message(801, 'HR_AU_REC_COMBINATION_DATES');
3590: hr_utility.raise_error;
3585: hr_utility.set_message(801, 'HR_AU_REC_MISSING_END_DATE');
3586: hr_utility.raise_error;
3587: when e_bad_combination_date
3588: then
3589: hr_utility.set_message(801, 'HR_AU_REC_COMBINATION_DATES');
3590: hr_utility.raise_error;
3591:
3592: end check_report_parameters;
3593:
3586: hr_utility.raise_error;
3587: when e_bad_combination_date
3588: then
3589: hr_utility.set_message(801, 'HR_AU_REC_COMBINATION_DATES');
3590: hr_utility.raise_error;
3591:
3592: end check_report_parameters;
3593:
3594: BEGIN
3592: end check_report_parameters;
3593:
3594: BEGIN
3595: /*Bug 2610141 - Code added to remove the gscc warnings */
3596: g_debug := hr_utility.debug_enabled;
3597: g_package := 'pay_au_reconciliation_pkg.';
3598:
3599: end pay_au_reconciliation_pkg;