APPS.EGO_ITEM_OPEN_INTERFACE_PVT dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 194: FROM mtl_system_items_interface

190: /* Bug 5257590 - Checking for validation errors so status can be set to WARNING */
191: -- Bug: 5529588 - performance issue. Re-writing sql.
192: BEGIN
193: SELECT 1 INTO l_pro_flag_3
194: FROM mtl_system_items_interface
195: WHERE process_flag = 3
196: AND request_id = l_request_id
197: AND set_process_id = p_xset_id
198: AND rownum = 1;

Line 203: /* bug 12603272 if no row in mtl_system_items_interface marks as error status, check mtl_item_revisions_interface */

199: EXCEPTION WHEN NO_DATA_FOUND THEN
200: l_pro_flag_3 := 0;
201: END;
202:
203: /* bug 12603272 if no row in mtl_system_items_interface marks as error status, check mtl_item_revisions_interface */
204: IF l_inv_debug_level IN(101, 102) THEN
205: INVPUTLI.info('l_pro_flag_3 from table mtl_system_items_interface ' || l_pro_flag_3 );
206: END IF;
207:

Line 205: INVPUTLI.info('l_pro_flag_3 from table mtl_system_items_interface ' || l_pro_flag_3 );

201: END;
202:
203: /* bug 12603272 if no row in mtl_system_items_interface marks as error status, check mtl_item_revisions_interface */
204: IF l_inv_debug_level IN(101, 102) THEN
205: INVPUTLI.info('l_pro_flag_3 from table mtl_system_items_interface ' || l_pro_flag_3 );
206: END IF;
207:
208: if l_pro_flag_3 = 0 then
209: SELECT count(*) INTO l_pro_flag_3

Line 565: UPDATE mtl_system_items_interface

561: l_ret_status NUMBER;
562: dumm_status NUMBER := 0;
563: BEGIN
564: /* Set the template id passed to the Function in the interface row */
565: UPDATE mtl_system_items_interface
566: SET template_id = p_template_id
567: WHERE process_flag = 1
568: AND set_process_id = p_xset_id
569: AND((p_all_org = 1) or (organization_id = p_org_id));

Line 584: UPDATE mtl_system_items_interface

580: ,xset_id => p_xset_id
581: ,err_text => x_err_text);
582:
583: /* Set the template id back to null in the interface row to avoid reapplication */
584: UPDATE mtl_system_items_interface
585: SET template_id = null
586: WHERE process_flag = 1
587: AND set_process_id = p_xset_id
588: AND((p_all_org = 1) or (organization_id = p_org_id));

Line 810: FROM MTL_SYSTEM_ITEMS_INTERFACE msii, MTL_PARAMETERS mp

806: -- results only to master organization.
807: -- sreharih. Thu Mar 24 12:45:06 PDT 2011
808: --
809: FOR i IN (SELECT msii.TRANSACTION_TYPE, msii.ITEM_NUMBER, NVL(msii.ORGANIZATION_CODE, mp.ORGANIZATION_CODE) AS ORGANIZATION_CODE
810: FROM MTL_SYSTEM_ITEMS_INTERFACE msii, MTL_PARAMETERS mp
811: WHERE msii.SET_PROCESS_ID = p_batch_id
812: AND msii.REQUEST_ID = l_request_id
813: AND msii.ORGANIZATION_ID = mp.ORGANIZATION_ID
814: --AND mp.MASTER_ORGANIZATION_ID = mp.ORGANIZATION_ID Bug 11901255