eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_BOM_BULKLOAD_PVT_PKG dependencies on EGO_BULKLOAD_INTF

Line 170: UPDATE EGO_BULKLOAD_INTF EBI

166:
167: BEGIN
168:
169: -- Update process flag in Ego Bulkload interface table
170: UPDATE EGO_BULKLOAD_INTF EBI
171: SET EBI.PROCESS_STATUS =
172: (
173: SELECT BMI.PROCESS_FLAG
174: FROM BOM_BILL_OF_MTLS_INTERFACE BMI

Line 186: UPDATE EGO_BULKLOAD_INTF EBI

182: )
183: AND EBI.RESULTFMT_USAGE_ID = p_resultfmt_usage_id;
184:
185:
186: UPDATE EGO_BULKLOAD_INTF EBI
187: SET EBI.PROCESS_STATUS =
188: (
189: SELECT BICI.PROCESS_FLAG
190: FROM BOM_INVENTORY_COMPS_INTERFACE BICI

Line 424: DELETE FROM EGO_BULKLOAD_INTF

420:
421:
422: -- Delete all the earlier uploads from the same spreadsheet.
423: /*
424: DELETE FROM EGO_BULKLOAD_INTF
425: WHERE RESULTFMT_USAGE_ID = p_resultfmt_usage_id
426: AND PROCESS_STATUS <> 1;
427: */
428:

Line 433: UPDATE EGO_BULKLOAD_INTF

429: --Error_Handler.Write_Debug('About to populate the EBI with Trans IDs');
430: --Populate the Transaction IDs for current result fmt usage ID
431: --New Transaction ID. It will be replaced by old Transaction ID Seq.
432: --SET transaction_id = MSII_TRANSACTION_ID_S.NEXTVAL
433: UPDATE EGO_BULKLOAD_INTF
434: SET Transaction_Id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
435: WHERE Resultfmt_Usage_Id = p_Resultfmt_Usage_Id AND PROCESS_STATUS = 1 ;
436:
437: IF l_debug = 'Y' THEN

Line 479: l_dyn_sql_select := l_dyn_sql_select || ' FROM EGO_BULKLOAD_INTF WHERE RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID ';

475: l_dyn_sql_select := '';
476: l_dyn_sql_select := l_dyn_sql_select || ' SELECT REQUEST_ID, Transaction_Type, Transaction_Id, 1, ' || l_item_col_name;
477: l_dyn_sql_select := l_dyn_sql_select || ', ' || G_INTF_ORG_CODE;
478: l_dyn_sql_select := l_dyn_sql_select || ', DECODE(' || G_INTF_STRUCT_NAME || ',Bom_Globals.Retrieve_Message(''BOM'', ''BOM_PRIMARY''),NULL,' || G_INTF_STRUCT_NAME || ')';
479: l_dyn_sql_select := l_dyn_sql_select || ' FROM EGO_BULKLOAD_INTF WHERE RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID ';
480: l_dyn_sql_select := l_dyn_sql_select || ' AND PROCESS_STATUS = 1 AND ' || l_parent_column || ' IS NULL ';
481:
482: l_dyn_sql := l_dyn_sql_insert || ' ' || l_dyn_sql_select;
483:

Line 538: l_dyn_sql_select := l_dyn_sql_select || ' FROM EGO_BULKLOAD_INTF ';

534:
535: l_dyn_sql_insert := SUBSTR(l_dyn_sql_insert,0,LENGTH(l_dyn_sql_insert) - 1);
536: l_dyn_sql_select := SUBSTR(l_dyn_sql_select,0,LENGTH(l_dyn_sql_select) - 1);
537: l_dyn_sql_insert := l_dyn_sql_insert || ' ) ';
538: l_dyn_sql_select := l_dyn_sql_select || ' FROM EGO_BULKLOAD_INTF ';
539: l_dyn_sql_select := l_dyn_sql_select || ' WHERE RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID ';
540: l_dyn_sql_select := l_dyn_sql_select || ' AND PROCESS_STATUS = 1 AND ' || l_parent_column || ' IS NOT NULL ';
541: l_dyn_sql_select := l_dyn_sql_select || ' AND Transaction_Type = ''' || G_TXN_UPDATE || ''' ';
542:

Line 563: l_dyn_sql_cursor := l_dyn_sql_cursor || ' FROM EGO_BULKLOAD_INTF WHERE Process_Status = 1';

559: l_dyn_sql_cursor := '';
560: l_dyn_sql_cursor := l_dyn_sql_cursor || ' SELECT Distinct Transaction_Id, ' || l_parent_column ;
561: l_dyn_sql_cursor := l_dyn_sql_cursor || ' , ' || G_INTF_ORG_CODE;
562: l_dyn_sql_cursor := l_dyn_sql_cursor || ', DECODE(' || G_INTF_STRUCT_NAME || ', Bom_Globals.Retrieve_Message(''BOM'', ''BOM_PRIMARY''),NULL,' || G_INTF_STRUCT_NAME || ')';
563: l_dyn_sql_cursor := l_dyn_sql_cursor || ' FROM EGO_BULKLOAD_INTF WHERE Process_Status = 1';
564: l_dyn_sql_cursor := l_dyn_sql_cursor || ' AND Resultfmt_Usage_Id = :RESULTFMT_USAGE_ID ';
565: l_dyn_sql_cursor := l_dyn_sql_cursor || ' AND ' || l_parent_column || ' IS NOT NULL ';
566: l_dyn_sql_cursor := l_dyn_sql_cursor || ' AND (Transaction_Type = ''' || G_TXN_CREATE || ''' OR Transaction_Type = ''' || G_TXN_ADD || ''' ';
567: l_dyn_sql_cursor := l_dyn_sql_cursor || ' OR Transaction_Type = ''' || G_TXN_SYNC || ''' )';

Line 660: l_dyn_sql_select := l_dyn_sql_select || ' FROM EGO_BULKLOAD_INTF ';

656:
657: l_dyn_sql_insert := SUBSTR(l_dyn_sql_insert,0,LENGTH(l_dyn_sql_insert) - 1);
658: l_dyn_sql_select := SUBSTR(l_dyn_sql_select,0,LENGTH(l_dyn_sql_select) - 1);
659: l_dyn_sql_insert := l_dyn_sql_insert || ' ) ';
660: l_dyn_sql_select := l_dyn_sql_select || ' FROM EGO_BULKLOAD_INTF ';
661: l_dyn_sql_select := l_dyn_sql_select || ' WHERE RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID ';
662: l_dyn_sql_select := l_dyn_sql_select || ' AND PROCESS_STATUS = 1 AND ' || l_parent_column || ' IS NOT NULL ';
663: -- l_dyn_sql_select := l_dyn_sql_select || ' AND (Transaction_Type = ''' || G_TXN_CREATE || ''' OR Transaction_Type = ''' || G_TXN_ADD || ''') ';
664:

Line 710: l_dyn_sql_select := l_dyn_sql_select || ' FROM EGO_BULKLOAD_INTF ';

706:
707: l_dyn_sql_insert := SUBSTR(l_dyn_sql_insert,0,LENGTH(l_dyn_sql_insert) - 1);
708: l_dyn_sql_select := SUBSTR(l_dyn_sql_select,0,LENGTH(l_dyn_sql_select) - 1);
709: l_dyn_sql_insert := l_dyn_sql_insert || ' ) ';
710: l_dyn_sql_select := l_dyn_sql_select || ' FROM EGO_BULKLOAD_INTF ';
711: l_dyn_sql_select := l_dyn_sql_select || ' WHERE RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID ';
712: l_dyn_sql_select := l_dyn_sql_select || ' AND PROCESS_STATUS = 1 AND ' || l_parent_column || ' IS NOT NULL ';
713: l_dyn_sql_select := l_dyn_sql_select || ' AND Transaction_Type = ''' || G_TXN_DELETE || ''' ';
714: