APPS.IBW_OE_PVT dependencies on IBW_CONTEXT_INTERFACE_TL

Line 2241: INSERT INTO ibw_context_interface_tl cont_tl

2237: ,'NONE',1,l_user_id,SYSDATE,l_user_id,SYSDATE,l_last_update_login,l_program_id,l_program_login_id,l_program_app_id,l_request_id);
2238:
2239: -- Inserting record with 'NONE' AS the business context IN TL Table
2240:
2241: INSERT INTO ibw_context_interface_tl cont_tl
2242: ( context_interface_id
2243: ,language
2244: ,context_instance_name
2245: ,source_lang

Line 2368: -- For populating the IBW_CONTEXT_INTERFACE_TL table

2364: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Context Load Program Return Status 1:' || x_return_status );
2365:
2366: end;
2367:
2368: -- For populating the IBW_CONTEXT_INTERFACE_TL table
2369:
2370: -- Here the Primary Key is combination of context_interface_id (FROM ibw_context_interface_b) AND language column
2371:
2372: begin

Line 2373: MERGE INTO ibw_context_interface_tl cont_tl

2369:
2370: -- Here the Primary Key is combination of context_interface_id (FROM ibw_context_interface_b) AND language column
2371:
2372: begin
2373: MERGE INTO ibw_context_interface_tl cont_tl
2374: USING (SELECT
2375: cont.context_interface_id context_interface_id /* Changed the query for Performance Bug No 4777097 */
2376: ,sect.display_name context_instance_name /* SQLID: 14752675. Removed FND_LANGUAGES table from the */
2377: ,sect.language language /* query thereby avoiding MERGE CARTESIAN JOIN */

Line 2436: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception in Context Load Program -Merge of ibw_context_interface_tl :' || sqlerrm);

2432: WHEN OTHERS THEN
2433: ROLLBACK;
2434: --dbms_output.put_line('CONTEXT_LOAD:' || sqlerrm);
2435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2436: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception in Context Load Program -Merge of ibw_context_interface_tl :' || sqlerrm);
2437: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Context Load Program Return Status 2:' || x_return_status );
2438: end;
2439: COMMIT;
2440: