1 PACKAGE CSP_ORDERHEADERS_PUB AUTHID CURRENT_USER AS
2 /* $Header: cspptmhs.pls 115.6 2002/11/26 06:13:21 hhaugeru ship $ */
3 -- Start of Comments
4 -- Package name : CSP_ORDERHEADERS_PUB
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 -- Default number of records fetch per call
11 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
12 -- *******************************************************
13 -- Start of Comments
14 -- -------------------------------------------------------
15 -- Record name:MOH_Rec_Type
16 -- -------------------------------------------------------
17 -- Parameters:
18 -- HEADER_ID
19 -- CREATED_BY
20 -- CREATION_DATE
21 -- LAST_UPDATED_BY
22 -- LAST_UPDATE_DATE
23 -- LAST_UPDATE_LOGIN
24 -- LOCATION_ID
25 -- CARRIER
26 -- SHIPMENT_METHOD
27 -- AUTORECEIPT_FLAG
28 -- ATTRIBUTE_CATEGORY
29 -- ADDRESS1
30 -- ADDRESS2
31 -- ADDRESS3
32 -- ADDRESS4
33 -- CITY
34 -- POSTAL_CODE
35 -- STATE
36 -- PROVINCE
37 -- COUNTRY
38 --
39 -- Required:
40 -- Defaults:
41 -- Note: This is automatic generated record definition, it includes all columns
42 -- defined in the table, developer must manually add or delete some of the attributes.
43 --
44 -- End of Comments
45
46 TYPE MOH_Rec_Type IS RECORD
47 (
48 HEADER_ID NUMBER := FND_API.G_MISS_NUM,
49 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
50 CREATION_DATE DATE := FND_API.G_MISS_DATE,
51 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
52 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
53 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
54 LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
55 CARRIER VARCHAR2(50) := FND_API.G_MISS_CHAR,
56 SHIPMENT_METHOD VARCHAR2(50) := FND_API.G_MISS_CHAR,
57 AUTORECEIPT_FLAG VARCHAR2(10) := FND_API.G_MISS_CHAR,
58 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
59 /* ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
60 ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
61 ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
62 ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
63 CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
64 POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
65 STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
66 PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
67 COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR */
68 );
69
70 G_MISS_MOH_REC MOH_Rec_Type;
71 TYPE MOH_Tbl_Type IS TABLE OF MOH_Rec_Type
72 INDEX BY BINARY_INTEGER;
73 G_MISS_MOH_TBL MOH_Tbl_Type;
74
75 TYPE MOH_sort_rec_type IS RECORD
76 (
77 -- Please define your own sort by record here.
78 CREATED_BY NUMBER := NULL
79 );
80
81 -- *******************************************************
82 -- Start of Comments
83 -- *******************************************************
84 -- API Name: Create_orderheaders
85 -- Type : Public
86 -- Pre-Req :
87 -- Parameters:
88 -- IN
89 -- p_api_version_number IN NUMBER Required
90 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
91 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
92 -- P_MOH_Rec IN MOH_Rec_Type Required
93 --
94 -- OUT:
95 -- x_return_status OUT NOCOPY VARCHAR2
96 -- x_msg_count OUT NOCOPY NUMBER
97 -- x_msg_data OUT NOCOPY VARCHAR2
98 -- Version : Current version 2.0
99 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
100 -- and basic operation, developer must manually add parameters and business logic as necessary.
101 --
102 -- End of Comments
103 --
104 PROCEDURE Create_orderheaders(
105 P_Api_Version_Number IN NUMBER,
106 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
107 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
108 P_MOH_Rec IN MOH_Rec_Type := G_MISS_MOH_REC,
109 --Hint: Add detail tables as parameter lists if it's master-detail relationship.
110 X_HEADER_ID OUT NOCOPY NUMBER,
111 X_Return_Status OUT NOCOPY VARCHAR2,
112 X_Msg_Count OUT NOCOPY NUMBER,
113 X_Msg_Data OUT NOCOPY VARCHAR2
114 );
115
116 -- *******************************************************
117 -- Start of Comments
118 -- *******************************************************
119 -- API Name: Update_orderheaders
120 -- Type : Public
121 -- Pre-Req :
122 -- Parameters:
123 -- IN
124 -- p_api_version_number IN NUMBER Required
125 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
126 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
127 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
128 -- P_MOH_Rec IN MOH_Rec_Type Required
129 --
130 -- OUT:
131 -- x_return_status OUT NOCOPY VARCHAR2
132 -- x_msg_count OUT NOCOPY NUMBER
133 -- x_msg_data OUT NOCOPY VARCHAR2
134 -- Version : Current version 2.0
135 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
136 -- and basic operation, developer must manually add parameters and business logic as necessary.
137 --
138 -- End of Comments
139 --
140 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
141 PROCEDURE Update_orderheaders(
142 P_Api_Version_Number IN NUMBER,
143 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
144 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
145 P_Identity_Salesforce_Id IN NUMBER := NULL,
146 P_MOH_Rec IN MOH_Rec_Type,
147 X_Return_Status OUT NOCOPY VARCHAR2,
148 X_Msg_Count OUT NOCOPY NUMBER,
149 X_Msg_Data OUT NOCOPY VARCHAR2
150 );
151
152 -- *******************************************************
153 -- Start of Comments
154 -- *******************************************************
155 -- API Name: Delete_orderheaders
156 -- Type : Public
157 -- Pre-Req :
158 -- Parameters:
159 -- IN
160 -- p_api_version_number IN NUMBER Required
161 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
162 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
163 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
164 -- P_MOH_Rec IN MOH_Rec_Type Required
165 --
166 -- OUT:
167 -- x_return_status OUT NOCOPY VARCHAR2
168 -- x_msg_count OUT NOCOPY NUMBER
169 -- x_msg_data OUT NOCOPY VARCHAR2
170 -- Version : Current version 2.0
171 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
172 -- and basic operation, developer must manually add parameters and business logic as necessary.
173 --
174 -- End of Comments
175 --
176 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
177 -- The Master delete procedure may not be needed depends on different business requirements.
178 PROCEDURE Delete_orderheaders(
179 P_Api_Version_Number IN NUMBER,
180 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
181 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
182 P_identity_salesforce_id IN NUMBER := NULL,
183 P_MOH_Rec IN MOH_Rec_Type,
184 X_Return_Status OUT NOCOPY VARCHAR2,
185 X_Msg_Count OUT NOCOPY NUMBER,
186 X_Msg_Data OUT NOCOPY VARCHAR2
187 );
188
189 -- *******************************************************
190 -- Start of Comments
191 -- *******************************************************
192 -- API Name: Get_orderheaders
193 -- Type : Public
194 -- Pre-Req :
195 -- Parameters:
196 -- IN
197 -- p_api_version_number IN NUMBER Required
198 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
199 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
200 -- P_MOH_Rec IN MOH_Rec_Type Required
201 -- Hint: Add List of bind variables here
202 -- p_rec_requested IN NUMBER Optional Default = 30
203 -- p_start_rec_ptr IN NUMBER Optional Default = 1
204 --
205 -- Return Total Records Count Flag. This flag controls whether the total record count
206 -- and total record amount is returned.
207 --
208 -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE
209 -- Hint: User defined record type
210 -- p_order_by_tbl IN JTF_PLSQL_API.UTIL_ORDER_BY_TBL_TYPE;
211 --
212 -- OUT:
213 -- x_return_status OUT NOCOPY VARCHAR2
214 -- x_msg_count OUT NOCOPY NUMBER
215 -- x_msg_data OUT NOCOPY VARCHAR2
216 -- X_MOH_Tbl OUT NOCOPY MOH_Rec_Type
217 -- x_returned_rec_count OUT NOCOPY NUMBER
218 -- x_next_rec_ptr OUT NOCOPY NUMBER
219 -- x_tot_rec_count OUT NOCOPY NUMBER
220 -- other optional OUT NOCOPY parameters
221 -- x_tot_rec_amount OUT NOCOPY NUMBER
222 -- Version : Current version 2.0
223 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
224 -- and basic operation, developer must manually add parameters and business logic as necessary.
225 --
226 -- End of Comments
227 --
228 PROCEDURE Get_orderheaders(
229 P_Api_Version_Number IN NUMBER,
230 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
231 P_identity_salesforce_id IN NUMBER := NULL,
232 P_MOH_Rec IN CSP_orderheaders_PUB.MOH_Rec_Type,
233 -- Hint: Add list of bind variables here
234 p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
235 p_start_rec_prt IN NUMBER := 1,
236 p_return_tot_count IN NUMBER := FND_API.G_FALSE,
237 -- Hint: user defined record type
241 x_msg_data OUT NOCOPY VARCHAR2,
238 p_order_by_rec IN CSP_orderheaders_PUB.MOH_sort_rec_type,
239 x_return_status OUT NOCOPY VARCHAR2,
240 x_msg_count OUT NOCOPY NUMBER,
242 X_MOH_Tbl OUT NOCOPY CSP_orderheaders_PUB.MOH_Tbl_Type,
243 x_returned_rec_count OUT NOCOPY NUMBER,
244 x_next_rec_ptr OUT NOCOPY NUMBER,
245 x_tot_rec_count OUT NOCOPY NUMBER
246 -- other optional parameters
247 -- x_tot_rec_amount OUT NOCOPY NUMBER
248 );
249
250 End CSP_ORDERHEADERS_PUB;