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 257: IF MTL_CCEOI_VAR_PVT.g_tracking_quantity_ind <> 'PS' THEN

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

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

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

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

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

Line 610: LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,

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

Line 611: LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,

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

Line 612: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,

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

Line 613: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,

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

Line 614: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,

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

Line 638: LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,

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

Line 639: LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,

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

Line 640: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,

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

Line 641: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,

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

Line 642: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,

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

Line 657: LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,

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

Line 658: LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,

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

Line 659: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,

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

Line 660: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,

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

Line 661: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,

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

Line 914: L_iface_rec MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE;

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

Line 964: LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,

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

Line 965: LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,

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

Line 966: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,

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

Line 967: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,

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

Line 968: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,

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

Line 984: MTL_CCEOI_VAR_PVT.G_cc_entry_interface_id :=

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1168: c_rec.action_code = MTL_CCEOI_VAR_PVT.G_VALIDATE THEN

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

Line 1178: c_rec.action_code = MTL_CCEOI_VAR_PVT.G_CREATE THEN

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

Line 1187: c_rec.action_code = MTL_CCEOI_VAR_PVT.G_VALSIM THEN

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

Line 1196: c_rec.action_code = MTL_CCEOI_VAR_PVT.G_PROCESS THEN

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

Line 1219: LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,

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

Line 1220: LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,

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

Line 1221: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,

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

Line 1222: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,

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

Line 1223: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,

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

Line 1246: LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,

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

Line 1247: LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,

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

Line 1248: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,

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

Line 1249: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,

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

Line 1250: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,

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

Line 1274: LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,

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

Line 1275: LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,

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

Line 1276: PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,

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

Line 1277: PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,

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

Line 1278: REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,

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