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 544: FROM MTL_CC_ENTRIES_INTERFACE

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

Line 554: FROM MTL_CC_ENTRIES_INTERFACE

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

Line 607: UPDATE mtl_cc_entries_interface

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

Line 627: SELECT MTL_CC_ENTRIES_INTERFACE_S1.NEXTVAL

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

Line 635: UPDATE mtl_cc_entries_interface

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

Line 654: UPDATE mtl_cc_entries_interface

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

Line 758: MTL_CC_ENTRIES_INTERFACE

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

Line 783: MTL_CC_ENTRIES_INTERFACE

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

Line 906: SELECT * FROM MTL_CC_ENTRIES_INTERFACE

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

Line 962: UPDATE mtl_cc_entries_interface

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

Line 1217: UPDATE mtl_cc_entries_interface

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

Line 1244: UPDATE mtl_cc_entries_interface

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

Line 1272: UPDATE mtl_cc_entries_interface

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

Line 1293: from mtl_cc_entries_interface where

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