DBA Data[Home] [Help]

APPS.MRP_AUTO_REDUCE_PK dependencies on MRP_SCHEDULE_CONSUMPTIONS

Line 110: -- mrp_schedule_consumptions, and then reduce the MPS entry to zero.

106: BEGIN
107:
108: -- If called for discrete schedules select all the discrete entries that
109: -- are past the auto-reduction date, insert a row into
110: -- mrp_schedule_consumptions, and then reduce the MPS entry to zero.
111:
112: var_watch_id := mrp_print_pk.start_watch('GEN-updated',
113: arg_request_id,
114: arg_user_id,

Line 130: INSERT INTO mrp_schedule_consumptions(

126: EXIT WHEN DISCRETE_SCHEDULES_CUR%NOTFOUND;
127:
128: rows_processed := rows_processed + 1;
129:
130: INSERT INTO mrp_schedule_consumptions(
131: transaction_id,
132: relief_type,
133: disposition_type,
134: disposition_id,