61:
62: --===================================================================
63: TYPE cat_activity_rec_type IS RECORD
64: (
65: cat_activity_id NUMBER := FND_API.G_MISS_NUM,
66: object_version_number NUMBER := FND_API.G_MISS_NUM,
67: category_id NUMBER := FND_API.G_MISS_NUM,
68: activity_id NUMBER := FND_API.G_MISS_NUM,
69: last_update_date DATE := FND_API.G_MISS_DATE,
62: --===================================================================
63: TYPE cat_activity_rec_type IS RECORD
64: (
65: cat_activity_id NUMBER := FND_API.G_MISS_NUM,
66: object_version_number NUMBER := FND_API.G_MISS_NUM,
67: category_id NUMBER := FND_API.G_MISS_NUM,
68: activity_id NUMBER := FND_API.G_MISS_NUM,
69: last_update_date DATE := FND_API.G_MISS_DATE,
70: last_updated_by NUMBER := FND_API.G_MISS_NUM,
63: TYPE cat_activity_rec_type IS RECORD
64: (
65: cat_activity_id NUMBER := FND_API.G_MISS_NUM,
66: object_version_number NUMBER := FND_API.G_MISS_NUM,
67: category_id NUMBER := FND_API.G_MISS_NUM,
68: activity_id NUMBER := FND_API.G_MISS_NUM,
69: last_update_date DATE := FND_API.G_MISS_DATE,
70: last_updated_by NUMBER := FND_API.G_MISS_NUM,
71: creation_date DATE := FND_API.G_MISS_DATE,
64: (
65: cat_activity_id NUMBER := FND_API.G_MISS_NUM,
66: object_version_number NUMBER := FND_API.G_MISS_NUM,
67: category_id NUMBER := FND_API.G_MISS_NUM,
68: activity_id NUMBER := FND_API.G_MISS_NUM,
69: last_update_date DATE := FND_API.G_MISS_DATE,
70: last_updated_by NUMBER := FND_API.G_MISS_NUM,
71: creation_date DATE := FND_API.G_MISS_DATE,
72: created_by NUMBER := FND_API.G_MISS_NUM,
65: cat_activity_id NUMBER := FND_API.G_MISS_NUM,
66: object_version_number NUMBER := FND_API.G_MISS_NUM,
67: category_id NUMBER := FND_API.G_MISS_NUM,
68: activity_id NUMBER := FND_API.G_MISS_NUM,
69: last_update_date DATE := FND_API.G_MISS_DATE,
70: last_updated_by NUMBER := FND_API.G_MISS_NUM,
71: creation_date DATE := FND_API.G_MISS_DATE,
72: created_by NUMBER := FND_API.G_MISS_NUM,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,
66: object_version_number NUMBER := FND_API.G_MISS_NUM,
67: category_id NUMBER := FND_API.G_MISS_NUM,
68: activity_id NUMBER := FND_API.G_MISS_NUM,
69: last_update_date DATE := FND_API.G_MISS_DATE,
70: last_updated_by NUMBER := FND_API.G_MISS_NUM,
71: creation_date DATE := FND_API.G_MISS_DATE,
72: created_by NUMBER := FND_API.G_MISS_NUM,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,
74: --security_group_id NUMBER := FND_API.G_MISS_NUM,
67: category_id NUMBER := FND_API.G_MISS_NUM,
68: activity_id NUMBER := FND_API.G_MISS_NUM,
69: last_update_date DATE := FND_API.G_MISS_DATE,
70: last_updated_by NUMBER := FND_API.G_MISS_NUM,
71: creation_date DATE := FND_API.G_MISS_DATE,
72: created_by NUMBER := FND_API.G_MISS_NUM,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,
74: --security_group_id NUMBER := FND_API.G_MISS_NUM,
75: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: activity_id NUMBER := FND_API.G_MISS_NUM,
69: last_update_date DATE := FND_API.G_MISS_DATE,
70: last_updated_by NUMBER := FND_API.G_MISS_NUM,
71: creation_date DATE := FND_API.G_MISS_DATE,
72: created_by NUMBER := FND_API.G_MISS_NUM,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,
74: --security_group_id NUMBER := FND_API.G_MISS_NUM,
75: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69: last_update_date DATE := FND_API.G_MISS_DATE,
70: last_updated_by NUMBER := FND_API.G_MISS_NUM,
71: creation_date DATE := FND_API.G_MISS_DATE,
72: created_by NUMBER := FND_API.G_MISS_NUM,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,
74: --security_group_id NUMBER := FND_API.G_MISS_NUM,
75: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: last_updated_by NUMBER := FND_API.G_MISS_NUM,
71: creation_date DATE := FND_API.G_MISS_DATE,
72: created_by NUMBER := FND_API.G_MISS_NUM,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,
74: --security_group_id NUMBER := FND_API.G_MISS_NUM,
75: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71: creation_date DATE := FND_API.G_MISS_DATE,
72: created_by NUMBER := FND_API.G_MISS_NUM,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,
74: --security_group_id NUMBER := FND_API.G_MISS_NUM,
75: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: created_by NUMBER := FND_API.G_MISS_NUM,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,
74: --security_group_id NUMBER := FND_API.G_MISS_NUM,
75: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,
74: --security_group_id NUMBER := FND_API.G_MISS_NUM,
75: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: --security_group_id NUMBER := FND_API.G_MISS_NUM,
75: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
83: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
91: );
84: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
91: );
92:
85: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
91: );
92:
93: g_miss_cat_activity_rec cat_activity_rec_type;
86: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
91: );
92:
93: g_miss_cat_activity_rec cat_activity_rec_type;
94: TYPE cat_activity_tbl_type IS TABLE OF cat_activity_rec_type INDEX BY BINARY_INTEGER;
106: -- Parameters
107: --
108: -- IN
109: -- p_api_version_number IN NUMBER Required
110: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
111: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
112: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
113: -- p_cat_activity_rec IN cat_activity_rec_type Required
114: --
107: --
108: -- IN
109: -- p_api_version_number IN NUMBER Required
110: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
111: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
112: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
113: -- p_cat_activity_rec IN cat_activity_rec_type Required
114: --
115: -- OUT
108: -- IN
109: -- p_api_version_number IN NUMBER Required
110: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
111: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
112: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
113: -- p_cat_activity_rec IN cat_activity_rec_type Required
114: --
115: -- OUT
116: -- x_return_status OUT VARCHAR2
125: --
126:
127: PROCEDURE Create_Cat_Activity(
128: p_api_version_number IN NUMBER,
129: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
130: p_commit IN VARCHAR2 := FND_API.G_FALSE,
131: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132:
133: x_return_status OUT NOCOPY VARCHAR2,
126:
127: PROCEDURE Create_Cat_Activity(
128: p_api_version_number IN NUMBER,
129: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
130: p_commit IN VARCHAR2 := FND_API.G_FALSE,
131: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132:
133: x_return_status OUT NOCOPY VARCHAR2,
134: x_msg_count OUT NOCOPY NUMBER,
127: PROCEDURE Create_Cat_Activity(
128: p_api_version_number IN NUMBER,
129: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
130: p_commit IN VARCHAR2 := FND_API.G_FALSE,
131: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132:
133: x_return_status OUT NOCOPY VARCHAR2,
134: x_msg_count OUT NOCOPY NUMBER,
135: x_msg_data OUT NOCOPY VARCHAR2,
150: -- Parameters
151: --
152: -- IN
153: -- p_api_version_number IN NUMBER Required
154: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
155: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
156: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
157: -- p_cat_activity_rec IN cat_activity_rec_type Required
158: --
151: --
152: -- IN
153: -- p_api_version_number IN NUMBER Required
154: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
155: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
156: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
157: -- p_cat_activity_rec IN cat_activity_rec_type Required
158: --
159: -- OUT
152: -- IN
153: -- p_api_version_number IN NUMBER Required
154: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
155: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
156: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
157: -- p_cat_activity_rec IN cat_activity_rec_type Required
158: --
159: -- OUT
160: -- x_return_status OUT VARCHAR2
169: --
170:
171: PROCEDURE Update_Cat_Activity(
172: p_api_version_number IN NUMBER,
173: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
174: p_commit IN VARCHAR2 := FND_API.G_FALSE,
175: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
176:
177: x_return_status OUT NOCOPY VARCHAR2,
170:
171: PROCEDURE Update_Cat_Activity(
172: p_api_version_number IN NUMBER,
173: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
174: p_commit IN VARCHAR2 := FND_API.G_FALSE,
175: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
176:
177: x_return_status OUT NOCOPY VARCHAR2,
178: x_msg_count OUT NOCOPY NUMBER,
171: PROCEDURE Update_Cat_Activity(
172: p_api_version_number IN NUMBER,
173: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
174: p_commit IN VARCHAR2 := FND_API.G_FALSE,
175: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
176:
177: x_return_status OUT NOCOPY VARCHAR2,
178: x_msg_count OUT NOCOPY NUMBER,
179: x_msg_data OUT NOCOPY VARCHAR2,
194: -- Parameters
195: --
196: -- IN
197: -- p_api_version_number IN NUMBER Required
198: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
199: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
200: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
201: -- p_CAT_ACTIVITY_ID IN NUMBER
202: -- p_object_version_number IN NUMBER Optional Default = NULL
195: --
196: -- IN
197: -- p_api_version_number IN NUMBER Required
198: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
199: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
200: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
201: -- p_CAT_ACTIVITY_ID IN NUMBER
202: -- p_object_version_number IN NUMBER Optional Default = NULL
203: --
196: -- IN
197: -- p_api_version_number IN NUMBER Required
198: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
199: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
200: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
201: -- p_CAT_ACTIVITY_ID IN NUMBER
202: -- p_object_version_number IN NUMBER Optional Default = NULL
203: --
204: -- OUT
214: --
215:
216: PROCEDURE Delete_Cat_Activity(
217: p_api_version_number IN NUMBER,
218: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
219: p_commit IN VARCHAR2 := FND_API.G_FALSE,
220: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
221: x_return_status OUT NOCOPY VARCHAR2,
222: x_msg_count OUT NOCOPY NUMBER,
215:
216: PROCEDURE Delete_Cat_Activity(
217: p_api_version_number IN NUMBER,
218: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
219: p_commit IN VARCHAR2 := FND_API.G_FALSE,
220: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
221: x_return_status OUT NOCOPY VARCHAR2,
222: x_msg_count OUT NOCOPY NUMBER,
223: x_msg_data OUT NOCOPY VARCHAR2,
216: PROCEDURE Delete_Cat_Activity(
217: p_api_version_number IN NUMBER,
218: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
219: p_commit IN VARCHAR2 := FND_API.G_FALSE,
220: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
221: x_return_status OUT NOCOPY VARCHAR2,
222: x_msg_count OUT NOCOPY NUMBER,
223: x_msg_data OUT NOCOPY VARCHAR2,
224: p_cat_activity_id IN NUMBER,
237: -- Parameters
238: --
239: -- IN
240: -- p_api_version_number IN NUMBER Required
241: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
242: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
243: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
244: -- p_cat_activity_rec IN cat_activity_rec_type Required
245: --
238: --
239: -- IN
240: -- p_api_version_number IN NUMBER Required
241: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
242: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
243: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
244: -- p_cat_activity_rec IN cat_activity_rec_type Required
245: --
246: -- OUT
239: -- IN
240: -- p_api_version_number IN NUMBER Required
241: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
242: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
243: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
244: -- p_cat_activity_rec IN cat_activity_rec_type Required
245: --
246: -- OUT
247: -- x_return_status OUT VARCHAR2
256: --
257:
258: PROCEDURE Lock_Cat_Activity(
259: p_api_version_number IN NUMBER,
260: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
261:
262: x_return_status OUT NOCOPY VARCHAR2,
263: x_msg_count OUT NOCOPY NUMBER,
264: x_msg_data OUT NOCOPY VARCHAR2,
280: -- End of Comments
281:
282: PROCEDURE Validate_cat_activity(
283: p_api_version_number IN NUMBER,
284: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
285: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
286: p_cat_activity_rec IN cat_activity_rec_type,
287: x_return_status OUT NOCOPY VARCHAR2,
288: x_msg_count OUT NOCOPY NUMBER,
281:
282: PROCEDURE Validate_cat_activity(
283: p_api_version_number IN NUMBER,
284: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
285: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
286: p_cat_activity_rec IN cat_activity_rec_type,
287: x_return_status OUT NOCOPY VARCHAR2,
288: x_msg_count OUT NOCOPY NUMBER,
289: x_msg_data OUT NOCOPY VARCHAR2
318: -- End of Comments
319:
320: PROCEDURE Validate_cat_activity_rec(
321: p_api_version_number IN NUMBER,
322: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
323: x_return_status OUT NOCOPY VARCHAR2,
324: x_msg_count OUT NOCOPY NUMBER,
325: x_msg_data OUT NOCOPY VARCHAR2,
326: p_cat_activity_rec IN cat_activity_rec_type