APPS.INVPULI2 dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 24: FROM MTL_SYSTEM_ITEMS_INTERFACE

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

Line 109: mtl_system_items_interface.transaction_type%TYPE;

105: INDEX BY BINARY_INTEGER;
106:
107: --Bug 4456453
108: TYPE transaction_table_type IS TABLE OF
109: mtl_system_items_interface.transaction_type%TYPE;
110:
111: template_table template_id_type;
112: transaction_table transaction_table_type; --Bug: 4456453
113:

Line 219: UPDATE mtl_system_items_interface

215:
216:
217: IF l_error_exists THEN
218:
219: UPDATE mtl_system_items_interface
220: SET process_flag = 3
221: WHERE rowid = cur.rowid ;
222: dumm_status := INVPUOPI.mtl_log_interface_err(
223: cur.organization_id,

Line 232: 'MTL_SYSTEM_ITEMS_INTERFACE',

228: request_id,
229: cur.transaction_id,
230: err_text,
231: l_column_name,
232: 'MTL_SYSTEM_ITEMS_INTERFACE',
233: l_message_name,
234: err_text);
235: if dumm_status < 0 then
236: raise LOGGING_ERR;

Line 240: UPDATE mtl_system_items_interface

236: raise LOGGING_ERR;
237: end if;
238:
239: ELSIF l_template_id IS NOT NULL AND l_template_id <> NVL (cur.template_id,0) THEN
240: UPDATE mtl_system_items_interface
241: SET template_id = l_template_id
242: WHERE rowid = cur.rowid;
243: END IF;
244:

Line 252: FROM mtl_system_items_interface

248: --with a template id in one go. template_id > 0 since, when called
249: --from ego_item_pub, it would have already applied the template.
250:
251: SELECT DISTINCT template_id, transaction_type BULK COLLECT INTO template_table, transaction_table
252: FROM mtl_system_items_interface
253: WHERE process_flag = 1
254: AND set_process_id = xset_id
255: AND ((organization_id = org_id) or (all_org = 1))
256: AND template_id > 0 ;

Line 870: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

866: end if; --Bug: 4456453 transaction_type
867: commented for bug 6417006 */
868: END LOOP; -- cursor cc
869:
870: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
871: SET
872: DESCRIPTION = nvl(DESCRIPTION , AttRec.DESCRIPTION),
873: ACCEPTABLE_EARLY_DAYS = nvl(ACCEPTABLE_EARLY_DAYS , AttRec.ACCEPTABLE_EARLY_DAYS),
874: ACCEPTABLE_RATE_DECREASE = nvl(ACCEPTABLE_RATE_DECREASE , AttRec.ACCEPTABLE_RATE_DECREASE),

Line 1157: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

1153: AND transaction_type = transaction_table(i);
1154:
1155: IF context_orgid IS NOT NULL THEN
1156:
1157: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
1158: SET
1159: BASE_ITEM_ID = nvl(BASE_ITEM_ID , AttRec.BASE_ITEM_ID),
1160: BASE_WARRANTY_SERVICE_ID = nvl(BASE_WARRANTY_SERVICE_ID , AttRec.BASE_WARRANTY_SERVICE_ID),
1161: COST_OF_SALES_ACCOUNT = nvl(COST_OF_SALES_ACCOUNT , AttRec.COST_OF_SALES_ACCOUNT),

Line 1185: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

1181: END IF;
1182:
1183:
1184: FOR cr IN global_flex(template_table(i)) LOOP
1185: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
1186: SET
1187: Global_attribute_Category = nvl(Global_attribute_Category,CR.Global_attribute_category),
1188: Global_attribute1 = nvl(Global_attribute1,CR.Global_attribute1),
1189: Global_attribute2 = nvl(Global_attribute2,CR.Global_attribute2),

Line 1261: UPDATE mtl_system_items_interface

1257: WHILE l_index IS NOT NULL
1258: LOOP
1259: l_template_id := p_template_tbl(l_index);
1260: /* Set the template id passed to the Function in the interface row */
1261: UPDATE mtl_system_items_interface
1262: SET template_id = l_template_id
1263: WHERE process_flag = 1
1264: AND set_process_id = p_xset_id
1265: AND((p_all_org = 1) or (organization_id = p_org_id));

Line 1283: UPDATE mtl_system_items_interface

1279: END IF;
1280: l_index := p_template_tbl.next(l_index);
1281: END LOOP;
1282: /* Set the template id back to null in the interface row to avoid reapplication */
1283: UPDATE mtl_system_items_interface
1284: SET template_id = null
1285: WHERE process_flag = 1
1286: AND set_process_id = p_xset_id
1287: AND((p_all_org = 1) or (organization_id = p_org_id));