DBA Data[Home] [Help]

APPS.MSC_SELECT_ALL_FOR_RELEASE_PUB dependencies on MSC_REL_WF

Line 332: p_valid := msc_rel_wf.is_pjm_valid(p_org_id,

328: FND_MESSAGE.GET_STRING('MRP', 'MRP_REL_ALL_UNIT_NUMBER');
329: end if;
330:
331: if p_project_id is not null then
332: p_valid := msc_rel_wf.is_pjm_valid(p_org_id,
333: p_project_id,
334: p_task_id,
335: p_due_date,
336: null,

Line 433: msc_rel_wf.get_acc_class_from_source(

429: OPEN sr_item;
430: FETCH sr_item INTO p_sr_item_id;
431: CLOSE sr_item;
432: p_item_wip_class :=
433: msc_rel_wf.get_acc_class_from_source(
434: p_org_id,
435: p_sr_item_id,
436: p_project_id,
437: p_inst_id);

Line 442: msc_rel_wf.get_job_seq_from_source(p_inst_id);

438: end if; -- if p_cfm_routing_flag <> 3
439: end if; -- if p_wip_class_code is null then
440:
441: p_job_name := get_wip_job_prefix(p_inst_id)||
442: msc_rel_wf.get_job_seq_from_source(p_inst_id);
443:
444: update msc_supplies mr
445: set implement_wip_class_code =
446: nvl(p_wip_class_code, p_item_wip_class),

Line 647: msc_rel_wf.update_so_dates(p_plan_id, p_transaction_id, p_inst_id,

643: v_ship_date date;
644: v_arrival_date date;
645: v_earliest_date date;
646: BEGIN
647: msc_rel_wf.update_so_dates(p_plan_id, p_transaction_id, p_inst_id,
648: p_impl_date, v_ship_date, v_arrival_date,
649: v_earliest_date);
650: update msc_demands
651: set implement_org_id = organization_id,

Line 685: msc_rel_wf.get_profile_value(

681: FROM msc_apps_instances;
682:
683: FOR i in 1..g_instance_id.COUNT LOOP
684: BEGIN
685: msc_rel_wf.get_profile_value(
686: p_profile_name => 'WIP_JOB_PREFIX',
687: p_instance_id => g_instance_id(i),
688: p_calling_source => 'PACKAGE',
689: p_profile_value => g_job_prefix(i));

Line 866: msc_rel_wf.verify_so_release(p_plan_id, p_transaction_id, p_inst_id);

862: FETCH selCur INTO p_plan_id,p_transaction_id, p_inst_id;
863: EXIT WHEN selCur%NOTFOUND;
864: p_mesg := null;
865: p_mesg :=
866: msc_rel_wf.verify_so_release(p_plan_id, p_transaction_id, p_inst_id);
867: if p_mesg is not null then
868: p_rel_error := FND_MESSAGE.GET_STRING('MSC',p_mesg);
869: update_dmd_rel_error;
870: p_error_rows := p_error_rows +1;