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