APPS.ARH_PHON_PKG dependencies on HZ_CONTACT_POINTS

Line 120: FROM HZ_CONTACT_POINTS

116: SELECT ROWID,
117: OBJECT_VERSION_NUMBER,
118: LAST_UPDATE_DATE,
119: NULL
120: FROM HZ_CONTACT_POINTS
121: WHERE CONTACT_POINT_ID = p_col_id;
122:
123: l_last_update_date DATE;
124:

Line 126: IF p_table_name = 'HZ_CONTACT_POINTS' THEN

122:
123: l_last_update_date DATE;
124:
125: BEGIN
126: IF p_table_name = 'HZ_CONTACT_POINTS' THEN
127: OPEN cu_contact_point_version;
128: FETCH cu_contact_point_version INTO
129: x_rowid ,
130: x_object_version_number,

Line 215: from hz_contact_points cont_point,

211: if (p_type = 'CUST') then
212:
213: select count(1)
214: into primary_count
215: from hz_contact_points cont_point,
216: hz_cust_account_roles car
217: where car.party_id = cont_point.owner_table_id
218: and cont_point.owner_table_name = 'HZ_PARTIES'
219: and cont_point.contact_point_type not

Line 237: from hz_contact_points cont_point,

233: elsif (p_type = 'ADDR' ) then
234: --
235: select count(1)
236: into primary_count
237: from hz_contact_points cont_point,
238: hz_cust_account_roles car
239: where car.party_id = cont_point.owner_table_id
240: and cont_point.owner_table_name = 'HZ_PARTIES'
241: and cont_point.contact_point_type not

Line 257: from hz_contact_points cont_point,

253: elsif (p_type = 'CONT' ) then
254: --
255: select count(1)
256: into primary_count
257: from hz_contact_points cont_point,
258: hz_cust_account_roles car
259: where car.party_id = cont_point.owner_table_id
260: and cont_point.owner_table_name = 'HZ_PARTIES'
261: and cont_point.contact_point_type not

Line 399: SELECT hz_contact_points_s.nextval

395:
396: l_count := 1;
397:
398: while l_count > 0 loop
399: SELECT hz_contact_points_s.nextval
400: INTO x_phone_id
401: FROM dual;
402:
403: select count(*) into l_count from hz_contact_points

Line 403: select count(*) into l_count from hz_contact_points

399: SELECT hz_contact_points_s.nextval
400: INTO x_phone_id
401: FROM dual;
402:
403: select count(*) into l_count from hz_contact_points
404: where contact_point_id = x_phone_id ;
405:
406: END LOOP;
407: --

Line 632: (p_table_name => 'HZ_CONTACT_POINTS',

628: END IF;
629: l_object_version := x_object_version;
630: IF l_object_version = -1 THEN
631: object_version_select
632: (p_table_name => 'HZ_CONTACT_POINTS',
633: p_col_id => x_phone_Id,
634: x_rowid => l_rowid,
635: x_object_version_number => l_object_version,
636: x_last_update_date => l_update_date,

Line 674: from hz_contact_points

670: select last_update_date,
671: object_version_number
672: into X_Last_Update_Date,
673: x_object_version
674: from hz_contact_points
675: where contact_point_id = X_Phone_Id;
676: END IF;
677:
678: IF x_msg_count > 1 THEN

Line 1011: DELETE FROM hz_contact_points

1007:
1008: PROCEDURE Delete_Row(X_phoneid VARCHAR2) IS
1009: BEGIN
1010:
1011: DELETE FROM hz_contact_points
1012: WHERE contact_point_id = X_phoneid;
1013: if (SQL%NOTFOUND) then
1014: Raise NO_DATA_FOUND;
1015: end if;