DBA Data[Home] [Help]

APPS.EGO_ITEM_BULKLOAD_PKG dependencies on MTL_SYSTEM_ITEMS_INTERFACE_S

Line 1257: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

1253: --------------------------------------------------------------------
1254: UPDATE ego_bulkload_intf
1255: --The Transaction ID sequence that is used in INVPOPIF package to
1256: --auto-populate Transaction ID in MSII.
1257: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
1258: WHERE resultfmt_usage_id = p_resultfmt_usage_id;
1259:
1260: Write_Debug('Retrieving the Display and INTF cols');
1261: i := 0;

Line 3489: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

3485: -- this was happening because the error was logged with a previous transaction id and
3486: -- here a new transaction id was updated to Bulkload interface table.
3487: IF p_data_level <> G_ITEM_DATA_LEVEL THEN
3488: UPDATE ego_bulkload_intf
3489: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
3490: WHERE resultfmt_usage_id = p_resultfmt_usage_id;
3491: END IF;
3492:
3493: Write_Debug('Retrieving the Display and INTF cols');

Line 5627: l_dyn_sql_update_msii := 'UPDATE MTL_SYSTEM_ITEMS_INTERFACE SET ';

5623: -- Update MSII with the internal values. --
5624: -- Use dynamic sql with bind variable to share cursor for all items. --
5625: -- Construct the sql text once and bind variables for each item. --
5626: --------------------------------------------------------------------------------
5627: l_dyn_sql_update_msii := 'UPDATE MTL_SYSTEM_ITEMS_INTERFACE SET ';
5628: l_cursor_update_msii := DBMS_SQL.OPEN_CURSOR;
5629:
5630: -- construct dynamic sql
5631: FOR i in 1..l_msii_col_table.COUNT LOOP

Line 7668: l_dyn_sql := l_dyn_sql || 'MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL , ';

7664: END IF;
7665: l_dyn_sql := l_dyn_sql || 'EBI.'||l_org_code_col ||' , ';
7666: l_dyn_sql := l_dyn_sql || '''SYNC'' , ';
7667: l_dyn_sql := l_dyn_sql || G_PROCESS_STATUS||' , ';
7668: l_dyn_sql := l_dyn_sql || 'MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL , ';
7669: l_dyn_sql := l_dyn_sql || 'EBI.'||'CREATED_BY , ';
7670: l_dyn_sql := l_dyn_sql || 'EBI.'||'CREATION_DATE , ';
7671: l_dyn_sql := l_dyn_sql || 'EBI.'||'LAST_UPDATED_BY , ';
7672: l_dyn_sql := l_dyn_sql || 'EBI.'||'LAST_UPDATE_DATE , ';

Line 7763: l_dyn_sql := l_dyn_sql || 'MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL , ';

7759: l_dyn_sql := l_dyn_sql || ' SOURCE_SYSTEM_REFERENCE , ';
7760: l_dyn_sql := l_dyn_sql || ' ASSOCIATION_ID ';
7761: l_dyn_sql := l_dyn_sql || ' ) ';
7762: l_dyn_sql := l_dyn_sql || 'SELECT ';
7763: l_dyn_sql := l_dyn_sql || 'MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL , ';
7764: l_dyn_sql := l_dyn_sql || ' INTERSECTIONS.* ';
7765: l_dyn_sql := l_dyn_sql || ' FROM ( ';
7766:
7767: l_dyn_sql := l_dyn_sql || 'SELECT ';

Line 7802: --l_dyn_sql := l_dyn_sql || 'MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL, ';

7798: l_dyn_sql := l_dyn_sql || 'EBI.'||l_supplier_site_name_col ||' , ';
7799: l_dyn_sql := l_dyn_sql || 'EBI.'||l_org_code_col ||' , ';
7800: l_dyn_sql := l_dyn_sql || '''SYNC'' , ';
7801: l_dyn_sql := l_dyn_sql || G_PROCESS_STATUS||' , ';
7802: --l_dyn_sql := l_dyn_sql || 'MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL, ';
7803: l_dyn_sql := l_dyn_sql || 'EBI.'||'CREATED_BY , ';
7804: l_dyn_sql := l_dyn_sql || 'EBI.'||'CREATION_DATE , ';
7805: l_dyn_sql := l_dyn_sql || 'EBI.'||'LAST_UPDATED_BY , ';
7806: l_dyn_sql := l_dyn_sql || 'EBI.'||'LAST_UPDATE_DATE , ';

Line 7864: --l_dyn_sql := l_dyn_sql || 'MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL, ';

7860:
7861: l_dyn_sql := l_dyn_sql || 'EBI.'||l_org_code_col ||' , ';
7862: l_dyn_sql := l_dyn_sql || '''SYNC'' , ';
7863: l_dyn_sql := l_dyn_sql || G_PROCESS_STATUS||' , ';
7864: --l_dyn_sql := l_dyn_sql || 'MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL, ';
7865: l_dyn_sql := l_dyn_sql || 'EBI.'||'CREATED_BY , ';
7866: l_dyn_sql := l_dyn_sql || 'EBI.'||'CREATION_DATE , ';
7867: l_dyn_sql := l_dyn_sql || 'EBI.'||'LAST_UPDATED_BY , ';
7868: l_dyn_sql := l_dyn_sql || 'EBI.'||'LAST_UPDATE_DATE , ';