DBA Data[Home] [Help]

APPS.AMS_APPROVERS_PVT dependencies on FND_API

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

71: -- Raise exception in case of duplicates.
72: -- 4. If a flag column is passed in, check if it is 'Y' or 'N'.
73: -- Raise exception for invalid flag.
74: -- 5. If a flag column is not passed in, default it to 'Y' or 'N'.
75: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
76: --------------------------------------------------------------------
77: PROCEDURE Create_approvers (
78: p_api_version IN NUMBER,
79: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

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

75: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
76: --------------------------------------------------------------------
77: PROCEDURE Create_approvers (
78: p_api_version IN NUMBER,
79: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
80: p_commit IN VARCHAR2 := FND_API.g_false,
81: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
82:
83: x_return_status OUT NOCOPY VARCHAR2,

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

76: --------------------------------------------------------------------
77: PROCEDURE Create_approvers (
78: p_api_version IN NUMBER,
79: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
80: p_commit IN VARCHAR2 := FND_API.g_false,
81: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
82:
83: x_return_status OUT NOCOPY VARCHAR2,
84: x_msg_count OUT NOCOPY NUMBER,

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

77: PROCEDURE Create_approvers (
78: p_api_version IN NUMBER,
79: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
80: p_commit IN VARCHAR2 := FND_API.g_false,
81: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
82:
83: x_return_status OUT NOCOPY VARCHAR2,
84: x_msg_count OUT NOCOPY NUMBER,
85: x_msg_data OUT NOCOPY VARCHAR2,

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

99: -- p_approvers_rec: the record representing AMS_APPROVERS
100: --
101: -- NOTES
102: -- 1. Raise exception if the object_version_number doesn't match.
103: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
104: -- that column won't be updated.
105: --------------------------------------------------------------------
106: PROCEDURE Update_approvers (
107: p_api_version IN NUMBER,

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

104: -- that column won't be updated.
105: --------------------------------------------------------------------
106: PROCEDURE Update_approvers (
107: p_api_version IN NUMBER,
108: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
109: p_commit IN VARCHAR2 := FND_API.g_false,
110: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
111:
112: x_return_status OUT NOCOPY VARCHAR2,

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

105: --------------------------------------------------------------------
106: PROCEDURE Update_approvers (
107: p_api_version IN NUMBER,
108: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
109: p_commit IN VARCHAR2 := FND_API.g_false,
110: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
111:
112: x_return_status OUT NOCOPY VARCHAR2,
113: x_msg_count OUT NOCOPY NUMBER,

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

106: PROCEDURE Update_approvers (
107: p_api_version IN NUMBER,
108: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
109: p_commit IN VARCHAR2 := FND_API.g_false,
110: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
111:
112: x_return_status OUT NOCOPY VARCHAR2,
113: x_msg_count OUT NOCOPY NUMBER,
114: x_msg_data OUT NOCOPY VARCHAR2,

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

133: -- 1. Raise exception if the object_version_number doesn't match.
134: --------------------------------------------------------------------
135: PROCEDURE Delete_approvers (
136: p_api_version IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
138: p_commit IN VARCHAR2 := FND_API.g_false,
139: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
140:
141: x_return_status OUT NOCOPY VARCHAR2,

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

134: --------------------------------------------------------------------
135: PROCEDURE Delete_approvers (
136: p_api_version IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
138: p_commit IN VARCHAR2 := FND_API.g_false,
139: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
140:
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,

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

135: PROCEDURE Delete_approvers (
136: p_api_version IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
138: p_commit IN VARCHAR2 := FND_API.g_false,
139: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
140:
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2,

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

163: -- 1. Raise exception if the object_version_number doesn't match.
164: --------------------------------------------------------------------
165: PROCEDURE Lock_approvers (
166: p_api_version IN NUMBER,
167: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
168: p_commit IN VARCHAR2 := FND_API.g_false,
169: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
170:
171: x_return_status OUT NOCOPY VARCHAR2,

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

164: --------------------------------------------------------------------
165: PROCEDURE Lock_approvers (
166: p_api_version IN NUMBER,
167: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
168: p_commit IN VARCHAR2 := FND_API.g_false,
169: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
170:
171: x_return_status OUT NOCOPY VARCHAR2,
172: x_msg_count OUT NOCOPY NUMBER,

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

165: PROCEDURE Lock_approvers (
166: p_api_version IN NUMBER,
167: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
168: p_commit IN VARCHAR2 := FND_API.g_false,
169: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
170:
171: x_return_status OUT NOCOPY VARCHAR2,
172: x_msg_count OUT NOCOPY NUMBER,
173: x_msg_data OUT NOCOPY VARCHAR2,

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

187: -- p_approvers_rec: the record representing AMS_APPROVERS
188: --
189: -- NOTES
190: -- 1. p_approvers_rec should be the complete approver record.
191: -- There should not be any FND_API.g_miss_char/num/date in it.
192: -- 2. If FND_API.g_miss_char/num/date is in the record, then raise
193: -- an exception, as those values are not handled.
194: --------------------------------------------------------------------
195: PROCEDURE Validate_approvers (

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

188: --
189: -- NOTES
190: -- 1. p_approvers_rec should be the complete approver record.
191: -- There should not be any FND_API.g_miss_char/num/date in it.
192: -- 2. If FND_API.g_miss_char/num/date is in the record, then raise
193: -- an exception, as those values are not handled.
194: --------------------------------------------------------------------
195: PROCEDURE Validate_approvers (
196: p_api_version IN NUMBER,

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

193: -- an exception, as those values are not handled.
194: --------------------------------------------------------------------
195: PROCEDURE Validate_approvers (
196: p_api_version IN NUMBER,
197: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
198: p_commit IN VARCHAR2 := FND_API.g_false,
199: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
200:
201: x_return_status OUT NOCOPY VARCHAR2,

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

194: --------------------------------------------------------------------
195: PROCEDURE Validate_approvers (
196: p_api_version IN NUMBER,
197: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
198: p_commit IN VARCHAR2 := FND_API.g_false,
199: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
200:
201: x_return_status OUT NOCOPY VARCHAR2,
202: x_msg_count OUT NOCOPY NUMBER,

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

195: PROCEDURE Validate_approvers (
196: p_api_version IN NUMBER,
197: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
198: p_commit IN VARCHAR2 := FND_API.g_false,
199: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
200:
201: x_return_status OUT NOCOPY VARCHAR2,
202: x_msg_count OUT NOCOPY NUMBER,
203: x_msg_data OUT NOCOPY VARCHAR2,

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

231: -- Check the record level business rules.
232: --
233: -- PARAMETERS
234: -- p_approvers_rec: the record to be validated; may contain attributes
235: -- as FND_API.g_miss_char/num/date
236: -- p_complete_rec: the complete record after all "g_miss" items
237: -- have been replaced by current database values
238: ---------------------------------------------------------------------
239: PROCEDURE Check_approvers_Record (

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

246: -- PROCEDURE
247: -- Init_approvers_Rec
248: --
249: -- PURPOSE
250: -- Initialize all attributes to be FND_API.g_miss_char/num/date.
251: ---------------------------------------------------------------------
252: PROCEDURE Init_approvers_Rec (
253: x_approvers_rec OUT NOCOPY approvers_Rec_Type
254: );

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

258: -- Complete_approvers_Rec
259: --
260: -- PURPOSE
261: -- For Update_approvers, some attributes may be passed in as
262: -- FND_API.g_miss_char/num/date if the user doesn't want to
263: -- update those attributes. This procedure will replace the
264: -- "g_miss" attributes with current database values.
265: --
266: -- PARAMETERS

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

264: -- "g_miss" attributes with current database values.
265: --
266: -- PARAMETERS
267: -- p_approvers_rec: the record which may contain attributes as
268: -- FND_API.g_miss_char/num/date
269: -- x_complete_rec: the complete record after all "g_miss" items
270: -- have been replaced by current database values
271: ---------------------------------------------------------------------
272: PROCEDURE Complete_approvers_Rec (