APPS.MSC_RESOURCE_PKG dependencies on MSC_RESOURCES_F

Line 13: insert into msc_resources_f(

9: l_constrained_plan := msc_phub_util.is_plan_constrained(p_plan_id);
10: retcode := 0;
11: errbuf := NULL;
12:
13: insert into msc_resources_f(
14: plan_id,
15: plan_run_id,
16: sr_instance_id,
17: organization_id,

Line 312: insert into msc_resources_f (

308: p_plan_id number, p_plan_run_id number)
309: is
310: begin
311: -- level 1
312: insert into msc_resources_f (
313: plan_id, plan_run_id,
314: sr_instance_id, organization_id,
315: department_id, owning_department_id, resource_id,
316: inventory_item_id, analysis_date,

Line 353: msc_resources_f f

349: sysdate, fnd_global.user_id, fnd_global.login_id,
350: fnd_global.conc_program_id, fnd_global.conc_login_id,
351: fnd_global.prog_appl_id, fnd_global.conc_request_id
352: from
353: msc_resources_f f
354: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id
355: and f.aggr_type=0
356: group by
357: f.plan_id, f.plan_run_id,

Line 387: msc_resources_f f,

383: sysdate, fnd_global.user_id, fnd_global.login_id,
384: fnd_global.conc_program_id, fnd_global.conc_login_id,
385: fnd_global.prog_appl_id, fnd_global.conc_request_id
386: from
387: msc_resources_f f,
388: msc_department_resources r
389: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id
390: and f.aggr_type=0
391: and r.plan_id(+) = f.plan_id

Line 405: insert into msc_resources_f (

401:
402: commit;
403:
404: -- level 2
405: insert into msc_resources_f (
406: plan_id, plan_run_id,
407: sr_instance_id, organization_id,
408: department_id, owning_department_id, resource_id,
409: inventory_item_id, analysis_date,

Line 444: msc_resources_f f,

440: sysdate, fnd_global.user_id, fnd_global.login_id,
441: fnd_global.conc_program_id, fnd_global.conc_login_id,
442: fnd_global.prog_appl_id, fnd_global.conc_request_id
443: from
444: msc_resources_f f,
445: msc_phub_mfg_cal_periods_mv mp
446: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id
447: and f.aggr_type = 82
448: and f.analysis_date between mp.period_start_date and mp.period_end_date

Line 477: msc_resources_f f,

473: sysdate, fnd_global.user_id, fnd_global.login_id,
474: fnd_global.conc_program_id, fnd_global.conc_login_id,
475: fnd_global.prog_appl_id, fnd_global.conc_request_id
476: from
477: msc_resources_f f,
478: msc_phub_fiscal_periods_mv fp
479: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id
480: and f.aggr_type = 82
481: and f.analysis_date between fp.start_date and fp.end_date

Line 510: from msc_resources_f

506: retcode := 0;
507: errbuf := NULL;
508:
509: delete
510: from msc_resources_f
511: where plan_id = p_plan_id
512: and plan_run_id = nvl(p_plan_run_id,plan_run_id);
513: COMMIT;
514: