DBA Data[Home] [Help]

APPS.AMS_ACCESS_PVT dependencies on FND_API

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

39: -- the sequence.
40: -- 4. If a flag column is passed in, check if it is 'Y' or 'N'.
41: -- Raise exception for invalid flag.
42: -- 5. If a flag column is not passed in, default it to 'Y' or 'N'.
43: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
44: ---------------------------------------------------------------------
45: PROCEDURE create_access(
46: p_api_version IN NUMBER,
47: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

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

43: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
44: ---------------------------------------------------------------------
45: PROCEDURE create_access(
46: p_api_version IN NUMBER,
47: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
48: p_commit IN VARCHAR2 := FND_API.g_false,
49: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
50:
51: x_return_status OUT NOCOPY VARCHAR2,

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

44: ---------------------------------------------------------------------
45: PROCEDURE create_access(
46: p_api_version IN NUMBER,
47: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
48: p_commit IN VARCHAR2 := FND_API.g_false,
49: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
50:
51: x_return_status OUT NOCOPY VARCHAR2,
52: x_msg_count OUT NOCOPY NUMBER,

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

45: PROCEDURE create_access(
46: p_api_version IN NUMBER,
47: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
48: p_commit IN VARCHAR2 := FND_API.g_false,
49: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
50:
51: x_return_status OUT NOCOPY VARCHAR2,
52: x_msg_count OUT NOCOPY NUMBER,
53: x_msg_data OUT NOCOPY VARCHAR2,

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

88: -- 1. Raise exception if the object_version_number doesn't match.
89: --------------------------------------------------------------------
90: PROCEDURE delete_access(
91: p_api_version IN NUMBER,
92: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
93: p_commit IN VARCHAR2 := FND_API.g_false,
94: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
95:
96: x_return_status OUT NOCOPY VARCHAR2,

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

89: --------------------------------------------------------------------
90: PROCEDURE delete_access(
91: p_api_version IN NUMBER,
92: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
93: p_commit IN VARCHAR2 := FND_API.g_false,
94: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
95:
96: x_return_status OUT NOCOPY VARCHAR2,
97: x_msg_count OUT NOCOPY NUMBER,

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

90: PROCEDURE delete_access(
91: p_api_version IN NUMBER,
92: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
93: p_commit IN VARCHAR2 := FND_API.g_false,
94: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
95:
96: x_return_status OUT NOCOPY VARCHAR2,
97: x_msg_count OUT NOCOPY NUMBER,
98: x_msg_data OUT NOCOPY VARCHAR2,

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

117: -- 1. Raise exception if the object_version_number doesn't match.
118: --------------------------------------------------------------------
119: PROCEDURE lock_access(
120: p_api_version IN NUMBER,
121: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
122: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
123:
124: x_return_status OUT NOCOPY VARCHAR2,
125: x_msg_count OUT NOCOPY NUMBER,

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

118: --------------------------------------------------------------------
119: PROCEDURE lock_access(
120: p_api_version IN NUMBER,
121: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
122: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
123:
124: x_return_status OUT NOCOPY VARCHAR2,
125: x_msg_count OUT NOCOPY NUMBER,
126: x_msg_data OUT NOCOPY VARCHAR2,

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

141: -- p_access_rec: the record with new items
142: --
143: -- NOTES
144: -- 1. Raise exception if the object_version_number doesn't match.
145: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
146: -- that column won't be updated.
147: ----------------------------------------------------------------------
148: PROCEDURE update_access(
149: p_api_version IN NUMBER,

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

146: -- that column won't be updated.
147: ----------------------------------------------------------------------
148: PROCEDURE update_access(
149: p_api_version IN NUMBER,
150: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
151: p_commit IN VARCHAR2 := FND_API.g_false,
152: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
153:
154: x_return_status OUT NOCOPY VARCHAR2,

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

147: ----------------------------------------------------------------------
148: PROCEDURE update_access(
149: p_api_version IN NUMBER,
150: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
151: p_commit IN VARCHAR2 := FND_API.g_false,
152: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
153:
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,

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

148: PROCEDURE update_access(
149: p_api_version IN NUMBER,
150: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
151: p_commit IN VARCHAR2 := FND_API.g_false,
152: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
153:
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
156: x_msg_data OUT NOCOPY VARCHAR2,

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

169: -- p_access_rec: the record with new items
170: --
171: -- NOTES
172: -- 1. Raise exception if the object_version_number doesn't match.
173: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
174: -- that column won't be updated.
175: ----------------------------------------------------------------------
176: PROCEDURE update_object_owner(
177: p_api_version IN NUMBER,

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

174: -- that column won't be updated.
175: ----------------------------------------------------------------------
176: PROCEDURE update_object_owner(
177: p_api_version IN NUMBER,
178: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
179: p_commit IN VARCHAR2 := FND_API.g_false,
180: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
181: x_return_status OUT NOCOPY VARCHAR2,
182: x_msg_count OUT NOCOPY NUMBER,

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

175: ----------------------------------------------------------------------
176: PROCEDURE update_object_owner(
177: p_api_version IN NUMBER,
178: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
179: p_commit IN VARCHAR2 := FND_API.g_false,
180: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
181: x_return_status OUT NOCOPY VARCHAR2,
182: x_msg_count OUT NOCOPY NUMBER,
183: x_msg_data OUT NOCOPY VARCHAR2,

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

176: PROCEDURE update_object_owner(
177: p_api_version IN NUMBER,
178: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
179: p_commit IN VARCHAR2 := FND_API.g_false,
180: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
181: x_return_status OUT NOCOPY VARCHAR2,
182: x_msg_count OUT NOCOPY NUMBER,
183: x_msg_data OUT NOCOPY VARCHAR2,
184: p_object_type IN VARCHAR2,

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

198: -- p_access_rec: the access record to be validated
199: --
200: -- NOTES
201: -- 1. p_access_rec should be the complete access record. There
202: -- should not be any FND_API.g_miss_char/num/date in it.
203: ----------------------------------------------------------------------
204: PROCEDURE validate_access(
205: p_api_version IN NUMBER,
206: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

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

202: -- should not be any FND_API.g_miss_char/num/date in it.
203: ----------------------------------------------------------------------
204: PROCEDURE validate_access(
205: p_api_version IN NUMBER,
206: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
207: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
208:
209: x_return_status OUT NOCOPY VARCHAR2,
210: x_msg_count OUT NOCOPY NUMBER,

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

203: ----------------------------------------------------------------------
204: PROCEDURE validate_access(
205: p_api_version IN NUMBER,
206: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
207: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
208:
209: x_return_status OUT NOCOPY VARCHAR2,
210: x_msg_count OUT NOCOPY NUMBER,
211: x_msg_data OUT NOCOPY VARCHAR2,

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

320: -- Check the record level business rules.
321: --
322: -- PARAMETERS
323: -- p_access_rec: the record to be validated; may contain attributes
324: -- as FND_API.g_miss_char/num/date
325: -- p_complete_rec: the complete record after all "g_miss" items
326: -- have been replaced by current database values
327: ---------------------------------------------------------------------
328: PROCEDURE check_access_record(

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

336: -- PROCEDURE
337: -- init_access_rec
338: --
339: -- PURPOSE
340: -- Initialize all attributes to be FND_API.g_miss_char/num/date.
341: ---------------------------------------------------------------------
342: PROCEDURE init_access_rec(
343: x_access_rec OUT NOCOPY access_rec_type
344: );

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

349: -- complete_access_rec
350: --
351: -- PURPOSE
352: -- For update_access, some attributes may be passed in as
353: -- FND_API.g_miss_char/num/date if the user doesn't want to
354: -- update those attributes. This procedure will replace the
355: -- "g_miss" attributes with current database values.
356: --
357: -- PARAMETERS

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

355: -- "g_miss" attributes with current database values.
356: --
357: -- PARAMETERS
358: -- p_access_rec: the record which may contain attributes as
359: -- FND_API.g_miss_char/num/date
360: -- x_complete_rec: the complete record after all "g_miss" items
361: -- have been replaced by current database values
362: ---------------------------------------------------------------------
363: PROCEDURE complete_access_rec(