42: X_quantity_reserved OUT NOCOPY /* file.sql.39 change */ NUMBER,
43: X_reservation_id OUT NOCOPY /* file.sql.39 change */ NUMBER
44: )
45: IS
46: l_rsv inv_reservation_global.mtl_reservation_rec_type;
47: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
48: l_dummy_sn_out inv_reservation_global.serial_number_tbl_type;
49: l_api_name CONSTANT VARCHAR2(30) := 'Create_Reservation' ;
50: l_api_version_number CONSTANT NUMBER := '1.0';
43: X_reservation_id OUT NOCOPY /* file.sql.39 change */ NUMBER
44: )
45: IS
46: l_rsv inv_reservation_global.mtl_reservation_rec_type;
47: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
48: l_dummy_sn_out inv_reservation_global.serial_number_tbl_type;
49: l_api_name CONSTANT VARCHAR2(30) := 'Create_Reservation' ;
50: l_api_version_number CONSTANT NUMBER := '1.0';
51: l_profile_name varchar2(240);
44: )
45: IS
46: l_rsv inv_reservation_global.mtl_reservation_rec_type;
47: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
48: l_dummy_sn_out inv_reservation_global.serial_number_tbl_type;
49: l_api_name CONSTANT VARCHAR2(30) := 'Create_Reservation' ;
50: l_api_version_number CONSTANT NUMBER := '1.0';
51: l_profile_name varchar2(240);
52: BEGIN
123: l_rsv.autodetail_group_id := NULL;
124: l_rsv.external_source_code := NULL;
125: l_rsv.external_source_line_id := NULL;
126: l_rsv.supply_source_type_id :=
127: inv_reservation_global.g_source_type_inv;
128: l_rsv.supply_source_header_id := NULL;
129: l_rsv.supply_source_line_id := NULL;
130: l_rsv.supply_source_name := NULL;
131: l_rsv.supply_source_line_detail := NULL;
245: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
246: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
247: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
248: IS
249: l_rsv_old inv_reservation_global.mtl_reservation_rec_type;
250: l_rsv_new inv_reservation_global.mtl_reservation_rec_type;
251: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
252: l_api_name CONSTANT VARCHAR2(30) := 'Update_Reservation';
253: l_api_version_number CONSTANT NUMBER := 1.0;
246: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
247: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
248: IS
249: l_rsv_old inv_reservation_global.mtl_reservation_rec_type;
250: l_rsv_new inv_reservation_global.mtl_reservation_rec_type;
251: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
252: l_api_name CONSTANT VARCHAR2(30) := 'Update_Reservation';
253: l_api_version_number CONSTANT NUMBER := 1.0;
254: BEGIN
247: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
248: IS
249: l_rsv_old inv_reservation_global.mtl_reservation_rec_type;
250: l_rsv_new inv_reservation_global.mtl_reservation_rec_type;
251: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
252: l_api_name CONSTANT VARCHAR2(30) := 'Update_Reservation';
253: l_api_version_number CONSTANT NUMBER := 1.0;
254: BEGIN
255: -- Standard Start of API savepoint
375: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
376: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
377: )
378: IS
379: l_rsv inv_reservation_global.mtl_reservation_rec_type;
380: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
381: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Reservation';
382: l_api_version_number CONSTANT NUMBER := 1.0;
383: BEGIN
376: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
377: )
378: IS
379: l_rsv inv_reservation_global.mtl_reservation_rec_type;
380: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
381: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Reservation';
382: l_api_version_number CONSTANT NUMBER := 1.0;
383: BEGIN
384: -- Standard Start of API savepoint
490: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ) IS
491: -- declaration of variables
492: l_api_version_number NUMBER := 1.0 ;
493: l_api_name CONSTANT VARCHAR2(30) := 'Transfer_Reservation' ;
494: l_rsv_old INV_RESERVATION_GLOBAL.Mtl_Reservation_Rec_Type ;
495: l_rsv_new INV_RESERVATION_GLOBAL.Mtl_Reservation_Rec_Type ;
496: l_dummy_sn INV_RESERVATION_GLOBAL.serial_number_tbl_type ;
497: l_new_rsv_id NUMBER ;
498: l_return_status VARCHAR2(240) ;
491: -- declaration of variables
492: l_api_version_number NUMBER := 1.0 ;
493: l_api_name CONSTANT VARCHAR2(30) := 'Transfer_Reservation' ;
494: l_rsv_old INV_RESERVATION_GLOBAL.Mtl_Reservation_Rec_Type ;
495: l_rsv_new INV_RESERVATION_GLOBAL.Mtl_Reservation_Rec_Type ;
496: l_dummy_sn INV_RESERVATION_GLOBAL.serial_number_tbl_type ;
497: l_new_rsv_id NUMBER ;
498: l_return_status VARCHAR2(240) ;
499: l_msg_count NUMBER ;
492: l_api_version_number NUMBER := 1.0 ;
493: l_api_name CONSTANT VARCHAR2(30) := 'Transfer_Reservation' ;
494: l_rsv_old INV_RESERVATION_GLOBAL.Mtl_Reservation_Rec_Type ;
495: l_rsv_new INV_RESERVATION_GLOBAL.Mtl_Reservation_Rec_Type ;
496: l_dummy_sn INV_RESERVATION_GLOBAL.serial_number_tbl_type ;
497: l_new_rsv_id NUMBER ;
498: l_return_status VARCHAR2(240) ;
499: l_msg_count NUMBER ;
500: l_msg_data VARCHAr2(240) ;
547: --specify the values to which reservation is going to be transferred
548: l_rsv_new.demand_source_header_id := p_header_rec.order_id;
549: l_rsv_new.demand_source_line_id := p_shipment_rec.order_line_id;
550: l_rsv_new.demand_source_type_id :=
551: INV_RESERVATION_GLOBAL.g_source_type_oe ;
552:
553: INV_RESERVATION_PUB.Transfer_Reservation (
554: p_api_version_number => l_api_version_number ,
555: p_init_msg_lst => fnd_api.g_false ,