APPS.INVPULI2 dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 25: FROM MTL_SYSTEM_ITEMS_INTERFACE

21: transaction_id,
22: transaction_type,
23: rowid,
24: style_item_flag
25: FROM MTL_SYSTEM_ITEMS_INTERFACE
26: WHERE process_flag = 1
27: AND set_process_id = xset_id
28: AND ((organization_id = org_id) or (all_org = 1));
29:

Line 151: mtl_system_items_interface.transaction_type%TYPE;

147: INDEX BY BINARY_INTEGER;
148:
149: --Bug 4456453
150: TYPE transaction_table_type IS TABLE OF
151: mtl_system_items_interface.transaction_type%TYPE;
152:
153: template_table template_id_type;
154: transaction_table transaction_table_type; --Bug: 4456453
155:

Line 365: UPDATE mtl_system_items_interface

361:
362:
363: IF l_error_exists THEN
364:
365: UPDATE mtl_system_items_interface
366: SET process_flag = 3
367: WHERE rowid = cur.rowid ;
368: dumm_status := INVPUOPI.mtl_log_interface_err(
369: cur.organization_id,

Line 378: 'MTL_SYSTEM_ITEMS_INTERFACE',

374: request_id,
375: cur.transaction_id,
376: err_text,
377: l_column_name,
378: 'MTL_SYSTEM_ITEMS_INTERFACE',
379: l_message_name,
380: err_text);
381: if dumm_status < 0 then
382: raise LOGGING_ERR;

Line 386: UPDATE mtl_system_items_interface

382: raise LOGGING_ERR;
383: end if;
384:
385: ELSIF l_template_id IS NOT NULL AND l_template_id <> NVL (cur.template_id,0) THEN
386: UPDATE mtl_system_items_interface
387: SET template_id = l_template_id
388: WHERE rowid = cur.rowid;
389: END IF;
390: /* bug 10064010, instead of this we will call in process phase invupd2b

Line 413: 'MTL_SYSTEM_ITEMS_INTERFACE',

409: request_id,
410: cur.transaction_id,
411: err_text,
412: 'SERIAL_TAGGING_FLAG',
413: 'MTL_SYSTEM_ITEMS_INTERFACE',
414: 'INV_COPY_SER_FAIL_UNEXP',
415: err_text);
416: if dumm_status < 0 then
417: raise LOGGING_ERR;

Line 433: FROM mtl_system_items_interface

429: --with a template id in one go. template_id > 0 since, when called
430: --from ego_item_pub, it would have already applied the template.
431:
432: SELECT DISTINCT template_id, transaction_type BULK COLLECT INTO template_table, transaction_table
433: FROM mtl_system_items_interface
434: WHERE process_flag = 1
435: AND set_process_id = xset_id
436: AND ((organization_id = org_id) or (all_org = 1))
437: AND template_id > 0 ;

Line 1051: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

1047: end if; --Bug: 4456453 transaction_type
1048: commented for bug 6417006 */
1049: END LOOP; -- cursor cc
1050:
1051: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
1052: SET
1053: DESCRIPTION = nvl(DESCRIPTION , AttRec.DESCRIPTION),
1054: ACCEPTABLE_EARLY_DAYS = nvl(ACCEPTABLE_EARLY_DAYS , AttRec.ACCEPTABLE_EARLY_DAYS),
1055: ACCEPTABLE_RATE_DECREASE = nvl(ACCEPTABLE_RATE_DECREASE , AttRec.ACCEPTABLE_RATE_DECREASE),

Line 1340: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

1336: AND transaction_type = transaction_table(i);
1337:
1338: IF context_orgid IS NOT NULL THEN
1339:
1340: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
1341: SET
1342: BASE_ITEM_ID = nvl(BASE_ITEM_ID , AttRec.BASE_ITEM_ID),
1343: BASE_WARRANTY_SERVICE_ID = nvl(BASE_WARRANTY_SERVICE_ID , AttRec.BASE_WARRANTY_SERVICE_ID),
1344: COST_OF_SALES_ACCOUNT = nvl(COST_OF_SALES_ACCOUNT , AttRec.COST_OF_SALES_ACCOUNT),

Line 1372: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

1368: l_global_attribute_Category := CR.Global_attribute_category; --Bug 14169429
1369: IF (jg_globe_flex_val.reassign_context_code( l_global_attribute_Category) <> TRUE) THEN
1370: l_global_attribute_Category := CR.Global_attribute_category;
1371: END IF;
1372: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
1373: SET
1374: Global_attribute_Category = nvl(Global_attribute_Category,l_global_attribute_Category),
1375: Global_attribute1 = nvl(Global_attribute1,CR.Global_attribute1),
1376: Global_attribute2 = nvl(Global_attribute2,CR.Global_attribute2),

Line 1448: FROM mtl_system_items_interface

1444: x_ret_sts VARCHAR2(1);
1445:
1446: CURSOR trans_cur IS
1447: SELECT transaction_id,inventory_item_id,organization_id
1448: FROM mtl_system_items_interface
1449: WHERE process_flag = 1
1450: AND set_process_id = p_xset_id
1451: AND((p_all_org = 1) or (organization_id = p_org_id));
1452:

Line 1460: UPDATE mtl_system_items_interface

1456: WHILE l_index IS NOT NULL
1457: LOOP
1458: l_template_id := p_template_tbl(l_index);
1459: /* Set the template id passed to the Function in the interface row */
1460: UPDATE mtl_system_items_interface
1461: SET template_id = l_template_id
1462: WHERE process_flag = 1
1463: AND set_process_id = p_xset_id
1464: AND((p_all_org = 1) or (organization_id = p_org_id));

Line 1513: UPDATE mtl_system_items_interface

1509:
1510:
1511: END LOOP;
1512: /* Set the template id back to null in the interface row to avoid reapplication */
1513: UPDATE mtl_system_items_interface
1514: SET template_id = null
1515: WHERE process_flag = 1
1516: AND set_process_id = p_xset_id
1517: AND((p_all_org = 1) or (organization_id = p_org_id));