APPS.WPS_COMMON dependencies on WPS_RES_INSTANCE_AVAILABILITY

Line 301: wps_res_instance_availability.calc_ins_avail(p_organization_id,

297:
298: LOOP
299: EXIT WHEN p_resource_table(x) = 0;
300:
301: wps_res_instance_availability.calc_ins_avail(p_organization_id,
302: p_dept_table(x),
303: p_resource_table(x),
304: p_simulation_set,
305: p_instance_table(x),

Line 626: * Wrapper on top of wps_res_instance_availability.calc_ins_avail.

622: END populate_mrp_avail_resources;
623:
624:
625: /*
626: * Wrapper on top of wps_res_instance_availability.calc_ins_avail.
627: * Basically delete the MRP_NET_RESOURCE_AVAIL table only for the date
628: * range specified by p_start_date and p_cutoff_date and for the passed
629: * in simulation_set identifier.
630: */

Line 793: wps_res_instance_availability.calc_ins_avail(p_organization_id,

789: x_resource_id,
790: x_instance_id,
791: x_serial_number;
792: EXIT WHEN dept_ins%NOTFOUND;
793: wps_res_instance_availability.calc_ins_avail(p_organization_id,
794: x_department_id,
795: x_resource_id,
796: p_simulation_set,
797: x_instance_id,

Line 814: wps_res_instance_availability.calc_ins_avail(p_organization_id,

810: x_instance_id,
811: x_serial_number;
812: EXIT WHEN wip_res%NOTFOUND;
813:
814: wps_res_instance_availability.calc_ins_avail(p_organization_id,
815: x_department_id,
816: x_resource_id,
817: p_simulation_set,
818: x_instance_id,

Line 925: wps_res_instance_availability.calc_ins_avail(p_organization_id,

921: LOOP
922: FETCH dept_ins into x_department_id,
923: x_24hr_flag;
924: EXIT WHEN dept_ins%NOTFOUND;
925: wps_res_instance_availability.calc_ins_avail(p_organization_id,
926: x_department_id,
927: p_resource_id,
928: p_simulation_set,
929: p_instance_id,