DBA Data[Home] [Help]

APPS.AMS_APPROVAL_DETAILS_PVT dependencies on FND_API

Line 91: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.

87: -- Raise exception in case of duplicates.
88: -- 4. If a flag column is passed in, check if it is 'Y' or 'N'.
89: -- Raise exception for invalid flag.
90: -- 5. If a flag column is not passed in, default it to 'Y' or 'N'.
91: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
92: --------------------------------------------------------------------
93: PROCEDURE Create_approval_details (
94: p_api_version IN NUMBER,
95: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

Line 95: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

91: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
92: --------------------------------------------------------------------
93: PROCEDURE Create_approval_details (
94: p_api_version IN NUMBER,
95: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
96: p_commit IN VARCHAR2 := FND_API.g_false,
97: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
98:
99: x_return_status OUT NOCOPY VARCHAR2,

Line 96: p_commit IN VARCHAR2 := FND_API.g_false,

92: --------------------------------------------------------------------
93: PROCEDURE Create_approval_details (
94: p_api_version IN NUMBER,
95: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
96: p_commit IN VARCHAR2 := FND_API.g_false,
97: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
98:
99: x_return_status OUT NOCOPY VARCHAR2,
100: x_msg_count OUT NOCOPY NUMBER,

Line 97: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

93: PROCEDURE Create_approval_details (
94: p_api_version IN NUMBER,
95: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
96: p_commit IN VARCHAR2 := FND_API.g_false,
97: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
98:
99: x_return_status OUT NOCOPY VARCHAR2,
100: x_msg_count OUT NOCOPY NUMBER,
101: x_msg_data OUT NOCOPY VARCHAR2,

Line 119: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,

115: -- p_approval_details_rec: the record representing AMS_APPROVAL_DETAILS_VL (without the ROW_ID column).
116: --
117: -- NOTES
118: -- 1. Raise exception if the object_version_number doesn't match.
119: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
120: -- that column won't be updated.
121: --------------------------------------------------------------------
122: PROCEDURE Update_approval_details (
123: p_api_version IN NUMBER,

Line 124: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

120: -- that column won't be updated.
121: --------------------------------------------------------------------
122: PROCEDURE Update_approval_details (
123: p_api_version IN NUMBER,
124: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
125: p_commit IN VARCHAR2 := FND_API.g_false,
126: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
127:
128: x_return_status OUT NOCOPY VARCHAR2,

Line 125: p_commit IN VARCHAR2 := FND_API.g_false,

121: --------------------------------------------------------------------
122: PROCEDURE Update_approval_details (
123: p_api_version IN NUMBER,
124: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
125: p_commit IN VARCHAR2 := FND_API.g_false,
126: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
127:
128: x_return_status OUT NOCOPY VARCHAR2,
129: x_msg_count OUT NOCOPY NUMBER,

Line 126: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

122: PROCEDURE Update_approval_details (
123: p_api_version IN NUMBER,
124: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
125: p_commit IN VARCHAR2 := FND_API.g_false,
126: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
127:
128: x_return_status OUT NOCOPY VARCHAR2,
129: x_msg_count OUT NOCOPY NUMBER,
130: x_msg_data OUT NOCOPY VARCHAR2,

Line 153: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

149: -- 1. Raise exception if the object_version_number doesn't match.
150: --------------------------------------------------------------------
151: PROCEDURE Delete_approval_details (
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
154: p_commit IN VARCHAR2 := FND_API.g_false,
155: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
156:
157: x_return_status OUT NOCOPY VARCHAR2,

Line 154: p_commit IN VARCHAR2 := FND_API.g_false,

150: --------------------------------------------------------------------
151: PROCEDURE Delete_approval_details (
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
154: p_commit IN VARCHAR2 := FND_API.g_false,
155: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
156:
157: x_return_status OUT NOCOPY VARCHAR2,
158: x_msg_count OUT NOCOPY NUMBER,

Line 155: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

151: PROCEDURE Delete_approval_details (
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
154: p_commit IN VARCHAR2 := FND_API.g_false,
155: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
156:
157: x_return_status OUT NOCOPY VARCHAR2,
158: x_msg_count OUT NOCOPY NUMBER,
159: x_msg_data OUT NOCOPY VARCHAR2,

Line 183: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

179: -- 1. Raise exception if the object_version_number doesn't match.
180: --------------------------------------------------------------------
181: PROCEDURE Lock_approval_details (
182: p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
184: p_commit IN VARCHAR2 := FND_API.g_false,
185: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
186:
187: x_return_status OUT NOCOPY VARCHAR2,

Line 184: p_commit IN VARCHAR2 := FND_API.g_false,

180: --------------------------------------------------------------------
181: PROCEDURE Lock_approval_details (
182: p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
184: p_commit IN VARCHAR2 := FND_API.g_false,
185: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
186:
187: x_return_status OUT NOCOPY VARCHAR2,
188: x_msg_count OUT NOCOPY NUMBER,

Line 185: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

181: PROCEDURE Lock_approval_details (
182: p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
184: p_commit IN VARCHAR2 := FND_API.g_false,
185: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
186:
187: x_return_status OUT NOCOPY VARCHAR2,
188: x_msg_count OUT NOCOPY NUMBER,
189: x_msg_data OUT NOCOPY VARCHAR2,

Line 207: -- There should not be any FND_API.g_miss_char/num/date in it.

203: -- p_approval_details_rec: the record representing AMS_APPROVAL_DETAILS_VL (without ROW_ID).
204: --
205: -- NOTES
206: -- 1. p_approval_details_rec should be the complete approval_details record.
207: -- There should not be any FND_API.g_miss_char/num/date in it.
208: -- 2. If FND_API.g_miss_char/num/date is in the record, then raise
209: -- an exception, as those values are not handled.
210: --------------------------------------------------------------------
211: PROCEDURE Validate_approval_details (

Line 208: -- 2. If FND_API.g_miss_char/num/date is in the record, then raise

204: --
205: -- NOTES
206: -- 1. p_approval_details_rec should be the complete approval_details record.
207: -- There should not be any FND_API.g_miss_char/num/date in it.
208: -- 2. If FND_API.g_miss_char/num/date is in the record, then raise
209: -- an exception, as those values are not handled.
210: --------------------------------------------------------------------
211: PROCEDURE Validate_approval_details (
212: p_api_version IN NUMBER,

Line 213: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

209: -- an exception, as those values are not handled.
210: --------------------------------------------------------------------
211: PROCEDURE Validate_approval_details (
212: p_api_version IN NUMBER,
213: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
214: p_commit IN VARCHAR2 := FND_API.g_false,
215: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
216:
217: x_return_status OUT NOCOPY VARCHAR2,

Line 214: p_commit IN VARCHAR2 := FND_API.g_false,

210: --------------------------------------------------------------------
211: PROCEDURE Validate_approval_details (
212: p_api_version IN NUMBER,
213: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
214: p_commit IN VARCHAR2 := FND_API.g_false,
215: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
216:
217: x_return_status OUT NOCOPY VARCHAR2,
218: x_msg_count OUT NOCOPY NUMBER,

Line 215: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

211: PROCEDURE Validate_approval_details (
212: p_api_version IN NUMBER,
213: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
214: p_commit IN VARCHAR2 := FND_API.g_false,
215: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
216:
217: x_return_status OUT NOCOPY VARCHAR2,
218: x_msg_count OUT NOCOPY NUMBER,
219: x_msg_data OUT NOCOPY VARCHAR2,

Line 251: -- as FND_API.g_miss_char/num/date

247: -- Check the record level business rules.
248: --
249: -- PARAMETERS
250: -- p_approval_details_rec: the record to be validated; may contain attributes
251: -- as FND_API.g_miss_char/num/date
252: -- p_complete_rec: the complete record after all "g_miss" items
253: -- have been replaced by current database values
254: ---------------------------------------------------------------------
255: PROCEDURE Check_approval_details_Record (

Line 266: -- Initialize all attributes to be FND_API.g_miss_char/num/date.

262: -- PROCEDURE
263: -- Init_approval_details_Rec
264: --
265: -- PURPOSE
266: -- Initialize all attributes to be FND_API.g_miss_char/num/date.
267: ---------------------------------------------------------------------
268: PROCEDURE Init_approval_details_Rec (
269: x_approval_details_rec OUT NOCOPY approval_details_Rec_Type
270: );

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

274: -- Complete_approval_details_Rec
275: --
276: -- PURPOSE
277: -- For Update_approval_details, some attributes may be passed in as
278: -- FND_API.g_miss_char/num/date if the user doesn't want to
279: -- update those attributes. This procedure will replace the
280: -- "g_miss" attributes with current database values.
281: --
282: -- PARAMETERS

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

280: -- "g_miss" attributes with current database values.
281: --
282: -- PARAMETERS
283: -- p_approval_details_rec: the record which may contain attributes as
284: -- FND_API.g_miss_char/num/date
285: -- x_complete_rec: the complete record after all "g_miss" items
286: -- have been replaced by current database values
287: ---------------------------------------------------------------------
288: PROCEDURE Complete_approval_details_Rec (