[Home] [Help]
150: The procedure processes assignments in 'chunks' to facilitate multi-threaded
151: operation. The chunk is defined by the size and the starting and ending person id.
152:
153: One assignment action is created for each payroll period for each assignment
154: Creates action for Group4 XML - Individual_Payroll_Detailed_Records
155: Best way is to do Group3 also in multithreaded level. But Sorting
156: requirements won't be met.
157:
158: *****************************************************************************/
259: END IF;
260:
261: SELECT pay_assignment_actions_s.NEXTVAL
262: INTO l_actid
263: FROM dual;
264:
265:
266: hr_nonrun_asact.insact(l_actid,i.assignment_id,p_pactid,p_chunk,NULL);
267:
545: AND PBT_TL.language = userenv('LANG')
546: AND g_end_date BETWEEN fnd_date.canonical_to_date(hoi.org_information5) AND NVL(fnd_date.canonical_to_date(hoi.org_information6),TO_DATE('4712/12/31','YYYY/MM/DD'));
547:
548:
549: /* Group 3 Individual Payroll Records */
550: -- Group each assignment by payroll
551: CURSOR csr_asg IS
552: SELECT paf.assignment_id ,
553: paf.assignment_number,
1427: IF nvl(l_count,0) >0 THEN
1428:
1429: SELECT USERENV('LANG')
1430: into l_lang
1431: from dual;
1432:
1433: IF l_lang='US' THEN
1434: l_set_layout := fnd_request.add_layout('PAY','PYCNAOT','en','US','PDF');
1435: ELSE
1520: Name : sort_action
1521: Arguments : 1. payroll_action_id
1522: 2. sql_string for deciding the sort order of data.
1523: 3. length of the sql_string
1524: Description : This procedure sorts the individual xml's generated by
1525: assact_xml procedure based on SERIAL_NUMBER column which
1526: is populated with payroll year, payroll period and payroll id.
1527: *****************************************************************************/
1528: