[Home] [Help]
PACKAGE: APPS.CSP_REQUIREMENT_HEADERS_PVT
Source
1 PACKAGE CSP_Requirement_headers_PVT AUTHID CURRENT_USER as
2 /* $Header: cspvrqhs.pls 120.0.12020000.2 2012/07/18 08:09:32 kgambhir ship $ */
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 SHIP_TO_CONTACT_ID NUMBER := FND_API.G_MISS_NUM
95 );
96
97 G_MISS_REQUIREMENT_HEADER_REC REQUIREMENT_HEADER_Rec_Type;
98 TYPE REQUIREMENT_HEADER_Tbl_Type IS TABLE OF REQUIREMENT_HEADER_Rec_Type
99 INDEX BY BINARY_INTEGER;
100 G_MISS_REQUIREMENT_HEADER_TBL REQUIREMENT_HEADER_Tbl_Type;
101
102 -- *******************************************************
103 -- Start of Comments
104 -- *******************************************************
105 -- API Name: Create_requirement_headers
106 -- Type : Private
107 -- Pre-Req :
108 -- Parameters:
109 -- IN
110 -- p_api_version_number IN NUMBER Required
111 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
112 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
113 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
114 -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
115 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
116 -- p_admin_group_id IN NUMBER Required
117 -- P_REQUIREMENT_HEADER_Rec IN REQUIREMENT_HEADER_Rec_Type Required
118 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
119 --
120 -- OUT:
121 -- x_return_status OUT NOCOPY VARCHAR2
122 -- x_msg_count OUT NOCOPY NUMBER
123 -- x_msg_data OUT NOCOPY VARCHAR2
124 -- Version : Current version 2.0
125 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
126 -- and basic operation, developer must manually add parameters and business logic as necessary.
127 --
128 -- End of Comments
129 --
130 PROCEDURE Create_requirement_headers(
131 P_Api_Version_Number IN NUMBER,
132 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
133 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
134 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
135 P_REQUIREMENT_HEADER_Rec IN REQUIREMENT_HEADER_Rec_Type := G_MISS_REQUIREMENT_HEADER_REC,
136 --Hint: Add detail tables as parameter lists if it's master-detail relationship.
137 X_REQUIREMENT_HEADER_ID OUT NOCOPY NUMBER,
138 X_Return_Status OUT NOCOPY VARCHAR2,
139 X_Msg_Count OUT NOCOPY NUMBER,
140 X_Msg_Data OUT NOCOPY VARCHAR2
141 );
142
143 -- *******************************************************
144 -- Start of Comments
145 -- *******************************************************
146 -- API Name: Update_requirement_headers
147 -- Type : Private
148 -- Pre-Req :
149 -- Parameters:
150 -- IN
151 -- p_api_version_number IN NUMBER Required
152 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
153 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
154 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
155 -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
156 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
157 -- p_admin_group_id IN NUMBER Required
158 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
159 -- P_REQUIREMENT_HEADER_Rec IN REQUIREMENT_HEADER_Rec_Type Required
160 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
161 --
162 -- OUT:
163 -- x_return_status OUT NOCOPY VARCHAR2
164 -- x_msg_count OUT NOCOPY NUMBER
165 -- x_msg_data OUT NOCOPY VARCHAR2
166 -- Version : Current version 2.0
167 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
168 -- and basic operation, developer must manually add parameters and business logic as necessary.
169 --
170 -- End of Comments
171 --
172 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
173 PROCEDURE Update_requirement_headers(
174 P_Api_Version_Number IN NUMBER,
175 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
176 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
177 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
178 P_REQUIREMENT_HEADER_Rec IN REQUIREMENT_HEADER_Rec_Type,
179 X_Return_Status OUT NOCOPY VARCHAR2,
180 X_Msg_Count OUT NOCOPY NUMBER,
181 X_Msg_Data OUT NOCOPY VARCHAR2
182 );
183
184 -- *******************************************************
185 -- Start of Comments
186 -- *******************************************************
187 -- API Name: Delete_requirement_headers
188 -- Type : Private
189 -- Pre-Req :
190 -- Parameters:
191 -- IN
192 -- p_api_version_number IN NUMBER Required
193 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
194 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
195 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
196 -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
197 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
198 -- p_admin_group_id IN NUMBER Required
199 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
200 -- P_REQUIREMENT_HEADER_Rec IN REQUIREMENT_HEADER_Rec_Type Required
201 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
202 --
203 -- OUT:
204 -- x_return_status OUT NOCOPY VARCHAR2
205 -- x_msg_count OUT NOCOPY NUMBER
206 -- x_msg_data OUT NOCOPY VARCHAR2
207 -- Version : Current version 2.0
208 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
209 -- and basic operation, developer must manually add parameters and business logic as necessary.
210 --
211 -- End of Comments
212 --
213 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
214 -- The Master delete procedure may not be needed depends on different business requirements.
215 PROCEDURE Delete_requirement_headers(
216 P_Api_Version_Number IN NUMBER,
217 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
218 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
219 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
220 P_REQUIREMENT_HEADER_Rec IN REQUIREMENT_HEADER_Rec_Type,
221 X_Return_Status OUT NOCOPY VARCHAR2,
222 X_Msg_Count OUT NOCOPY NUMBER,
223 X_Msg_Data OUT NOCOPY VARCHAR2
224 );
225
226 End CSP_Requirement_headers_PVT;