139:
140: /* End of input validation */
141:
142: -- Get a new cycle count schedule ID
143: SELECT mtl_cc_schedule_requests_s.NEXTVAL
144: INTO l_cycle_count_schedule_id
145: FROM dual;
146: IF (l_debug = 1) THEN
147: print_debug('CC Schedule ID: ' || l_cycle_count_schedule_id);
160: END IF;
161:
162: /* End of fix for Bug 5236299 */
163:
164: -- Insert a new record into MTL_CC_SCHEDULE_REQUESTS
165: IF (l_debug = 1) THEN
166: print_debug('Inserting into table MTL_CC_SCHEDULE_REQUESTS');
167: END IF;
168: INSERT INTO MTL_CC_SCHEDULE_REQUESTS
162: /* End of fix for Bug 5236299 */
163:
164: -- Insert a new record into MTL_CC_SCHEDULE_REQUESTS
165: IF (l_debug = 1) THEN
166: print_debug('Inserting into table MTL_CC_SCHEDULE_REQUESTS');
167: END IF;
168: INSERT INTO MTL_CC_SCHEDULE_REQUESTS
169: (cycle_count_schedule_id, last_update_date, last_updated_by,
170: creation_date, created_by, cycle_count_header_id,
164: -- Insert a new record into MTL_CC_SCHEDULE_REQUESTS
165: IF (l_debug = 1) THEN
166: print_debug('Inserting into table MTL_CC_SCHEDULE_REQUESTS');
167: END IF;
168: INSERT INTO MTL_CC_SCHEDULE_REQUESTS
169: (cycle_count_schedule_id, last_update_date, last_updated_by,
170: creation_date, created_by, cycle_count_header_id,
171: request_source_type, zero_count_flag, schedule_date,
172: schedule_status, subinventory, locator_id,