APPS.CRP_PLANNER_PK dependencies on CRP_RESOURCE_PLAN

Line 64: INSERT INTO crp_resource_plan

60: --- To correctly calculate the resource end date, we find the difference
61: --- between the actual # of days the requiremente should be spread
62: --- and the current amount of days we spread now. We correct the
63: ---
64: INSERT INTO crp_resource_plan
65: (transaction_id,
66: department_id,
67: resource_id,
68: organization_id,

Line 84: SELECT crp_resource_plan_s.nextval,

80: operation_seq_num,
81: resource_seq_num,
82: resource_end_date,
83: daily_resource_hours)
84: SELECT crp_resource_plan_s.nextval,
85: resources.department_id,
86: resources.resource_id,
87: resources.organization_id,
88: arg_compile_desig,

Line 181: INSERT INTO crp_resource_plan

177: arg_user_id);
178:
179: var_spread_load := TO_NUMBER(FND_PROFILE.VALUE('CRP_SPREAD_LOAD'));
180:
181: INSERT INTO crp_resource_plan
182: (transaction_id,
183: department_id,
184: resource_id,
185: organization_id,

Line 201: SELECT crp_resource_plan_s.nextval,

197: operation_seq_num,
198: resource_seq_num,
199: resource_end_date,
200: daily_resource_hours)
201: SELECT crp_resource_plan_s.nextval,
202: labor.department_id,
203: labor.resource_id,
204: labor.organization_id,
205: arg_compile_desig,

Line 280: 'crp_resource_plan(1)',

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)',
281: 'N');
282:
283: update crp_resource_plan plan1
284: set resource_end_date =

Line 283: update crp_resource_plan plan1

279: 'ENTITY',
280: 'crp_resource_plan(1)',
281: 'N');
282:
283: update crp_resource_plan plan1
284: set resource_end_date =
285: (SELECT resource_date
286: FROM crp_resource_plan plan2
287: WHERE (plan2.resource_seq_num =

Line 286: FROM crp_resource_plan plan2

282:
283: update crp_resource_plan plan1
284: set resource_end_date =
285: (SELECT resource_date
286: FROM crp_resource_plan plan2
287: WHERE (plan2.resource_seq_num =
288: (select min(resource_seq_num)
289: from crp_resource_plan plan3
290: where plan3.source_transaction_id =

Line 289: from crp_resource_plan plan3

285: (SELECT resource_date
286: FROM crp_resource_plan plan2
287: WHERE (plan2.resource_seq_num =
288: (select min(resource_seq_num)
289: from crp_resource_plan plan3
290: where plan3.source_transaction_id =
291: plan2.source_transaction_id
292: and plan3.operation_seq_num =
293: plan2.operation_seq_num

Line 323: 'crp_resource_plan(2)',

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)',
324: 'N');
325:
326: update crp_resource_plan plan1
327: set resource_end_date =

Line 326: update crp_resource_plan plan1

322: 'ENTITY',
323: 'crp_resource_plan(2)',
324: 'N');
325:
326: update crp_resource_plan plan1
327: set resource_end_date =
328: (SELECT resource_date
329: FROM crp_resource_plan plan2
330: WHERE (plan2.resource_seq_num, plan2.operation_seq_num) =

Line 329: FROM crp_resource_plan plan2

325:
326: update crp_resource_plan plan1
327: set resource_end_date =
328: (SELECT resource_date
329: FROM crp_resource_plan plan2
330: WHERE (plan2.resource_seq_num, plan2.operation_seq_num) =
331: (SELECT min(resource_seq_num), min(operation_seq_num)
332: FROM crp_resource_plan plan3
333: where plan3.source_transaction_id =

Line 332: FROM crp_resource_plan plan3

328: (SELECT resource_date
329: FROM crp_resource_plan plan2
330: WHERE (plan2.resource_seq_num, plan2.operation_seq_num) =
331: (SELECT min(resource_seq_num), min(operation_seq_num)
332: FROM crp_resource_plan plan3
333: where plan3.source_transaction_id =
334: plan2.source_transaction_id
335: and plan3.operation_seq_num >
336: plan1.operation_seq_num)

Line 363: 'crp_resource_plan(3)',

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)',
364: 'N');
365:
366: update crp_resource_plan plan1
367: set resource_end_date =

Line 366: update crp_resource_plan plan1

362: 'ENTITY',
363: 'crp_resource_plan(3)',
364: 'N');
365:
366: update crp_resource_plan plan1
367: set resource_end_date =
368: (select new_schedule_date
369: from mrp_recommendations
370: where transaction_id = plan1.source_transaction_id)

Line 409: INSERT INTO crp_resource_plan

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
410: (transaction_id,
411: department_id,
412: resource_id,
413: organization_id,

Line 429: SELECT crp_resource_plan_s.nextval,

425: operation_seq_num,
426: resource_seq_num,
427: resource_end_date,
428: daily_resource_hours)
429: SELECT crp_resource_plan_s.nextval,
430: labor.department_id,
431: labor.resource_id,
432: labor.organization_id,
433: arg_compile_desig,