DBA Data[Home] [Help]

APPS.MRP_AUTO_REDUCE_PK dependencies on MRP_PRINT_PK

Line 112: var_watch_id := mrp_print_pk.start_watch('GEN-updated',

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,
115: 'ENTITY',
116: 'mrp_schedule_dates',

Line 175: mrp_print_pk.stop_watch(arg_request_id,

171: WHERE rowid = sched_rowid;
172:
173: END LOOP;
174:
175: mrp_print_pk.stop_watch(arg_request_id,
176: var_watch_id,
177: rows_processed);
178:
179: -- Delete all the repetitive entries that are past the auto-reduce date

Line 181: var_watch_id := mrp_print_pk.start_watch('GEN-deleting from table',

177: rows_processed);
178:
179: -- Delete all the repetitive entries that are past the auto-reduce date
180:
181: var_watch_id := mrp_print_pk.start_watch('GEN-deleting from table',
182: arg_request_id,
183: arg_user_id,
184: 'ROUTINE',
185: 'mrarmps_auto_reduce_mps',

Line 252: mrp_print_pk.stop_watch(arg_request_id,

248: arg_sched_desig);
249:
250: rows_processed := SQL%ROWCOUNT;
251:
252: mrp_print_pk.stop_watch(arg_request_id,
253: var_watch_id,
254: rows_processed);
255: -- Truncate all the entries that start before the auto-reduce date but end
256: -- after the auto-reduce date

Line 257: var_watch_id := mrp_print_pk.start_watch('GEN-updated',

253: var_watch_id,
254: rows_processed);
255: -- Truncate all the entries that start before the auto-reduce date but end
256: -- after the auto-reduce date
257: var_watch_id := mrp_print_pk.start_watch('GEN-updated',
258: arg_request_id,
259: arg_user_id,
260: 'ENTITY',
261: 'mrp_schedule_dates',

Line 385: mrp_print_pk.stop_watch(arg_request_id,

381: SYS_YES, dates.schedule_designator,
382: arg_sched_desig);
383: rows_processed := SQL%ROWCOUNT;
384:
385: mrp_print_pk.stop_watch(arg_request_id,
386: var_watch_id,
387: rows_processed);
388: END mrp_auto_reduce_mps;
389: