DBA Data[Home] [Help]

APPS.PSP_ENC_SUM_TRAN dependencies on GL_INTERFACE_CONTROL

Line 1979: SELECT gl_interface_control_s.nextval

1975: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1977: END IF;
1978:
1979: SELECT gl_interface_control_s.nextval
1980: INTO l_group_id
1981: FROM dual;
1982:
1983: OPEN enc_control_cur;

Line 2156: insert into gl_interface_control(

2152: SELECT GL_JOURNAL_IMPORT_S.NEXTVAL
2153: INTO l_int_run_id
2154: FROM dual;
2155:
2156: insert into gl_interface_control(
2157: je_source_name,
2158: status,
2159: interface_run_id,
2160: group_id,

Line 2371: SELECT gl_interface_control_s.nextval

2367: END IF;
2368:
2369: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_enc_type_id: ' || l_enc_type_id);
2370:
2371: SELECT gl_interface_control_s.nextval
2372: INTO l_group_id
2373: FROM dual;
2374:
2375: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_group_id: ' || l_group_id);

Line 2450: INSERT INTO gl_interface_control

2446: FROM DUAL;
2447:
2448: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_int_run_id: ' || l_int_run_id);
2449:
2450: INSERT INTO gl_interface_control
2451: (je_source_name, status, interface_run_id,
2452: group_id, set_of_books_id)
2453: VALUES (l_user_je_source, 'S', l_int_run_id,
2454: l_group_id, g_set_of_books_id);

Line 2456: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Inserted control record into gl_interface_control');

2452: group_id, set_of_books_id)
2453: VALUES (l_user_je_source, 'S', l_int_run_id,
2454: l_group_id, g_set_of_books_id);
2455:
2456: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Inserted control record into gl_interface_control');
2457: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Before submitting Journal Import');
2458:
2459: req_id := fnd_request.submit_request( 'SQLGL',
2460: 'GLLEZL',