1 PACKAGE INV_MAINTAIN_RESERVATION_PUB AS
2 /* $Header: INVPMRVS.pls 120.2 2005/07/27 11:57:11 jxlu noship $*/
3
4 ------------------------------------------------------------------------------
5 -- Note
6 -- APIs in this package conforms to the PLSQL Business Object API Coding
7 -- Standard.
8 ------------------------------------------------------------------------------
9
10
11 ------------------------------------------------------------------------------
12 -- Please refers to inv_reservation_global package spec for the definitions
13 -- of mtl_reservation_rec_type, serial_number_tbl_type , mtl_rsv_tbl_type
14 -- mtl_Maint_Rsv_Rec_Type, Mtl_Maint_Rsv_Tbl_type
15 ------------------------------------------------------------------------------
16
17 --
18 --
19 -- Procedure
20 -- MAINTAIN_RESERVATION
21 --
22 -- Description
23 -- API will handle changes to the resevation record based on the action code.
24 --
25 -- Input Paramters
26 -- p_api_version_number API version number (current version is 1.0 Standard in parameter)
27 -- p_Init_Msg_lst Flag to determine to initialize message stack for API, standard input parameter
28 -- p_header_id Purchase order header id or requisition header id
29 -- p_line_id Purchase order line id or requisition line id
30 -- p_line_location_id Purchase order shipment id
31 -- p_distribution_id Purchase order distribution_id
32 -- p_transaction_id Receiving transaction id
33 -- p_ordered_quantity Ordered quantity from order entry form
34 -- p_ordered_uom Ordered uom from order entry form
35 -- p_action different action codes for po approve/delete, requisition approve/delete
36 -- Output Parameters
37 -- x_Return_Status Return Status of API, Standard out parameter
38 -- x_Msg_Count Message count from the stack, standard out parameter
39 -- x_Msg_Data Message from message stack, standard out parameter
40
41
42 PROCEDURE MAINTAIN_RESERVATION
43 (
44 p_api_version_number IN NUMBER DEFAULT 1.0
45 , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
46 , p_header_id IN NUMBER DEFAULT NULL
47 , p_line_id IN NUMBER DEFAULT NULL
48 , p_line_location_id IN NUMBER DEFAULT NULL
49 , p_distribution_id IN NUMBER DEFAULT NULL
50 , p_transaction_id IN NUMBER DEFAULT NULL
51 , p_ordered_quantity IN NUMBER DEFAULT NULL
52 , p_ordered_uom IN VARCHAR2 DEFAULT NULL
53 , p_action IN VARCHAR2
54 , x_return_status OUT NOCOPY VARCHAR2
55 , x_msg_count OUT NOCOPY NUMBER
56 , x_msg_data OUT NOCOPY VARCHAR2
57 );
58
59
60
61 ------------------------------------------------------------------------------
62 -- Procedures and Functions
63 ------------------------------------------------------------------------------
64 -- Procedure
65 -- Reduce_Reservations
66 --
67 -- Description
68 -- API will handle changes to the resevation record based on the changes to the supply or demand record changes.
69 --
70 -- Input Paramters
71 -- p_api_version_number Number API version number (current version is 1.0 Standard in parameter)
72 -- p_Init_Msg_lst Varcahar2(1) (Flag to determine to initialize message stack for API, standard input parameter)
73 -- p_Mtl_Maint_Rsv_Tbl Inv_Reservations_Global.mtl_Main_rsv_tbl_type
74 -- p_Delete_Flag Varchar2(1) Accepted values 'Y', 'N' and Null. Null value is equivalent to 'N'
75 -- p_Sort_By_Criteria Number
76 --Out Parameters
77 -- x_Return_Status Varchar2(1) (Return Status of API, Standard out parameter)
78 -- x_Msg_Count Number (Message count from the stack, standard out parameter)
79 -- x_Msg_Data Varchar2(255) (Message from message stack, standard out parameter)
80 -- x_Quantity_Modified Number (Quantity that has been reduced or deleted by API)
81 -- CodeReview.SU.01: Added NoCopy for Out parameters
82 -- CodeReview.SU.02: Added default value for API_Version_NUmber
83 -- CodeReview.SU.03: Added default value for Init_Msg_Lst
84
85 Procedure Reduce_Reservation (
86 p_API_Version_Number In Number default 1.0,
87 p_Init_Msg_Lst In Varchar2 default fnd_api.G_False,
88 x_Return_Status Out NoCopy Varchar2,
89 x_Msg_Count Out NoCopy Number,
90 x_Msg_Data Out NoCopy Varchar2,
91 p_Mtl_Maintain_Rsv_Rec In Inv_Reservation_Global.Mtl_Maintain_Rsv_Rec_Type,
92 p_Delete_Flag In Varchar2,
93 p_Sort_By_Criteria In Number,
94 x_Quantity_Modified Out NoCopy Number );
95
96
97
98
99 END INV_MAINTAIN_RESERVATION_PUB;