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.WIP_WPS_COMMON dependencies on MRP_RHX_RESOURCE_AVAILABILITY

Line 92: -- call MRP_RHX_RESOURCE_AVAILABILITY

88: -- in MRP_NET_RESOURCE_AVAIL, then no need to call MRP again
89: -- The p_start_date, p_cutoff_date can be modified by
90: -- resource_info_found_in_mrp function if this function
91: -- returns FALSE so that we can get a new from_date to
92: -- call MRP_RHX_RESOURCE_AVAILABILITY
93: if (resource_info_found_in_mrp(p_simulation_set,
94: p_organization_id,
95: x_date_from,
96: x_date_to)) then

Line 149: -- call MRP_RHX_RESOURCE_AVAILABILITY

145: -- in MRP_NET_RESOURCE_AVAIL, then no need to call MRP again
146: -- The p_start_date, p_cutoff_date can be modified by
147: -- resource_info_found_in_mrp function if this function
148: -- returns FALSE so that we can get a new from_date to
149: -- call MRP_RHX_RESOURCE_AVAILABILITY
150: if (resource_info_found_in_mrp(p_simulation_set,
151: p_organization_id,
152: x_date_from,
153: x_date_to)) then

Line 170: MRP_RHX_RESOURCE_AVAILABILITY.calc_res_avail(p_organization_id,

166:
167: LOOP
168: EXIT WHEN p_resource_table(x) = 0;
169:
170: MRP_RHX_RESOURCE_AVAILABILITY.calc_res_avail(p_organization_id,
171: p_dept_table(x),
172: p_resource_table(x),
173: p_simulation_set,
174: p_24hour_flag_table(x),

Line 220: -- call MRP_RHX_RESOURCE_AVAILABILITY

216: -- in MRP_NET_RESOURCE_AVAIL, then no need to call MRP again
217: -- The p_start_date, p_cutoff_date can be modified by
218: -- resource_info_found_in_mrp function if this function
219: -- returns FALSE so that we can get a new from_date to
220: -- call MRP_RHX_RESOURCE_AVAILABILITY
221: if (resource_info_found_in_mrp(p_simulation_set,
222: p_organization_id,
223: x_date_from,
224: x_date_to)) then

Line 280: -- call MRP_RHX_RESOURCE_AVAILABILITY

276: -- in MRP_NET_RESOURCE_AVAIL, then no need to call MRP again
277: -- The p_start_date, p_cutoff_date can be modified by
278: -- resource_info_found_in_mrp function if this function
279: -- returns FALSE so that we can get a new from_date to
280: -- call MRP_RHX_RESOURCE_AVAILABILITY
281: if (resource_info_found_in_mrp(p_simulation_set,
282: p_organization_id,
283: x_date_from,
284: x_date_to)) then

Line 367: -- call MRP_RHX_RESOURCE_AVAILABILITY

363: -- in MRP_NET_RESOURCE_AVAIL, then no need to call MRP again
364: -- The p_start_date, p_cutoff_date can be modified by
365: -- individual_res_info_found_in_mrp function if this function
366: -- returns FALSE so that we can get a new from_date and to_date to
367: -- call MRP_RHX_RESOURCE_AVAILABILITY
368: IF (single_res_info_found_in_mrp(p_simulation_set,
369: p_organization_id,
370: p_resource_id,
371: x_date_from,

Line 448: -- call MRP_RHX_RESOURCE_AVAILABILITY

444: -- in MRP_NET_RESOURCE_AVAIL, then no need to call MRP again
445: -- The p_start_date, p_cutoff_date can be modified by
446: -- individual_res_info_found_in_mrp function if this function
447: -- returns FALSE so that we can get a new from_date and to_date to
448: -- call MRP_RHX_RESOURCE_AVAILABILITY
449: IF (single_ins_info_found_in_mrp(p_simulation_set,
450: p_organization_id,
451: p_resource_id,
452: p_instance_id,

Line 486: * Wrapper on top of MRP_RHX_RESOURCE_AVAILABILITY.calc_res_avail.

482:
483: END Populate_Individual_Ins_Avails ;
484:
485: /*
486: * Wrapper on top of MRP_RHX_RESOURCE_AVAILABILITY.calc_res_avail.
487: * Basically delete the MRP_NET_RESOURCE_AVAIL table only for the date
488: * range specified by p_start_date and p_cutoff_date and for the passed
489: * in simulation_set identifier.
490: */

Line 587: -- MRP_RHX_RESOURCE_AVAILABILITY.calc_res_avail to insert resource

583: and trunc(shift_date) >= trunc(p_start_date)
584: and trunc(shift_date) <= trunc(p_cutoff_date);
585:
586: -- open the cursor and loop through each department resource and call
587: -- MRP_RHX_RESOURCE_AVAILABILITY.calc_res_avail to insert resource
588: -- availability information into MRP_NET_RESOURCE_AVAIL
589: IF (p_wip_entity_id IS NULL) THEN
590: OPEN dept_res;
591: LOOP

Line 596: MRP_RHX_RESOURCE_AVAILABILITY.calc_res_avail(p_organization_id,

592: FETCH dept_res into x_department_id,
593: x_resource_id,
594: x_24hr_flag;
595: EXIT WHEN dept_res%NOTFOUND;
596: MRP_RHX_RESOURCE_AVAILABILITY.calc_res_avail(p_organization_id,
597: x_department_id,
598: x_resource_id,
599: p_simulation_set,
600: x_24hr_flag,

Line 612: MRP_RHX_RESOURCE_AVAILABILITY.calc_res_avail(p_organization_id,

608: FETCH wip_res into x_department_id,
609: x_resource_id,
610: x_24hr_flag;
611: EXIT WHEN wip_res%NOTFOUND;
612: MRP_RHX_RESOURCE_AVAILABILITY.calc_res_avail(p_organization_id,
613: x_department_id,
614: x_resource_id,
615: p_simulation_set,
616: x_24hr_flag,

Line 782: -- MRP_RHX_RESOURCE_AVAILABILITY.calc_res_avail to insert resource

778: and trunc(shift_date) >= trunc(p_start_date)
779: and trunc(shift_date) <= trunc(p_cutoff_date);
780:
781: -- open the cursor and loop through each department resource and call
782: -- MRP_RHX_RESOURCE_AVAILABILITY.calc_res_avail to insert resource
783: -- availability information into MRP_NET_RESOURCE_AVAIL
784: IF (p_wip_entity_id IS NULL) THEN
785: OPEN dept_ins;
786: LOOP

Line 831: * Wrapper on top of MRP_RHX_RESOURCE_AVAILABILITY.calc_res_avail.

827:
828:
829:
830: /*
831: * Wrapper on top of MRP_RHX_RESOURCE_AVAILABILITY.calc_res_avail.
832: * Basically delete the MRP_NET_RESOURCE_AVAIL table only for the date
833: * range specified by p_start_date and p_cutoff_date and for the passed
834: * in simulation_set identifier.
835: */

Line 860: -- MRP_RHX_RESOURCE_AVAILABILITY.calc_res_avail to insert resource

856: AND decode(p_department_id,null,-1,dept.department_id) = nvl(p_department_id,-1);
857:
858: BEGIN
859: -- open the cursor and loop through each department resource and call
860: -- MRP_RHX_RESOURCE_AVAILABILITY.calc_res_avail to insert resource
861: -- availability information into MRP_NET_RESOURCE_AVAIL
862: OPEN dept_res;
863: LOOP
864: FETCH dept_res into x_department_id,

Line 867: MRP_RHX_RESOURCE_AVAILABILITY.calc_res_avail(p_organization_id,

863: LOOP
864: FETCH dept_res into x_department_id,
865: x_24hr_flag;
866: EXIT WHEN dept_res%NOTFOUND;
867: MRP_RHX_RESOURCE_AVAILABILITY.calc_res_avail(p_organization_id,
868: x_department_id,
869: p_resource_id,
870: p_simulation_set,
871: x_24hr_flag,

Line 882: * Wrapper on top of MRP_RHX_RESOURCE_AVAILABILITY.calc_res_avail.

878:
879: END populate_single_mrp_avail_res;
880:
881: /*
882: * Wrapper on top of MRP_RHX_RESOURCE_AVAILABILITY.calc_res_avail.
883: * Basically delete the MRP_NET_RESOURCE_AVAIL table only for the date
884: * range specified by p_start_date and p_cutoff_date and for the passed
885: * in simulation_set identifier.
886: */

Line 916: -- MRP_RHX_RESOURCE_AVAILABILITY.calc_res_avail to insert resource

912: AND decode(p_department_id,null,-1,dept.department_id) = nvl(p_department_id,-1);
913:
914: BEGIN
915: -- open the cursor and loop through each department resource and call
916: -- MRP_RHX_RESOURCE_AVAILABILITY.calc_res_avail to insert resource
917: -- availability information into MRP_NET_RESOURCE_AVAIL
918: -- dbms_output.put_line('In populate single mrp avail ins.......');
919:
920: OPEN dept_ins;