11: * @rep:category BUSINESS_ENTITY CAC_APPOINTMENT
12: */
13:
14: TYPE calItemRec IS RECORD
15: ( CAL_RESOURCE_ID NUMBER := FND_API.g_miss_num -- JTF Resource ID of calendar on which Item
16: -- should be displayed
17: , CAL_RESOURCE_TYPE VARCHAR2(30) := FND_API.g_miss_char -- JTF Resource Type of resource on which
18: -- item should be displayed values:
19: -- RS_EMPLOYEE and RS_GROUP
13:
14: TYPE calItemRec IS RECORD
15: ( CAL_RESOURCE_ID NUMBER := FND_API.g_miss_num -- JTF Resource ID of calendar on which Item
16: -- should be displayed
17: , CAL_RESOURCE_TYPE VARCHAR2(30) := FND_API.g_miss_char -- JTF Resource Type of resource on which
18: -- item should be displayed values:
19: -- RS_EMPLOYEE and RS_GROUP
20: , CAL_ITEM_ID NUMBER := FND_API.g_miss_num -- Calendar Item key only used for update
21: -- and delete
16: -- should be displayed
17: , CAL_RESOURCE_TYPE VARCHAR2(30) := FND_API.g_miss_char -- JTF Resource Type of resource on which
18: -- item should be displayed values:
19: -- RS_EMPLOYEE and RS_GROUP
20: , CAL_ITEM_ID NUMBER := FND_API.g_miss_num -- Calendar Item key only used for update
21: -- and delete
22: , ITEM_TYPE_CODE VARCHAR2(30) := FND_API.g_miss_char -- 'CALENDAR', 'MEMO', 'TASK' determines
23: -- where the item will be displayed
24: , ITEM_NAME VARCHAR2(80) := FND_API.g_miss_char -- Short Name/description that will be
18: -- item should be displayed values:
19: -- RS_EMPLOYEE and RS_GROUP
20: , CAL_ITEM_ID NUMBER := FND_API.g_miss_num -- Calendar Item key only used for update
21: -- and delete
22: , ITEM_TYPE_CODE VARCHAR2(30) := FND_API.g_miss_char -- 'CALENDAR', 'MEMO', 'TASK' determines
23: -- where the item will be displayed
24: , ITEM_NAME VARCHAR2(80) := FND_API.g_miss_char -- Short Name/description that will be
25: -- (partly)displayed
26: , ITEM_DESCRIPTION VARCHAR2(2000) := FND_API.g_miss_char -- Description of the item, for future use
20: , CAL_ITEM_ID NUMBER := FND_API.g_miss_num -- Calendar Item key only used for update
21: -- and delete
22: , ITEM_TYPE_CODE VARCHAR2(30) := FND_API.g_miss_char -- 'CALENDAR', 'MEMO', 'TASK' determines
23: -- where the item will be displayed
24: , ITEM_NAME VARCHAR2(80) := FND_API.g_miss_char -- Short Name/description that will be
25: -- (partly)displayed
26: , ITEM_DESCRIPTION VARCHAR2(2000) := FND_API.g_miss_char -- Description of the item, for future use
27: -- think balloon text
28: , SOURCE_CODE VARCHAR2(30) := FND_API.g_miss_char -- JTF_OBJECTS source code of the parent
22: , ITEM_TYPE_CODE VARCHAR2(30) := FND_API.g_miss_char -- 'CALENDAR', 'MEMO', 'TASK' determines
23: -- where the item will be displayed
24: , ITEM_NAME VARCHAR2(80) := FND_API.g_miss_char -- Short Name/description that will be
25: -- (partly)displayed
26: , ITEM_DESCRIPTION VARCHAR2(2000) := FND_API.g_miss_char -- Description of the item, for future use
27: -- think balloon text
28: , SOURCE_CODE VARCHAR2(30) := FND_API.g_miss_char -- JTF_OBJECTS source code of the parent
29: -- object, may be used in future for drill
30: -- down
24: , ITEM_NAME VARCHAR2(80) := FND_API.g_miss_char -- Short Name/description that will be
25: -- (partly)displayed
26: , ITEM_DESCRIPTION VARCHAR2(2000) := FND_API.g_miss_char -- Description of the item, for future use
27: -- think balloon text
28: , SOURCE_CODE VARCHAR2(30) := FND_API.g_miss_char -- JTF_OBJECTS source code of the parent
29: -- object, may be used in future for drill
30: -- down
31: , SOURCE_ID NUMBER := FND_API.g_miss_num -- Primary key for the parent object as
32: -- defined in JTF_OBJECTS, may be used in
27: -- think balloon text
28: , SOURCE_CODE VARCHAR2(30) := FND_API.g_miss_char -- JTF_OBJECTS source code of the parent
29: -- object, may be used in future for drill
30: -- down
31: , SOURCE_ID NUMBER := FND_API.g_miss_num -- Primary key for the parent object as
32: -- defined in JTF_OBJECTS, may be used in
33: -- future for drill down
34: , START_DATE DATE := FND_API.g_miss_date -- Start date and time for the item
35: , END_DATE DATE := FND_API.g_miss_date -- End date and time for the item
30: -- down
31: , SOURCE_ID NUMBER := FND_API.g_miss_num -- Primary key for the parent object as
32: -- defined in JTF_OBJECTS, may be used in
33: -- future for drill down
34: , START_DATE DATE := FND_API.g_miss_date -- Start date and time for the item
35: , END_DATE DATE := FND_API.g_miss_date -- End date and time for the item
36: , TIMEZONE_ID NUMBER := FND_API.g_miss_num -- Timezone ID from HZ_TIMEZONES
37: , URL VARCHAR2(4000) := FND_API.g_miss_char -- URL to drill down to parent object
38: , CREATED_BY NUMBER := FND_API.g_miss_num -- Standard Who Column (only used by CreateItem)
31: , SOURCE_ID NUMBER := FND_API.g_miss_num -- Primary key for the parent object as
32: -- defined in JTF_OBJECTS, may be used in
33: -- future for drill down
34: , START_DATE DATE := FND_API.g_miss_date -- Start date and time for the item
35: , END_DATE DATE := FND_API.g_miss_date -- End date and time for the item
36: , TIMEZONE_ID NUMBER := FND_API.g_miss_num -- Timezone ID from HZ_TIMEZONES
37: , URL VARCHAR2(4000) := FND_API.g_miss_char -- URL to drill down to parent object
38: , CREATED_BY NUMBER := FND_API.g_miss_num -- Standard Who Column (only used by CreateItem)
39: , CREATION_DATE DATE := FND_API.g_miss_date -- Standard Who Column (only used by CreateItem)
32: -- defined in JTF_OBJECTS, may be used in
33: -- future for drill down
34: , START_DATE DATE := FND_API.g_miss_date -- Start date and time for the item
35: , END_DATE DATE := FND_API.g_miss_date -- End date and time for the item
36: , TIMEZONE_ID NUMBER := FND_API.g_miss_num -- Timezone ID from HZ_TIMEZONES
37: , URL VARCHAR2(4000) := FND_API.g_miss_char -- URL to drill down to parent object
38: , CREATED_BY NUMBER := FND_API.g_miss_num -- Standard Who Column (only used by CreateItem)
39: , CREATION_DATE DATE := FND_API.g_miss_date -- Standard Who Column (only used by CreateItem)
40: , LAST_UPDATED_BY NUMBER := FND_API.g_miss_num -- Standard Who Column
33: -- future for drill down
34: , START_DATE DATE := FND_API.g_miss_date -- Start date and time for the item
35: , END_DATE DATE := FND_API.g_miss_date -- End date and time for the item
36: , TIMEZONE_ID NUMBER := FND_API.g_miss_num -- Timezone ID from HZ_TIMEZONES
37: , URL VARCHAR2(4000) := FND_API.g_miss_char -- URL to drill down to parent object
38: , CREATED_BY NUMBER := FND_API.g_miss_num -- Standard Who Column (only used by CreateItem)
39: , CREATION_DATE DATE := FND_API.g_miss_date -- Standard Who Column (only used by CreateItem)
40: , LAST_UPDATED_BY NUMBER := FND_API.g_miss_num -- Standard Who Column
41: , LAST_UPDATE_DATE DATE := FND_API.g_miss_date -- Standard Who Column
34: , START_DATE DATE := FND_API.g_miss_date -- Start date and time for the item
35: , END_DATE DATE := FND_API.g_miss_date -- End date and time for the item
36: , TIMEZONE_ID NUMBER := FND_API.g_miss_num -- Timezone ID from HZ_TIMEZONES
37: , URL VARCHAR2(4000) := FND_API.g_miss_char -- URL to drill down to parent object
38: , CREATED_BY NUMBER := FND_API.g_miss_num -- Standard Who Column (only used by CreateItem)
39: , CREATION_DATE DATE := FND_API.g_miss_date -- Standard Who Column (only used by CreateItem)
40: , LAST_UPDATED_BY NUMBER := FND_API.g_miss_num -- Standard Who Column
41: , LAST_UPDATE_DATE DATE := FND_API.g_miss_date -- Standard Who Column
42: , LAST_UPDATE_LOGIN NUMBER := FND_API.g_miss_num -- Standard Who Column
35: , END_DATE DATE := FND_API.g_miss_date -- End date and time for the item
36: , TIMEZONE_ID NUMBER := FND_API.g_miss_num -- Timezone ID from HZ_TIMEZONES
37: , URL VARCHAR2(4000) := FND_API.g_miss_char -- URL to drill down to parent object
38: , CREATED_BY NUMBER := FND_API.g_miss_num -- Standard Who Column (only used by CreateItem)
39: , CREATION_DATE DATE := FND_API.g_miss_date -- Standard Who Column (only used by CreateItem)
40: , LAST_UPDATED_BY NUMBER := FND_API.g_miss_num -- Standard Who Column
41: , LAST_UPDATE_DATE DATE := FND_API.g_miss_date -- Standard Who Column
42: , LAST_UPDATE_LOGIN NUMBER := FND_API.g_miss_num -- Standard Who Column
43: , OBJECT_VERSION_NUMBER NUMBER := FND_API.g_miss_num -- Object version number for the Calendar Item
36: , TIMEZONE_ID NUMBER := FND_API.g_miss_num -- Timezone ID from HZ_TIMEZONES
37: , URL VARCHAR2(4000) := FND_API.g_miss_char -- URL to drill down to parent object
38: , CREATED_BY NUMBER := FND_API.g_miss_num -- Standard Who Column (only used by CreateItem)
39: , CREATION_DATE DATE := FND_API.g_miss_date -- Standard Who Column (only used by CreateItem)
40: , LAST_UPDATED_BY NUMBER := FND_API.g_miss_num -- Standard Who Column
41: , LAST_UPDATE_DATE DATE := FND_API.g_miss_date -- Standard Who Column
42: , LAST_UPDATE_LOGIN NUMBER := FND_API.g_miss_num -- Standard Who Column
43: , OBJECT_VERSION_NUMBER NUMBER := FND_API.g_miss_num -- Object version number for the Calendar Item
44: -- can be obtained with GetObjectVerion
37: , URL VARCHAR2(4000) := FND_API.g_miss_char -- URL to drill down to parent object
38: , CREATED_BY NUMBER := FND_API.g_miss_num -- Standard Who Column (only used by CreateItem)
39: , CREATION_DATE DATE := FND_API.g_miss_date -- Standard Who Column (only used by CreateItem)
40: , LAST_UPDATED_BY NUMBER := FND_API.g_miss_num -- Standard Who Column
41: , LAST_UPDATE_DATE DATE := FND_API.g_miss_date -- Standard Who Column
42: , LAST_UPDATE_LOGIN NUMBER := FND_API.g_miss_num -- Standard Who Column
43: , OBJECT_VERSION_NUMBER NUMBER := FND_API.g_miss_num -- Object version number for the Calendar Item
44: -- can be obtained with GetObjectVerion
45: , APPLICATION_ID NUMBER := FND_API.g_miss_num -- Application ID of parent object
38: , CREATED_BY NUMBER := FND_API.g_miss_num -- Standard Who Column (only used by CreateItem)
39: , CREATION_DATE DATE := FND_API.g_miss_date -- Standard Who Column (only used by CreateItem)
40: , LAST_UPDATED_BY NUMBER := FND_API.g_miss_num -- Standard Who Column
41: , LAST_UPDATE_DATE DATE := FND_API.g_miss_date -- Standard Who Column
42: , LAST_UPDATE_LOGIN NUMBER := FND_API.g_miss_num -- Standard Who Column
43: , OBJECT_VERSION_NUMBER NUMBER := FND_API.g_miss_num -- Object version number for the Calendar Item
44: -- can be obtained with GetObjectVerion
45: , APPLICATION_ID NUMBER := FND_API.g_miss_num -- Application ID of parent object
46: );
39: , CREATION_DATE DATE := FND_API.g_miss_date -- Standard Who Column (only used by CreateItem)
40: , LAST_UPDATED_BY NUMBER := FND_API.g_miss_num -- Standard Who Column
41: , LAST_UPDATE_DATE DATE := FND_API.g_miss_date -- Standard Who Column
42: , LAST_UPDATE_LOGIN NUMBER := FND_API.g_miss_num -- Standard Who Column
43: , OBJECT_VERSION_NUMBER NUMBER := FND_API.g_miss_num -- Object version number for the Calendar Item
44: -- can be obtained with GetObjectVerion
45: , APPLICATION_ID NUMBER := FND_API.g_miss_num -- Application ID of parent object
46: );
47:
41: , LAST_UPDATE_DATE DATE := FND_API.g_miss_date -- Standard Who Column
42: , LAST_UPDATE_LOGIN NUMBER := FND_API.g_miss_num -- Standard Who Column
43: , OBJECT_VERSION_NUMBER NUMBER := FND_API.g_miss_num -- Object version number for the Calendar Item
44: -- can be obtained with GetObjectVerion
45: , APPLICATION_ID NUMBER := FND_API.g_miss_num -- Application ID of parent object
46: );
47:
48: --------------------------------------------------------------------------
49: -- Start of comments
74: --------------------------------------------------------------------------
75: /*#
76: * Create Item, inserts a calendar item into JTF_CAL_ITEMS_B table
77: * @param p_api_version API Version Required
78: * @param p_init_msg_list Initialize message list flag, Optional Default = FND_API.G_FALSE
79: * @param p_commit Optional Default = FND_API.G_FALSE
80: * @param x_return_status Required Length = 1
81: * @param x_msg_count API Error message count, Required
82: * @param x_msg_data API Error message data, Required Length = 2000
75: /*#
76: * Create Item, inserts a calendar item into JTF_CAL_ITEMS_B table
77: * @param p_api_version API Version Required
78: * @param p_init_msg_list Initialize message list flag, Optional Default = FND_API.G_FALSE
79: * @param p_commit Optional Default = FND_API.G_FALSE
80: * @param x_return_status Required Length = 1
81: * @param x_msg_count API Error message count, Required
82: * @param x_msg_data API Error message data, Required Length = 2000
83: * @param p_itm_rec Required take input record type object "CALItemRec"
87: * @rep:displayname Create Item
88: */
89: PROCEDURE CreateItem
90: ( p_api_version IN NUMBER
91: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
92: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
93: , x_return_status OUT NOCOPY VARCHAR2
94: , x_msg_count OUT NOCOPY NUMBER
95: , x_msg_data OUT NOCOPY VARCHAR2
88: */
89: PROCEDURE CreateItem
90: ( p_api_version IN NUMBER
91: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
92: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
93: , x_return_status OUT NOCOPY VARCHAR2
94: , x_msg_count OUT NOCOPY NUMBER
95: , x_msg_data OUT NOCOPY VARCHAR2
96: , p_itm_rec IN CalItemRec
129: --------------------------------------------------------------------------
130: /*#
131: * Update Item, updates a calendar item into JTF_CAL_ITEMS_B table
132: * @param p_api_version API Version Required
133: * @param p_init_msg_list Initialize message list flag, Optional Default = FND_API.G_FALSE
134: * @param p_commit Optional Default = FND_API.G_FALSE
135: * @param p_validation_level Optional DEFAULT fnd_api.g_valid_level_full
136: * @param x_return_status Required Length = 1
137: * @param x_msg_count API Error message count, Required
130: /*#
131: * Update Item, updates a calendar item into JTF_CAL_ITEMS_B table
132: * @param p_api_version API Version Required
133: * @param p_init_msg_list Initialize message list flag, Optional Default = FND_API.G_FALSE
134: * @param p_commit Optional Default = FND_API.G_FALSE
135: * @param p_validation_level Optional DEFAULT fnd_api.g_valid_level_full
136: * @param x_return_status Required Length = 1
137: * @param x_msg_count API Error message count, Required
138: * @param x_msg_data API Error message data, Required Length = 2000
131: * Update Item, updates a calendar item into JTF_CAL_ITEMS_B table
132: * @param p_api_version API Version Required
133: * @param p_init_msg_list Initialize message list flag, Optional Default = FND_API.G_FALSE
134: * @param p_commit Optional Default = FND_API.G_FALSE
135: * @param p_validation_level Optional DEFAULT fnd_api.g_valid_level_full
136: * @param x_return_status Required Length = 1
137: * @param x_msg_count API Error message count, Required
138: * @param x_msg_data API Error message data, Required Length = 2000
139: * @param p_itm_rec Required take input record type object "CALItemRec"
143: * @rep:displayname Update Item
144: */
145: PROCEDURE UpdateItem
146: ( p_api_version IN NUMBER
147: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
148: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
149: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
150: , x_return_status OUT NOCOPY VARCHAR2
151: , x_msg_count OUT NOCOPY NUMBER
144: */
145: PROCEDURE UpdateItem
146: ( p_api_version IN NUMBER
147: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
148: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
149: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
150: , x_return_status OUT NOCOPY VARCHAR2
151: , x_msg_count OUT NOCOPY NUMBER
152: , x_msg_data OUT NOCOPY VARCHAR2
145: PROCEDURE UpdateItem
146: ( p_api_version IN NUMBER
147: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
148: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
149: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
150: , x_return_status OUT NOCOPY VARCHAR2
151: , x_msg_count OUT NOCOPY NUMBER
152: , x_msg_data OUT NOCOPY VARCHAR2
153: , p_itm_rec IN CalItemRec
185: --------------------------------------------------------------------------
186: /*#
187: * Delete Item, deletes a calendar item from JTF_CAL_ITEMS_B table
188: * @param p_api_version API Version Required
189: * @param p_init_msg_list Initialize message list flag, Optional Default = FND_API.G_FALSE
190: * @param p_commit Optional Default = FND_API.G_FALSE
191: * @param p_validation_level Optional DEFAULT fnd_api.g_valid_level_full
192: * @param x_return_status Required Length = 1
193: * @param x_msg_count API Error message count, Required
186: /*#
187: * Delete Item, deletes a calendar item from JTF_CAL_ITEMS_B table
188: * @param p_api_version API Version Required
189: * @param p_init_msg_list Initialize message list flag, Optional Default = FND_API.G_FALSE
190: * @param p_commit Optional Default = FND_API.G_FALSE
191: * @param p_validation_level Optional DEFAULT fnd_api.g_valid_level_full
192: * @param x_return_status Required Length = 1
193: * @param x_msg_count API Error message count, Required
194: * @param x_msg_data API Error message data, Required Length = 2000
187: * Delete Item, deletes a calendar item from JTF_CAL_ITEMS_B table
188: * @param p_api_version API Version Required
189: * @param p_init_msg_list Initialize message list flag, Optional Default = FND_API.G_FALSE
190: * @param p_commit Optional Default = FND_API.G_FALSE
191: * @param p_validation_level Optional DEFAULT fnd_api.g_valid_level_full
192: * @param x_return_status Required Length = 1
193: * @param x_msg_count API Error message count, Required
194: * @param x_msg_data API Error message data, Required Length = 2000
195: * @param p_cal_item_id Required
199: * @rep:displayname Delete Item
200: */
201: PROCEDURE DeleteItem
202: ( p_api_version IN NUMBER
203: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
204: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
205: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
206: , x_return_status OUT NOCOPY VARCHAR2
207: , x_msg_count OUT NOCOPY NUMBER
200: */
201: PROCEDURE DeleteItem
202: ( p_api_version IN NUMBER
203: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
204: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
205: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
206: , x_return_status OUT NOCOPY VARCHAR2
207: , x_msg_count OUT NOCOPY NUMBER
208: , x_msg_data OUT NOCOPY VARCHAR2
201: PROCEDURE DeleteItem
202: ( p_api_version IN NUMBER
203: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
204: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
205: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
206: , x_return_status OUT NOCOPY VARCHAR2
207: , x_msg_count OUT NOCOPY NUMBER
208: , x_msg_data OUT NOCOPY VARCHAR2
209: , p_cal_item_id IN NUMBER
241: /*#
242: * Get Object Version, Returns the current object version number for the given
243: * Calendar Item.
244: * @param p_api_version API Version Required
245: * @param p_init_msg_list Initialize message list flag, Optional Default = FND_API.G_FALSE
246: * @param p_validation_level Optional DEFAULT fnd_api.g_valid_level_full
247: * @param x_return_status Required Length = 1
248: * @param x_msg_count API Error message count, Required
249: * @param x_msg_data API Error message data, Required Length = 2000
242: * Get Object Version, Returns the current object version number for the given
243: * Calendar Item.
244: * @param p_api_version API Version Required
245: * @param p_init_msg_list Initialize message list flag, Optional Default = FND_API.G_FALSE
246: * @param p_validation_level Optional DEFAULT fnd_api.g_valid_level_full
247: * @param x_return_status Required Length = 1
248: * @param x_msg_count API Error message count, Required
249: * @param x_msg_data API Error message data, Required Length = 2000
250: * @param p_cal_item_id Required
254: * @rep:displayname Get Object Version
255: */
256: PROCEDURE GetObjectVersion
257: ( p_api_version IN NUMBER
258: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
259: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
260: , x_return_status OUT NOCOPY VARCHAR2
261: , x_msg_count OUT NOCOPY NUMBER
262: , x_msg_data OUT NOCOPY VARCHAR2
255: */
256: PROCEDURE GetObjectVersion
257: ( p_api_version IN NUMBER
258: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
259: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
260: , x_return_status OUT NOCOPY VARCHAR2
261: , x_msg_count OUT NOCOPY NUMBER
262: , x_msg_data OUT NOCOPY VARCHAR2
263: , p_cal_item_id IN NUMBER