APPS.PSP_SUM_TRANS dependencies on GL_INTERFACE_CONTROL

Line 1351: SELECT gl_interface_control_s.nextval

1347: END IF;
1348:
1349: -- get the group_id
1350:
1351: SELECT gl_interface_control_s.nextval
1352: INTO l_group_id
1353: FROM dual;
1354:
1355: BEGIN

Line 1490: -- insert into gl_interface_control

1486: WHEN others THEN
1487: NULL;
1488: END;
1489:
1490: -- insert into gl_interface_control
1491:
1492: SELECT GL_JOURNAL_IMPORT_S.NEXTVAL
1493: INTO l_int_run_id
1494: FROM dual;

Line 1496: INSERT into gl_interface_control(je_source_name,status,interface_run_id,

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,
1499: l_group_id,p_set_of_books_id);
1500:

Line 1947: delete gl_interface_Control

1943: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1945: END IF;
1946:
1947: delete gl_interface_Control
1948: where group_id = p_group_id
1949: and je_source_name = l_user_je_source_name;
1950:
1951: update psp_payroll_controls