[Home] [Help]
54: ,NVL (mr.secondary_detailed_quantity, 0)
55: ,NVL (mr.secondary_reservation_quantity, 0)
56: ,mr.secondary_uom_code, mr.inventory_item_id
57: ,loc.concatenated_segments
58: FROM mtl_reservations mr, wms_item_locations_kfv loc
59: WHERE mr.organization_id = p_organization_id
60: AND mr.demand_source_type_id = gme_common_pvt.g_txn_source_type
61: AND mr.demand_source_header_id = p_batch_id
62: AND mr.demand_source_line_id = p_material_detail_id
380: ,v_batch_id NUMBER
381: ,v_material_detail_id NUMBER)
382: IS
383: SELECT mr.*
384: FROM mtl_reservations mr
385: WHERE organization_id = v_org_id
386: AND demand_source_type_id = gme_common_pvt.g_txn_source_type
387: AND demand_source_header_id = v_batch_id
388: AND demand_source_line_id = v_material_detail_id
443: x_return_status := fnd_api.g_ret_sts_unexp_error;
444: END get_material_reservations;
445:
446: FUNCTION reservation_fully_specified (
447: p_reservation_rec IN mtl_reservations%ROWTYPE
448: ,p_item_location_control IN NUMBER
449: ,p_item_restrict_locators IN NUMBER)
450: RETURN NUMBER
451: IS
503: RETURN -1;
504: END reservation_fully_specified;
505:
506: PROCEDURE convert_partial_to_dlr (
507: p_reservation_rec IN mtl_reservations%ROWTYPE
508: ,p_material_dtl_rec IN gme_material_details%ROWTYPE
509: ,p_item_rec IN mtl_system_items%ROWTYPE
510: ,p_qty_check IN VARCHAR2 := fnd_api.g_false
511: ,x_reservation_rec OUT NOCOPY mtl_reservations%ROWTYPE
507: p_reservation_rec IN mtl_reservations%ROWTYPE
508: ,p_material_dtl_rec IN gme_material_details%ROWTYPE
509: ,p_item_rec IN mtl_system_items%ROWTYPE
510: ,p_qty_check IN VARCHAR2 := fnd_api.g_false
511: ,x_reservation_rec OUT NOCOPY mtl_reservations%ROWTYPE
512: ,x_return_status OUT NOCOPY VARCHAR2)
513: IS
514: l_api_name CONSTANT VARCHAR2 (30) := 'convert_partial_to_dlr';
515: l_eff_locator_control NUMBER;
771: x_return_status := fnd_api.g_ret_sts_unexp_error;
772: END delete_reservation;
773:
774: PROCEDURE get_reservation_dtl_qty (
775: p_reservation_rec IN mtl_reservations%ROWTYPE
776: ,p_uom_code IN VARCHAR2
777: ,x_qty OUT NOCOPY NUMBER
778: ,x_return_status OUT NOCOPY VARCHAR2)
779: IS
862:
863: CURSOR cur_get_resvns
864: IS
865: SELECT mr.*
866: FROM mtl_reservations mr
867: WHERE mr.demand_source_type_id = gme_common_pvt.g_txn_source_type
868: AND mr.demand_source_header_id = l_mtl_dtl_rec.batch_id
869: AND mr.demand_source_line_id = l_mtl_dtl_rec.material_detail_id
870: AND ( (p_supply_sub_only = fnd_api.g_false)
1238: SELECT 1
1239: FROM DUAL
1240: WHERE EXISTS (
1241: SELECT 1
1242: FROM mtl_reservations mr
1243: WHERE organization_id = v_org_id
1244: AND demand_source_type_id =
1245: gme_common_pvt.g_txn_source_type
1246: AND demand_source_header_id = v_batch_id
1289: RETURN FALSE;
1290: END pending_reservations_exist;
1291:
1292: PROCEDURE convert_dtl_reservation (
1293: p_reservation_rec IN mtl_reservations%ROWTYPE
1294: ,p_material_details_rec IN gme_material_details%ROWTYPE
1295: ,p_qty_convert IN NUMBER := NULL
1296: ,x_message_count OUT NOCOPY NUMBER
1297: ,x_message_list OUT NOCOPY VARCHAR2
1304: create_transaction_error EXCEPTION;
1305: detail_reservation_error EXCEPTION;
1306: uom_conversion_failure EXCEPTION;
1307: l_item_rec mtl_system_items%ROWTYPE;
1308: l_reservation_rec mtl_reservations%ROWTYPE;
1309: l_qty_convert NUMBER;
1310: l_rsv_type NUMBER;
1311: l_return_status VARCHAR2 (1);
1312: l_actual_qty NUMBER;
1536: ,x_return_status OUT NOCOPY VARCHAR2)
1537: IS
1538: l_api_name CONSTANT VARCHAR2 (30) := 'auto_detail_line';
1539: l_item_rec mtl_system_items_b%ROWTYPE;
1540: l_rsv_rec mtl_reservations%ROWTYPE;
1541: l_rsv_tbl gme_common_pvt.reservations_tab;
1542: l_reservations_tbl inv_reservation_global.mtl_reservation_tbl_type;
1543: l_rsv_type NUMBER;
1544: l_open_qty NUMBER;