DBA Data[Home] [Help]

APPS.MSC_RELEASE_PK dependencies on MSC_REL_WF

Line 91: var_released_instance msc_rel_wf.NumTblTyp:= msc_rel_wf.NumTblTyp(0);

87: var_loaded_cmro_jobs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
88: var_loaded_cmro_req_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
89: var_resched_cmro_jobs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
90: var_resched_cmro_req_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
91: var_released_instance msc_rel_wf.NumTblTyp:= msc_rel_wf.NumTblTyp(0);
92: var_po_res_id msc_rel_wf.NumTblTyp:= msc_rel_wf.NumTblTyp(0);
93: var_po_res_count msc_rel_wf.NumTblTyp:= msc_rel_wf.NumTblTyp(0);
94: var_po_pwb_count msc_rel_wf.NumTblTyp:= msc_rel_wf.NumTblTyp(0);
95: var_count_po NUMBER := 0;

Line 92: var_po_res_id msc_rel_wf.NumTblTyp:= msc_rel_wf.NumTblTyp(0);

88: var_loaded_cmro_req_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
89: var_resched_cmro_jobs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
90: var_resched_cmro_req_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
91: var_released_instance msc_rel_wf.NumTblTyp:= msc_rel_wf.NumTblTyp(0);
92: var_po_res_id msc_rel_wf.NumTblTyp:= msc_rel_wf.NumTblTyp(0);
93: var_po_res_count msc_rel_wf.NumTblTyp:= msc_rel_wf.NumTblTyp(0);
94: var_po_pwb_count msc_rel_wf.NumTblTyp:= msc_rel_wf.NumTblTyp(0);
95: var_count_po NUMBER := 0;
96:

Line 93: var_po_res_count msc_rel_wf.NumTblTyp:= msc_rel_wf.NumTblTyp(0);

89: var_resched_cmro_jobs MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
90: var_resched_cmro_req_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
91: var_released_instance msc_rel_wf.NumTblTyp:= msc_rel_wf.NumTblTyp(0);
92: var_po_res_id msc_rel_wf.NumTblTyp:= msc_rel_wf.NumTblTyp(0);
93: var_po_res_count msc_rel_wf.NumTblTyp:= msc_rel_wf.NumTblTyp(0);
94: var_po_pwb_count msc_rel_wf.NumTblTyp:= msc_rel_wf.NumTblTyp(0);
95: var_count_po NUMBER := 0;
96:
97:

Line 94: var_po_pwb_count msc_rel_wf.NumTblTyp:= msc_rel_wf.NumTblTyp(0);

90: var_resched_cmro_req_id MSC_Rel_Plan_PUB.NumTblTyp:= MSC_Rel_Plan_PUB.NumTblTyp(0);
91: var_released_instance msc_rel_wf.NumTblTyp:= msc_rel_wf.NumTblTyp(0);
92: var_po_res_id msc_rel_wf.NumTblTyp:= msc_rel_wf.NumTblTyp(0);
93: var_po_res_count msc_rel_wf.NumTblTyp:= msc_rel_wf.NumTblTyp(0);
94: var_po_pwb_count msc_rel_wf.NumTblTyp:= msc_rel_wf.NumTblTyp(0);
95: var_count_po NUMBER := 0;
96:
97:
98: -- ========================================================================

Line 1493: msc_rel_wf.reschedule_purchase_orders

1489: update msc_supplies
1490: set releasable= null where releasable = 99 ;
1491:
1492: /*purchase order reschedules require separate function call */
1493: msc_rel_wf.reschedule_purchase_orders
1494: (arg_plan_id,lv_arg_org_id_new,lv_arg_instance_id_new,lv_arg_org_id_new,
1495: lv_arg_instance_id_new,var_count_po,var_released_instance,
1496: var_po_res_id,var_po_res_count,var_po_pwb_count);
1497: