[Home] [Help]
165: compare_archive_data so that if the
166: number of archived items to be compared
167: is different then the amendment flag is
168: set to Y without checking all the
169: individual data records.
170: 21-FEB-2004 pganguly 115.55 Fixed bug# 3459723. Changed the cursor
171: c_get_asg_id so that it picks
172: assignment of type 'E' only.
173: 02-APR-2004 ssattini 115.56 11510 Changes to fix bug#3356533.
382: p_jurisdiction_context - Should the JURISDICTION_CODE context be set up
383: for the testing of the balance.
384:
385: Notes : This routine provides a way of coding explicit rules for
386: individual reports where they are different from the
387: standard selection criteria for the report type ie. in
388: NY state the selection of people in the 4th quarter is
389: different from the first 3.
390: */
1323: combination. */
1324:
1325: select pay_assignment_actions_s.nextval
1326: into lockingactid
1327: from dual;
1328:
1329: /* Insert into pay_assignment_actions. */
1330:
1331: hr_utility.trace('creating assignment action');
1893: l_flag varchar2(1);
1894:
1895: cursor c_chk_payroll_action is
1896: select 'Y'
1897: from dual
1898: where exists (select null
1899: from ff_archive_items fai
1900: where fai.context1 = p_payroll_action_id);
1901: begin
2556:
2557: hr_utility.trace('2');
2558:
2559: select l_rl1_last_slip_number + pay_ca_eoy_rl1_s.nextval - 1
2560: into l_rl1_curr_slip_number from dual;
2561:
2562: hr_utility.trace('1');
2563:
2564: select mod(l_rl1_curr_slip_number,7)
2562: hr_utility.trace('1');
2563:
2564: select mod(l_rl1_curr_slip_number,7)
2565: into l_rl1_slip_number_last_digit
2566: from dual;
2567:
2568: hr_utility.trace('l_rl1_slip_number_last_digit : '||
2569: l_rl1_slip_number_last_digit);
2570:
3273: end if;
3274:
3275: end loop;
3276:
3277: /* Archive BOXO, which is sum of all the individual
3278: balances under BOXO, also determine the correct
3279: BOXO code that needs to be archived */
3280:
3281: l_user_entity_value_tab_boxo := 0;