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.
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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: );
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
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