DBA Data[Home] [Help]

APPS.WMS_CYCLE_PVT dependencies on MTL_CC_SCHEDULE_REQUESTS

Line 162: SELECT mtl_cc_schedule_requests_s.NEXTVAL

158:
159: /* End of input validation */
160:
161: -- Get a new cycle count schedule ID
162: SELECT mtl_cc_schedule_requests_s.NEXTVAL
163: INTO l_cycle_count_schedule_id
164: FROM dual;
165: IF (l_debug = 1) THEN
166: print_debug('CC Schedule ID: ' || l_cycle_count_schedule_id);

Line 192: -- Insert a new record into MTL_CC_SCHEDULE_REQUESTS

188: IF (l_debug = 1) THEN
189: print_debug('p_lpn_id is null');
190: END IF;
191:
192: -- Insert a new record into MTL_CC_SCHEDULE_REQUESTS
193: IF (l_debug = 1) THEN
194: print_debug('Inserting into table MTL_CC_SCHEDULE_REQUESTS');
195: END IF;
196: INSERT INTO MTL_CC_SCHEDULE_REQUESTS

Line 194: print_debug('Inserting into table MTL_CC_SCHEDULE_REQUESTS');

190: END IF;
191:
192: -- Insert a new record into MTL_CC_SCHEDULE_REQUESTS
193: IF (l_debug = 1) THEN
194: print_debug('Inserting into table MTL_CC_SCHEDULE_REQUESTS');
195: END IF;
196: INSERT INTO MTL_CC_SCHEDULE_REQUESTS
197: (cycle_count_schedule_id, last_update_date, last_updated_by,
198: creation_date, created_by, cycle_count_header_id,

Line 196: INSERT INTO MTL_CC_SCHEDULE_REQUESTS

192: -- Insert a new record into MTL_CC_SCHEDULE_REQUESTS
193: IF (l_debug = 1) THEN
194: print_debug('Inserting into table MTL_CC_SCHEDULE_REQUESTS');
195: END IF;
196: INSERT INTO MTL_CC_SCHEDULE_REQUESTS
197: (cycle_count_schedule_id, last_update_date, last_updated_by,
198: creation_date, created_by, cycle_count_header_id,
199: request_source_type, zero_count_flag, schedule_date,
200: schedule_status, subinventory, locator_id,