DBA Data[Home] [Help]

APPS.MSC_EXP_WF dependencies on MSC_REL_WF

Line 1945: msc_rel_wf.init_db(l_planner);

1941: if (funcmode = 'RUN') then
1942: -- This is the new call to the reschedule procedure
1943: if (l_order_type in (1, 2, 3)) then -- po, req, discrete
1944: begin
1945: msc_rel_wf.init_db(l_planner);
1946: p_request_id := fnd_request.submit_request(
1947: 'MSC',
1948: 'MSCWFRES',
1949: null,

Line 2047: p_po_res_id msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);

2043: var_loaded_ext_repair_orders MSC_Rel_Plan_PUB.NumTblTyp:=
2044: MSC_Rel_Plan_PUB.NumTblTyp(0);
2045: var_ext_repair_orders_id MSC_Rel_Plan_PUB.NumTblTyp:=
2046: MSC_Rel_Plan_PUB.NumTblTyp(0);
2047: p_po_res_id msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
2048: p_po_res_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
2049: p_po_pwb_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
2050: p_released_inst msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
2051: p_res_po_count number :=0;

Line 2048: p_po_res_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);

2044: MSC_Rel_Plan_PUB.NumTblTyp(0);
2045: var_ext_repair_orders_id MSC_Rel_Plan_PUB.NumTblTyp:=
2046: MSC_Rel_Plan_PUB.NumTblTyp(0);
2047: p_po_res_id msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
2048: p_po_res_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
2049: p_po_pwb_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
2050: p_released_inst msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
2051: p_res_po_count number :=0;
2052: p_request_id number;

Line 2049: p_po_pwb_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);

2045: var_ext_repair_orders_id MSC_Rel_Plan_PUB.NumTblTyp:=
2046: MSC_Rel_Plan_PUB.NumTblTyp(0);
2047: p_po_res_id msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
2048: p_po_res_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
2049: p_po_pwb_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
2050: p_released_inst msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
2051: p_res_po_count number :=0;
2052: p_request_id number;
2053: BEGIN

Line 2050: p_released_inst msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);

2046: MSC_Rel_Plan_PUB.NumTblTyp(0);
2047: p_po_res_id msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
2048: p_po_res_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
2049: p_po_pwb_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
2050: p_released_inst msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
2051: p_res_po_count number :=0;
2052: p_request_id number;
2053: BEGIN
2054:

Line 2086: msc_rel_wf.reschedule_purchase_orders(

2082:
2083: if l_order_type = 1 then -- po
2084: FND_FILE.PUT_LINE(FND_FILE.LOG,
2085: 'start to launch PO Reschedule for '||l_transaction_id);
2086: msc_rel_wf.reschedule_purchase_orders(
2087: l_plan_id,
2088: l_org_id,
2089: l_sr_instance_id,
2090: l_org_id,

Line 3589: msc_rel_wf.init_db(p_planner);

3585: p_item_key in varchar2,
3586: p_request_id out NOCOPY number) IS
3587: p_result boolean;
3588: Begin
3589: msc_rel_wf.init_db(p_planner);
3590: p_result := fnd_request.set_mode(true);
3591:
3592: -- this will call start_deferred_activity
3593: p_request_id := fnd_request.submit_request(