APPS.EGO_ITEM_OPEN_INTERFACE_PVT dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 169: FROM mtl_system_items_interface

165: /* Bug 5257590 - Checking for validation errors so status can be set to WARNING */
166: -- Bug: 5529588 - performance issue. Re-writing sql.
167: BEGIN
168: SELECT 1 INTO l_pro_flag_3
169: FROM mtl_system_items_interface
170: WHERE process_flag = 3
171: AND request_id = l_request_id
172: AND set_process_id = p_xset_id
173: AND rownum = 1;

Line 505: UPDATE mtl_system_items_interface

501: l_ret_status NUMBER;
502: dumm_status NUMBER := 0;
503: BEGIN
504: /* Set the template id passed to the Function in the interface row */
505: UPDATE mtl_system_items_interface
506: SET template_id = p_template_id
507: WHERE process_flag = 1
508: AND set_process_id = p_xset_id
509: AND((p_all_org = 1) or (organization_id = p_org_id));

Line 524: UPDATE mtl_system_items_interface

520: ,xset_id => p_xset_id
521: ,err_text => x_err_text);
522:
523: /* Set the template id back to null in the interface row to avoid reapplication */
524: UPDATE mtl_system_items_interface
525: SET template_id = null
526: WHERE process_flag = 1
527: AND set_process_id = p_xset_id
528: AND((p_all_org = 1) or (organization_id = p_org_id));

Line 742: FROM MTL_SYSTEM_ITEMS_INTERFACE msii, MTL_PARAMETERS mp

738: FND_FILE.put_line(FND_FILE.LOG, '----------------------------------------------------');
739: FND_FILE.put_line(FND_FILE.LOG, 'TRANSACTION TYPE ORGANIZATION CODE ITEM NUMBER');
740: FND_FILE.put_line(FND_FILE.LOG, '----------------------------------------------------');
741: FOR i IN (SELECT msii.TRANSACTION_TYPE, msii.ITEM_NUMBER, NVL(msii.ORGANIZATION_CODE, mp.ORGANIZATION_CODE) AS ORGANIZATION_CODE
742: FROM MTL_SYSTEM_ITEMS_INTERFACE msii, MTL_PARAMETERS mp
743: WHERE msii.SET_PROCESS_ID = p_batch_id
744: AND msii.REQUEST_ID = l_request_id
745: AND msii.ORGANIZATION_ID = mp.ORGANIZATION_ID
746: AND mp.MASTER_ORGANIZATION_ID = mp.ORGANIZATION_ID