[Home] [Help]
246: -- Replaced the following lines of code for bug fix 1769610 and included new set of codes
247:
248: SELECT psp_st_run_id_s.nextval
249: INTO g_run_id
250: FROM DUAL;
251:
252:
253: --- 2444657: derive run-mode
254: open derive_run_mode;
986:
987:
988: SELECT PSP_SUMMARY_LINES_S.NEXTVAL
989: INTO P_SUMMARY_LINE_ID
990: FROM DUAL;
991:
992: INSERT INTO PSP_SUMMARY_LINES(
993: SUMMARY_LINE_ID,
994: PERSON_ID,
1252: end if;
1253: -- get the group_id. Moved the group id out of payroll control id loop. Bug 1977939
1254: SELECT gl_interface_control_s.nextval
1255: INTO l_group_id
1256: FROM DUAL;
1257:
1258: l_rec_count := 0; -- MOVED this stmt, from inside the payroll control loop id Bug 1977939.
1259: OPEN gl_batch_cursor(pc_batch_rec.batch_name);
1260: LOOP
1384:
1385: -- insert into gl_interface_control
1386: SELECT GL_JOURNAL_IMPORT_S.NEXTVAL
1387: INTO l_int_run_id
1388: FROM DUAL;
1389:
1390: insert into gl_interface_control(
1391: je_source_name,
1392: status,
2916: FOR i in 1..org_id_tab.count
2917: LOOP
2918: SELECT to_char(psp_gms_batch_name_s.nextval)
2919: INTO gms_batch_name_tab(i)
2920: FROM dual;
2921: END LOOP;
2922: /*
2923: -- get the gms_batch_name for the summary batch
2924: SELECT to_char(psp_gms_batch_name_s.nextval)
2922: /*
2923: -- get the gms_batch_name for the summary batch
2924: SELECT to_char(psp_gms_batch_name_s.nextval)
2925: INTO l_gms_batch_name
2926: FROM DUAL;
2927: */
2928: OPEN pc_batch_cur;
2929: LOOP
2930: FETCH pc_batch_cur into pc_batch_rec;
3141: l_rec_count := l_rec_count + 1;
3142:
3143: select pa_txn_interface_s.nextval
3144: into l_txn_interface_id
3145: from dual;
3146:
3147: -- set the context to single to call pa_utils function
3148: mo_global.set_policy_context('S', gms_interface_rec.org_id );
3149:
4558: l_msg_id number(9);
4559: BEGIN
4560: SELECT PSP_STOUT_S.NEXTVAL
4561: INTO l_msg_id
4562: FROM DUAL;
4563:
4564: INSERT INTO PSP_STOUT(
4565: MSG_ID,
4566: MSG)