1 PACKAGE AS_OPP_OBSTACLE_PVT AUTHID CURRENT_USER as
2 /* $Header: asxvobss.pls 115.11 2002/12/13 12:17:36 nkamble ship $ */
3 -- Start of Comments
4 -- Package name : AS_OPP_OBSTACLE_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 -- *******************************************************
14 -- Start of Comments
15 -- *******************************************************
16 -- API Name: Create_obstacles
17 -- Type : Private
18 -- Pre-Req :
19 -- Parameters:
20 -- IN
21 -- p_api_version_number IN NUMBER Required
22 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
23 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
24 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
25 -- P_Obstacle_Rec IN Obstacle_Rec_Type Required
26 --
27 -- OUT:
28 -- x_return_status OUT VARCHAR2
29 -- x_msg_count OUT NUMBER
30 -- x_msg_data OUT VARCHAR2
31 -- Version : Current version 2.0
32 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
33 -- and basic operation, developer must manually add parameters and business logic as necessary.
34 --
35 -- End of Comments
36 --
37 PROCEDURE Create_obstacles(
38 P_Api_Version_Number IN NUMBER,
39 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
40 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
41 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
42 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
43 P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
44 P_Admin_Group_Id IN NUMBER,
45 P_Identity_Salesforce_Id IN VARCHAR2 := FND_API.G_FALSE,
46 P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
47 p_partner_cont_party_id IN NUMBER := FND_API.G_MISS_NUM,
48 P_Obstacle_tbl IN AS_OPPORTUNITY_PUB.Obstacle_tbl_Type := AS_OPPORTUNITY_PUB.G_MISS_Obstacle_tbl,
49 --Hint: Add detail tables as parameter lists if it's master-detail relationship.
50 X_LEAD_OBSTACLE_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.obstacle_out_tbl_type,
51 X_Return_Status OUT NOCOPY VARCHAR2,
52 X_Msg_Count OUT NOCOPY NUMBER,
53 X_Msg_Data OUT NOCOPY VARCHAR2
54 );
55
56 -- *******************************************************
57 -- Start of Comments
58 -- *******************************************************
59 -- API Name: Update_obstacles
60 -- Type : Private
61 -- Pre-Req :
62 -- Parameters:
63 -- IN
64 -- p_api_version_number IN NUMBER Required
65 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
66 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
67 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
68 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
69 -- P_Obstacle_Rec IN Obstacle_Rec_Type Required
70 --
71 -- OUT:
72 -- x_return_status OUT VARCHAR2
73 -- x_msg_count OUT NUMBER
74 -- x_msg_data OUT VARCHAR2
75 -- Version : Current version 2.0
76 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
77 -- and basic operation, developer must manually add parameters and business logic as necessary.
78 --
79 -- End of Comments
80 --
81 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
82 PROCEDURE Update_obstacles(
83 P_Api_Version_Number IN NUMBER,
84 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
85 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
86 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
87 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
88 P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
89 P_Admin_Group_Id IN NUMBER,
90 P_Identity_Salesforce_Id IN NUMBER,
91 P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
92 p_partner_cont_party_id IN NUMBER := FND_API.G_MISS_NUM,
93 P_Obstacle_tbl IN AS_OPPORTUNITY_PUB.Obstacle_tbl_type,
94 X_LEAD_OBSTACLE_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.obstacle_out_tbl_type,
95 X_Return_Status OUT NOCOPY VARCHAR2,
96 X_Msg_Count OUT NOCOPY NUMBER,
97 X_Msg_Data OUT NOCOPY VARCHAR2
98 );
99
100 -- *******************************************************
101 -- Start of Comments
102 -- *******************************************************
103 -- API Name: Delete_obstacles
104 -- Type : Private
105 -- Pre-Req :
106 -- Parameters:
107 -- IN
108 -- p_api_version_number IN NUMBER Required
109 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
110 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
111 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
112 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
113 -- P_Obstacle_Rec IN Obstacle_Rec_Type Required
114 --
115 -- OUT:
116 -- x_return_status OUT VARCHAR2
117 -- x_msg_count OUT NUMBER
118 -- x_msg_data OUT VARCHAR2
119 -- Version : Current version 2.0
120 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
121 -- and basic operation, developer must manually add parameters and business logic as necessary.
122 --
123 -- End of Comments
124 --
125 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
126 -- The Master delete procedure may not be needed depends on different business requirements.
127 PROCEDURE Delete_obstacles(
128 P_Api_Version_Number IN NUMBER,
129 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
130 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
131 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
133 P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
134 P_Admin_Group_Id IN NUMBER,
135 P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
136 P_identity_salesforce_id IN NUMBER := NULL,
137 p_partner_cont_party_id IN NUMBER := FND_API.G_MISS_NUM,
138 P_Obstacle_tbl IN AS_OPPORTUNITY_PUB.Obstacle_tbl_Type,
139 X_LEAD_OBSTACLE_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.obstacle_out_tbl_type,
140 X_Return_Status OUT NOCOPY VARCHAR2,
141 X_Msg_Count OUT NOCOPY NUMBER,
142 X_Msg_Data OUT NOCOPY VARCHAR2
143 );
144
145
146 -- Start of Comments
147 --
148 -- Item level validation procedures
149 --
150 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
151 -- For create: G_CREATE, for update: G_UPDATE
152 -- Note: 1. This is automated generated item level validation procedure.
153 -- The actual validation detail is needed to be added.
154 --
155 -- End of Comments
156
157 PROCEDURE Validate_LEAD_OBSTACLE_ID (
158 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
159 P_Validation_mode IN VARCHAR2,
160 P_LEAD_OBSTACLE_ID IN NUMBER,
161 -- Hint: You may add 'X_Item_Property_Rec OUT AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
162 X_Return_Status OUT NOCOPY VARCHAR2,
163 X_Msg_Count OUT NOCOPY NUMBER,
164 X_Msg_Data OUT NOCOPY VARCHAR2
165 );
166
167 -- Start of Comments
168 --
169 -- Item level validation procedures
170 --
171 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
172 -- For create: G_CREATE, for update: G_UPDATE
173 -- Note: 1. This is automated generated item level validation procedure.
174 -- The actual validation detail is needed to be added.
175 --
176 -- End of Comments
177
178 PROCEDURE Validate_LEAD_ID (
179 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
180 P_Validation_mode IN VARCHAR2,
181 P_LEAD_ID IN NUMBER,
182 -- Hint: You may add 'X_Item_Property_Rec OUT AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
183 X_Return_Status OUT NOCOPY VARCHAR2,
184 X_Msg_Count OUT NOCOPY NUMBER,
185 X_Msg_Data OUT NOCOPY VARCHAR2
186 );
187
188 -- Start of Comments
189 --
190 -- Item level validation procedures
191 --
192 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
193 -- For create: G_CREATE, for update: G_UPDATE
194 -- Note: 1. This is automated generated item level validation procedure.
195 -- The actual validation detail is needed to be added.
196 --
197 -- End of Comments
198
199 PROCEDURE Validate_OBSTACLE_CODE (
200 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
201 P_Validation_mode IN VARCHAR2,
202 P_OBSTACLE_CODE IN VARCHAR2,
203 -- Hint: You may add 'X_Item_Property_Rec OUT AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
204 X_Return_Status OUT NOCOPY VARCHAR2,
205 X_Msg_Count OUT NOCOPY NUMBER,
206 X_Msg_Data OUT NOCOPY VARCHAR2
207 );
208
209
210 -- Start of Comments
211 --
212 -- Record level validation procedures
213 --
214 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
215 -- For create: G_CREATE, for update: G_UPDATE
216 -- Note: 1. This is automated generated item level validation procedure.
217 -- The actual validation detail is needed to be added.
218 -- 2. Developer can manually added inter-field level validation.
219 -- End of Comments
220
221 PROCEDURE Validate_Obstacle_rec(
222 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
223 P_Validation_mode IN VARCHAR2,
224 P_Obstacle_Rec IN AS_OPPORTUNITY_PUB.Obstacle_Rec_Type,
225 X_Return_Status OUT NOCOPY VARCHAR2,
226 X_Msg_Count OUT NOCOPY NUMBER,
227 X_Msg_Data OUT NOCOPY VARCHAR2
228 );
229
230 -- Start of Comments
231 --
232 -- validation procedures
233 --
234 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
235 -- For create: G_CREATE, for update: G_UPDATE
236 -- Note: 1. This is automated generated item level validation procedure.
237 -- The actual validation detail is needed to be added.
238 -- 2. We can also validate table instead of record. There will be an option for user to choose.
239 -- End of Comments
240
241 PROCEDURE Validate_obstacle(
242 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
243 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
244 P_Validation_mode IN VARCHAR2,
245 P_Obstacle_Rec IN AS_OPPORTUNITY_PUB.Obstacle_Rec_Type,
246 X_Return_Status OUT NOCOPY VARCHAR2,
247 X_Msg_Count OUT NOCOPY NUMBER,
248 X_Msg_Data OUT NOCOPY VARCHAR2
249 );
250 End AS_OPP_OBSTACLE_PVT;