[Home] [Help]
109: and (p_begin_date between peg.start_date_active and peg.end_date_active -- Bug 8970980
110: OR p_end_date between peg.start_date_active and peg.end_date_active )
111: group by pgel.element_type_id --Bug 14128743
112: ) pegl,-- Introduced for bug fix 3098050
113: psp_payroll_controls ppc -- Introduced for bug fix 2916848
114: WHERE
115: psl.person_id = p_person_id
116: AND psl.summary_line_id = pdl.summary_line_id
117: AND psl.assignment_id = p_assignment_id
191: and (p_begin_date between peg.start_date_active and peg.end_date_active -- Bug 8970980
192: OR p_end_date between peg.start_date_active and peg.end_date_active)
193: group by pgel.element_type_id -- Bug 14128743
194: ) pegl, -- Introduced for bug fix 3098050
195: psp_payroll_controls ppc -- Introduced for bug fix 2916848
196: WHERE
197: ppg.assignment_id = p_assignment_id
198: AND ppg.distribution_date between p_begin_date and p_end_date
199: AND ppg.business_group_id = p_business_group_id
263: and (p_begin_date between peg.start_date_active and peg.end_date_active -- Bug 8970980
264: OR p_end_date between peg.start_date_active and peg.end_date_active)
265: group by pgel.element_type_id -- Bug 14128743
266: ) pegl, -- Introduced for bug fix 3098050
267: psp_payroll_controls ppc -- Introduced for bug fix 2916848
268: WHERE
269: pal.assignment_id = p_assignment_id
270: AND pal.distribution_date between p_begin_date and p_end_date
271: AND pal.business_group_id = p_business_group_id
2272: approval_date = SYSDATE -- Added to fix bug 1661405. approval_date is a new column added to the table
2273: where adjustment_batch_name = p_batch_name;
2274:
2275: --Modified by Rashmi to update psp_payroll_control table.
2276: update psp_payroll_controls set status_code = 'N'
2277: where batch_name = p_batch_name and source_type = 'A'
2278: and status_code = 'C';
2279:
2280: commit;
2297: ----------P R O C E D U R E: UPDATE_PAYROLL_CONTROL -------------------------------
2298: --
2299: --
2300: -- Purpose: This procedure is called by procedure generate_lines described below.
2301: -- The purpose is to insert a record into psp_payroll_controls for
2302: -- every time_period_id that exists within the time frame of the
2303: -- adjusted lines for the batch. The psp_adjustment_lines table is
2304: -- updated with the new payroll_control_id for the time_period_id.
2305: --
2403: close get_payroll_id;
2404:
2405: --Modified the code by Rashmi to assign status = 'C' (for Creation).
2406:
2407: insert into psp_payroll_controls(
2408: payroll_control_id,
2409: payroll_action_id,
2410: payroll_source_code,
2411: source_type,
2487: close get_payroll_id;
2488:
2489: --Modified the code by Rashmi to assign status = 'C' (for Creation).
2490:
2491: select psp_payroll_controls_s.nextval into l_payroll_control_id from dual;
2492: insert into psp_payroll_controls(
2493: payroll_control_id,
2494: payroll_action_id,
2495: payroll_source_code,
2488:
2489: --Modified the code by Rashmi to assign status = 'C' (for Creation).
2490:
2491: select psp_payroll_controls_s.nextval into l_payroll_control_id from dual;
2492: insert into psp_payroll_controls(
2493: payroll_control_id,
2494: payroll_action_id,
2495: payroll_source_code,
2496: source_type,
3126: counter := 1;
3127:
3128: l_struc_num := psp_general.find_chart_of_accts(p_set_of_books_id,l_chart_of_accts);
3129:
3130: select psp_payroll_controls_s.nextval into l_payroll_control_id from dual;
3131:
3132: hr_utility.trace('l_payroll_control_id = '||l_payroll_control_id);
3133: hr_utility.trace('Inserting into PSP_ADJUSTMENT_CONTROL_TABLE : batch = '||p_batch_name);
3134:
4383:
4384: /*---------------------------------------------------------------------*/
4385: /*3. Delete the record for the rejected batch from PSP_PAYROLL_CONTROL */
4386: /*---------------------------------------------------------------------*/
4387: DELETE FROM psp_payroll_controls
4388: WHERE batch_name = p_batch_name
4389: AND source_type = 'A';
4390: IF (SQL%NOTFOUND) THEN
4391: errbuf := 'Failed when update psp_payroll_control table: no row found.';