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_PLAN_RELEASE dependencies on MSC_REL_WF

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

140: loaded_int_repair_orders MSC_Rel_Plan_PUB.NumTblTyp := MSC_Rel_Plan_PUB.NumTblTyp(0);
141: int_repair_orders_id MSC_Rel_Plan_PUB.NumTblTyp := MSC_Rel_Plan_PUB.NumTblTyp(0);
142: loaded_ext_repair_orders MSC_Rel_Plan_PUB.NumTblTyp := MSC_Rel_Plan_PUB.NumTblTyp(0);
143: ext_repair_orders_id MSC_Rel_Plan_PUB.NumTblTyp := MSC_Rel_Plan_PUB.NumTblTyp(0);
144: p_po_res_id msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
145: p_released_inst msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
146: p_po_res_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
147: p_po_pwb_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
148: p_so_rel_id msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);

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

141: int_repair_orders_id MSC_Rel_Plan_PUB.NumTblTyp := MSC_Rel_Plan_PUB.NumTblTyp(0);
142: loaded_ext_repair_orders MSC_Rel_Plan_PUB.NumTblTyp := MSC_Rel_Plan_PUB.NumTblTyp(0);
143: ext_repair_orders_id MSC_Rel_Plan_PUB.NumTblTyp := MSC_Rel_Plan_PUB.NumTblTyp(0);
144: p_po_res_id msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
145: p_released_inst msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
146: p_po_res_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
147: p_po_pwb_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
148: p_so_rel_id msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
149: p_so_released_inst msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);

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

142: loaded_ext_repair_orders MSC_Rel_Plan_PUB.NumTblTyp := MSC_Rel_Plan_PUB.NumTblTyp(0);
143: ext_repair_orders_id MSC_Rel_Plan_PUB.NumTblTyp := MSC_Rel_Plan_PUB.NumTblTyp(0);
144: p_po_res_id msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
145: p_released_inst msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
146: p_po_res_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
147: p_po_pwb_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
148: p_so_rel_id msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
149: p_so_released_inst msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
150: p_so_rel_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);

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

143: ext_repair_orders_id MSC_Rel_Plan_PUB.NumTblTyp := MSC_Rel_Plan_PUB.NumTblTyp(0);
144: p_po_res_id msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
145: p_released_inst msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
146: p_po_res_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
147: p_po_pwb_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
148: p_so_rel_id msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
149: p_so_released_inst msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
150: p_so_rel_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
151: p_so_pwb_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);

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

144: p_po_res_id msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
145: p_released_inst msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
146: p_po_res_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
147: p_po_pwb_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
148: p_so_rel_id msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
149: p_so_released_inst msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
150: p_so_rel_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
151: p_so_pwb_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
152: resched_cmro_jobs MSC_Rel_Plan_PUB.NumTblTyp := MSC_Rel_Plan_PUB.NumTblTyp(0);

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

145: p_released_inst msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
146: p_po_res_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
147: p_po_pwb_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
148: p_so_rel_id msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
149: p_so_released_inst msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
150: p_so_rel_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
151: p_so_pwb_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
152: resched_cmro_jobs MSC_Rel_Plan_PUB.NumTblTyp := MSC_Rel_Plan_PUB.NumTblTyp(0);
153: resched_cmro_jobs_req_id MSC_Rel_Plan_PUB.NumTblTyp := MSC_Rel_Plan_PUB.NumTblTyp(0);

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

146: p_po_res_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
147: p_po_pwb_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
148: p_so_rel_id msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
149: p_so_released_inst msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
150: p_so_rel_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
151: p_so_pwb_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
152: resched_cmro_jobs MSC_Rel_Plan_PUB.NumTblTyp := MSC_Rel_Plan_PUB.NumTblTyp(0);
153: resched_cmro_jobs_req_id MSC_Rel_Plan_PUB.NumTblTyp := MSC_Rel_Plan_PUB.NumTblTyp(0);
154: cmro_loaded_jobs MSC_Rel_Plan_PUB.NumTblTyp := MSC_Rel_Plan_PUB.NumTblTyp(0);

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

147: p_po_pwb_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
148: p_so_rel_id msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
149: p_so_released_inst msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
150: p_so_rel_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
151: p_so_pwb_count msc_rel_wf.numTblTyp:=msc_rel_wf.numTblTyp(0);
152: resched_cmro_jobs MSC_Rel_Plan_PUB.NumTblTyp := MSC_Rel_Plan_PUB.NumTblTyp(0);
153: resched_cmro_jobs_req_id MSC_Rel_Plan_PUB.NumTblTyp := MSC_Rel_Plan_PUB.NumTblTyp(0);
154: cmro_loaded_jobs MSC_Rel_Plan_PUB.NumTblTyp := MSC_Rel_Plan_PUB.NumTblTyp(0);
155: cmro_loaded_jobs_req_id MSC_Rel_Plan_PUB.NumTblTyp := MSC_Rel_Plan_PUB.NumTblTyp(0);

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

263: -- before we have SSO enable, we temp hardcode the user id
264: fnd_global.apps_initialize(p_user_id, p_resp_id, p_appl_id);
265:
266:
267: -- msc_rel_wf.init_db('OPERATIONS');
268: -- get plan info
269: -----------------------------------------------------
270: open cur_plan_info;
271: fetch cur_plan_info into p_plan_org_id,p_plan_inst_id ,p_compile_designator;

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

281: nvl(GET_RP_PLAN_PROFILE_VALUE(p_plan_id,'MSC_RELEASED_BY_USER_ONLY'),'N');
282:
283: req_load_group_by := to_number(GET_RP_PLAN_PROFILE_VALUE(p_plan_id,'MRP_LOAD_REQ_GROUP_BY'));
284: if (req_load_group_by is null) then
285: msc_rel_wf.get_profile_value(p_profile_name => 'MRP_LOAD_REQ_GROUP_BY',
286: p_instance_id => p_inst_id,
287: p_profile_value => req_load_group_by);
288:
289: end if;

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

377: end if;
378:
379:
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 409: msc_rel_wf.release_sales_orders(

405: ------release sales order
406: ---------------------------------------------------------------------
407: if v_rel_so_count > 0 then
408: -- print_debug('Releasing sales orders ...');
409: msc_rel_wf.release_sales_orders(
410: p_plan_id,
411: p_plan_org_id,
412: p_plan_inst_id,
413: p_plan_org_id,

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

739: l_seq_num number;
740: lv_job_prefix varchar2(40);
741:
742: begin
743: l_seq_num := msc_rel_wf.get_job_seq_from_source(p_instance_id);
744:
745:
746:
747: msc_rel_wf.get_profile_value(p_profile_name => 'WIP_JOB_PREFIX',

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

743: l_seq_num := msc_rel_wf.get_job_seq_from_source(p_instance_id);
744:
745:
746:
747: msc_rel_wf.get_profile_value(p_profile_name => 'WIP_JOB_PREFIX',
748: p_instance_id =>p_instance_id,
749: p_profile_value => lv_job_prefix);
750: return lv_job_prefix||to_char(l_seq_num);
751: END GET_WIP_JOB_PREFIX;

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

905:
906: BEGIN
907: /* we should not release vmi items*/
908: fnd_global.apps_initialize(p_user_id, p_resp_id, p_appl_id);
909: -- msc_rel_wf.init_db('OPERATIONS');
910: l_def_pref_id := msc_get_name.get_default_pref_id(l_user_id);
911: l_pref_release_vmi:= msc_get_name.GET_preference('ORDERS_RELEASE_VMI_ITEMS', l_def_pref_id, l_plan_type);
912: -- l_include_so:= msc_get_name.GET_preference('INCLUDE_SO', l_def_pref_id, l_plan_type);
913: l_include_so:= 'Y';

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

938: end if;
939:
940:
941: /* if source db is not running */
942: if not (msc_rel_wf.is_source_db_up(p_inst_id)) then
943: p_rel_error :=FND_MESSAGE.GET_STRING('MSC', 'MSC_SOURCE_IS_INVALID');
944: return p_rel_error;
945: end if;
946:

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

986:
987:
988: /* not able to release sales order */
989: if (p_source_table ='MSC_DEMANDS' and p_order_type=30) then
990: p_rel_error := msc_rel_wf.verify_so_release(p_plan_id,p_transaction_id,p_inst_id);
991: if (p_rel_error is not null) then
992: return p_rel_error;
993: end if;
994:

Line 1199: l_wip_class_code := msc_rel_wf.get_acc_class_from_source(

1195: OPEN sr_item_cur;
1196: FETCH sr_item_cur INTO v_sr_item;
1197: CLOSE sr_item_cur;
1198:
1199: l_wip_class_code := msc_rel_wf.get_acc_class_from_source(
1200: p_org_id,
1201: v_sr_item,
1202: v_project_id,
1203: p_instance_id);