DBA Data[Home] [Help]

APPS.MSC_SELECT_ALL_FOR_RELEASE_PUB dependencies on MSC_REL_WF

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

260: FND_MESSAGE.GET_STRING('MRP', 'MRP_REL_ALL_UNIT_NUMBER');
261: end if;
262:
263: if p_project_id is not null then
264: p_valid := msc_rel_wf.is_pjm_valid(p_org_id,
265: p_project_id,
266: p_task_id,
267: p_due_date,
268: null,

Line 360: msc_rel_wf.get_acc_class_from_source(

356: OPEN sr_item;
357: FETCH sr_item INTO p_sr_item_id;
358: CLOSE sr_item;
359: p_item_wip_class :=
360: msc_rel_wf.get_acc_class_from_source(
361: p_org_id,
362: p_sr_item_id,
363: p_project_id,
364: p_inst_id);

Line 369: msc_rel_wf.get_job_seq_from_source(p_inst_id);

365: end if; -- if p_cfm_routing_flag <> 3
366: end if; -- if p_wip_class_code is null then
367:
368: p_job_name := get_wip_job_prefix(p_inst_id)||
369: msc_rel_wf.get_job_seq_from_source(p_inst_id);
370:
371: update msc_supplies mr
372: set implement_wip_class_code =
373: nvl(p_wip_class_code, p_item_wip_class),

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

570: v_ship_date date;
571: v_arrival_date date;
572: v_earliest_date date;
573: BEGIN
574: msc_rel_wf.update_so_dates(p_plan_id, p_transaction_id, p_inst_id,
575: p_impl_date, v_ship_date, v_arrival_date,
576: v_earliest_date);
577: update msc_demands
578: set implement_org_id = organization_id,

Line 607: msc_rel_wf.get_profile_value(

603: FROM msc_apps_instances;
604:
605: FOR i in 1..g_instance_id.COUNT LOOP
606: BEGIN
607: msc_rel_wf.get_profile_value(
608: p_profile_name => 'WIP_JOB_PREFIX',
609: p_instance_id => g_instance_id(i),
610: p_calling_source => 'PACKAGE',
611: p_profile_value => g_job_prefix(i));

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

722: FETCH selCur INTO p_plan_id,p_transaction_id, p_inst_id;
723: EXIT WHEN selCur%NOTFOUND;
724: p_mesg := null;
725: p_mesg :=
726: msc_rel_wf.verify_so_release(p_plan_id, p_transaction_id, p_inst_id);
727: if p_mesg is not null then
728: p_rel_error := FND_MESSAGE.GET_STRING('MSC',p_mesg);
729: update_dmd_rel_error;
730: p_error_rows := p_error_rows +1;