eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MTL_RELATED_ITEMS_PVT dependencies on MTL_RELATED_ITEMS_INTERFACE

Line 2217: -- MTL_RELATED_ITEMS_INTERFACE for processing.

2213: -- -----------------------------------------------------------------------------
2214: -- Procedure Name: Process_Rel_Items_Rows
2215: --
2216: -- Description : Concurrent program to pull rows from
2217: -- MTL_RELATED_ITEMS_INTERFACE for processing.
2218: -- Does not support planning details.
2219: -- -----------------------------------------------------------------------------
2220: PROCEDURE Process_Rel_Items_Rows(
2221: ERRBUF OUT NOCOPY VARCHAR2,

Line 2253: FROM MTL_RELATED_ITEMS_INTERFACE A

2249: -- or all records if parameter is NULL
2250: -- and process flag is 1
2251: CURSOR C_INTF_ROWS(C_DATA_SET_ID NUMBER) IS
2252: SELECT A.ROWID,A.*
2253: FROM MTL_RELATED_ITEMS_INTERFACE A
2254: WHERE DECODE(C_DATA_SET_ID, NULL, -1, A.SET_PROCESS_ID) = NVL(C_DATA_SET_ID, -1)
2255: AND a.PROCESS_FLAG = 1;
2256:
2257: BEGIN

Line 2268: UPDATE MTL_RELATED_ITEMS_INTERFACE

2264:
2265: L_PROC_REC_COUNT := 0;
2266:
2267: FOR L_MTL_REL_ITEM_REC IN C_INTF_ROWS(P_DATA_SET_ID) LOOP
2268: UPDATE MTL_RELATED_ITEMS_INTERFACE
2269: SET TRANSACTION_ID = MTL_RELATED_ITEMS_INTERFACE_S.NEXTVAL,
2270: REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID
2271: WHERE ROWID = l_mtl_Rel_Item_rec.ROWID;
2272: END LOOP;

Line 2269: SET TRANSACTION_ID = MTL_RELATED_ITEMS_INTERFACE_S.NEXTVAL,

2265: L_PROC_REC_COUNT := 0;
2266:
2267: FOR L_MTL_REL_ITEM_REC IN C_INTF_ROWS(P_DATA_SET_ID) LOOP
2268: UPDATE MTL_RELATED_ITEMS_INTERFACE
2269: SET TRANSACTION_ID = MTL_RELATED_ITEMS_INTERFACE_S.NEXTVAL,
2270: REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID
2271: WHERE ROWID = l_mtl_Rel_Item_rec.ROWID;
2272: END LOOP;
2273:

Line 2303: ,p_table_name => 'MTL_RELATED_ITEMS_INTERFACE'

2299: ,p_application_id => 'EGO'
2300: ,p_message_type => 'E'
2301: ,p_entity_code => G_Entity_Code
2302: ,p_entity_index => 1
2303: ,p_table_name => 'MTL_RELATED_ITEMS_INTERFACE'
2304: );
2305:
2306: l_msg_count := 1;
2307: Error_Handler.Get_Entity_Message(G_Entity_Code, l_msg_list);

Line 2326: ,p_table_name => 'MTL_RELATED_ITEMS_INTERFACE'

2322: ,p_application_id => 'EGO'
2323: ,p_message_type => 'E'
2324: ,p_entity_code => G_Entity_Code
2325: ,p_entity_index => 1
2326: ,p_table_name => 'MTL_RELATED_ITEMS_INTERFACE'
2327: );
2328:
2329: l_msg_count := 1;
2330: Error_Handler.Get_Entity_Message(G_Entity_Code, l_msg_list);

Line 2358: ,p_table_name => 'MTL_RELATED_ITEMS_INTERFACE'

2354: ,p_application_id => 'EGO'
2355: ,p_message_type => 'E'
2356: ,p_entity_code => G_Entity_Code
2357: ,p_entity_index => 1
2358: ,p_table_name => 'MTL_RELATED_ITEMS_INTERFACE'
2359: );
2360:
2361: l_msg_count := 1;
2362: Error_Handler.Get_Entity_Message(G_Entity_Code, l_msg_list);

Line 2381: ,p_table_name => 'MTL_RELATED_ITEMS_INTERFACE'

2377: ,p_application_id => 'EGO'
2378: ,p_message_type => 'E'
2379: ,p_entity_code => G_Entity_Code
2380: ,p_entity_index => 1
2381: ,p_table_name => 'MTL_RELATED_ITEMS_INTERFACE'
2382: );
2383: l_msg_count := 1;
2384: Error_Handler.Get_Entity_Message(G_Entity_Code, l_msg_list);
2385:

Line 2412: ,p_table_name => 'MTL_RELATED_ITEMS_INTERFACE'

2408: ,p_application_id => 'EGO'
2409: ,p_message_type => 'E'
2410: ,p_entity_code => G_Entity_Code
2411: ,p_entity_index => 1
2412: ,p_table_name => 'MTL_RELATED_ITEMS_INTERFACE'
2413: );
2414:
2415: l_msg_count := 1;
2416: Error_Handler.Get_Entity_Message(G_Entity_Code, l_msg_list);

Line 2433: ,p_table_name => 'MTL_RELATED_ITEMS_INTERFACE'

2429: ,p_application_id => 'EGO'
2430: ,p_message_type => 'E'
2431: ,p_entity_code => G_Entity_Code
2432: ,p_entity_index => 1
2433: ,p_table_name => 'MTL_RELATED_ITEMS_INTERFACE'
2434: );
2435: l_msg_count := 1;
2436: Error_Handler.Get_Entity_Message(G_Entity_Code, l_msg_list);
2437:

Line 2512: UPDATE MTL_RELATED_ITEMS_INTERFACE

2508: );
2509: END IF;
2510:
2511: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2512: UPDATE MTL_RELATED_ITEMS_INTERFACE
2513: SET process_flag = 3
2514: WHERE Transaction_Id = l_mtl_Rel_Item_rec.Transaction_Id;
2515:
2516: -- looping to take out the messages

Line 2534: ,tbl_name => 'MTL_RELATED_ITEMS_INTERFACE'

2530: ,req_id => fnd_global.conc_request_id
2531: ,trans_id => l_mtl_Rel_Item_rec.Transaction_Id
2532: ,error_text => l_msg.message_text
2533: ,p_column_name => null
2534: ,tbl_name => 'MTL_RELATED_ITEMS_INTERFACE'
2535: ,msg_name => l_msg.message_name
2536: ,err_text => l_err_text -- error text out
2537: );
2538: END LOOP;

Line 2546: UPDATE MTL_RELATED_ITEMS_INTERFACE

2542: l_err_count := 1;
2543:
2544: ELSE
2545: Write_Debug('Transaction ' ||To_Char(l_mtl_Rel_Item_rec.Transaction_Id)|| ' has completed successfully.');
2546: UPDATE MTL_RELATED_ITEMS_INTERFACE
2547: SET process_flag = 7
2548: WHERE Transaction_Id = l_mtl_Rel_Item_rec.Transaction_Id;
2549: END IF;
2550: END LOOP;

Line 2593: DELETE FROM MTL_RELATED_ITEMS_INTERFACE

2589:
2590: BEGIN
2591:
2592: LOOP
2593: DELETE FROM MTL_RELATED_ITEMS_INTERFACE
2594: WHERE process_flag = l_process_flag_7
2595: AND set_process_id=p_data_set_id
2596: AND rownum < l_rownum;
2597: