APPS.AMS_CAT_ACTIVITIES_PKG dependencies on FND_API

Line 108: DECODE( px_cat_activity_id, FND_API.g_miss_num, NULL, px_cat_activity_id),

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),

Line 109: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

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),

Line 110: DECODE( p_category_id, FND_API.g_miss_num, NULL, p_category_id),

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),

Line 111: DECODE( p_activity_id, FND_API.g_miss_num, NULL, p_activity_id),

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),

Line 112: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

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),

Line 113: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

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),

Line 114: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

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),

Line 115: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

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),

Line 116: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

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),

Line 117: --DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),

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),

Line 118: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),

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),

Line 119: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),

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),

Line 120: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),

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),

Line 121: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),

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),

Line 122: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),

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),

Line 123: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),

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),

Line 124: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),

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),

Line 125: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),

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),

Line 126: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),

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),

Line 127: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),

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),

Line 128: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),

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),

Line 129: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),

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));

Line 130: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),

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;

Line 131: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),

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:

Line 132: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),

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:

Line 133: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));

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: ----------------------------------------------------------

Line 185: cat_activity_id = DECODE( p_cat_activity_id, FND_API.g_miss_num, cat_activity_id, p_cat_activity_id),

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),

Line 186: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),

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),

Line 187: category_id = DECODE( p_category_id, FND_API.g_miss_num, category_id, p_category_id),

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),

Line 188: activity_id = DECODE( p_activity_id, FND_API.g_miss_num, activity_id, p_activity_id),

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),

Line 189: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

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),

Line 190: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

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),

Line 191: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),

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),

Line 192: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

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),

Line 193: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

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),

Line 194: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),

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),

Line 195: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),

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),

Line 196: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),

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),

Line 197: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),

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),

Line 198: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),

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),

Line 199: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),

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),

Line 200: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),

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),

Line 201: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),

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),

Line 202: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),

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),

Line 203: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),

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),

Line 204: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),

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),

Line 205: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),

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),

Line 206: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),

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)

Line 207: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),

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

Line 208: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),

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;

Line 209: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),

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:

Line 210: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15)

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

Line 215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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: