APPS.AMS_ACT_CONTACT_POINTS_PKG dependencies on FND_API

Line 114: DECODE( px_contact_point_id, FND_API.g_miss_num, NULL, px_contact_point_id),

110: attribute14,
111: attribute15,
112: contact_point_value_id
113: ) VALUES (
114: DECODE( px_contact_point_id, FND_API.g_miss_num, NULL, px_contact_point_id),
115: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
116: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
117: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
118: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

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

111: attribute15,
112: contact_point_value_id
113: ) VALUES (
114: DECODE( px_contact_point_id, FND_API.g_miss_num, NULL, px_contact_point_id),
115: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
116: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
117: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
118: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
119: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

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

112: contact_point_value_id
113: ) VALUES (
114: DECODE( px_contact_point_id, FND_API.g_miss_num, NULL, px_contact_point_id),
115: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
116: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
117: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
118: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
119: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
120: px_object_version_number, -- object version_number is always 1 when created

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

113: ) VALUES (
114: DECODE( px_contact_point_id, FND_API.g_miss_num, NULL, px_contact_point_id),
115: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
116: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
117: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
118: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
119: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
120: px_object_version_number, -- object version_number is always 1 when created
121: DECODE( p_arc_contact_used_by, FND_API.g_miss_char, NULL, p_arc_contact_used_by),

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

114: DECODE( px_contact_point_id, FND_API.g_miss_num, NULL, px_contact_point_id),
115: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
116: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
117: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
118: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
119: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
120: px_object_version_number, -- object version_number is always 1 when created
121: DECODE( p_arc_contact_used_by, FND_API.g_miss_char, NULL, p_arc_contact_used_by),
122: DECODE( p_act_contact_used_by_id, FND_API.g_miss_num, NULL, p_act_contact_used_by_id),

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

115: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
116: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
117: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
118: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
119: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
120: px_object_version_number, -- object version_number is always 1 when created
121: DECODE( p_arc_contact_used_by, FND_API.g_miss_char, NULL, p_arc_contact_used_by),
122: DECODE( p_act_contact_used_by_id, FND_API.g_miss_num, NULL, p_act_contact_used_by_id),
123: DECODE( p_contact_point_type, FND_API.g_miss_char, NULL, p_contact_point_type),

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

117: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
118: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
119: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
120: px_object_version_number, -- object version_number is always 1 when created
121: DECODE( p_arc_contact_used_by, FND_API.g_miss_char, NULL, p_arc_contact_used_by),
122: DECODE( p_act_contact_used_by_id, FND_API.g_miss_num, NULL, p_act_contact_used_by_id),
123: DECODE( p_contact_point_type, FND_API.g_miss_char, NULL, p_contact_point_type),
124: DECODE( p_contact_point_value, FND_API.g_miss_char, NULL, p_contact_point_value),
125: DECODE( p_city, FND_API.g_miss_char, NULL, p_city),

Line 122: DECODE( p_act_contact_used_by_id, FND_API.g_miss_num, NULL, p_act_contact_used_by_id),

118: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
119: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
120: px_object_version_number, -- object version_number is always 1 when created
121: DECODE( p_arc_contact_used_by, FND_API.g_miss_char, NULL, p_arc_contact_used_by),
122: DECODE( p_act_contact_used_by_id, FND_API.g_miss_num, NULL, p_act_contact_used_by_id),
123: DECODE( p_contact_point_type, FND_API.g_miss_char, NULL, p_contact_point_type),
124: DECODE( p_contact_point_value, FND_API.g_miss_char, NULL, p_contact_point_value),
125: DECODE( p_city, FND_API.g_miss_char, NULL, p_city),
126: DECODE( p_country, FND_API.g_miss_num, NULL, p_country),

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

119: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
120: px_object_version_number, -- object version_number is always 1 when created
121: DECODE( p_arc_contact_used_by, FND_API.g_miss_char, NULL, p_arc_contact_used_by),
122: DECODE( p_act_contact_used_by_id, FND_API.g_miss_num, NULL, p_act_contact_used_by_id),
123: DECODE( p_contact_point_type, FND_API.g_miss_char, NULL, p_contact_point_type),
124: DECODE( p_contact_point_value, FND_API.g_miss_char, NULL, p_contact_point_value),
125: DECODE( p_city, FND_API.g_miss_char, NULL, p_city),
126: DECODE( p_country, FND_API.g_miss_num, NULL, p_country),
127: DECODE( p_zipcode, FND_API.g_miss_char, NULL, p_zipcode),

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

120: px_object_version_number, -- object version_number is always 1 when created
121: DECODE( p_arc_contact_used_by, FND_API.g_miss_char, NULL, p_arc_contact_used_by),
122: DECODE( p_act_contact_used_by_id, FND_API.g_miss_num, NULL, p_act_contact_used_by_id),
123: DECODE( p_contact_point_type, FND_API.g_miss_char, NULL, p_contact_point_type),
124: DECODE( p_contact_point_value, FND_API.g_miss_char, NULL, p_contact_point_value),
125: DECODE( p_city, FND_API.g_miss_char, NULL, p_city),
126: DECODE( p_country, FND_API.g_miss_num, NULL, p_country),
127: DECODE( p_zipcode, FND_API.g_miss_char, NULL, p_zipcode),
128: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),

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

121: DECODE( p_arc_contact_used_by, FND_API.g_miss_char, NULL, p_arc_contact_used_by),
122: DECODE( p_act_contact_used_by_id, FND_API.g_miss_num, NULL, p_act_contact_used_by_id),
123: DECODE( p_contact_point_type, FND_API.g_miss_char, NULL, p_contact_point_type),
124: DECODE( p_contact_point_value, FND_API.g_miss_char, NULL, p_contact_point_value),
125: DECODE( p_city, FND_API.g_miss_char, NULL, p_city),
126: DECODE( p_country, FND_API.g_miss_num, NULL, p_country),
127: DECODE( p_zipcode, FND_API.g_miss_char, NULL, p_zipcode),
128: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
129: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),

Line 126: DECODE( p_country, FND_API.g_miss_num, NULL, p_country),

122: DECODE( p_act_contact_used_by_id, FND_API.g_miss_num, NULL, p_act_contact_used_by_id),
123: DECODE( p_contact_point_type, FND_API.g_miss_char, NULL, p_contact_point_type),
124: DECODE( p_contact_point_value, FND_API.g_miss_char, NULL, p_contact_point_value),
125: DECODE( p_city, FND_API.g_miss_char, NULL, p_city),
126: DECODE( p_country, FND_API.g_miss_num, NULL, p_country),
127: DECODE( p_zipcode, FND_API.g_miss_char, NULL, p_zipcode),
128: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
129: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
130: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),

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

123: DECODE( p_contact_point_type, FND_API.g_miss_char, NULL, p_contact_point_type),
124: DECODE( p_contact_point_value, FND_API.g_miss_char, NULL, p_contact_point_value),
125: DECODE( p_city, FND_API.g_miss_char, NULL, p_city),
126: DECODE( p_country, FND_API.g_miss_num, NULL, p_country),
127: DECODE( p_zipcode, FND_API.g_miss_char, NULL, p_zipcode),
128: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
129: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
130: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
131: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),

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

124: DECODE( p_contact_point_value, FND_API.g_miss_char, NULL, p_contact_point_value),
125: DECODE( p_city, FND_API.g_miss_char, NULL, p_city),
126: DECODE( p_country, FND_API.g_miss_num, NULL, p_country),
127: DECODE( p_zipcode, FND_API.g_miss_char, NULL, p_zipcode),
128: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
129: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
130: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
131: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
132: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),

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

125: DECODE( p_city, FND_API.g_miss_char, NULL, p_city),
126: DECODE( p_country, FND_API.g_miss_num, NULL, p_country),
127: DECODE( p_zipcode, FND_API.g_miss_char, NULL, p_zipcode),
128: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
129: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
130: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
131: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
132: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
133: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),

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

126: DECODE( p_country, FND_API.g_miss_num, NULL, p_country),
127: DECODE( p_zipcode, FND_API.g_miss_char, NULL, p_zipcode),
128: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
129: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
130: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
131: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
132: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
133: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
134: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),

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

127: DECODE( p_zipcode, FND_API.g_miss_char, NULL, p_zipcode),
128: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
129: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
130: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
131: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
132: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
133: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
134: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
135: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),

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

128: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
129: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
130: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
131: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
132: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
133: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
134: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
135: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
136: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),

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

129: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
130: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
131: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
132: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
133: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
134: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
135: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
136: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
137: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),

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

130: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
131: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
132: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
133: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
134: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
135: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
136: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
137: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
138: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),

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

131: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
132: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
133: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
134: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
135: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
136: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
137: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
138: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
139: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),

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

132: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
133: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
134: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
135: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
136: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
137: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
138: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
139: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
140: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),

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

133: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
134: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
135: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
136: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
137: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
138: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
139: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
140: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
141: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),

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

134: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
135: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
136: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
137: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
138: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
139: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
140: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
141: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
142: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),

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

135: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
136: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
137: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
138: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
139: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
140: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
141: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
142: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
143: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),

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

136: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
137: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
138: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
139: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
140: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
141: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
142: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
143: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
144: DECODE( p_contact_point_value_id, FND_API.g_miss_num, NULL, p_contact_point_value_id));

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

137: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
138: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
139: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
140: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
141: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
142: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
143: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
144: DECODE( p_contact_point_value_id, FND_API.g_miss_num, NULL, p_contact_point_value_id));
145: END Insert_Row;

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

138: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
139: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
140: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
141: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
142: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
143: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
144: DECODE( p_contact_point_value_id, FND_API.g_miss_num, NULL, p_contact_point_value_id));
145: END Insert_Row;
146:

Line 143: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),

139: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
140: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
141: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
142: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
143: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
144: DECODE( p_contact_point_value_id, FND_API.g_miss_num, NULL, p_contact_point_value_id));
145: END Insert_Row;
146:
147:

Line 144: DECODE( p_contact_point_value_id, FND_API.g_miss_num, NULL, p_contact_point_value_id));

140: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
141: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
142: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
143: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
144: DECODE( p_contact_point_value_id, FND_API.g_miss_num, NULL, p_contact_point_value_id));
145: END Insert_Row;
146:
147:
148: ----------------------------------------------------------

Line 201: contact_point_id = DECODE( p_contact_point_id, FND_API.g_miss_num, contact_point_id, p_contact_point_id),

197:
198:
199: Update AMS_ACT_CONTACT_POINTS
200: SET
201: contact_point_id = DECODE( p_contact_point_id, FND_API.g_miss_num, contact_point_id, p_contact_point_id),
202: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
203: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
204: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
205: object_version_number = object_version_number + 1, -- always increment the object version Number by 1

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

198:
199: Update AMS_ACT_CONTACT_POINTS
200: SET
201: contact_point_id = DECODE( p_contact_point_id, FND_API.g_miss_num, contact_point_id, p_contact_point_id),
202: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
203: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
204: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
205: object_version_number = object_version_number + 1, -- always increment the object version Number by 1
206: arc_contact_used_by = DECODE( p_arc_contact_used_by, FND_API.g_miss_char, arc_contact_used_by, p_arc_contact_used_by),

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

199: Update AMS_ACT_CONTACT_POINTS
200: SET
201: contact_point_id = DECODE( p_contact_point_id, FND_API.g_miss_num, contact_point_id, p_contact_point_id),
202: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
203: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
204: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
205: object_version_number = object_version_number + 1, -- always increment the object version Number by 1
206: arc_contact_used_by = DECODE( p_arc_contact_used_by, FND_API.g_miss_char, arc_contact_used_by, p_arc_contact_used_by),
207: act_contact_used_by_id = DECODE( p_act_contact_used_by_id, FND_API.g_miss_num, act_contact_used_by_id, p_act_contact_used_by_id),

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

200: SET
201: contact_point_id = DECODE( p_contact_point_id, FND_API.g_miss_num, contact_point_id, p_contact_point_id),
202: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
203: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
204: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
205: object_version_number = object_version_number + 1, -- always increment the object version Number by 1
206: arc_contact_used_by = DECODE( p_arc_contact_used_by, FND_API.g_miss_char, arc_contact_used_by, p_arc_contact_used_by),
207: act_contact_used_by_id = DECODE( p_act_contact_used_by_id, FND_API.g_miss_num, act_contact_used_by_id, p_act_contact_used_by_id),
208: contact_point_type = DECODE( p_contact_point_type, FND_API.g_miss_char, contact_point_type, p_contact_point_type),

Line 206: arc_contact_used_by = DECODE( p_arc_contact_used_by, FND_API.g_miss_char, arc_contact_used_by, p_arc_contact_used_by),

202: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
203: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
204: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
205: object_version_number = object_version_number + 1, -- always increment the object version Number by 1
206: arc_contact_used_by = DECODE( p_arc_contact_used_by, FND_API.g_miss_char, arc_contact_used_by, p_arc_contact_used_by),
207: act_contact_used_by_id = DECODE( p_act_contact_used_by_id, FND_API.g_miss_num, act_contact_used_by_id, p_act_contact_used_by_id),
208: contact_point_type = DECODE( p_contact_point_type, FND_API.g_miss_char, contact_point_type, p_contact_point_type),
209: contact_point_value = DECODE( p_contact_point_value, FND_API.g_miss_char, contact_point_value, p_contact_point_value),
210: city = DECODE( p_city, FND_API.g_miss_char, city, p_city),

Line 207: act_contact_used_by_id = DECODE( p_act_contact_used_by_id, FND_API.g_miss_num, act_contact_used_by_id, p_act_contact_used_by_id),

203: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
204: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
205: object_version_number = object_version_number + 1, -- always increment the object version Number by 1
206: arc_contact_used_by = DECODE( p_arc_contact_used_by, FND_API.g_miss_char, arc_contact_used_by, p_arc_contact_used_by),
207: act_contact_used_by_id = DECODE( p_act_contact_used_by_id, FND_API.g_miss_num, act_contact_used_by_id, p_act_contact_used_by_id),
208: contact_point_type = DECODE( p_contact_point_type, FND_API.g_miss_char, contact_point_type, p_contact_point_type),
209: contact_point_value = DECODE( p_contact_point_value, FND_API.g_miss_char, contact_point_value, p_contact_point_value),
210: city = DECODE( p_city, FND_API.g_miss_char, city, p_city),
211: country = DECODE( p_country, FND_API.g_miss_num, country, p_country),

Line 208: contact_point_type = DECODE( p_contact_point_type, FND_API.g_miss_char, contact_point_type, p_contact_point_type),

204: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
205: object_version_number = object_version_number + 1, -- always increment the object version Number by 1
206: arc_contact_used_by = DECODE( p_arc_contact_used_by, FND_API.g_miss_char, arc_contact_used_by, p_arc_contact_used_by),
207: act_contact_used_by_id = DECODE( p_act_contact_used_by_id, FND_API.g_miss_num, act_contact_used_by_id, p_act_contact_used_by_id),
208: contact_point_type = DECODE( p_contact_point_type, FND_API.g_miss_char, contact_point_type, p_contact_point_type),
209: contact_point_value = DECODE( p_contact_point_value, FND_API.g_miss_char, contact_point_value, p_contact_point_value),
210: city = DECODE( p_city, FND_API.g_miss_char, city, p_city),
211: country = DECODE( p_country, FND_API.g_miss_num, country, p_country),
212: zipcode = DECODE( p_zipcode, FND_API.g_miss_char, zipcode, p_zipcode),

Line 209: contact_point_value = DECODE( p_contact_point_value, FND_API.g_miss_char, contact_point_value, p_contact_point_value),

205: object_version_number = object_version_number + 1, -- always increment the object version Number by 1
206: arc_contact_used_by = DECODE( p_arc_contact_used_by, FND_API.g_miss_char, arc_contact_used_by, p_arc_contact_used_by),
207: act_contact_used_by_id = DECODE( p_act_contact_used_by_id, FND_API.g_miss_num, act_contact_used_by_id, p_act_contact_used_by_id),
208: contact_point_type = DECODE( p_contact_point_type, FND_API.g_miss_char, contact_point_type, p_contact_point_type),
209: contact_point_value = DECODE( p_contact_point_value, FND_API.g_miss_char, contact_point_value, p_contact_point_value),
210: city = DECODE( p_city, FND_API.g_miss_char, city, p_city),
211: country = DECODE( p_country, FND_API.g_miss_num, country, p_country),
212: zipcode = DECODE( p_zipcode, FND_API.g_miss_char, zipcode, p_zipcode),
213: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),

Line 210: city = DECODE( p_city, FND_API.g_miss_char, city, p_city),

206: arc_contact_used_by = DECODE( p_arc_contact_used_by, FND_API.g_miss_char, arc_contact_used_by, p_arc_contact_used_by),
207: act_contact_used_by_id = DECODE( p_act_contact_used_by_id, FND_API.g_miss_num, act_contact_used_by_id, p_act_contact_used_by_id),
208: contact_point_type = DECODE( p_contact_point_type, FND_API.g_miss_char, contact_point_type, p_contact_point_type),
209: contact_point_value = DECODE( p_contact_point_value, FND_API.g_miss_char, contact_point_value, p_contact_point_value),
210: city = DECODE( p_city, FND_API.g_miss_char, city, p_city),
211: country = DECODE( p_country, FND_API.g_miss_num, country, p_country),
212: zipcode = DECODE( p_zipcode, FND_API.g_miss_char, zipcode, p_zipcode),
213: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
214: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),

Line 211: country = DECODE( p_country, FND_API.g_miss_num, country, p_country),

207: act_contact_used_by_id = DECODE( p_act_contact_used_by_id, FND_API.g_miss_num, act_contact_used_by_id, p_act_contact_used_by_id),
208: contact_point_type = DECODE( p_contact_point_type, FND_API.g_miss_char, contact_point_type, p_contact_point_type),
209: contact_point_value = DECODE( p_contact_point_value, FND_API.g_miss_char, contact_point_value, p_contact_point_value),
210: city = DECODE( p_city, FND_API.g_miss_char, city, p_city),
211: country = DECODE( p_country, FND_API.g_miss_num, country, p_country),
212: zipcode = DECODE( p_zipcode, FND_API.g_miss_char, zipcode, p_zipcode),
213: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
214: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
215: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),

Line 212: zipcode = DECODE( p_zipcode, FND_API.g_miss_char, zipcode, p_zipcode),

208: contact_point_type = DECODE( p_contact_point_type, FND_API.g_miss_char, contact_point_type, p_contact_point_type),
209: contact_point_value = DECODE( p_contact_point_value, FND_API.g_miss_char, contact_point_value, p_contact_point_value),
210: city = DECODE( p_city, FND_API.g_miss_char, city, p_city),
211: country = DECODE( p_country, FND_API.g_miss_num, country, p_country),
212: zipcode = DECODE( p_zipcode, FND_API.g_miss_char, zipcode, p_zipcode),
213: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
214: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
215: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
216: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),

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

209: contact_point_value = DECODE( p_contact_point_value, FND_API.g_miss_char, contact_point_value, p_contact_point_value),
210: city = DECODE( p_city, FND_API.g_miss_char, city, p_city),
211: country = DECODE( p_country, FND_API.g_miss_num, country, p_country),
212: zipcode = DECODE( p_zipcode, FND_API.g_miss_char, zipcode, p_zipcode),
213: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
214: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
215: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
216: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
217: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),

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

210: city = DECODE( p_city, FND_API.g_miss_char, city, p_city),
211: country = DECODE( p_country, FND_API.g_miss_num, country, p_country),
212: zipcode = DECODE( p_zipcode, FND_API.g_miss_char, zipcode, p_zipcode),
213: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
214: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
215: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
216: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
217: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
218: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),

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

211: country = DECODE( p_country, FND_API.g_miss_num, country, p_country),
212: zipcode = DECODE( p_zipcode, FND_API.g_miss_char, zipcode, p_zipcode),
213: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
214: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
215: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
216: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
217: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
218: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
219: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),

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

212: zipcode = DECODE( p_zipcode, FND_API.g_miss_char, zipcode, p_zipcode),
213: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
214: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
215: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
216: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
217: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
218: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
219: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
220: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),

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

213: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
214: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
215: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
216: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
217: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
218: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
219: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
220: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
221: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),

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

214: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
215: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
216: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
217: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
218: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
219: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
220: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
221: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
222: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),

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

215: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
216: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
217: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
218: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
219: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
220: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
221: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
222: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
223: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),

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

216: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
217: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
218: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
219: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
220: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
221: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
222: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
223: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
224: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),

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

217: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
218: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
219: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
220: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
221: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
222: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
223: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
224: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
225: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),

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

218: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
219: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
220: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
221: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
222: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
223: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
224: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
225: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
226: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),

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

219: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
220: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
221: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
222: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
223: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
224: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
225: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
226: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
227: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),

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

220: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
221: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
222: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
223: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
224: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
225: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
226: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
227: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
228: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),

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

221: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
222: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
223: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
224: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
225: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
226: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
227: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
228: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),
229: contact_point_value_id = DECODE( p_contact_point_value_id, FND_API.g_miss_num, contact_point_value_id, p_contact_point_value_id)

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

222: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
223: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
224: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
225: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
226: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
227: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
228: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),
229: contact_point_value_id = DECODE( p_contact_point_value_id, FND_API.g_miss_num, contact_point_value_id, p_contact_point_value_id)
230: WHERE CONTACT_POINT_ID = p_CONTACT_POINT_ID

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

223: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
224: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
225: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
226: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
227: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
228: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),
229: contact_point_value_id = DECODE( p_contact_point_value_id, FND_API.g_miss_num, contact_point_value_id, p_contact_point_value_id)
230: WHERE CONTACT_POINT_ID = p_CONTACT_POINT_ID
231: AND object_version_number = p_object_version_number;

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

224: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
225: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
226: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
227: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
228: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),
229: contact_point_value_id = DECODE( p_contact_point_value_id, FND_API.g_miss_num, contact_point_value_id, p_contact_point_value_id)
230: WHERE CONTACT_POINT_ID = p_CONTACT_POINT_ID
231: AND object_version_number = p_object_version_number;
232:

Line 229: contact_point_value_id = DECODE( p_contact_point_value_id, FND_API.g_miss_num, contact_point_value_id, p_contact_point_value_id)

225: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
226: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
227: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
228: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),
229: contact_point_value_id = DECODE( p_contact_point_value_id, FND_API.g_miss_num, contact_point_value_id, p_contact_point_value_id)
230: WHERE CONTACT_POINT_ID = p_CONTACT_POINT_ID
231: AND object_version_number = p_object_version_number;
232:
233: IF (SQL%NOTFOUND) THEN

Line 234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

230: WHERE CONTACT_POINT_ID = p_CONTACT_POINT_ID
231: AND object_version_number = p_object_version_number;
232:
233: IF (SQL%NOTFOUND) THEN
234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
235: END IF;
236: END Update_Row;
237:
238:

Line 262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

258: BEGIN
259: DELETE FROM AMS_ACT_CONTACT_POINTS
260: WHERE CONTACT_POINT_ID = p_CONTACT_POINT_ID;
261: If (SQL%NOTFOUND) then
262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
263: End If;
264: END Delete_Row ;
265:
266: