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 680: p_cc_rsv_rec inv_reservation_global.mtl_reservation_rec_type

676: END IF;
677: END split_allocation;
678:
679: PROCEDURE get_availability(
680: p_cc_rsv_rec inv_reservation_global.mtl_reservation_rec_type
681: --INVCONV kkilams
682: ,p_res_qty OUT NOCOPY NUMBER
683: ,p_sec_qty OUT NOCOPY NUMBER
684: --END INVCONV kkillams

Line 780: l_cc_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

776: , p_secondary_quantity IN NUMBER
777: , p_secondary_uom_code IN VARCHAR2
778: --END INVCONV KKILLAMS
779: ) IS
780: l_cc_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
781: l_existing_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
782: l_reservations_tbl inv_reservation_global.mtl_reservation_tbl_type;
783: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
784: l_reservation_count NUMBER;

Line 781: l_existing_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

777: , p_secondary_uom_code IN VARCHAR2
778: --END INVCONV KKILLAMS
779: ) IS
780: l_cc_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
781: l_existing_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
782: l_reservations_tbl inv_reservation_global.mtl_reservation_tbl_type;
783: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
784: l_reservation_count NUMBER;
785: l_update_rsv BOOLEAN := FALSE;

Line 782: l_reservations_tbl inv_reservation_global.mtl_reservation_tbl_type;

778: --END INVCONV KKILLAMS
779: ) IS
780: l_cc_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
781: l_existing_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
782: l_reservations_tbl inv_reservation_global.mtl_reservation_tbl_type;
783: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
784: l_reservation_count NUMBER;
785: l_update_rsv BOOLEAN := FALSE;
786: l_new_reservation_id NUMBER;

Line 783: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

779: ) IS
780: l_cc_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
781: l_existing_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
782: l_reservations_tbl inv_reservation_global.mtl_reservation_tbl_type;
783: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
784: l_reservation_count NUMBER;
785: l_update_rsv BOOLEAN := FALSE;
786: l_new_reservation_id NUMBER;
787: l_qty_reserved NUMBER;

Line 924: , p_demand_source_type_id => inv_reservation_global.g_source_type_cycle_count

920: , p_tree_mode => inv_quantity_tree_pub.g_reservation_mode
921: , p_is_revision_control => (p_revision IS NOT NULL)
922: , p_is_lot_control => (p_lot_number IS NOT NULL)
923: , p_is_serial_control => FALSE
924: , p_demand_source_type_id => inv_reservation_global.g_source_type_cycle_count
925: , p_demand_source_header_id => -1
926: , p_demand_source_line_id => -1
927: , p_demand_source_name => NULL
928: , p_revision => p_revision