APPS.MRP_UPDATE_MRP_INFO_PK dependencies on MRP_PRINT_PK

Line 277: var_watch_id := mrp_print_pk.start_watch(

273:
274: BEGIN
275:
276:
277: var_watch_id := mrp_print_pk.start_watch(
278: 'GEN-deleted from table', arg_request_id, arg_user_id,
279: 'TABLE', 'mrp_schedule_dates', 'N');
280: var_row_count := 0;
281: OPEN dates_cursor;

Line 294: mrp_print_pk.stop_watch(arg_request_id, var_watch_id, var_row_count);

290: var_row_count := var_row_count + NVL(SQL%ROWCOUNT, 0);
291:
292: END LOOP;
293: CLOSE dates_cursor;
294: mrp_print_pk.stop_watch(arg_request_id, var_watch_id, var_row_count);
295:
296:
297: var_watch_id := mrp_print_pk.start_watch(
298: 'GEN-deleted from table', arg_request_id, arg_user_id,

Line 297: var_watch_id := mrp_print_pk.start_watch(

293: CLOSE dates_cursor;
294: mrp_print_pk.stop_watch(arg_request_id, var_watch_id, var_row_count);
295:
296:
297: var_watch_id := mrp_print_pk.start_watch(
298: 'GEN-deleted from table', arg_request_id, arg_user_id,
299: 'TABLE', 'mrp_recommendations', 'N');
300: var_row_count := 0;
301: OPEN recommendations_cursor;

Line 314: mrp_print_pk.stop_watch(arg_request_id, var_watch_id, var_row_count);

310: var_row_count := var_row_count + NVL(SQL%ROWCOUNT, 0);
311:
312: END LOOP;
313: CLOSE recommendations_cursor;
314: mrp_print_pk.stop_watch(arg_request_id, var_watch_id, var_row_count);
315:
316: --
317: -- If called for wip jobs set the completion_date and completion
318: -- quantities for all the jobs that we performed relief

Line 321: var_watch_id := mrp_print_pk.start_watch(

317: -- If called for wip jobs set the completion_date and completion
318: -- quantities for all the jobs that we performed relief
319: --
320:
321: var_watch_id := mrp_print_pk.start_watch(
322: 'GEN-updated', arg_request_id, arg_user_id, 'ENTITY',
323: 'wip_discrete_jobs', 'N');
324: var_row_count := 0;
325: SAVEPOINT jobs;

Line 369: mrp_print_pk.stop_watch(arg_request_id, var_watch_id,var_row_count);

365: prev_org_id := var_org_id;
366:
367: END LOOP;
368: CLOSE jobs_cursor;
369: mrp_print_pk.stop_watch(arg_request_id, var_watch_id,var_row_count);
370:
371: --
372: -- WIP Flow Schedules: set the completion_date and completion
373: -- quantities for all the flow schedules that we performed relief

Line 375: var_watch_id := mrp_print_pk.start_watch(

371: --
372: -- WIP Flow Schedules: set the completion_date and completion
373: -- quantities for all the flow schedules that we performed relief
374: --
375: var_watch_id := mrp_print_pk.start_watch(
376: 'GEN-updated', arg_request_id, arg_user_id, 'ENTITY',
377: 'wip_flow_schedules', 'N');
378: var_row_count := 0;
379: prev_wip_entity_id := -1;

Line 418: mrp_print_pk.stop_watch(arg_request_id, var_watch_id, var_row_count);

414: prev_org_id := var_org_id;
415:
416: END LOOP;
417: CLOSE flow_schedules_cursor;
418: mrp_print_pk.stop_watch(arg_request_id, var_watch_id, var_row_count);
419:
420: var_watch_id := mrp_print_pk.start_watch(
421: 'GEN-updated', arg_request_id, arg_user_id,
422: 'ENTITY', 'mtl_supply', 'N');

Line 420: var_watch_id := mrp_print_pk.start_watch(

416: END LOOP;
417: CLOSE flow_schedules_cursor;
418: mrp_print_pk.stop_watch(arg_request_id, var_watch_id, var_row_count);
419:
420: var_watch_id := mrp_print_pk.start_watch(
421: 'GEN-updated', arg_request_id, arg_user_id,
422: 'ENTITY', 'mtl_supply', 'N');
423:
424: var_row_count := 0;

Line 464: mrp_print_pk.stop_watch(arg_request_id, var_watch_id,var_row_count);

460:
461: END LOOP;
462: CLOSE consol_cursor_ms;
463:
464: mrp_print_pk.stop_watch(arg_request_id, var_watch_id,var_row_count);
465:
466: END mrp_update_mrp_cols;
467:
468: END MRP_UPDATE_MRP_INFO_PK;