[Home] [Help]
397:
398: BEGIN
399: SELECT psp_st_run_id_s.nextval
400: INTO g_run_id
401: FROM dual;
402: open payroll_control_cur2;
403: loop
404: fetch payroll_control_cur2 into l_payroll_control_id;
405: if payroll_control_cur2%notfound then
1178: -- Code ended for Enhancement Employee Assignment with Zero Work Days
1179:
1180: SELECT PSP_SUMMARY_LINES_S.NEXTVAL
1181: INTO P_SUMMARY_LINE_ID
1182: FROM DUAL;
1183: INSERT INTO PSP_SUMMARY_LINES(
1184: SUMMARY_LINE_ID,
1185: PERSON_ID,
1186: ASSIGNMENT_ID,
1436: -- get the group_id
1437:
1438: SELECT gl_interface_control_s.nextval
1439: INTO l_group_id
1440: FROM dual;
1441:
1442: BEGIN
1443: --- uncommented the end date for 2663344
1444: SELECT substr(period_name,1,35),end_date
1587: -- insert into gl_interface_control
1588:
1589: SELECT GL_JOURNAL_IMPORT_S.NEXTVAL
1590: INTO l_int_run_id
1591: FROM dual;
1592: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' insert into gl_interface_control');
1593: INSERT into gl_interface_control(je_source_name,status,interface_run_id,
1594: group_id,set_of_books_id)
1595: VALUES (l_user_je_source_name, 'S',l_int_run_id,
3850: FOR I in 1..org_id_tab.count
3851: LOOP
3852: SELECT to_char(psp_gms_batch_name_s.nextval)
3853: INTO gms_batch_name_tab(i)
3854: FROM dual;
3855: END LOOP;
3856: /*
3857: -- get the group_id
3858: SELECT to_char(psp_gms_batch_name_s.nextval)
3856: /*
3857: -- get the group_id
3858: SELECT to_char(psp_gms_batch_name_s.nextval)
3859: INTO l_gms_batch_name
3860: FROM dual;
3861: */
3862: -- R12 MOAC Uptake. Moved this code to loop
3863: -- update psp_summary_lines with gms batch name
3864: FOR I in 1..org_id_tab.count
3986: -- Get the transaction_interface_id. We need this to populate the gms_interface table.
3987:
3988: select pa_txn_interface_s.nextval
3989: into l_txn_interface_id
3990: from dual;
3991:
3992: -- get the expenditure week ending date
3993:
3994: -- set the context to single to call pa_utils function
6310: ', p_time_period_id='||p_time_period_id);
6311:
6312: select psp_wf_item_key_s.nextval
6313: into l_wf_itemkey
6314: from dual;
6315:
6316: if p_source_type = 'A' then
6317: l_superceding_process := 'PSP: Summarize And Transfer Adjustments';
6318: l_superceding_proc_param := p_batch_name;