175: MTL_CC_ENTRIES_INTERFACE_S2.nextval
176: INTO
177: L_cc_entry_iface_group_id
178: FROM
179: dual;
180: END IF;
181: --
182: -- Only one parameter can be used
183: IF P_Cycle_Count_Entry_Id IS NOT NULL THEN
589: SELECT ROUND(L_MaxNumRows/L_CountWorker)
590: INTO
591: L_CountRows
592: FROM
593: DUAL;
594: --
595: IF(L_CountRows*L_CountWorker
597: END IF;
627: SELECT MTL_CC_ENTRIES_INTERFACE_S1.NEXTVAL
628: INTO
629: L_NextGroupID
630: FROM
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