APPS.AHL_INV_RESERVATIONS_GRP dependencies on INV_RESERVATION_GLOBAL

Line 225: IF (p_supply_demand_type_id = inv_reservation_global.g_source_type_wip) THEN

221: -- End logging
222: RAISE FND_API.G_EXC_ERROR;
223: END IF;
224:
225: IF (p_supply_demand_type_id = inv_reservation_global.g_source_type_wip) THEN
226: --Check job existance only if supply_demand_type_id is of WIP as we are checking for WO supply only.
227: OPEN get_workorder_quantity(p_supply_demand_header_id,
228: inv_reservation_global.g_source_type_wip);
229: FETCH get_workorder_quantity INTO l_wo_quantity;

Line 228: inv_reservation_global.g_source_type_wip);

224:
225: IF (p_supply_demand_type_id = inv_reservation_global.g_source_type_wip) THEN
226: --Check job existance only if supply_demand_type_id is of WIP as we are checking for WO supply only.
227: OPEN get_workorder_quantity(p_supply_demand_header_id,
228: inv_reservation_global.g_source_type_wip);
229: FETCH get_workorder_quantity INTO l_wo_quantity;
230: CLOSE get_workorder_quantity;
231: ELSE
232: --If Supply demand type is not equal to WIP then raise error, as this supply check is only applicable on WIP supply.

Line 620: IF p_supply_demand_type_id = inv_reservation_global.g_source_type_inv THEN

616: RAISE FND_API.G_EXC_ERROR;
617: END IF;
618:
619: -- Validate the details by seeing whether they exist
620: IF p_supply_demand_type_id = inv_reservation_global.g_source_type_inv THEN
621: OPEN get_mtl_dtls_inv_cur( p_supply_demand_line_detail,
622: p_supply_demand_header_id,
623: p_supply_demand_line_id,
624: p_organization_id,

Line 628: ELSIF p_supply_demand_type_id = inv_reservation_global.g_source_type_wip THEN

624: p_organization_id,
625: p_item_id);
626: FETCH get_mtl_dtls_inv_cur INTO l_scheduled_material_id;
627: CLOSE get_mtl_dtls_inv_cur;
628: ELSIF p_supply_demand_type_id = inv_reservation_global.g_source_type_wip THEN
629: OPEN get_mtl_dtls_wip_cur ( p_supply_demand_line_detail,
630: p_supply_demand_header_id,
631: p_supply_demand_line_id,
632: p_organization_id,

Line 659: IF (p_supply_demand_type_id = inv_reservation_global.g_source_type_wip) THEN

655: END IF;
656:
657: ELSIF (p_supply_demand_code = 1 ) THEN
658: --Validation for Supply.
659: IF (p_supply_demand_type_id = inv_reservation_global.g_source_type_wip) THEN
660: --Check job existance only if supply_demand_type_id is of WIP as we are checking for WO supply only.
661: OPEN validate_wip_supply(p_supply_demand_header_id,
662: p_item_id,
663: p_organization_id,

Line 664: inv_reservation_global.g_source_type_wip);

660: --Check job existance only if supply_demand_type_id is of WIP as we are checking for WO supply only.
661: OPEN validate_wip_supply(p_supply_demand_header_id,
662: p_item_id,
663: p_organization_id,
664: inv_reservation_global.g_source_type_wip);
665: FETCH validate_wip_supply INTO l_job_exists;
666: CLOSE validate_wip_supply;
667: ELSE
668: --If Supply demand type is not equal to WIP then raise error, as this supply check is only applicable on WIP supply.