DBA Data[Home] [Help]

APPS.CRP_PLANNER_PK dependencies on MRP_PRINT_PK

Line 49: var_watch_id := mrp_print_pk.start_watch('CAP-load discrete jobs',

45: var_row_count NUMBER;
46: var_spread_load NUMBER;
47: BEGIN
48:
49: var_watch_id := mrp_print_pk.start_watch('CAP-load discrete jobs',
50: arg_request_id,
51: arg_user_id);
52:
53: var_spread_load := TO_NUMBER(FND_PROFILE.VALUE('CRP_SPREAD_LOAD'));

Line 156: mrp_print_pk.stop_watch(arg_request_id,

152: AND recom.compile_designator = arg_compile_desig;
153:
154:
155: var_row_count := SQL%ROWCOUNT;
156: mrp_print_pk.stop_watch(arg_request_id,
157: var_watch_id,
158: var_row_count);
159: COMMIT;
160: END plan_jobs;

Line 175: var_watch_id := mrp_print_pk.start_watch('CAP-load planned orders',

171: var_watch_id NUMBER;
172: var_row_count NUMBER;
173: var_spread_load NUMBER;
174: BEGIN
175: var_watch_id := mrp_print_pk.start_watch('CAP-load planned orders',
176: arg_request_id,
177: arg_user_id);
178:
179: var_spread_load := TO_NUMBER(FND_PROFILE.VALUE('CRP_SPREAD_LOAD'));

Line 266: mrp_print_pk.stop_watch(arg_request_id,

262: AND mp.organization_id = arg_org_id
263: AND mp.compile_designator = arg_compile_desig;
264:
265: var_row_count := SQL%ROWCOUNT;
266: mrp_print_pk.stop_watch(arg_request_id,
267: var_watch_id,
268: var_row_count);
269:
270: if var_spread_load = 1 then

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

272: -- Update the resource end date of a resource requirement to
273: -- the start date of the next resource requirement within the
274: -- same operation.
275:
276: var_watch_id := mrp_print_pk.start_watch('GEN-updated',
277: arg_request_id,
278: arg_user_id,
279: 'ENTITY',
280: 'crp_resource_plan(1)',

Line 312: mrp_print_pk.stop_watch(arg_request_id,

308: and order_type = PLANNED_ORDER);
309:
310: var_row_count := SQL%ROWCOUNT;
311:
312: mrp_print_pk.stop_watch(arg_request_id,
313: var_watch_id,
314: var_row_count);
315:
316: -- Update the resource end date of last resource requirement in

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

315:
316: -- Update the resource end date of last resource requirement in
317: -- an operation to the start date of the next operation
318:
319: var_watch_id := mrp_print_pk.start_watch('GEN-updated',
320: arg_request_id,
321: arg_user_id,
322: 'ENTITY',
323: 'crp_resource_plan(2)',

Line 353: mrp_print_pk.stop_watch(arg_request_id,

349: and resource_end_date is null;
350:
351: var_row_count := SQL%ROWCOUNT;
352:
353: mrp_print_pk.stop_watch(arg_request_id,
354: var_watch_id,
355: var_row_count);
356:
357: -- Update the resource end date of the last resource requirement

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

355: var_row_count);
356:
357: -- Update the resource end date of the last resource requirement
358: -- for a planned order to the planned order due date
359: var_watch_id := mrp_print_pk.start_watch('GEN-updated',
360: arg_request_id,
361: arg_user_id,
362: 'ENTITY',
363: 'crp_resource_plan(3)',

Line 383: mrp_print_pk.stop_watch(arg_request_id,

379: and organization_id = arg_org_id)
380: and order_type = PLANNED_ORDER)
381: and resource_end_date is null;
382:
383: mrp_print_pk.stop_watch(arg_request_id,
384: var_watch_id,
385: var_row_count);
386:
387: end if;

Line 405: var_watch_id := mrp_print_pk.start_watch('CAP-load repetitive jobs',

401: var_row_count NUMBER;
402:
403: BEGIN
404:
405: var_watch_id := mrp_print_pk.start_watch('CAP-load repetitive jobs',
406: arg_request_id,
407: arg_user_id);
408:
409: INSERT INTO crp_resource_plan

Line 513: mrp_print_pk.stop_watch(arg_request_id,

509: AND mp.organization_id = arg_org_id
510: AND mp.compile_designator = arg_compile_desig;
511:
512: var_row_count := SQL%ROWCOUNT;
513: mrp_print_pk.stop_watch(arg_request_id,
514: var_watch_id,
515: var_row_count);
516: COMMIT;
517: END plan_repetitive;