DBA Data[Home] [Help]

APPS.OZF_REASON_PVT dependencies on FND_API

Line 125: -- p_init_msg_list IN VARCHAR2 Optional Default=FND_API_G_FALSE

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_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL
128: -- P_reason_Rec IN reason_Rec_Type Required
129: --

Line 126: -- p_commit IN VARCHAR2 Optional Default=FND_API.G_FALSE

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_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL
128: -- P_reason_Rec IN reason_Rec_Type Required
129: --
130: -- OUT:

Line 127: -- p_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL

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_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL
128: -- P_reason_Rec IN reason_Rec_Type Required
129: --
130: -- OUT:
131: -- x_return_status OUT VARCHAR2

Line 142: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

138: -- End of Comments
139: --
140: PROCEDURE Create_reason(
141: P_Api_Version_Number IN NUMBER,
142: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
143: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
144: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
145:
146: X_Return_Status OUT NOCOPY VARCHAR2,

Line 143: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

139: --
140: PROCEDURE Create_reason(
141: P_Api_Version_Number IN NUMBER,
142: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
143: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
144: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
145:
146: X_Return_Status OUT NOCOPY VARCHAR2,
147: X_Msg_Count OUT NOCOPY NUMBER,

Line 144: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

140: PROCEDURE Create_reason(
141: P_Api_Version_Number IN NUMBER,
142: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
143: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
144: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
145:
146: X_Return_Status OUT NOCOPY VARCHAR2,
147: X_Msg_Count OUT NOCOPY NUMBER,
148: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 163: -- p_init_msg_list IN VARCHAR2 Optional Default=FND_API_G_FALSE

159: -- Pre-Req :
160: -- Parameters:
161: -- IN
162: -- p_api_version_number IN NUMBER Required
163: -- p_init_msg_list IN VARCHAR2 Optional Default=FND_API_G_FALSE
164: -- p_commit IN VARCHAR2 Optional Default=FND_API.G_FALSE
165: -- p_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL
166: -- P_reason_Rec IN reason_Rec_Type Required
167: --

Line 164: -- p_commit IN VARCHAR2 Optional Default=FND_API.G_FALSE

160: -- Parameters:
161: -- IN
162: -- p_api_version_number IN NUMBER Required
163: -- p_init_msg_list IN VARCHAR2 Optional Default=FND_API_G_FALSE
164: -- p_commit IN VARCHAR2 Optional Default=FND_API.G_FALSE
165: -- p_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL
166: -- P_reason_Rec IN reason_Rec_Type Required
167: --
168: -- OUT:

Line 165: -- p_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL

161: -- IN
162: -- p_api_version_number IN NUMBER Required
163: -- p_init_msg_list IN VARCHAR2 Optional Default=FND_API_G_FALSE
164: -- p_commit IN VARCHAR2 Optional Default=FND_API.G_FALSE
165: -- p_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL
166: -- P_reason_Rec IN reason_Rec_Type Required
167: --
168: -- OUT:
169: -- x_return_status OUT VARCHAR2

Line 180: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

176: -- End of Comments
177: --
178: PROCEDURE Update_reason(
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_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
183:
184: X_Return_Status OUT NOCOPY VARCHAR2,

Line 181: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

177: --
178: PROCEDURE Update_reason(
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_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
183:
184: X_Return_Status OUT NOCOPY VARCHAR2,
185: X_Msg_Count OUT NOCOPY NUMBER,

Line 182: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

178: PROCEDURE Update_reason(
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_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
183:
184: X_Return_Status OUT NOCOPY VARCHAR2,
185: X_Msg_Count OUT NOCOPY NUMBER,
186: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 201: -- p_init_msg_list IN VARCHAR2 Optional Default=FND_API_G_FALSE

197: -- Pre-Req :
198: -- Parameters:
199: -- IN
200: -- p_api_version_number IN NUMBER Required
201: -- p_init_msg_list IN VARCHAR2 Optional Default=FND_API_G_FALSE
202: -- p_commit IN VARCHAR2 Optional Default=FND_API.G_FALSE
203: -- p_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL
204: -- p_REASON_CODE_ID IN NUMBER
205: -- p_object_version_number IN NUMBER Optional Default=NULL

Line 202: -- p_commit IN VARCHAR2 Optional Default=FND_API.G_FALSE

198: -- Parameters:
199: -- IN
200: -- p_api_version_number IN NUMBER Required
201: -- p_init_msg_list IN VARCHAR2 Optional Default=FND_API_G_FALSE
202: -- p_commit IN VARCHAR2 Optional Default=FND_API.G_FALSE
203: -- p_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL
204: -- p_REASON_CODE_ID IN NUMBER
205: -- p_object_version_number IN NUMBER Optional Default=NULL
206: --

Line 203: -- p_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL

199: -- IN
200: -- p_api_version_number IN NUMBER Required
201: -- p_init_msg_list IN VARCHAR2 Optional Default=FND_API_G_FALSE
202: -- p_commit IN VARCHAR2 Optional Default=FND_API.G_FALSE
203: -- p_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL
204: -- p_REASON_CODE_ID IN NUMBER
205: -- p_object_version_number IN NUMBER Optional Default=NULL
206: --
207: -- OUT:

Line 221: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

217: -- End of Comments
218: --
219: PROCEDURE Delete_reason(
220: P_Api_Version_Number IN NUMBER,
221: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
222: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
223: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
224: X_Return_Status OUT NOCOPY VARCHAR2,
225: X_Msg_Count OUT NOCOPY NUMBER,

Line 222: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

218: --
219: PROCEDURE Delete_reason(
220: P_Api_Version_Number IN NUMBER,
221: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
222: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
223: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
224: X_Return_Status OUT NOCOPY VARCHAR2,
225: X_Msg_Count OUT NOCOPY NUMBER,
226: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 223: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

219: PROCEDURE Delete_reason(
220: P_Api_Version_Number IN NUMBER,
221: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
222: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
223: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
224: X_Return_Status OUT NOCOPY VARCHAR2,
225: X_Msg_Count OUT NOCOPY NUMBER,
226: X_Msg_Data OUT NOCOPY VARCHAR2,
227: P_REASON_CODE_ID IN NUMBER,

Line 240: -- p_init_msg_list IN VARCHAR2 Optional Default=FND_API_G_FALSE

236: -- Pre-Req :
237: -- Parameters:
238: -- IN
239: -- p_api_version_number IN NUMBER Required
240: -- p_init_msg_list IN VARCHAR2 Optional Default=FND_API_G_FALSE
241: -- p_commit IN VARCHAR2 Optional Default=FND_API.G_FALSE
242: -- p_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL
243: -- p_action_Tbl IN action_Tbl_Type
244: --

Line 241: -- p_commit IN VARCHAR2 Optional Default=FND_API.G_FALSE

237: -- Parameters:
238: -- IN
239: -- p_api_version_number IN NUMBER Required
240: -- p_init_msg_list IN VARCHAR2 Optional Default=FND_API_G_FALSE
241: -- p_commit IN VARCHAR2 Optional Default=FND_API.G_FALSE
242: -- p_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL
243: -- p_action_Tbl IN action_Tbl_Type
244: --
245: -- OUT:

Line 242: -- p_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL

238: -- IN
239: -- p_api_version_number IN NUMBER Required
240: -- p_init_msg_list IN VARCHAR2 Optional Default=FND_API_G_FALSE
241: -- p_commit IN VARCHAR2 Optional Default=FND_API.G_FALSE
242: -- p_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL
243: -- p_action_Tbl IN action_Tbl_Type
244: --
245: -- OUT:
246: -- x_return_status OUT VARCHAR2

Line 259: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

255: -- End of Comments
256: --
257: PROCEDURE Update_actions(
258: P_Api_Version_Number IN NUMBER,
259: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
260: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
261: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
262: X_Return_Status OUT NOCOPY VARCHAR2,
263: X_Msg_Count OUT NOCOPY NUMBER,

Line 260: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

256: --
257: PROCEDURE Update_actions(
258: P_Api_Version_Number IN NUMBER,
259: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
260: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
261: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
262: X_Return_Status OUT NOCOPY VARCHAR2,
263: X_Msg_Count OUT NOCOPY NUMBER,
264: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 261: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

257: PROCEDURE Update_actions(
258: P_Api_Version_Number IN NUMBER,
259: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
260: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
261: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
262: X_Return_Status OUT NOCOPY VARCHAR2,
263: X_Msg_Count OUT NOCOPY NUMBER,
264: X_Msg_Data OUT NOCOPY VARCHAR2,
265: P_action_Tbl IN action_Tbl_Type

Line 277: -- p_init_msg_list IN VARCHAR2 Optional Default=FND_API_G_FALSE

273: -- Pre-Req :
274: -- Parameters:
275: -- IN
276: -- p_api_version_number IN NUMBER Required
277: -- p_init_msg_list IN VARCHAR2 Optional Default=FND_API_G_FALSE
278: -- p_commit IN VARCHAR2 Optional Default=FND_API.G_FALSE
279: -- p_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL
280: -- p_reason_type_id IN NUMBER
281: -- p_object_version_number IN NUMBER

Line 278: -- p_commit IN VARCHAR2 Optional Default=FND_API.G_FALSE

274: -- Parameters:
275: -- IN
276: -- p_api_version_number IN NUMBER Required
277: -- p_init_msg_list IN VARCHAR2 Optional Default=FND_API_G_FALSE
278: -- p_commit IN VARCHAR2 Optional Default=FND_API.G_FALSE
279: -- p_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL
280: -- p_reason_type_id IN NUMBER
281: -- p_object_version_number IN NUMBER
282: --

Line 279: -- p_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL

275: -- IN
276: -- p_api_version_number IN NUMBER Required
277: -- p_init_msg_list IN VARCHAR2 Optional Default=FND_API_G_FALSE
278: -- p_commit IN VARCHAR2 Optional Default=FND_API.G_FALSE
279: -- p_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL
280: -- p_reason_type_id IN NUMBER
281: -- p_object_version_number IN NUMBER
282: --
283: -- OUT:

Line 297: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

293: -- End of Comments
294: --
295: PROCEDURE Delete_action(
296: P_Api_Version_Number IN NUMBER,
297: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
298: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
299: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
300: X_Return_Status OUT NOCOPY VARCHAR2,
301: X_Msg_Count OUT NOCOPY NUMBER,

Line 298: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

294: --
295: PROCEDURE Delete_action(
296: P_Api_Version_Number IN NUMBER,
297: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
298: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
299: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
300: X_Return_Status OUT NOCOPY VARCHAR2,
301: X_Msg_Count OUT NOCOPY NUMBER,
302: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 299: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

295: PROCEDURE Delete_action(
296: P_Api_Version_Number IN NUMBER,
297: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
298: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
299: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
300: X_Return_Status OUT NOCOPY VARCHAR2,
301: X_Msg_Count OUT NOCOPY NUMBER,
302: X_Msg_Data OUT NOCOPY VARCHAR2,
303: P_reason_type_id IN NUMBER,

Line 345: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

341: -- End of Comments
342:
343: PROCEDURE Validate_reason_rec(
344: P_Api_Version_Number IN NUMBER,
345: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
346: X_Return_Status OUT NOCOPY VARCHAR2,
347: X_Msg_Count OUT NOCOPY NUMBER,
348: X_Msg_Data OUT NOCOPY VARCHAR2,
349: P_reason_Rec IN reason_Rec_Type

Line 366: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

362: -- End of Comments
363:
364: PROCEDURE Validate_reason(
365: P_Api_Version_Number IN NUMBER,
366: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
367: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
368: P_reason_Rec IN reason_Rec_Type,
369: X_Return_Status OUT NOCOPY VARCHAR2,
370: X_Msg_Count OUT NOCOPY NUMBER,

Line 367: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

363:
364: PROCEDURE Validate_reason(
365: P_Api_Version_Number IN NUMBER,
366: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
367: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
368: P_reason_Rec IN reason_Rec_Type,
369: X_Return_Status OUT NOCOPY VARCHAR2,
370: X_Msg_Count OUT NOCOPY NUMBER,
371: X_Msg_Data OUT NOCOPY VARCHAR2

Line 380: -- FND_API.g_miss_char/num/date if the user doesn't want to

376: -- Complete_Claim_Rec
377: --
378: -- PURPOSE
379: -- For Update_Claim, some attributes may be passed in as
380: -- FND_API.g_miss_char/num/date if the user doesn't want to
381: -- update those attributes. This procedure will replace the
382: -- "g_miss" attributes with current database values.
383: --
384: -- PARAMETERS

Line 386: -- FND_API.g_miss_char/num/date

382: -- "g_miss" attributes with current database values.
383: --
384: -- PARAMETERS
385: -- p_claim_rec : the record which may contain attributes as
386: -- FND_API.g_miss_char/num/date
387: -- x_complete_rec: the complete record after all "g_miss" items
388: -- have been replaced by current database values
389: ---------------------------------------------------------------------
390: PROCEDURE Complete_Reason_Rec (