[Home] [Help]
PACKAGE: APPS.CSP_REQUIREMENT_LINES_PVT
Source
1 PACKAGE CSP_Requirement_Lines_PVT AUTHID CURRENT_USER as
2 /* $Header: cspvrqls.pls 115.8 2003/05/02 16:32:32 hhaugeru noship $ */
3 -- Start of Comments
4 -- Package name : CSP_Requirement_Lines_PVT
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:Requirement_Lines_Rec_Type
16 -- -------------------------------------------------------
17 -- Parameters:
18 -- REQUIREMENT_LINE_ID
19 -- CREATED_BY
20 -- CREATION_DATE
21 -- LAST_UPDATED_BY
22 -- LAST_UPDATE_DATE
23 -- LAST_UPDATE_LOGIN
24 -- REQUIREMENT_HEADER_ID
25 -- INVENTORY_ITEM_ID
26 -- UOM_CODE
27 -- REQUIRED_QUANTITY
28 -- SHIP_COMPLETE_FLAG
29 -- LIKELIHOOD
30 -- REVISION
31 -- SOURCE_ORGANIZATION_ID
32 -- SOURCE_SUBINVENTORY
33 -- ORDERED_QUANTITY
34 -- ORDER_LINE_ID
35 -- RESERVATION_ID
36 -- ORDER_BY_DATE
37 -- ATTRIBUTE_CATEGORY
38 -- ATTRIBUTE1
39 -- ATTRIBUTE2
40 -- ATTRIBUTE3
41 -- ATTRIBUTE4
42 -- ATTRIBUTE5
43 -- ATTRIBUTE6
44 -- ATTRIBUTE7
45 -- ATTRIBUTE8
46 -- ATTRIBUTE9
47 -- ATTRIBUTE10
48 -- ATTRIBUTE11
49 -- ATTRIBUTE12
50 -- ATTRIBUTE13
51 -- ATTRIBUTE14
52 -- ATTRIBUTE15
53 --
54 -- Required:
55 -- Defaults:
56 -- Note: This is automatic generated record definition, it includes all columns
57 -- defined in the table, developer must manually add or delete some of the attributes.
58 --
59 -- End of Comments
60
61 TYPE Requirement_Line_Rec_Type IS RECORD
62 (
63 REQUIREMENT_LINE_ID NUMBER := FND_API.G_MISS_NUM,
64 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
65 CREATION_DATE DATE := FND_API.G_MISS_DATE,
66 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
67 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
68 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
69 REQUIREMENT_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
70 INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
71 UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
72 REQUIRED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
73 SHIP_COMPLETE_FLAG VARCHAR2(3) := FND_API.G_MISS_CHAR,
74 LIKELIHOOD NUMBER := FND_API.G_MISS_NUM,
75 REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
76 SOURCE_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
77 SOURCE_SUBINVENTORY VARCHAR2(10) := FND_API.G_MISS_CHAR,
78 ORDERED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
79 ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
80 RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
81 ORDER_BY_DATE DATE := FND_API.G_MISS_DATE,
82 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
83 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98 ARRIVAL_DATE DATE := FND_API.G_MISS_DATE,
99 ITEM_SCRATCHPAD VARCHAR2(240) := FND_API.G_MISS_CHAR,
100 SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
101 LOCAL_RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
102 SOURCED_FROM VARCHAR2(30) := FND_API.G_MISS_CHAR
103 );
104
105 G_MISS_Requirement_Line_REC Requirement_Line_Rec_Type;
106 TYPE Requirement_Line_Tbl_Type IS TABLE OF Requirement_Line_Rec_Type
107 INDEX BY BINARY_INTEGER;
108 G_MISS_Requirement_Line_TBL Requirement_Line_Tbl_Type;
109
110 -- *******************************************************
111 -- Start of Comments
112 -- *******************************************************
113 -- API Name: Create_requirement_lines
114 -- Type : Private
115 -- Pre-Req :
116 -- Parameters:
117 -- IN
118 -- p_api_version_number IN NUMBER Required
119 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
120 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
121 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
122 -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
123 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
124 -- p_admin_group_id IN NUMBER Required
125 -- P_Requirement_Lines_Rec IN Requirement_Lines_Rec_Type Required
126 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
127 --
128 -- OUT:
129 -- x_return_status OUT NOCOPY VARCHAR2
130 -- x_msg_count OUT NOCOPY NUMBER
131 -- x_msg_data OUT NOCOPY VARCHAR2
132 -- Version : Current version 2.0
133 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
134 -- and basic operation, developer must manually add parameters and business logic as necessary.
135 --
136 -- End of Comments
137 --
138 PROCEDURE Create_requirement_lines(
139 P_Api_Version_Number IN NUMBER,
140 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
141 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
142 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
143 P_Requirement_Line_Tbl IN Requirement_Line_Tbl_Type := G_MISS_Requirement_Line_Tbl,
144 x_Requirement_Line_tbl OUT NOCOPY Requirement_Line_Tbl_Type,
145 X_Return_Status OUT NOCOPY VARCHAR2,
146 X_Msg_Count OUT NOCOPY NUMBER,
147 X_Msg_Data OUT NOCOPY VARCHAR2
148 );
149
150 -- *******************************************************
151 -- Start of Comments
152 -- *******************************************************
153 -- API Name: Update_requirement_lines
154 -- Type : Private
155 -- Pre-Req :
156 -- Parameters:
157 -- IN
158 -- p_api_version_number IN NUMBER Required
159 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
160 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
161 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
162 -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
163 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
164 -- p_admin_group_id IN NUMBER Required
165 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
166 -- P_Requirement_Lines_Rec IN Requirement_Lines_Rec_Type Required
167 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
168 --
169 -- OUT:
170 -- x_return_status OUT NOCOPY VARCHAR2
171 -- x_msg_count OUT NOCOPY NUMBER
172 -- x_msg_data OUT NOCOPY VARCHAR2
173 -- Version : Current version 2.0
174 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
175 -- and basic operation, developer must manually add parameters and business logic as necessary.
176 --
177 -- End of Comments
178 --
179 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
180 PROCEDURE Update_requirement_lines(
181 P_Api_Version_Number IN NUMBER,
182 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
183 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
184 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
185 P_Requirement_Line_Tbl IN Requirement_Line_Tbl_Type,
186 X_Return_Status OUT NOCOPY VARCHAR2,
187 X_Msg_Count OUT NOCOPY NUMBER,
188 X_Msg_Data OUT NOCOPY VARCHAR2
189 );
190
191 -- *******************************************************
192 -- Start of Comments
193 -- *******************************************************
194 -- API Name: Delete_requirement_lines
195 -- Type : Private
196 -- Pre-Req :
197 -- Parameters:
198 -- IN
199 -- p_api_version_number IN NUMBER Required
200 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
201 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
202 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
203 -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
204 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
205 -- p_admin_group_id IN NUMBER Required
206 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
207 -- P_Requirement_Lines_Rec IN Requirement_Lines_Rec_Type Required
208 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
209 --
210 -- OUT:
211 -- x_return_status OUT NOCOPY VARCHAR2
212 -- x_msg_count OUT NOCOPY NUMBER
213 -- x_msg_data OUT NOCOPY VARCHAR2
214 -- Version : Current version 2.0
215 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
216 -- and basic operation, developer must manually add parameters and business logic as necessary.
217 --
218 -- End of Comments
219 --
220 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
221 -- The Master delete procedure may not be needed depends on different business requirements.
222 PROCEDURE Delete_requirement_lines(
223 P_Api_Version_Number IN NUMBER,
224 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
225 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
226 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
227 P_Requirement_Line_Tbl IN Requirement_Line_Tbl_Type,
228 X_Return_Status OUT NOCOPY VARCHAR2,
229 X_Msg_Count OUT NOCOPY NUMBER,
230 X_Msg_Data OUT NOCOPY VARCHAR2
231 );
232
233 End CSP_Requirement_Lines_PVT;