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_CCEOI_VAR_PVT

Line 129: L_CCEOIEntry_record MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE;

125: AND msi.organization_id = mtp.organization_id
126: AND msi.inventory_item_id = cp_inventory_item_id;
127: -- END INVCONV
128:
129: L_CCEOIEntry_record MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE;
130: L_cc_entry_iface_group_id NUMBER;
131: L_rec_counter_pos integer := 0;
132: L_rec_counter_neg integer := 0;
133: L_counter integer := 0;

Line 216: INTO MTL_CCEOI_VAR_PVT.g_tracking_quantity_ind,

212: L_CCEOIEntry_record.system_quantity := c_rec.system_quantity_current;
213: -- BEGIN INVCONV
214: OPEN cur_get_item_attr (c_rec.inventory_item_id, c_rec.organization_id);
215: FETCH cur_get_item_attr
216: INTO MTL_CCEOI_VAR_PVT.g_tracking_quantity_ind,
217: MTL_CCEOI_VAR_PVT.g_secondary_default_ind,
218: MTL_CCEOI_VAR_PVT.g_secondary_uom_code,
219: MTL_CCEOI_VAR_PVT.g_process_costing_enabled_flag,
220: MTL_CCEOI_VAR_PVT.g_process_enabled_flag;

Line 217: MTL_CCEOI_VAR_PVT.g_secondary_default_ind,

213: -- BEGIN INVCONV
214: OPEN cur_get_item_attr (c_rec.inventory_item_id, c_rec.organization_id);
215: FETCH cur_get_item_attr
216: INTO MTL_CCEOI_VAR_PVT.g_tracking_quantity_ind,
217: MTL_CCEOI_VAR_PVT.g_secondary_default_ind,
218: MTL_CCEOI_VAR_PVT.g_secondary_uom_code,
219: MTL_CCEOI_VAR_PVT.g_process_costing_enabled_flag,
220: MTL_CCEOI_VAR_PVT.g_process_enabled_flag;
221: CLOSE cur_get_item_attr;

Line 218: MTL_CCEOI_VAR_PVT.g_secondary_uom_code,

214: OPEN cur_get_item_attr (c_rec.inventory_item_id, c_rec.organization_id);
215: FETCH cur_get_item_attr
216: INTO MTL_CCEOI_VAR_PVT.g_tracking_quantity_ind,
217: MTL_CCEOI_VAR_PVT.g_secondary_default_ind,
218: MTL_CCEOI_VAR_PVT.g_secondary_uom_code,
219: MTL_CCEOI_VAR_PVT.g_process_costing_enabled_flag,
220: MTL_CCEOI_VAR_PVT.g_process_enabled_flag;
221: CLOSE cur_get_item_attr;
222:

Line 219: MTL_CCEOI_VAR_PVT.g_process_costing_enabled_flag,

215: FETCH cur_get_item_attr
216: INTO MTL_CCEOI_VAR_PVT.g_tracking_quantity_ind,
217: MTL_CCEOI_VAR_PVT.g_secondary_default_ind,
218: MTL_CCEOI_VAR_PVT.g_secondary_uom_code,
219: MTL_CCEOI_VAR_PVT.g_process_costing_enabled_flag,
220: MTL_CCEOI_VAR_PVT.g_process_enabled_flag;
221: CLOSE cur_get_item_attr;
222:
223: L_CCEOIEntry_record.secondary_uom := MTL_CCEOI_VAR_PVT.g_secondary_uom_code;

Line 220: MTL_CCEOI_VAR_PVT.g_process_enabled_flag;

216: INTO MTL_CCEOI_VAR_PVT.g_tracking_quantity_ind,
217: MTL_CCEOI_VAR_PVT.g_secondary_default_ind,
218: MTL_CCEOI_VAR_PVT.g_secondary_uom_code,
219: MTL_CCEOI_VAR_PVT.g_process_costing_enabled_flag,
220: MTL_CCEOI_VAR_PVT.g_process_enabled_flag;
221: CLOSE cur_get_item_attr;
222:
223: L_CCEOIEntry_record.secondary_uom := MTL_CCEOI_VAR_PVT.g_secondary_uom_code;
224: L_CCEOIEntry_record.secondary_system_quantity := c_rec.secondary_system_qty_current;

Line 223: L_CCEOIEntry_record.secondary_uom := MTL_CCEOI_VAR_PVT.g_secondary_uom_code;

219: MTL_CCEOI_VAR_PVT.g_process_costing_enabled_flag,
220: MTL_CCEOI_VAR_PVT.g_process_enabled_flag;
221: CLOSE cur_get_item_attr;
222:
223: L_CCEOIEntry_record.secondary_uom := MTL_CCEOI_VAR_PVT.g_secondary_uom_code;
224: L_CCEOIEntry_record.secondary_system_quantity := c_rec.secondary_system_qty_current;
225: -- END INVCONV
226:
227: -- This code is added for the bug 2311404 by aapaul

Line 258: IF MTL_CCEOI_VAR_PVT.g_tracking_quantity_ind <> 'PS' THEN

254: , x_lpn_systemqty => L_CCEOIEntry_record.system_quantity
255: , x_lpn_sec_systemqty => L_CCEOIEntry_record.secondary_system_quantity -- INVCONV
256: );
257: -- BEGIN INVCONV
258: IF MTL_CCEOI_VAR_PVT.g_tracking_quantity_ind <> 'PS' THEN
259: L_CCEOIEntry_record.secondary_system_quantity := NULL;
260: END IF;
261: -- END INVCONV
262: else

Line 287: IF MTL_CCEOI_VAR_PVT.g_tracking_quantity_ind <> 'PS' THEN

283: , x_system_quantity => L_CCEOIEntry_record.system_quantity
284: , x_sec_system_quantity => L_CCEOIEntry_record.secondary_system_quantity -- INVCONV
285: );
286: -- BEGIN INVCONV
287: IF MTL_CCEOI_VAR_PVT.g_tracking_quantity_ind <> 'PS' THEN
288: L_CCEOIEntry_record.secondary_system_quantity := NULL;
289: END IF;
290: -- END INVCONV
291: end if;

Line 332: L_CCEOIEntry_record.action_code := MTL_CCEOI_VAR_PVT.G_PROCESS;

328: -- Export STATI
329: L_CCEOIEntry_record.VALID_FLAG := 1;
330: L_CCEOIEntry_record.cycle_count_entry_id :=
331: c_rec.cycle_count_entry_id;
332: L_CCEOIEntry_record.action_code := MTL_CCEOI_VAR_PVT.G_PROCESS;
333: L_CCEOIEntry_record.STATUS_FLAG := NULL;
334: -- END: prepare the input parameter FOR the Public API PROCEDURE
335: --
336: IF (l_debug = 1) THEN

Line 611: LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,

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,
612: LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,
613: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,
614: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,
615: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,

Line 612: LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,

608: SET
609: cc_entry_interface_group_id = NULL,
610: LAST_UPDATE_DATE = SYSDATE,
611: LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,
612: LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,
613: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,
614: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,
615: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,
616: PROGRAM_UPDATE_DATE = SYSDATE

Line 613: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,

609: cc_entry_interface_group_id = NULL,
610: LAST_UPDATE_DATE = SYSDATE,
611: LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,
612: LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,
613: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,
614: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,
615: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,
616: PROGRAM_UPDATE_DATE = SYSDATE
617: WHERE

Line 614: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,

610: LAST_UPDATE_DATE = SYSDATE,
611: LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,
612: LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,
613: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,
614: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,
615: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,
616: PROGRAM_UPDATE_DATE = SYSDATE
617: WHERE
618: CYCLE_COUNT_HEADER_ID = NVL(P_Cycle_Count_Header_Id,CYCLE_COUNT_HEADER_ID)

Line 615: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,

611: LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,
612: LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,
613: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,
614: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,
615: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,
616: PROGRAM_UPDATE_DATE = SYSDATE
617: WHERE
618: CYCLE_COUNT_HEADER_ID = NVL(P_Cycle_Count_Header_Id,CYCLE_COUNT_HEADER_ID)
619: AND NVL(PROCESS_FLAG, 1) = 1

Line 639: LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,

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,
640: LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,
641: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,
642: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,
643: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,

Line 640: LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,

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,
640: LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,
641: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,
642: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,
643: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,
644: PROGRAM_UPDATE_DATE = SYSDATE

Line 641: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,

637: cc_entry_interface_group_id = L_NextGroupID,
638: LAST_UPDATE_DATE = SYSDATE,
639: LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,
640: LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,
641: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,
642: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,
643: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,
644: PROGRAM_UPDATE_DATE = SYSDATE
645: WHERE

Line 642: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,

638: LAST_UPDATE_DATE = SYSDATE,
639: LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,
640: LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,
641: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,
642: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,
643: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,
644: PROGRAM_UPDATE_DATE = SYSDATE
645: WHERE
646: NVL(PROCESS_FLAG, 1) = 1

Line 643: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,

639: LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,
640: LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,
641: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,
642: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,
643: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,
644: PROGRAM_UPDATE_DATE = SYSDATE
645: WHERE
646: NVL(PROCESS_FLAG, 1) = 1
647: AND NVL(LOCK_FLAG, 2) = 2

Line 658: LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,

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,
659: LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,
660: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,
661: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,
662: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,

Line 659: LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,

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,
659: LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,
660: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,
661: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,
662: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,
663: PROGRAM_UPDATE_DATE = SYSDATE

Line 660: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,

656: cc_entry_interface_group_id = L_NextGroupID,
657: LAST_UPDATE_DATE = SYSDATE,
658: LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,
659: LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,
660: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,
661: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,
662: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,
663: PROGRAM_UPDATE_DATE = SYSDATE
664: WHERE

Line 661: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,

657: LAST_UPDATE_DATE = SYSDATE,
658: LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,
659: LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,
660: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,
661: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,
662: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,
663: PROGRAM_UPDATE_DATE = SYSDATE
664: WHERE
665: CYCLE_COUNT_HEADER_ID = P_Cycle_Count_Header_Id

Line 662: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,

658: LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,
659: LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,
660: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,
661: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,
662: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,
663: PROGRAM_UPDATE_DATE = SYSDATE
664: WHERE
665: CYCLE_COUNT_HEADER_ID = P_Cycle_Count_Header_Id
666: AND NVL(PROCESS_FLAG, 1) = 1

Line 915: L_iface_rec MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE;

911: AND NVL(PROCESS_MODE, 3) IN(2, 3)
912: AND NVL(STATUS_FLAG,4)=4
913: AND NVL(DELETE_FLAG,2)=2;
914: --
915: L_iface_rec MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE;
916: L_errorcode NUMBER;
917: L_return_status VARCHAR2(30);
918: L_msg_count NUMBER;
919: L_msg_data VARCHAR2(32000);

Line 965: LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,

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,
967: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,
968: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,
969: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,

Line 966: LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,

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,
967: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,
968: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,
969: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,
970: PROGRAM_UPDATE_DATE = sysdate

Line 967: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,

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,
967: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,
968: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,
969: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,
970: PROGRAM_UPDATE_DATE = sysdate
971: -- LOCK_FLAG = 1

Line 968: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,

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,
967: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,
968: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,
969: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,
970: PROGRAM_UPDATE_DATE = sysdate
971: -- LOCK_FLAG = 1
972: WHERE

Line 969: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,

965: LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,
966: LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,
967: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,
968: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,
969: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,
970: PROGRAM_UPDATE_DATE = sysdate
971: -- LOCK_FLAG = 1
972: WHERE
973: cc_entry_interface_group_id = P_CC_Interface_Group_ID

Line 985: MTL_CCEOI_VAR_PVT.G_cc_entry_interface_id :=

981: FOR c_rec IN L_CCEOI_records_CSR(P_CC_Interface_Group_ID) LOOP
982:
983: -- Current processed interface RECORD
984: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker: Inside Loop-process IR ');
985: MTL_CCEOI_VAR_PVT.G_cc_entry_interface_id :=
986: c_rec.cc_entry_interface_id;
987: -- Defined by suresh
988: MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID := c_rec.inventory_item_id;
989: MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID := c_rec.cycle_count_header_id;

Line 988: MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID := c_rec.inventory_item_id;

984: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker: Inside Loop-process IR ');
985: MTL_CCEOI_VAR_PVT.G_cc_entry_interface_id :=
986: c_rec.cc_entry_interface_id;
987: -- Defined by suresh
988: MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID := c_rec.inventory_item_id;
989: MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID := c_rec.cycle_count_header_id;
990: MTL_CCEOI_VAR_PVT.G_COUNT_QUANTITY := c_rec.count_quantity;
991: MTL_CCEOI_VAR_PVT.G_SECONDARY_COUNT_QUANTITY := c_rec.secondary_count_quantity; -- INVCONV
992: MTL_CCEOI_VAR_PVT.G_COUNT_DATE := c_rec.count_date;

Line 989: MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID := c_rec.cycle_count_header_id;

985: MTL_CCEOI_VAR_PVT.G_cc_entry_interface_id :=
986: c_rec.cc_entry_interface_id;
987: -- Defined by suresh
988: MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID := c_rec.inventory_item_id;
989: MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID := c_rec.cycle_count_header_id;
990: MTL_CCEOI_VAR_PVT.G_COUNT_QUANTITY := c_rec.count_quantity;
991: MTL_CCEOI_VAR_PVT.G_SECONDARY_COUNT_QUANTITY := c_rec.secondary_count_quantity; -- INVCONV
992: MTL_CCEOI_VAR_PVT.G_COUNT_DATE := c_rec.count_date;
993: MTL_CCEOI_VAR_PVT.G_LOCATOR_ID := c_rec.locator_id;

Line 990: MTL_CCEOI_VAR_PVT.G_COUNT_QUANTITY := c_rec.count_quantity;

986: c_rec.cc_entry_interface_id;
987: -- Defined by suresh
988: MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID := c_rec.inventory_item_id;
989: MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID := c_rec.cycle_count_header_id;
990: MTL_CCEOI_VAR_PVT.G_COUNT_QUANTITY := c_rec.count_quantity;
991: MTL_CCEOI_VAR_PVT.G_SECONDARY_COUNT_QUANTITY := c_rec.secondary_count_quantity; -- INVCONV
992: MTL_CCEOI_VAR_PVT.G_COUNT_DATE := c_rec.count_date;
993: MTL_CCEOI_VAR_PVT.G_LOCATOR_ID := c_rec.locator_id;
994: MTL_CCEOI_VAR_PVT.G_SUBINVENTORY := c_rec.subinventory;

Line 991: MTL_CCEOI_VAR_PVT.G_SECONDARY_COUNT_QUANTITY := c_rec.secondary_count_quantity; -- INVCONV

987: -- Defined by suresh
988: MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID := c_rec.inventory_item_id;
989: MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID := c_rec.cycle_count_header_id;
990: MTL_CCEOI_VAR_PVT.G_COUNT_QUANTITY := c_rec.count_quantity;
991: MTL_CCEOI_VAR_PVT.G_SECONDARY_COUNT_QUANTITY := c_rec.secondary_count_quantity; -- INVCONV
992: MTL_CCEOI_VAR_PVT.G_COUNT_DATE := c_rec.count_date;
993: MTL_CCEOI_VAR_PVT.G_LOCATOR_ID := c_rec.locator_id;
994: MTL_CCEOI_VAR_PVT.G_SUBINVENTORY := c_rec.subinventory;
995: -- Adding by suresh

Line 992: MTL_CCEOI_VAR_PVT.G_COUNT_DATE := c_rec.count_date;

988: MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID := c_rec.inventory_item_id;
989: MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID := c_rec.cycle_count_header_id;
990: MTL_CCEOI_VAR_PVT.G_COUNT_QUANTITY := c_rec.count_quantity;
991: MTL_CCEOI_VAR_PVT.G_SECONDARY_COUNT_QUANTITY := c_rec.secondary_count_quantity; -- INVCONV
992: MTL_CCEOI_VAR_PVT.G_COUNT_DATE := c_rec.count_date;
993: MTL_CCEOI_VAR_PVT.G_LOCATOR_ID := c_rec.locator_id;
994: MTL_CCEOI_VAR_PVT.G_SUBINVENTORY := c_rec.subinventory;
995: -- Adding by suresh
996: MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION := c_rec.revision;

Line 993: MTL_CCEOI_VAR_PVT.G_LOCATOR_ID := c_rec.locator_id;

989: MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID := c_rec.cycle_count_header_id;
990: MTL_CCEOI_VAR_PVT.G_COUNT_QUANTITY := c_rec.count_quantity;
991: MTL_CCEOI_VAR_PVT.G_SECONDARY_COUNT_QUANTITY := c_rec.secondary_count_quantity; -- INVCONV
992: MTL_CCEOI_VAR_PVT.G_COUNT_DATE := c_rec.count_date;
993: MTL_CCEOI_VAR_PVT.G_LOCATOR_ID := c_rec.locator_id;
994: MTL_CCEOI_VAR_PVT.G_SUBINVENTORY := c_rec.subinventory;
995: -- Adding by suresh
996: MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION := c_rec.revision;
997: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_NUMBER := c_rec.LOT_NUMBER;

Line 994: MTL_CCEOI_VAR_PVT.G_SUBINVENTORY := c_rec.subinventory;

990: MTL_CCEOI_VAR_PVT.G_COUNT_QUANTITY := c_rec.count_quantity;
991: MTL_CCEOI_VAR_PVT.G_SECONDARY_COUNT_QUANTITY := c_rec.secondary_count_quantity; -- INVCONV
992: MTL_CCEOI_VAR_PVT.G_COUNT_DATE := c_rec.count_date;
993: MTL_CCEOI_VAR_PVT.G_LOCATOR_ID := c_rec.locator_id;
994: MTL_CCEOI_VAR_PVT.G_SUBINVENTORY := c_rec.subinventory;
995: -- Adding by suresh
996: MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION := c_rec.revision;
997: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_NUMBER := c_rec.LOT_NUMBER;
998: MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER := c_rec.SERIAL_NUMBER;

Line 996: MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION := c_rec.revision;

992: MTL_CCEOI_VAR_PVT.G_COUNT_DATE := c_rec.count_date;
993: MTL_CCEOI_VAR_PVT.G_LOCATOR_ID := c_rec.locator_id;
994: MTL_CCEOI_VAR_PVT.G_SUBINVENTORY := c_rec.subinventory;
995: -- Adding by suresh
996: MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION := c_rec.revision;
997: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_NUMBER := c_rec.LOT_NUMBER;
998: MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER := c_rec.SERIAL_NUMBER;
999:
1000: --p_sku_rec.revision := c_rec.revision;

Line 997: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_NUMBER := c_rec.LOT_NUMBER;

993: MTL_CCEOI_VAR_PVT.G_LOCATOR_ID := c_rec.locator_id;
994: MTL_CCEOI_VAR_PVT.G_SUBINVENTORY := c_rec.subinventory;
995: -- Adding by suresh
996: MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION := c_rec.revision;
997: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_NUMBER := c_rec.LOT_NUMBER;
998: MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER := c_rec.SERIAL_NUMBER;
999:
1000: --p_sku_rec.revision := c_rec.revision;
1001: FND_FILE.PUT_LINE(FND_FILE.LOG, 'System Qty before assign IRec '||to_char(c_rec.system_quantity));

Line 998: MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER := c_rec.SERIAL_NUMBER;

994: MTL_CCEOI_VAR_PVT.G_SUBINVENTORY := c_rec.subinventory;
995: -- Adding by suresh
996: MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION := c_rec.revision;
997: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_NUMBER := c_rec.LOT_NUMBER;
998: MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER := c_rec.SERIAL_NUMBER;
999:
1000: --p_sku_rec.revision := c_rec.revision;
1001: FND_FILE.PUT_LINE(FND_FILE.LOG, 'System Qty before assign IRec '||to_char(c_rec.system_quantity));
1002: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CCEntry ID '||to_char(c_rec.cycle_count_entry_id));

Line 1169: c_rec.action_code = MTL_CCEOI_VAR_PVT.G_VALIDATE THEN

1165: 'INV_CCEOI_UNKNOWN_ACTION_CODE');
1166: FND_FILE.PUT_LINE(FND_FILE.LOG,
1167: ERRBUF);
1168: ELSIF
1169: c_rec.action_code = MTL_CCEOI_VAR_PVT.G_VALIDATE THEN
1170: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker: Action-is Vaildate ');
1171: MTL_CCEOI_ACTION_PVT.Validate_CountRequest(
1172: p_api_version => 0.9,
1173: p_init_msg_list => FND_API.G_TRUE,

Line 1179: c_rec.action_code = MTL_CCEOI_VAR_PVT.G_CREATE THEN

1175: x_msg_count => L_msg_count,
1176: x_msg_data => L_msg_data,
1177: P_interface_rec => L_iface_rec);
1178: ELSIF
1179: c_rec.action_code = MTL_CCEOI_VAR_PVT.G_CREATE THEN
1180: MTL_CCEOI_ACTION_PVT.Create_CountRequest(
1181: p_api_version => 0.9,
1182: p_init_msg_list => FND_API.G_TRUE,
1183: x_return_status => L_return_status,

Line 1188: c_rec.action_code = MTL_CCEOI_VAR_PVT.G_VALSIM THEN

1184: x_msg_count => L_msg_count,
1185: x_msg_data => L_msg_data,
1186: P_interface_rec => L_iface_rec);
1187: ELSIF
1188: c_rec.action_code = MTL_CCEOI_VAR_PVT.G_VALSIM THEN
1189: MTL_CCEOI_ACTION_PVT.ValSim_CountRequest(
1190: p_api_version => 0.9,
1191: p_init_msg_list => FND_API.G_TRUE,
1192: x_return_status => L_return_status,

Line 1197: c_rec.action_code = MTL_CCEOI_VAR_PVT.G_PROCESS THEN

1193: x_msg_count => L_msg_count,
1194: x_msg_data => L_msg_data,
1195: P_interface_rec => L_iface_rec);
1196: ELSIF
1197: c_rec.action_code = MTL_CCEOI_VAR_PVT.G_PROCESS THEN
1198: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker: Action-is process ');
1199: MTL_CCEOI_ACTION_PVT.Process_CountRequest(
1200: p_api_version => 0.9,
1201: p_init_msg_list => FND_API.G_TRUE,

Line 1220: LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,

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,
1222: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,
1223: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,
1224: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,

Line 1221: LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,

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,
1222: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,
1223: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,
1224: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,
1225: PROGRAM_UPDATE_DATE = SYSDATE

Line 1222: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,

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,
1222: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,
1223: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,
1224: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,
1225: PROGRAM_UPDATE_DATE = SYSDATE
1226: -- LOCK_FLAG = 2

Line 1223: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,

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,
1222: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,
1223: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,
1224: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,
1225: PROGRAM_UPDATE_DATE = SYSDATE
1226: -- LOCK_FLAG = 2
1227: WHERE

Line 1224: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,

1220: LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,
1221: LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,
1222: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,
1223: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,
1224: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,
1225: PROGRAM_UPDATE_DATE = SYSDATE
1226: -- LOCK_FLAG = 2
1227: WHERE
1228: cc_entry_interface_group_id = P_CC_Interface_Group_Id;

Line 1247: LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,

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,
1249: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,
1250: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,
1251: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,

Line 1248: LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,

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,
1249: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,
1250: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,
1251: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,
1252: PROGRAM_UPDATE_DATE = SYSDATE

Line 1249: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,

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,
1249: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,
1250: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,
1251: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,
1252: PROGRAM_UPDATE_DATE = SYSDATE
1253: -- LOCK_FLAG = 2

Line 1250: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,

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,
1249: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,
1250: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,
1251: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,
1252: PROGRAM_UPDATE_DATE = SYSDATE
1253: -- LOCK_FLAG = 2
1254: WHERE

Line 1251: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,

1247: LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,
1248: LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,
1249: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,
1250: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,
1251: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,
1252: PROGRAM_UPDATE_DATE = SYSDATE
1253: -- LOCK_FLAG = 2
1254: WHERE
1255: cc_entry_interface_group_id = P_CC_Interface_Group_ID;

Line 1275: LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,

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,
1277: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,
1278: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,
1279: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,

Line 1276: LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,

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,
1277: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,
1278: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,
1279: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,
1280: PROGRAM_UPDATE_DATE = SYSDATE

Line 1277: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,

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,
1277: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,
1278: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,
1279: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,
1280: PROGRAM_UPDATE_DATE = SYSDATE
1281: -- LOCK_FLAG = 2

Line 1278: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,

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,
1277: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,
1278: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,
1279: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,
1280: PROGRAM_UPDATE_DATE = SYSDATE
1281: -- LOCK_FLAG = 2
1282: WHERE

Line 1279: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,

1275: LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,
1276: LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,
1277: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,
1278: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,
1279: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,
1280: PROGRAM_UPDATE_DATE = SYSDATE
1281: -- LOCK_FLAG = 2
1282: WHERE
1283: cc_entry_interface_group_id = P_CC_Interface_Group_ID;