DBA Data[Home] [Help]

APPS.INV_MISSING_QTY_ACTIONS_ENGINE dependencies on INV_RESERVATION_GLOBAL

Line 54: x_rsv_rec OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type

50: CLOSE c_item_controls;
51: END get_item_controls;
52:
53: PROCEDURE fill_cycle_count_rsv_rec(
54: x_rsv_rec OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type
55: , p_organization_id NUMBER
56: , p_inventory_item_id NUMBER
57: , p_revision VARCHAR2
58: , p_lot_number VARCHAR2

Line 75: x_rsv_rec.supply_source_type_id := inv_reservation_global.g_source_type_inv;

71: x_rsv_rec.subinventory_code := p_subinventory_code;
72: x_rsv_rec.locator_id := p_locator_id;
73: x_rsv_rec.primary_uom_code := p_primary_uom_code;
74: x_rsv_rec.reservation_uom_code := p_primary_uom_code;
75: x_rsv_rec.supply_source_type_id := inv_reservation_global.g_source_type_inv;
76: x_rsv_rec.demand_source_type_id := inv_reservation_global.g_source_type_cycle_count;
77: x_rsv_rec.demand_source_header_id := -1;
78: x_rsv_rec.demand_source_line_id := -1;
79:

Line 76: x_rsv_rec.demand_source_type_id := inv_reservation_global.g_source_type_cycle_count;

72: x_rsv_rec.locator_id := p_locator_id;
73: x_rsv_rec.primary_uom_code := p_primary_uom_code;
74: x_rsv_rec.reservation_uom_code := p_primary_uom_code;
75: x_rsv_rec.supply_source_type_id := inv_reservation_global.g_source_type_inv;
76: x_rsv_rec.demand_source_type_id := inv_reservation_global.g_source_type_cycle_count;
77: x_rsv_rec.demand_source_header_id := -1;
78: x_rsv_rec.demand_source_line_id := -1;
79:
80: -- Fill the Required Fields expected by Create Reservations API

Line 220: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

216: --END INVCONV KKILLAMS
217: ) IS
218: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
219: l_api_name VARCHAR2(30) := 'BACKORDER_ONLY';
220: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
221: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
222: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
223: l_primary_qty NUMBER := p_quantity;
224: l_rsv_primary_qty NUMBER;

Line 221: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

217: ) IS
218: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
219: l_api_name VARCHAR2(30) := 'BACKORDER_ONLY';
220: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
221: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
222: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
223: l_primary_qty NUMBER := p_quantity;
224: l_rsv_primary_qty NUMBER;
225: l_rsv_detailed_qty NUMBER;

Line 222: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

218: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
219: l_api_name VARCHAR2(30) := 'BACKORDER_ONLY';
220: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
221: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
222: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
223: l_primary_qty NUMBER := p_quantity;
224: l_rsv_primary_qty NUMBER;
225: l_rsv_detailed_qty NUMBER;
226: l_ato_item NUMBER := 0;

Line 597: p_cc_rsv_rec inv_reservation_global.mtl_reservation_rec_type

593: END IF;
594: END split_allocation;
595:
596: PROCEDURE get_availability(
597: p_cc_rsv_rec inv_reservation_global.mtl_reservation_rec_type
598: --INVCONV kkilams
599: ,p_res_qty OUT NOCOPY NUMBER
600: ,p_sec_qty OUT NOCOPY NUMBER
601: --END INVCONV kkillams

Line 697: l_cc_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

693: , p_secondary_quantity IN NUMBER
694: , p_secondary_uom_code IN VARCHAR2
695: --END INVCONV KKILLAMS
696: ) IS
697: l_cc_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
698: l_existing_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
699: l_reservations_tbl inv_reservation_global.mtl_reservation_tbl_type;
700: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
701: l_reservation_count NUMBER;

Line 698: l_existing_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

694: , p_secondary_uom_code IN VARCHAR2
695: --END INVCONV KKILLAMS
696: ) IS
697: l_cc_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
698: l_existing_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
699: l_reservations_tbl inv_reservation_global.mtl_reservation_tbl_type;
700: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
701: l_reservation_count NUMBER;
702: l_update_rsv BOOLEAN := FALSE;

Line 699: l_reservations_tbl inv_reservation_global.mtl_reservation_tbl_type;

695: --END INVCONV KKILLAMS
696: ) IS
697: l_cc_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
698: l_existing_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
699: l_reservations_tbl inv_reservation_global.mtl_reservation_tbl_type;
700: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
701: l_reservation_count NUMBER;
702: l_update_rsv BOOLEAN := FALSE;
703: l_new_reservation_id NUMBER;

Line 700: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

696: ) IS
697: l_cc_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
698: l_existing_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
699: l_reservations_tbl inv_reservation_global.mtl_reservation_tbl_type;
700: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
701: l_reservation_count NUMBER;
702: l_update_rsv BOOLEAN := FALSE;
703: l_new_reservation_id NUMBER;
704: l_qty_reserved NUMBER;