63: --------------------------------------------------------------------------
64: /*#
65: * Insert Row, inserts a calendar item into JTF_CAL_ITEMS_B table
66: * @param p_api_version API Version Required
67: * @param p_init_msg_list Initialize message list flag, Optional Default = FND_API.G_FALSE
68: * @param p_commit Optional Default = FND_API.G_FALSE
69: * @param x_return_status Required Length = 1
70: * @param x_msg_count API Error message count, Required
71: * @param x_msg_data API Error message data, Required Length = 2000
64: /*#
65: * Insert Row, inserts a calendar item into JTF_CAL_ITEMS_B table
66: * @param p_api_version API Version Required
67: * @param p_init_msg_list Initialize message list flag, Optional Default = FND_API.G_FALSE
68: * @param p_commit Optional Default = FND_API.G_FALSE
69: * @param x_return_status Required Length = 1
70: * @param x_msg_count API Error message count, Required
71: * @param x_msg_data API Error message data, Required Length = 2000
72: * @param p_itm_rec Required take input record type object "cal_item_rec_type"
76: * @rep:displayname Insert Row
77: */
78: PROCEDURE Insert_Row
79: ( p_api_version IN NUMBER
80: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
81: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
82: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
83: , x_return_status OUT NOCOPY VARCHAR2
84: , x_msg_count OUT NOCOPY NUMBER
77: */
78: PROCEDURE Insert_Row
79: ( p_api_version IN NUMBER
80: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
81: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
82: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
83: , x_return_status OUT NOCOPY VARCHAR2
84: , x_msg_count OUT NOCOPY NUMBER
85: , x_msg_data OUT NOCOPY VARCHAR2
78: PROCEDURE Insert_Row
79: ( p_api_version IN NUMBER
80: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
81: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
82: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
83: , x_return_status OUT NOCOPY VARCHAR2
84: , x_msg_count OUT NOCOPY NUMBER
85: , x_msg_data OUT NOCOPY VARCHAR2
86: , p_itm_rec IN cal_item_rec_type
117: --------------------------------------------------------------------------
118: /*#
119: * Update Item row, updates a calendar item into JTF_CAL_ITEMS_B table
120: * @param p_api_version API Version Required
121: * @param p_init_msg_list Initialize message list flag, Optional Default = FND_API.G_FALSE
122: * @param p_commit Optional Default = FND_API.G_FALSE
123: * @param p_validation_level Optional DEFAULT fnd_api.g_valid_level_full
124: * @param x_return_status Required Length = 1
125: * @param x_msg_count API Error message count, Required
118: /*#
119: * Update Item row, updates a calendar item into JTF_CAL_ITEMS_B table
120: * @param p_api_version API Version Required
121: * @param p_init_msg_list Initialize message list flag, Optional Default = FND_API.G_FALSE
122: * @param p_commit Optional Default = FND_API.G_FALSE
123: * @param p_validation_level Optional DEFAULT fnd_api.g_valid_level_full
124: * @param x_return_status Required Length = 1
125: * @param x_msg_count API Error message count, Required
126: * @param x_msg_data API Error message data, Required Length = 2000
119: * Update Item row, updates a calendar item into JTF_CAL_ITEMS_B table
120: * @param p_api_version API Version Required
121: * @param p_init_msg_list Initialize message list flag, Optional Default = FND_API.G_FALSE
122: * @param p_commit Optional Default = FND_API.G_FALSE
123: * @param p_validation_level Optional DEFAULT fnd_api.g_valid_level_full
124: * @param x_return_status Required Length = 1
125: * @param x_msg_count API Error message count, Required
126: * @param x_msg_data API Error message data, Required Length = 2000
127: * @param p_itm_rec Required take input record type object "cal_item_rec_type"
131: * @rep:displayname Update Row
132: */
133: PROCEDURE Update_Row
134: ( p_api_version IN NUMBER
135: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
136: , p_commit IN VARCHAR2 := fnd_api.g_false
137: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
138: , x_return_status OUT NOCOPY VARCHAR2
139: , x_msg_count OUT NOCOPY NUMBER
132: */
133: PROCEDURE Update_Row
134: ( p_api_version IN NUMBER
135: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
136: , p_commit IN VARCHAR2 := fnd_api.g_false
137: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
138: , x_return_status OUT NOCOPY VARCHAR2
139: , x_msg_count OUT NOCOPY NUMBER
140: , x_msg_data OUT NOCOPY VARCHAR2
133: PROCEDURE Update_Row
134: ( p_api_version IN NUMBER
135: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
136: , p_commit IN VARCHAR2 := fnd_api.g_false
137: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
138: , x_return_status OUT NOCOPY VARCHAR2
139: , x_msg_count OUT NOCOPY NUMBER
140: , x_msg_data OUT NOCOPY VARCHAR2
141: , p_itm_rec IN cal_item_rec_type
172: --------------------------------------------------------------------------
173: /*#
174: * Delete Item row, deletes a calendar item from JTF_CAL_ITEMS_B table
175: * @param p_api_version API Version Required
176: * @param p_init_msg_list Initialize message list flag, Optional Default = FND_API.G_FALSE
177: * @param p_commit Optional Default = FND_API.G_FALSE
178: * @param p_validation_level Optional DEFAULT fnd_api.g_valid_level_full
179: * @param x_return_status Required Length = 1
180: * @param x_msg_count API Error message count, Required
173: /*#
174: * Delete Item row, deletes a calendar item from JTF_CAL_ITEMS_B table
175: * @param p_api_version API Version Required
176: * @param p_init_msg_list Initialize message list flag, Optional Default = FND_API.G_FALSE
177: * @param p_commit Optional Default = FND_API.G_FALSE
178: * @param p_validation_level Optional DEFAULT fnd_api.g_valid_level_full
179: * @param x_return_status Required Length = 1
180: * @param x_msg_count API Error message count, Required
181: * @param x_msg_data API Error message data, Required Length = 2000
174: * Delete Item row, deletes a calendar item from JTF_CAL_ITEMS_B table
175: * @param p_api_version API Version Required
176: * @param p_init_msg_list Initialize message list flag, Optional Default = FND_API.G_FALSE
177: * @param p_commit Optional Default = FND_API.G_FALSE
178: * @param p_validation_level Optional DEFAULT fnd_api.g_valid_level_full
179: * @param x_return_status Required Length = 1
180: * @param x_msg_count API Error message count, Required
181: * @param x_msg_data API Error message data, Required Length = 2000
182: * @param p_cal_item_id Required
186: * @rep:displayname Delete Row
187: */
188: PROCEDURE Delete_Row
189: ( p_api_version IN NUMBER
190: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
191: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
192: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
193: , x_return_status OUT NOCOPY VARCHAR2
194: , x_msg_count OUT NOCOPY NUMBER
187: */
188: PROCEDURE Delete_Row
189: ( p_api_version IN NUMBER
190: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
191: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
192: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
193: , x_return_status OUT NOCOPY VARCHAR2
194: , x_msg_count OUT NOCOPY NUMBER
195: , x_msg_data OUT NOCOPY VARCHAR2
188: PROCEDURE Delete_Row
189: ( p_api_version IN NUMBER
190: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
191: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
192: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
193: , x_return_status OUT NOCOPY VARCHAR2
194: , x_msg_count OUT NOCOPY NUMBER
195: , x_msg_data OUT NOCOPY VARCHAR2
196: , p_cal_item_id IN NUMBER
228: /*#
229: * Get Object Version, Returns the current object version number for the given
230: * Calendar Item.
231: * @param p_api_version API Version Required
232: * @param p_init_msg_list Initialize message list flag, Optional Default = FND_API.G_FALSE
233: * @param p_validation_level Optional DEFAULT fnd_api.g_valid_level_full
234: * @param x_return_status Required Length = 1
235: * @param x_msg_count API Error message count, Required
236: * @param x_msg_data API Error message data, Required Length = 2000
229: * Get Object Version, Returns the current object version number for the given
230: * Calendar Item.
231: * @param p_api_version API Version Required
232: * @param p_init_msg_list Initialize message list flag, Optional Default = FND_API.G_FALSE
233: * @param p_validation_level Optional DEFAULT fnd_api.g_valid_level_full
234: * @param x_return_status Required Length = 1
235: * @param x_msg_count API Error message count, Required
236: * @param x_msg_data API Error message data, Required Length = 2000
237: * @param p_cal_item_id Required
241: * @rep:displayname Get Object Version
242: */
243: PROCEDURE Get_Object_Version
244: ( p_api_version IN NUMBER
245: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
246: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
247: , x_return_status OUT NOCOPY VARCHAR2
248: , x_msg_count OUT NOCOPY NUMBER
249: , x_msg_data OUT NOCOPY VARCHAR2
242: */
243: PROCEDURE Get_Object_Version
244: ( p_api_version IN NUMBER
245: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
246: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
247: , x_return_status OUT NOCOPY VARCHAR2
248: , x_msg_count OUT NOCOPY NUMBER
249: , x_msg_data OUT NOCOPY VARCHAR2
250: , p_cal_item_id IN NUMBER