APPS.MTL_CCEOI_CONC_PVT dependencies on MTL_CYCLE_COUNT_ENTRIES

Line 104: FROM mtl_cycle_count_entries

100: (cycle_count_header_id = cchid);
101: --
102: CURSOR L_CycleCount_Records_Csr(HID NUMBER, CCID IN NUMBER) IS
103: SELECT *
104: FROM mtl_cycle_count_entries
105: WHERE
106: (cycle_count_header_id = hid
107: OR cycle_count_entry_id = ccid)
108: AND NVL(export_flag, 2) = 2

Line 796: -- reset the export_flag in the mtl_cycle_count_entries table

792: --
793: FOR c_rec IN L_Purge_Iface_Csr LOOP
794: -- IS it an exported RECORD
795: IF c_rec.cycle_count_entry_id IS NOT NULL THEN
796: -- reset the export_flag in the mtl_cycle_count_entries table
797: MTL_CCEOI_PROCESS_PVT.Set_CCExport(
798: p_api_version => 0.9,
799: X_return_status=> L_return_status,
800: x_msg_count => L_msg_count,

Line 1289: Update mtl_cycle_count_entries

1285: commit;
1286: begin
1287: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker: Unexport all of them successfully processed');
1288: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker:'||to_char(P_CC_Interface_Group_ID));
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