APPS.PSP_SUM_TRANS dependencies on GL_INTERFACE_CONTROL

Line 1438: SELECT gl_interface_control_s.nextval

1434: END IF;
1435:
1436: -- get the group_id
1437:
1438: SELECT gl_interface_control_s.nextval
1439: INTO l_group_id
1440: FROM dual;
1441:
1442: BEGIN

Line 1587: -- insert into gl_interface_control

1583: NULL;
1584: END;
1585: */
1586:
1587: -- insert into gl_interface_control
1588:
1589: SELECT GL_JOURNAL_IMPORT_S.NEXTVAL
1590: INTO l_int_run_id
1591: FROM dual;

Line 1592: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' 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,
1596: l_group_id,p_set_of_books_id);

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

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,
1596: l_group_id,p_set_of_books_id);
1597:

Line 2066: delete gl_interface_Control

2062: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2064: END IF;
2065:
2066: delete gl_interface_Control
2067: where group_id = p_group_id
2068: and je_source_name = l_user_je_source_name;
2069:
2070: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted from gl_interface_control count: '||sql%rowcount);

Line 2070: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted from gl_interface_control count: '||sql%rowcount);

2066: delete gl_interface_Control
2067: where group_id = p_group_id
2068: and je_source_name = l_user_je_source_name;
2069:
2070: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted from gl_interface_control count: '||sql%rowcount);
2071:
2072: update psp_payroll_controls
2073: set phase = null
2074: where payroll_control_id = p_payroll_control_id;