DBA Data[Home] [Help]

APPS.AMS_CHANNEL_PVT dependencies on FND_API

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

58: -- p_chan_rec: the new record to be inserted
59: -- x_chan_id: return the channel_id of the new channel
60: --
61: -- NOTES
62: -- 1. Please don't pass in any FND_API.g_mess_char/num/date.
63: -- 2. object_version_number will be set to 1.
64: -- 3. If channel_id is passed in, the uniqueness will be checked.
65: -- Raise exception in case of duplicates. If channel_id is not
66: -- passed in, generate a unique one from the sequence.

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

69: -- passed in, default it to 'Y' or 'N'.
70: ---------------------------------------------------------------------
71: PROCEDURE create_channel(
72: p_api_version IN NUMBER,
73: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
74: p_commit IN VARCHAR2 := FND_API.g_false,
75: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
76:
77: x_return_status OUT NOCOPY VARCHAR2,

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

70: ---------------------------------------------------------------------
71: PROCEDURE create_channel(
72: p_api_version IN NUMBER,
73: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
74: p_commit IN VARCHAR2 := FND_API.g_false,
75: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
76:
77: x_return_status OUT NOCOPY VARCHAR2,
78: x_msg_count OUT NOCOPY NUMBER,

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

71: PROCEDURE create_channel(
72: p_api_version IN NUMBER,
73: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
74: p_commit IN VARCHAR2 := FND_API.g_false,
75: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
76:
77: x_return_status OUT NOCOPY VARCHAR2,
78: x_msg_count OUT NOCOPY NUMBER,
79: x_msg_data OUT NOCOPY VARCHAR2,

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

101: -- from database.
102: --------------------------------------------------------------------
103: PROCEDURE delete_channel(
104: p_api_version IN NUMBER,
105: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
106: p_commit IN VARCHAR2 := FND_API.g_false,
107:
108: x_return_status OUT NOCOPY VARCHAR2,
109: x_msg_count OUT NOCOPY NUMBER,

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

102: --------------------------------------------------------------------
103: PROCEDURE delete_channel(
104: p_api_version IN NUMBER,
105: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
106: p_commit IN VARCHAR2 := FND_API.g_false,
107:
108: x_return_status OUT NOCOPY VARCHAR2,
109: x_msg_count OUT NOCOPY NUMBER,
110: x_msg_data OUT NOCOPY VARCHAR2,

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

129: -- 1. Raise exception if the object_version_number doesn't match.
130: --------------------------------------------------------------------
131: PROCEDURE lock_channel(
132: p_api_version IN NUMBER,
133: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
134:
135: x_return_status OUT NOCOPY VARCHAR2,
136: x_msg_count OUT NOCOPY NUMBER,
137: x_msg_data OUT NOCOPY VARCHAR2,

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

152: -- p_chan_rec: the record with new items
153: --
154: -- NOTES
155: -- 1. Raise exception if the object_version_number doesn't match.
156: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
157: -- that column won't be updated.
158: ----------------------------------------------------------------------
159: PROCEDURE update_channel(
160: p_api_version IN NUMBER,

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

157: -- that column won't be updated.
158: ----------------------------------------------------------------------
159: PROCEDURE update_channel(
160: p_api_version IN NUMBER,
161: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
162: p_commit IN VARCHAR2 := FND_API.g_false,
163: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
164:
165: x_return_status OUT NOCOPY VARCHAR2,

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

158: ----------------------------------------------------------------------
159: PROCEDURE update_channel(
160: p_api_version IN NUMBER,
161: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
162: p_commit IN VARCHAR2 := FND_API.g_false,
163: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
164:
165: x_return_status OUT NOCOPY VARCHAR2,
166: x_msg_count OUT NOCOPY NUMBER,

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

159: PROCEDURE update_channel(
160: p_api_version IN NUMBER,
161: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
162: p_commit IN VARCHAR2 := FND_API.g_false,
163: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
164:
165: x_return_status OUT NOCOPY VARCHAR2,
166: x_msg_count OUT NOCOPY NUMBER,
167: x_msg_data OUT NOCOPY VARCHAR2,

Line 185: -- any FND_API.g_miss_char/num/date items.

181: -- p_chan_rec: the record to be validated
182: --
183: -- NOTES
184: -- 1. p_chan_rec should be the complete channel record wothout
185: -- any FND_API.g_miss_char/num/date items.
186: ----------------------------------------------------------------------
187: PROCEDURE validate_channel(
188: p_api_version IN NUMBER,
189: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

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

185: -- any FND_API.g_miss_char/num/date items.
186: ----------------------------------------------------------------------
187: PROCEDURE validate_channel(
188: p_api_version IN NUMBER,
189: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
190: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
191:
192: x_return_status OUT NOCOPY VARCHAR2,
193: x_msg_count OUT NOCOPY NUMBER,

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

186: ----------------------------------------------------------------------
187: PROCEDURE validate_channel(
188: p_api_version IN NUMBER,
189: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
190: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
191:
192: x_return_status OUT NOCOPY VARCHAR2,
193: x_msg_count OUT NOCOPY NUMBER,
194: x_msg_data OUT NOCOPY VARCHAR2,

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

221: -- PROCEDURE
222: -- init_chan_rec
223: --
224: -- PURPOSE
225: -- Initialize all attributes to be FND_API.g_miss_char/num/date.
226: ---------------------------------------------------------------------
227: PROCEDURE init_chan_rec(
228: x_chan_rec OUT NOCOPY chan_rec_type
229: );

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

234: -- complete_chan_rec
235: --
236: -- PURPOSE
237: -- For update_channel, some attributes may be passed in as
238: -- FND_API.g_miss_char/num/date if the user doesn't want to
239: -- update those attributes. This procedure will replace the
240: -- "g_miss" attributes with current database values.
241: --
242: -- PARAMETERS

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

240: -- "g_miss" attributes with current database values.
241: --
242: -- PARAMETERS
243: -- p_chan_rec: the record which may contain attributes as
244: -- FND_API.g_miss_char/num/date
245: -- x_complete_rec: the complete record after all "g_miss" items
246: -- have been replaced by current database values
247: --
248: -- NOTES