DBA Data[Home] [Help]

APPS.GME_COMMON_PVT dependencies on GME_RESERVATIONS_PVT

Line 3012: gme_reservations_pvt.get_reserved_qty

3008:
3009: -- All qty should be in the detail line uom.
3010: -- all allocations excludes the invisible move orders
3011: IF p_called_by = 'S' THEN
3012: gme_reservations_pvt.get_reserved_qty
3013: (p_mtl_dtl_rec => p_mtl_dtl_rec
3014: ,x_reserved_qty => l_reserved_qty
3015: ,x_return_status => l_return_status);
3016:

Line 3034: gme_reservations_pvt.get_reserved_qty

3030: || x_open_qty);
3031: END IF;
3032: ELSIF p_called_by = 'P' THEN
3033: -- Bug 12613813 - pass in true for p_locator_only parameter so picking can consider locator also.
3034: gme_reservations_pvt.get_reserved_qty
3035: (p_mtl_dtl_rec => p_mtl_dtl_rec
3036: ,p_supply_sub_only => fnd_api.g_true
3037: ,p_locator_only => fnd_api.g_true
3038: ,x_reserved_qty => l_reserved_qty

Line 3104: gme_reservations_pvt.get_material_reservations

3100: || ' Calculated open qty for picking is '
3101: || x_open_qty);
3102: END IF;
3103: ELSIF p_called_by = 'R' THEN
3104: gme_reservations_pvt.get_material_reservations
3105: (p_organization_id => p_mtl_dtl_rec.organization_id
3106: ,p_batch_id => p_mtl_dtl_rec.batch_id
3107: ,p_material_detail_id => p_mtl_dtl_rec.material_detail_id
3108: ,x_return_status => l_return_status

Line 3133: causing the extra HLR to be created from the gme_reservations_pvt.auto_detail_line */

3129:
3130: -- Assess fully detailed (1) and part detailed (2) reservations
3131: /*Bug#7346653 commenting the below if condition as the open qty
3132: should not include the the already created high level reservation as this is
3133: causing the extra HLR to be created from the gme_reservations_pvt.auto_detail_line */
3134: /* IF (gme_reservations_pvt.reservation_fully_specified
3135: (p_reservation_rec => l_resv_tbl (i)
3136: ,p_item_location_control => l_item_loc_control
3137: ,p_item_restrict_locators => l_item_restrict_locators) in (1,2)) THEN */

Line 3134: /* IF (gme_reservations_pvt.reservation_fully_specified

3130: -- Assess fully detailed (1) and part detailed (2) reservations
3131: /*Bug#7346653 commenting the below if condition as the open qty
3132: should not include the the already created high level reservation as this is
3133: causing the extra HLR to be created from the gme_reservations_pvt.auto_detail_line */
3134: /* IF (gme_reservations_pvt.reservation_fully_specified
3135: (p_reservation_rec => l_resv_tbl (i)
3136: ,p_item_location_control => l_item_loc_control
3137: ,p_item_restrict_locators => l_item_restrict_locators) in (1,2)) THEN */
3138:

Line 3139: gme_reservations_pvt.get_reservation_dtl_qty

3135: (p_reservation_rec => l_resv_tbl (i)
3136: ,p_item_location_control => l_item_loc_control
3137: ,p_item_restrict_locators => l_item_restrict_locators) in (1,2)) THEN */
3138:
3139: gme_reservations_pvt.get_reservation_dtl_qty
3140: (p_reservation_rec => l_resv_tbl
3141: (i)
3142: ,p_uom_code => p_mtl_dtl_rec.dtl_um
3143: ,x_qty => l_temp_qty

Line 3206: gme_reservations_pvt.get_material_res

3202: || x_open_qty);
3203: END IF;
3204: /* Added below ELSIF in bug 9924437*/
3205: ELSIF p_called_by = 'Z' THEN
3206: gme_reservations_pvt.get_material_res
3207: (p_organization_id => p_mtl_dtl_rec.organization_id
3208: ,p_batch_id => p_mtl_dtl_rec.batch_id
3209: ,p_material_detail_id => p_mtl_dtl_rec.material_detail_id
3210: ,x_return_status => l_return_status

Line 3232: gme_reservations_pvt.get_reservation_dtl_qty

3228: l_item_loc_control := p_item_location_control;
3229: l_item_restrict_locators := p_item_restrict_locators;
3230: END IF;
3231:
3232: gme_reservations_pvt.get_reservation_dtl_qty
3233: (p_reservation_rec => l_resv_tbl
3234: (i)
3235: ,p_uom_code => p_mtl_dtl_rec.dtl_um
3236: ,x_qty => l_temp_qty

Line 4526: gme_reservations_pvt.get_material_reservations

4522: gme_debug.put_line ('Calling Query Reservation.');
4523: END IF;
4524:
4525: /* start ,Punit Kumar */
4526: gme_reservations_pvt.get_material_reservations
4527: (p_organization_id => l_material_detail_rec.organization_id
4528: ,p_batch_id => l_material_detail_rec.batch_id
4529: ,p_material_detail_id => l_material_detail_rec.material_detail_id
4530: ,x_return_status => l_return_status

Line 4565: gme_reservations_pvt.delete_reservation

4561: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4562: gme_debug.put_line ('Calling Delete Reservation.');
4563: END IF;
4564:
4565: gme_reservations_pvt.delete_reservation
4566: (p_reservation_id => l_rsv_array (j).reservation_id
4567: ,x_return_status => l_return_status);
4568:
4569: IF (NVL (g_debug, 0) IN

Line 4600: gme_reservations_pvt.update_reservation

4596: || ' requirement_date: '
4597: || TO_CHAR (l_material_date, 'MM/DD/YYYY HH24:MI:SS') );
4598: END IF;
4599:
4600: gme_reservations_pvt.update_reservation
4601: (p_reservation_id => l_rsv_array (j).reservation_id
4602: ,p_revision => l_rsv_array (j).revision
4603: ,p_subinventory => l_rsv_array (j).subinventory_code
4604: ,p_locator_id => l_rsv_array (j).locator_id