DBA Data[Home] [Help]

APPS.ASO_RESERVATION_INT dependencies on INV_RESERVATION_GLOBAL

Line 46: l_rsv inv_reservation_global.mtl_reservation_rec_type;

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';

Line 47: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

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);

Line 48: l_dummy_sn_out inv_reservation_global.serial_number_tbl_type;

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

Line 127: inv_reservation_global.g_source_type_inv;

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;

Line 249: l_rsv_old inv_reservation_global.mtl_reservation_rec_type;

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;

Line 250: l_rsv_new inv_reservation_global.mtl_reservation_rec_type;

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

Line 251: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

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

Line 379: l_rsv inv_reservation_global.mtl_reservation_rec_type;

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

Line 380: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

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

Line 494: l_rsv_old INV_RESERVATION_GLOBAL.Mtl_Reservation_Rec_Type ;

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) ;

Line 495: l_rsv_new INV_RESERVATION_GLOBAL.Mtl_Reservation_Rec_Type ;

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 ;

Line 496: l_dummy_sn INV_RESERVATION_GLOBAL.serial_number_tbl_type ;

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) ;

Line 551: INV_RESERVATION_GLOBAL.g_source_type_oe ;

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 ,