DBA Data[Home] [Help]

APPS.CTO_RESERVE_CONFIG dependencies on INV_RESERVATION_GLOBAL

Line 80: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

76:
77: RESERVATION_ERROR exception;
78:
79: -- These are the variables passed to Inventory's Reservation API.
80: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
81: l_msg_count number;
82: l_msg_data varchar2(150);
83: l_serial_number inv_reservation_global.serial_number_tbl_type;
84:

Line 83: l_serial_number inv_reservation_global.serial_number_tbl_type;

79: -- These are the variables passed to Inventory's Reservation API.
80: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
81: l_msg_count number;
82: l_msg_data varchar2(150);
83: l_serial_number inv_reservation_global.serial_number_tbl_type;
84:
85: BEGIN
86:
87: /********************************************************************

Line 96: -- bugfix 1799874 : if Internal SO, then pass INV_RESERVATION_GLOBAL.g_source_type_internal_ord

92: l_rsv_rec.requirement_date := p_rec_reserve.f_ship_date;
93: l_rsv_rec.organization_id := p_rec_reserve.f_mfg_org_id;
94: l_rsv_rec.inventory_item_id := p_rec_reserve.f_item_id;
95:
96: -- bugfix 1799874 : if Internal SO, then pass INV_RESERVATION_GLOBAL.g_source_type_internal_ord
97: -- l_rsv_rec.demand_source_type_id := INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE;
98:
99:
100: if (p_rec_reserve.f_source_document_type_id = 10) then

Line 97: -- l_rsv_rec.demand_source_type_id := INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE;

93: l_rsv_rec.organization_id := p_rec_reserve.f_mfg_org_id;
94: l_rsv_rec.inventory_item_id := p_rec_reserve.f_item_id;
95:
96: -- bugfix 1799874 : if Internal SO, then pass INV_RESERVATION_GLOBAL.g_source_type_internal_ord
97: -- l_rsv_rec.demand_source_type_id := INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE;
98:
99:
100: if (p_rec_reserve.f_source_document_type_id = 10) then
101: oe_debug_pub.add('Source Document Type Id = 10 which means, it is an INTERNAL ORDER', 1);

Line 103: INV_RESERVATION_GLOBAL.g_source_type_internal_ord;

99:
100: if (p_rec_reserve.f_source_document_type_id = 10) then
101: oe_debug_pub.add('Source Document Type Id = 10 which means, it is an INTERNAL ORDER', 1);
102: l_rsv_rec.demand_source_type_id :=
103: INV_RESERVATION_GLOBAL.g_source_type_internal_ord;
104: else
105: oe_debug_pub.add('Source Document Type Id = '||p_rec_reserve.f_source_document_type_id, 1);
106: l_rsv_rec.demand_source_type_id :=
107: INV_RESERVATION_GLOBAL.g_source_type_oe;

Line 107: INV_RESERVATION_GLOBAL.g_source_type_oe;

103: INV_RESERVATION_GLOBAL.g_source_type_internal_ord;
104: else
105: oe_debug_pub.add('Source Document Type Id = '||p_rec_reserve.f_source_document_type_id, 1);
106: l_rsv_rec.demand_source_type_id :=
107: INV_RESERVATION_GLOBAL.g_source_type_oe;
108: end if;
109:
110: l_rsv_rec.demand_source_name := NULL;
111: l_rsv_rec.demand_source_delivery := NULL;

Line 125: -- INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INV;

121: l_rsv_rec.autodetail_group_id := NULL;
122: l_rsv_rec.external_source_code := NULL;
123: l_rsv_rec.external_source_line_id := NULL;
124: l_rsv_rec.supply_source_type_id := p_rec_reserve.f_supply_source;
125: -- INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INV;
126: l_rsv_rec.supply_source_header_id :=
127: p_rec_reserve.f_supply_header_id;
128: l_rsv_rec.supply_source_line_id := NULL;
129: l_rsv_rec.supply_source_name := NULL;