eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_RP_RELEASE_PUB dependencies on MSC_REL_WF

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

27: loaded_int_repair_orders MSC_Rel_Plan_PUB.NumTblTyp := MSC_Rel_Plan_PUB.NumTblTyp(0);
28: int_repair_orders_id MSC_Rel_Plan_PUB.NumTblTyp := MSC_Rel_Plan_PUB.NumTblTyp(0);
29: loaded_ext_repair_orders MSC_Rel_Plan_PUB.NumTblTyp := MSC_Rel_Plan_PUB.NumTblTyp(0);
30: ext_repair_orders_id MSC_Rel_Plan_PUB.NumTblTyp := MSC_Rel_Plan_PUB.NumTblTyp(0);
31: p_po_res_id msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
32: p_released_inst msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
33: p_po_res_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
34: p_po_pwb_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
35: p_so_rel_id msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);

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

28: int_repair_orders_id MSC_Rel_Plan_PUB.NumTblTyp := MSC_Rel_Plan_PUB.NumTblTyp(0);
29: loaded_ext_repair_orders MSC_Rel_Plan_PUB.NumTblTyp := MSC_Rel_Plan_PUB.NumTblTyp(0);
30: ext_repair_orders_id MSC_Rel_Plan_PUB.NumTblTyp := MSC_Rel_Plan_PUB.NumTblTyp(0);
31: p_po_res_id msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
32: p_released_inst msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
33: p_po_res_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
34: p_po_pwb_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
35: p_so_rel_id msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
36: p_so_released_inst msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);

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

29: loaded_ext_repair_orders MSC_Rel_Plan_PUB.NumTblTyp := MSC_Rel_Plan_PUB.NumTblTyp(0);
30: ext_repair_orders_id MSC_Rel_Plan_PUB.NumTblTyp := MSC_Rel_Plan_PUB.NumTblTyp(0);
31: p_po_res_id msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
32: p_released_inst msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
33: p_po_res_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
34: p_po_pwb_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
35: p_so_rel_id msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
36: p_so_released_inst msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
37: p_so_rel_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);

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

30: ext_repair_orders_id MSC_Rel_Plan_PUB.NumTblTyp := MSC_Rel_Plan_PUB.NumTblTyp(0);
31: p_po_res_id msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
32: p_released_inst msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
33: p_po_res_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
34: p_po_pwb_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
35: p_so_rel_id msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
36: p_so_released_inst msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
37: p_so_rel_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
38: p_so_pwb_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);

Line 35: p_so_rel_id msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);

31: p_po_res_id msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
32: p_released_inst msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
33: p_po_res_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
34: p_po_pwb_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
35: p_so_rel_id msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
36: p_so_released_inst msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
37: p_so_rel_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
38: p_so_pwb_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
39:

Line 36: p_so_released_inst msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);

32: p_released_inst msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
33: p_po_res_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
34: p_po_pwb_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
35: p_so_rel_id msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
36: p_so_released_inst msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
37: p_so_rel_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
38: p_so_pwb_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
39:
40:

Line 37: p_so_rel_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);

33: p_po_res_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
34: p_po_pwb_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
35: p_so_rel_id msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
36: p_so_released_inst msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
37: p_so_rel_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
38: p_so_pwb_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
39:
40:
41: user_id NUMBER :=nvl(p_user_id,1);

Line 38: p_so_pwb_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);

34: p_po_pwb_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
35: p_so_rel_id msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
36: p_so_released_inst msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
37: p_so_rel_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
38: p_so_pwb_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
39:
40:
41: user_id NUMBER :=nvl(p_user_id,1);
42: req_load_group_by NUMBER;

Line 133: -- msc_rel_wf.init_db('OPERATIONS');

129: -- before we have SSO enable, we temp hardcode the user id
130: fnd_global.apps_initialize(p_user_id, p_resp_id, p_appl_id);
131:
132:
133: -- msc_rel_wf.init_db('OPERATIONS');
134: -- get plan info
135: -----------------------------------------------------
136: open cur_plan_info;
137: fetch cur_plan_info into p_plan_org_id,p_plan_inst_id ,p_compile_designator;

Line 151: msc_rel_wf.get_profile_value(p_profile_name => 'MRP_LOAD_REQ_GROUP_BY',

147: nvl(GET_RP_PLAN_PROFILE_VALUE(p_plan_id,'MSC_RELEASED_BY_USER_ONLY'),'N');
148:
149: req_load_group_by := to_number(GET_RP_PLAN_PROFILE_VALUE(p_plan_id,'MRP_LOAD_REQ_GROUP_BY'));
150: if (req_load_group_by is null) then
151: msc_rel_wf.get_profile_value(p_profile_name => 'MRP_LOAD_REQ_GROUP_BY',
152: p_instance_id => p_inst_id,
153: p_profile_value => req_load_group_by);
154:
155: end if;

Line 381: --- msc_rel_wf.reschedule_purchase_orders needs to be updated to report

377: end loop;
378: end if;
379: commit;
380: --- release purchasing order, which includes cancel and reschdule po
381: --- msc_rel_wf.reschedule_purchase_orders needs to be updated to report
382: --- request id and progress
383:
384: if v_res_po_count > 0 then
385:

Line 387: msc_rel_wf.reschedule_purchase_orders(

383:
384: if v_res_po_count > 0 then
385:
386: print_debug('Releasing purchasing orders ...');
387: msc_rel_wf.reschedule_purchase_orders(
388: p_plan_id,
389: p_plan_org_id, -- p_org_id release all org order,
390: p_plan_inst_id, --p_inst_id release all instance order,
391: p_plan_org_id,

Line 427: msc_rel_wf.release_sales_orders(

423: ------release sales order
424: ---------------------------------------------------------------------
425: if v_rel_so_count > 0 then
426: -- print_debug('Releasing sales orders ...');
427: msc_rel_wf.release_sales_orders(
428: p_plan_id,
429: p_plan_org_id,
430: p_plan_inst_id,
431: p_plan_org_id,

Line 633: l_seq_num := msc_rel_wf.get_job_seq_from_source(p_instance_id);

629: l_seq_num number;
630: lv_job_prefix varchar2(40);
631:
632: begin
633: l_seq_num := msc_rel_wf.get_job_seq_from_source(p_instance_id);
634:
635:
636:
637: msc_rel_wf.get_profile_value(p_profile_name => 'WIP_JOB_PREFIX',

Line 637: msc_rel_wf.get_profile_value(p_profile_name => 'WIP_JOB_PREFIX',

633: l_seq_num := msc_rel_wf.get_job_seq_from_source(p_instance_id);
634:
635:
636:
637: msc_rel_wf.get_profile_value(p_profile_name => 'WIP_JOB_PREFIX',
638: p_instance_id =>p_instance_id,
639: p_profile_value => lv_job_prefix);
640: return lv_job_prefix||to_char(l_seq_num);
641: END GET_WIP_JOB_PREFIX;

Line 791: -- msc_rel_wf.init_db('OPERATIONS');

787:
788: BEGIN
789: /* we should not release vmi items*/
790: fnd_global.apps_initialize(p_user_id, p_resp_id, p_appl_id);
791: -- msc_rel_wf.init_db('OPERATIONS');
792: l_def_pref_id := msc_get_name.get_default_pref_id(l_user_id);
793: l_pref_release_vmi:= msc_get_name.GET_preference('ORDERS_RELEASE_VMI_ITEMS', l_def_pref_id, l_plan_type);
794: -- l_include_so:= msc_get_name.GET_preference('INCLUDE_SO', l_def_pref_id, l_plan_type);
795: l_include_so:= 'Y';

Line 824: if not (msc_rel_wf.is_source_db_up(p_inst_id)) then

820: end if;
821:
822:
823: /* if source db is not running */
824: if not (msc_rel_wf.is_source_db_up(p_inst_id)) then
825: p_rel_error :=FND_MESSAGE.GET_STRING('MSC', 'MSC_SOURCE_IS_INVALID');
826: return p_rel_error;
827: end if;
828:

Line 875: p_rel_error := msc_rel_wf.verify_so_release(p_plan_id,p_transaction_id,p_inst_id);

871:
872:
873: /* not able to release sales order */
874: if (p_source_table ='MSC_DEMANDS' and p_order_type=30) then
875: p_rel_error := msc_rel_wf.verify_so_release(p_plan_id,p_transaction_id,p_inst_id);
876: if (p_rel_error is not null) then
877: return p_rel_error;
878: end if;
879:

Line 1078: l_wip_class_code := msc_rel_wf.get_acc_class_from_source(

1074: OPEN sr_item_cur;
1075: FETCH sr_item_cur INTO v_sr_item;
1076: CLOSE sr_item_cur;
1077:
1078: l_wip_class_code := msc_rel_wf.get_acc_class_from_source(
1079: p_org_id,
1080: v_sr_item,
1081: v_project_id,
1082: p_instance_id);