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.MTL_CCEOI_CONC_PVT dependencies on MTL_CC_ENTRIES_INTERFACE

Line 59: -- TABLE MTL_CC_ENTRIES_INTERFACE

55: -- Pre-reqs :
56: -- FUNCTION :
57: -- The Export concurrent program select all unexported rows
58: -- from the given cycle count. Each row will be inserted INTO
59: -- TABLE MTL_CC_ENTRIES_INTERFACE
60: -- by calling the PRIVAT API procedure MTL_CCEOI_ACTION_PVT.
61: -- Export_CountRequest). IF the p_cycle_count_entry_id parameter
62: -- IS populated only one ROW will be exported.
63: -- Parameters :

Line 175: MTL_CC_ENTRIES_INTERFACE_S2.nextval

171: IF p_cc_entry_iface_group_id IS NOT NULL THEN
172: L_cc_entry_iface_group_id :=p_cc_entry_iface_group_id;
173: ELSE
174: SELECT
175: MTL_CC_ENTRIES_INTERFACE_S2.nextval
176: INTO
177: L_cc_entry_iface_group_id
178: FROM
179: dual;

Line 543: FROM MTL_CC_ENTRIES_INTERFACE

539: status flag is NULL */
540: IF p_cycle_count_header_id IS NULL THEN
541: SELECT COUNT(*)
542: INTO L_MaxNumRows
543: FROM MTL_CC_ENTRIES_INTERFACE
544: WHERE NVL(STATUS_FLAG, 4) = 4
545: -- STATUS_FLAG = 4
546: AND NVL(LOCK_FLAG, 2) =2
547: AND NVL(DELETE_FLAG, 2) = 2

Line 553: FROM MTL_CC_ENTRIES_INTERFACE

549: AND NVL(PROCESS_MODE, 3) = 3;
550: ELSE
551: SELECT COUNT(*)
552: INTO L_MaxNumRows
553: FROM MTL_CC_ENTRIES_INTERFACE
554: WHERE CYCLE_COUNT_HEADER_ID = P_CYCLE_COUNT_HEADER_ID
555: AND NVL(STATUS_FLAG, 4) = 4
556: --AND STATUS_FLAG = 4
557: AND NVL(LOCK_FLAG, 2) =2

Line 606: UPDATE mtl_cc_entries_interface

602: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Rows/Worker = '||
603: TO_CHAR(L_CountRows));
604: --
605: -- New Logic to initialize the grpId before assign
606: UPDATE mtl_cc_entries_interface
607: SET
608: cc_entry_interface_group_id = NULL,
609: LAST_UPDATE_DATE = SYSDATE,
610: LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,

Line 626: SELECT MTL_CC_ENTRIES_INTERFACE_S1.NEXTVAL

622: AND NVL(DELETE_FLAG, 2) = 2;
623: --
624: FOR i IN 1..L_CountWorker LOOP
625: --
626: SELECT MTL_CC_ENTRIES_INTERFACE_S1.NEXTVAL
627: INTO
628: L_NextGroupID
629: FROM
630: DUAL;

Line 634: UPDATE mtl_cc_entries_interface

630: DUAL;
631: -- UPDATE the interface entries with the group ID
632: IF p_cycle_count_header_id IS NULL THEN
633: --dbms_output.put_line('Updating with cc header is null');
634: UPDATE mtl_cc_entries_interface
635: SET
636: cc_entry_interface_group_id = L_NextGroupID,
637: LAST_UPDATE_DATE = SYSDATE,
638: LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,

Line 653: UPDATE mtl_cc_entries_interface

649: AND NVL(DELETE_FLAG, 2) = 2
650: AND cc_entry_interface_group_id IS NULL
651: AND ROWNUM <= L_CountRows;
652: ELSE
653: UPDATE mtl_cc_entries_interface
654: SET
655: cc_entry_interface_group_id = L_NextGroupID,
656: LAST_UPDATE_DATE = SYSDATE,
657: LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,

Line 757: MTL_CC_ENTRIES_INTERFACE

753: CURSOR L_Purge_Iface_Csr IS
754: SELECT
755: *
756: FROM
757: MTL_CC_ENTRIES_INTERFACE
758: WHERE
759: (ERROR_FLAG = 2
760: AND STATUS_FLAG IN(0, 1))
761: OR DELETE_FLAG = 1;

Line 782: MTL_CC_ENTRIES_INTERFACE

778: begin
779: select count(*)
780: into L_recs
781: FROM
782: MTL_CC_ENTRIES_INTERFACE
783: WHERE
784: (ERROR_FLAG = 2 AND STATUS_FLAG IN (0, 1))
785: OR DELETE_FLAG = 1;
786: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Deleting rows : '||to_char(L_recs));

Line 905: SELECT * FROM MTL_CC_ENTRIES_INTERFACE

901: -- END OF comments
902: DECLARE
903: --
904: CURSOR L_CCEOI_records_CSR(id IN NUMBER) IS
905: SELECT * FROM MTL_CC_ENTRIES_INTERFACE
906: WHERE
907: CC_ENTRY_INTERFACE_GROUP_ID = id
908: -- AND LOCK_FLAG = 1 -- record will be locked by public API
909: AND NVL(PROCESS_FLAG, 1) = 1

Line 961: UPDATE mtl_cc_entries_interface

957: -- END OF VALIDATION
958: --
959: -- Before processing lock all records for this worker
960: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker: before process lock all recs');
961: UPDATE mtl_cc_entries_interface
962: SET
963: LAST_UPDATE_DATE = SYSDATE,
964: LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,
965: LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,

Line 1216: UPDATE mtl_cc_entries_interface

1212: IF p_errorreportlev = 1 THEN
1213: --
1214: -- Reswitch the Lockflag after failure
1215: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker: switch back lockflag-After Failure ');
1216: UPDATE mtl_cc_entries_interface
1217: SET
1218: LAST_UPDATE_DATE = SYSDATE,
1219: LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,
1220: LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,

Line 1243: UPDATE mtl_cc_entries_interface

1239: IF P_ErrorReportLev = 1 THEN
1240: --
1241: -- Reswitch the Lockflag after failure
1242: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker: switch back lock-flag -2 ');
1243: UPDATE mtl_cc_entries_interface
1244: SET
1245: LAST_UPDATE_DATE = SYSDATE,
1246: LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,
1247: LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,

Line 1271: UPDATE mtl_cc_entries_interface

1267: commit;
1268: --
1269: -- Reswitch the Lockflag after failure
1270: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker: switch back lock-flag -3 ');
1271: UPDATE mtl_cc_entries_interface
1272: SET
1273: LAST_UPDATE_DATE = SYSDATE,
1274: LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,
1275: LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,

Line 1292: from mtl_cc_entries_interface where

1288: Update mtl_cycle_count_entries
1289: set export_flag = 2
1290: where cycle_count_entry_id
1291: in (select cycle_count_entry_id
1292: from mtl_cc_entries_interface where
1293: cc_entry_interface_group_id = P_CC_Interface_Group_ID
1294: and status_flag = 0 );
1295: --
1296: commit;