APPS.PSP_SUM_ADJ dependencies on GL_INTERFACE_CONTROL

Line 1254: SELECT gl_interface_control_s.nextval

1250: close pc_batch_cur;
1251: exit;
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.

Line 1385: -- insert into gl_interface_control

1381: null;
1382:
1383: end;
1384:
1385: -- insert into gl_interface_control
1386: SELECT GL_JOURNAL_IMPORT_S.NEXTVAL
1387: INTO l_int_run_id
1388: FROM DUAL;
1389:

Line 1390: 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,
1393: interface_run_id,
1394: group_id,

Line 1708: delete from gl_interface_control

1704: delete from gl_interface
1705: where group_id = l_group_id
1706: and user_je_source_name = 'OLD';
1707:
1708: delete from gl_interface_control
1709: where group_id = l_group_id
1710: and je_source_name = 'OLD';
1711:
1712: commit;

Line 4168: delete from gl_interface_control

4164: where user_je_source_name = l_user_je_source_name
4165: and group_id = p_group_id ;
4166:
4167: --- Added this stmt for Bug 2133056
4168: delete from gl_interface_control
4169: where je_source_name = l_user_je_source_name
4170: and group_id = p_group_id;
4171:
4172: end if;

Line 4334: delete from gl_interface_control

4330: delete from gl_interface
4331: where group_id = l_group_id
4332: and user_je_source_name = 'OLD';
4333:
4334: delete from gl_interface_control
4335: where group_id = l_group_id
4336: and je_source_name = 'OLD';
4337: end if;
4338: