APPS.EGO_ITEM_ORG_BULKLOAD_PVT dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 228: l_dyn_sql := l_dyn_sql || ', ''MTL_SYSTEM_ITEMS_INTERFACE'' ';

224: l_dyn_sql := l_dyn_sql || ', '||G_USER_ID ;
225: l_dyn_sql := l_dyn_sql || ', SYSDATE ';
226: l_dyn_sql := l_dyn_sql || ', '||G_USER_ID;
227: l_dyn_sql := l_dyn_sql || ', '||G_LOGIN_ID;
228: l_dyn_sql := l_dyn_sql || ', ''MTL_SYSTEM_ITEMS_INTERFACE'' ';
229: l_dyn_sql := l_dyn_sql || ', DECODE(MSII.PROCESS_FLAG, ';
230: l_dyn_sql := l_dyn_sql || G_PRIMARY_UOM_ERR_STS||', ''EGO_PRIMARYUOM_INVALID'' ';
231: l_dyn_sql := l_dyn_sql || ' ) ';
232: l_dyn_sql := l_dyn_sql || ', NULL ';

Line 243: l_dyn_sql := l_dyn_sql || 'FROM MTL_SYSTEM_ITEMS_INTERFACE MSII ';

239: l_dyn_sql := l_dyn_sql || ' ) ';
240: l_dyn_sql := l_dyn_sql || ', MSII.TRANSACTION_ID ';
241: l_dyn_sql := l_dyn_sql || ', NULL ';
242: l_dyn_sql := l_dyn_sql || ', NULL ';
243: l_dyn_sql := l_dyn_sql || 'FROM MTL_SYSTEM_ITEMS_INTERFACE MSII ';
244: l_dyn_sql := l_dyn_sql || ' AND MSII.PROCESS_FLAG IN ';
245: l_dyn_sql := l_dyn_sql || ' ( ';
246: l_dyn_sql := l_dyn_sql || G_PRIMARY_UOM_ERR_STS;
247: l_dyn_sql := l_dyn_sql || ' ) ';

Line 261: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

257: Write_Debug('MIERR: Inserted Pre-processed error messages in MTL_INTERFACE_ERRORS');
258:
259: --Now that the error messages are inserted, update MSII lines to
260: --Process status ERROR.
261: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
262: SET PROCESS_FLAG = G_INTF_STATUS_ERROR
263: WHERE PROCESS_FLAG IN
264: (
265: G_PRIMARY_UOM_ERR_STS