APPS.HZ_CONTACT_POINTS_PKG dependencies on HZ_CONTACT_POINTS_S

Line 171: fnd_api.g_miss_num, hz_contact_points_s.NEXTVAL,

167: ACTUAL_CONTENT_SOURCE
168: )
169: VALUES (
170: DECODE(x_contact_point_id,
171: fnd_api.g_miss_num, hz_contact_points_s.NEXTVAL,
172: NULL, hz_contact_points_s.nextval,
173: x_contact_point_id),
174: DECODE(x_contact_point_type,
175: fnd_api.g_miss_char, NULL, x_contact_point_type),

Line 172: NULL, hz_contact_points_s.nextval,

168: )
169: VALUES (
170: DECODE(x_contact_point_id,
171: fnd_api.g_miss_num, hz_contact_points_s.NEXTVAL,
172: NULL, hz_contact_points_s.nextval,
173: x_contact_point_id),
174: DECODE(x_contact_point_type,
175: fnd_api.g_miss_char, NULL, x_contact_point_type),
176: DECODE(x_status, fnd_api.g_miss_char, 'A', NULL, 'A', x_status),

Line 185: hz_contact_points_s.CURRVAL)),

181: DECODE(x_primary_flag,
182: fnd_api.g_miss_char, 'N', NULL, 'N', x_primary_flag),
183: DECODE(x_orig_system_reference,
184: fnd_api.g_miss_char, TO_CHAR(NVL(x_contact_point_id,
185: hz_contact_points_s.CURRVAL)),
186: NULL, TO_CHAR(NVL(x_contact_point_id,
187: hz_contact_points_s.CURRVAL)),
188: x_orig_system_reference),
189: hz_utility_v2pub.last_update_date,

Line 187: hz_contact_points_s.CURRVAL)),

183: DECODE(x_orig_system_reference,
184: fnd_api.g_miss_char, TO_CHAR(NVL(x_contact_point_id,
185: hz_contact_points_s.CURRVAL)),
186: NULL, TO_CHAR(NVL(x_contact_point_id,
187: hz_contact_points_s.CURRVAL)),
188: x_orig_system_reference),
189: hz_utility_v2pub.last_update_date,
190: hz_utility_v2pub.last_updated_by,
191: hz_utility_v2pub.creation_date,

Line 315: SELECT hz_contact_points_s.NEXTVAL

311: l_count NUMBER;
312: l_dummy VARCHAR2(1);
313:
314: CURSOR c_idseq IS
315: SELECT hz_contact_points_s.NEXTVAL
316: FROM dual;
317: CURSOR c_cpchk IS
318: SELECT 'Y'
319: FROM hz_contact_points

Line 422: UPDATE hz_contact_points SET

418: ) IS
419:
420: BEGIN
421:
422: UPDATE hz_contact_points SET
423: contact_point_id = DECODE(x_contact_point_id,
424: NULL, contact_point_id,
425: fnd_api.g_miss_num, NULL,
426: x_contact_point_id),