DBA Data[Home] [Help]

APPS.WMS_CYCLE_PVT dependencies on MTL_CC_SCHEDULE_REQUESTS

Line 143: SELECT mtl_cc_schedule_requests_s.NEXTVAL

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);

Line 164: -- Insert a new record into MTL_CC_SCHEDULE_REQUESTS

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

Line 166: print_debug('Inserting into table 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,

Line 168: INSERT INTO MTL_CC_SCHEDULE_REQUESTS

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,