APPS.MSC_DEMANTRA_PKG dependencies on MSC_DEMANTRA_F

Line 33: insert into msc_demantra_f (

29: end;
30:
31:
32: --dbms_output.put_line(l_api_name||'('||p_plan_id||', '||p_plan_run_id||')');
33: insert into msc_demantra_f (
34: ods_plan_id,
35: plan_id,
36: plan_run_id,
37: sr_instance_id,

Line 181: insert into msc_demantra_f (

177: is
178: l_category_set_id1 number := fnd_profile.value('MSC_HUB_CAT_SET_ID_1');
179: begin
180: -- level 1
181: insert into msc_demantra_f (
182: ods_plan_id, plan_id, plan_run_id,
183: sr_instance_id, organization_id, owning_org_id, owning_inst_id,
184: inventory_item_id,
185: customer_id, customer_site_id, region_id,

Line 217: msc_demantra_f f,

213: sysdate, fnd_global.user_id, fnd_global.login_id,
214: fnd_global.conc_program_id, fnd_global.conc_login_id,
215: fnd_global.prog_appl_id, fnd_global.conc_request_id
216: from
217: msc_demantra_f f,
218: msc_phub_item_categories_mv q
219: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id
220: and f.aggr_type=0
221: and f.owning_inst_id=q.sr_instance_id(+)

Line 256: delete from msc_demantra_f

252: begin
253: retcode := 0;
254: errbuf := '';
255:
256: delete from msc_demantra_f
257: where plan_id = p_plan_id
258: and plan_run_id = nvl(p_plan_run_id, plan_run_id);
259:
260: commit;