[Home] [Help]
344:
345: BEGIN
346: SELECT psp_st_run_id_s.nextval
347: INTO g_run_id
348: FROM dual;
349: open payroll_control_cur2;
350: loop
351: fetch payroll_control_cur2 into l_payroll_control_id;
352: if payroll_control_cur2%notfound then
1095: -- Code ended for Enhancement Employee Assignment with Zero Work Days
1096:
1097: SELECT PSP_SUMMARY_LINES_S.NEXTVAL
1098: INTO P_SUMMARY_LINE_ID
1099: FROM DUAL;
1100: INSERT INTO PSP_SUMMARY_LINES(
1101: SUMMARY_LINE_ID,
1102: PERSON_ID,
1103: ASSIGNMENT_ID,
1349: -- get the group_id
1350:
1351: SELECT gl_interface_control_s.nextval
1352: INTO l_group_id
1353: FROM dual;
1354:
1355: BEGIN
1356: --- uncommented the end date for 2663344
1357: SELECT substr(period_name,1,35),end_date
1490: -- insert into gl_interface_control
1491:
1492: SELECT GL_JOURNAL_IMPORT_S.NEXTVAL
1493: INTO l_int_run_id
1494: FROM dual;
1495:
1496: INSERT into gl_interface_control(je_source_name,status,interface_run_id,
1497: group_id,set_of_books_id)
1498: VALUES (l_user_je_source_name, 'S',l_int_run_id,
3655: FOR I in 1..org_id_tab.count
3656: LOOP
3657: SELECT to_char(psp_gms_batch_name_s.nextval)
3658: INTO gms_batch_name_tab(i)
3659: FROM dual;
3660: END LOOP;
3661: /*
3662: -- get the group_id
3663: SELECT to_char(psp_gms_batch_name_s.nextval)
3661: /*
3662: -- get the group_id
3663: SELECT to_char(psp_gms_batch_name_s.nextval)
3664: INTO l_gms_batch_name
3665: FROM dual;
3666: */
3667: -- R12 MOAC Uptake. Moved this code to loop
3668: -- update psp_summary_lines with gms batch name
3669: FOR I in 1..org_id_tab.count
3786: -- Get the transaction_interface_id. We need this to populate the gms_interface table.
3787:
3788: select pa_txn_interface_s.nextval
3789: into l_txn_interface_id
3790: from dual;
3791:
3792: -- get the expenditure week ending date
3793:
3794: -- set the context to single to call pa_utils function
5887: ', p_time_period_id='||p_time_period_id);
5888:
5889: select psp_wf_item_key_s.nextval
5890: into l_wf_itemkey
5891: from dual;
5892:
5893: if p_source_type = 'A' then
5894: l_superceding_process := 'PSP: Summarize And Transfer Adjustments';
5895: l_superceding_proc_param := p_batch_name;