[Home] [Help]
107: AND set_of_books_id = p_set_of_books_id
108: AND peg.element_group_id (+) = pgel.element_group_id
109: and (peg.start_date_active between p_begin_date and p_end_date -- Bug 7582233
110: OR peg.end_date_active between p_begin_date and p_end_date)) pegl,-- Introduced for bug fix 3098050
111: psp_payroll_controls ppc -- Introduced for bug fix 2916848
112: WHERE
113: psl.person_id = p_person_id
114: AND psl.summary_line_id = pdl.summary_line_id
115: AND psl.assignment_id = p_assignment_id
187: AND set_of_books_id = p_set_of_books_id
188: AND peg.element_group_id (+) = pgel.element_group_id
189: and (peg.start_date_active between p_begin_date and p_end_date -- Bug 7582233
190: OR peg.end_date_active between p_begin_date and p_end_date)) pegl, -- Introduced for bug fix 3098050
191: psp_payroll_controls ppc -- Introduced for bug fix 2916848
192: WHERE
193: ppg.assignment_id = p_assignment_id
194: AND ppg.distribution_date between p_begin_date and p_end_date
195: AND ppg.business_group_id = p_business_group_id
257: AND set_of_books_id = p_set_of_books_id
258: AND peg.element_group_id (+) = pgel.element_group_id
259: and (peg.start_date_active between p_begin_date and p_end_date -- Bug 7582233
260: OR peg.end_date_active between p_begin_date and p_end_date)) pegl, -- Introduced for bug fix 3098050
261: psp_payroll_controls ppc -- Introduced for bug fix 2916848
262: WHERE
263: pal.assignment_id = p_assignment_id
264: AND pal.distribution_date between p_begin_date and p_end_date
265: AND pal.business_group_id = p_business_group_id
2263: approval_date = SYSDATE -- Added to fix bug 1661405. approval_date is a new column added to the table
2264: where adjustment_batch_name = p_batch_name;
2265:
2266: --Modified by Rashmi to update psp_payroll_control table.
2267: update psp_payroll_controls set status_code = 'N'
2268: where batch_name = p_batch_name and source_type = 'A'
2269: and status_code = 'C';
2270:
2271: commit;
2288: ----------P R O C E D U R E: UPDATE_PAYROLL_CONTROL -------------------------------
2289: --
2290: --
2291: -- Purpose: This procedure is called by procedure generate_lines described below.
2292: -- The purpose is to insert a record into psp_payroll_controls for
2293: -- every time_period_id that exists within the time frame of the
2294: -- adjusted lines for the batch. The psp_adjustment_lines table is
2295: -- updated with the new payroll_control_id for the time_period_id.
2296: --
2394: close get_payroll_id;
2395:
2396: --Modified the code by Rashmi to assign status = 'C' (for Creation).
2397:
2398: insert into psp_payroll_controls(
2399: payroll_control_id,
2400: payroll_action_id,
2401: payroll_source_code,
2402: source_type,
2478: close get_payroll_id;
2479:
2480: --Modified the code by Rashmi to assign status = 'C' (for Creation).
2481:
2482: select psp_payroll_controls_s.nextval into l_payroll_control_id from dual;
2483: insert into psp_payroll_controls(
2484: payroll_control_id,
2485: payroll_action_id,
2486: payroll_source_code,
2479:
2480: --Modified the code by Rashmi to assign status = 'C' (for Creation).
2481:
2482: select psp_payroll_controls_s.nextval into l_payroll_control_id from dual;
2483: insert into psp_payroll_controls(
2484: payroll_control_id,
2485: payroll_action_id,
2486: payroll_source_code,
2487: source_type,
3117: counter := 1;
3118:
3119: l_struc_num := psp_general.find_chart_of_accts(p_set_of_books_id,l_chart_of_accts);
3120:
3121: select psp_payroll_controls_s.nextval into l_payroll_control_id from dual;
3122:
3123: hr_utility.trace('l_payroll_control_id = '||l_payroll_control_id);
3124: hr_utility.trace('Inserting into PSP_ADJUSTMENT_CONTROL_TABLE : batch = '||p_batch_name);
3125:
4374:
4375: /*---------------------------------------------------------------------*/
4376: /*3. Delete the record for the rejected batch from PSP_PAYROLL_CONTROL */
4377: /*---------------------------------------------------------------------*/
4378: DELETE FROM psp_payroll_controls
4379: WHERE batch_name = p_batch_name
4380: AND source_type = 'A';
4381: IF (SQL%NOTFOUND) THEN
4382: errbuf := 'Failed when update psp_payroll_control table: no row found.';