104: attribute13,
105: attribute14,
106: attribute15
107: ) VALUES (
108: DECODE( px_cat_activity_id, FND_API.g_miss_num, NULL, px_cat_activity_id),
109: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
110: DECODE( p_category_id, FND_API.g_miss_num, NULL, p_category_id),
111: DECODE( p_activity_id, FND_API.g_miss_num, NULL, p_activity_id),
112: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
105: attribute14,
106: attribute15
107: ) VALUES (
108: DECODE( px_cat_activity_id, FND_API.g_miss_num, NULL, px_cat_activity_id),
109: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
110: DECODE( p_category_id, FND_API.g_miss_num, NULL, p_category_id),
111: DECODE( p_activity_id, FND_API.g_miss_num, NULL, p_activity_id),
112: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
113: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
106: attribute15
107: ) VALUES (
108: DECODE( px_cat_activity_id, FND_API.g_miss_num, NULL, px_cat_activity_id),
109: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
110: DECODE( p_category_id, FND_API.g_miss_num, NULL, p_category_id),
111: DECODE( p_activity_id, FND_API.g_miss_num, NULL, p_activity_id),
112: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
113: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
114: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
107: ) VALUES (
108: DECODE( px_cat_activity_id, FND_API.g_miss_num, NULL, px_cat_activity_id),
109: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
110: DECODE( p_category_id, FND_API.g_miss_num, NULL, p_category_id),
111: DECODE( p_activity_id, FND_API.g_miss_num, NULL, p_activity_id),
112: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
113: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
114: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
115: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
108: DECODE( px_cat_activity_id, FND_API.g_miss_num, NULL, px_cat_activity_id),
109: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
110: DECODE( p_category_id, FND_API.g_miss_num, NULL, p_category_id),
111: DECODE( p_activity_id, FND_API.g_miss_num, NULL, p_activity_id),
112: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
113: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
114: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
115: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
116: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
109: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
110: DECODE( p_category_id, FND_API.g_miss_num, NULL, p_category_id),
111: DECODE( p_activity_id, FND_API.g_miss_num, NULL, p_activity_id),
112: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
113: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
114: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
115: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
116: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
117: --DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
110: DECODE( p_category_id, FND_API.g_miss_num, NULL, p_category_id),
111: DECODE( p_activity_id, FND_API.g_miss_num, NULL, p_activity_id),
112: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
113: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
114: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
115: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
116: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
117: --DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
118: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
111: DECODE( p_activity_id, FND_API.g_miss_num, NULL, p_activity_id),
112: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
113: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
114: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
115: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
116: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
117: --DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
118: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
119: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
112: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
113: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
114: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
115: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
116: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
117: --DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
118: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
119: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
120: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
113: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
114: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
115: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
116: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
117: --DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
118: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
119: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
120: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
121: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
114: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
115: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
116: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
117: --DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
118: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
119: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
120: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
121: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
122: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
115: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
116: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
117: --DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
118: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
119: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
120: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
121: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
122: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
123: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
116: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
117: --DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
118: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
119: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
120: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
121: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
122: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
123: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
124: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
117: --DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
118: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
119: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
120: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
121: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
122: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
123: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
124: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
125: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
118: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
119: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
120: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
121: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
122: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
123: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
124: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
125: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
126: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
119: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
120: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
121: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
122: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
123: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
124: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
125: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
126: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
127: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
120: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
121: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
122: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
123: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
124: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
125: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
126: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
127: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
128: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
121: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
122: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
123: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
124: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
125: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
126: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
127: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
128: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
129: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
122: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
123: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
124: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
125: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
126: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
127: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
128: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
129: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
130: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
123: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
124: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
125: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
126: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
127: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
128: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
129: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
130: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
131: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
124: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
125: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
126: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
127: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
128: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
129: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
130: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
131: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
132: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
125: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
126: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
127: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
128: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
129: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
130: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
131: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
132: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
133: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));
126: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
127: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
128: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
129: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
130: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
131: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
132: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
133: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));
134: END Insert_Row;
127: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
128: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
129: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
130: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
131: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
132: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
133: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));
134: END Insert_Row;
135:
128: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
129: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
130: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
131: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
132: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
133: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));
134: END Insert_Row;
135:
136:
129: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
130: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
131: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
132: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
133: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));
134: END Insert_Row;
135:
136:
137: ----------------------------------------------------------
181: IS
182: BEGIN
183: Update AMS_CAT_ACTIVITIES
184: SET
185: cat_activity_id = DECODE( p_cat_activity_id, FND_API.g_miss_num, cat_activity_id, p_cat_activity_id),
186: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
187: category_id = DECODE( p_category_id, FND_API.g_miss_num, category_id, p_category_id),
188: activity_id = DECODE( p_activity_id, FND_API.g_miss_num, activity_id, p_activity_id),
189: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
182: BEGIN
183: Update AMS_CAT_ACTIVITIES
184: SET
185: cat_activity_id = DECODE( p_cat_activity_id, FND_API.g_miss_num, cat_activity_id, p_cat_activity_id),
186: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
187: category_id = DECODE( p_category_id, FND_API.g_miss_num, category_id, p_category_id),
188: activity_id = DECODE( p_activity_id, FND_API.g_miss_num, activity_id, p_activity_id),
189: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
190: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
183: Update AMS_CAT_ACTIVITIES
184: SET
185: cat_activity_id = DECODE( p_cat_activity_id, FND_API.g_miss_num, cat_activity_id, p_cat_activity_id),
186: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
187: category_id = DECODE( p_category_id, FND_API.g_miss_num, category_id, p_category_id),
188: activity_id = DECODE( p_activity_id, FND_API.g_miss_num, activity_id, p_activity_id),
189: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
190: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
191: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
184: SET
185: cat_activity_id = DECODE( p_cat_activity_id, FND_API.g_miss_num, cat_activity_id, p_cat_activity_id),
186: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
187: category_id = DECODE( p_category_id, FND_API.g_miss_num, category_id, p_category_id),
188: activity_id = DECODE( p_activity_id, FND_API.g_miss_num, activity_id, p_activity_id),
189: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
190: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
191: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
192: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
185: cat_activity_id = DECODE( p_cat_activity_id, FND_API.g_miss_num, cat_activity_id, p_cat_activity_id),
186: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
187: category_id = DECODE( p_category_id, FND_API.g_miss_num, category_id, p_category_id),
188: activity_id = DECODE( p_activity_id, FND_API.g_miss_num, activity_id, p_activity_id),
189: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
190: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
191: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
192: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
193: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
186: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
187: category_id = DECODE( p_category_id, FND_API.g_miss_num, category_id, p_category_id),
188: activity_id = DECODE( p_activity_id, FND_API.g_miss_num, activity_id, p_activity_id),
189: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
190: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
191: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
192: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
193: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
194: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
187: category_id = DECODE( p_category_id, FND_API.g_miss_num, category_id, p_category_id),
188: activity_id = DECODE( p_activity_id, FND_API.g_miss_num, activity_id, p_activity_id),
189: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
190: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
191: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
192: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
193: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
194: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
195: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
188: activity_id = DECODE( p_activity_id, FND_API.g_miss_num, activity_id, p_activity_id),
189: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
190: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
191: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
192: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
193: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
194: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
195: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
196: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
189: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
190: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
191: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
192: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
193: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
194: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
195: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
196: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
197: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
190: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
191: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
192: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
193: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
194: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
195: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
196: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
197: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
198: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
191: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
192: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
193: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
194: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
195: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
196: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
197: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
198: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
199: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
192: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
193: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
194: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
195: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
196: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
197: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
198: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
199: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
200: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
193: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
194: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
195: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
196: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
197: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
198: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
199: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
200: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
201: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
194: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
195: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
196: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
197: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
198: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
199: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
200: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
201: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
202: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
195: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
196: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
197: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
198: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
199: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
200: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
201: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
202: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
203: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
196: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
197: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
198: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
199: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
200: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
201: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
202: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
203: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
204: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
197: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
198: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
199: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
200: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
201: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
202: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
203: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
204: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
205: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
198: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
199: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
200: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
201: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
202: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
203: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
204: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
205: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
206: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
199: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
200: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
201: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
202: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
203: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
204: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
205: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
206: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
207: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
200: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
201: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
202: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
203: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
204: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
205: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
206: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
207: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
208: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
201: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
202: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
203: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
204: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
205: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
206: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
207: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
208: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
209: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
202: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
203: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
204: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
205: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
206: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
207: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
208: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
209: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
210: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15)
203: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
204: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
205: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
206: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
207: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
208: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
209: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
210: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15)
211: WHERE CAT_ACTIVITY_ID = p_CAT_ACTIVITY_ID
204: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
205: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
206: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
207: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
208: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
209: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
210: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15)
211: WHERE CAT_ACTIVITY_ID = p_CAT_ACTIVITY_ID
212: AND object_version_number = p_object_version_number;
205: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
206: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
207: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
208: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
209: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
210: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15)
211: WHERE CAT_ACTIVITY_ID = p_CAT_ACTIVITY_ID
212: AND object_version_number = p_object_version_number;
213:
206: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
207: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
208: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
209: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
210: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15)
211: WHERE CAT_ACTIVITY_ID = p_CAT_ACTIVITY_ID
212: AND object_version_number = p_object_version_number;
213:
214: IF (SQL%NOTFOUND) THEN
211: WHERE CAT_ACTIVITY_ID = p_CAT_ACTIVITY_ID
212: AND object_version_number = p_object_version_number;
213:
214: IF (SQL%NOTFOUND) THEN
215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
216: END IF;
217: END Update_Row;
218:
219:
241: DELETE FROM AMS_CAT_ACTIVITIES
242: WHERE CAT_ACTIVITY_ID = p_CAT_ACTIVITY_ID
243: AND object_version_number = p_object_version_number;
244: If (SQL%NOTFOUND) then
245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
246: End If;
247: END Delete_Row ;
248:
249: