APPS.POS_PROFILE_PKG dependencies on HZ_CONTACT_POINTS

Line 128: FROM hz_contact_points

124: l_date DATE;
125: BEGIN
126: SELECT last_update_date
127: INTO l_date
128: FROM hz_contact_points
129: WHERE contact_point_id = p_contact_id;
130: return l_date;
131: END get_update_date_from_contact;
132:

Line 144: FROM hz_contact_points hcp

140: l_count NUMBER;
141: BEGIN
142: SELECT count(contact_point_id)
143: INTO l_count
144: FROM hz_contact_points hcp
145: WHERE hcp.owner_table_name = owner_table_name
146: AND hcp.owner_table_id = p_party_id
147: AND hcp.contact_point_type = p_contact_point_type
148: AND hcp.phone_line_type = p_phone_line_type

Line 169: FROM hz_contact_points hcp

165: BEGIN
166: IF (p_contact_point_type='EMAIL') then
167: SELECT count(contact_point_id)
168: INTO l_count
169: FROM hz_contact_points hcp
170: WHERE hcp.owner_table_name = p_owner_table_name
171: AND hcp.owner_table_id = p_party_id
172: AND hcp.contact_point_type = p_contact_point_type
173: AND hcp.primary_flag = 'Y'

Line 178: FROM hz_contact_points hcp

174: AND hcp.status = 'A';
175: ELSE
176: SELECT count(contact_point_id)
177: INTO l_count
178: FROM hz_contact_points hcp
179: WHERE hcp.owner_table_name = p_owner_table_name
180: AND hcp.owner_table_id = p_party_id
181: AND hcp.contact_point_type = p_contact_point_type
182: AND hcp.web_type = p_web_type

Line 502: l_old_email HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;

498: profile_id NUMBER;
499: l_email VARCHAR2(2000);
500: l_update_date DATE;
501: l_object_version_number number;
502: l_old_email HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;
503: l_email_status varchar2(10);
504: BEGIN
505: --dbms_output.put_line (' In update party email .Start');
506: x_exception_msg := 'BEGIN: update_party_email';

Line 514: FROM hz_contact_points hcp

510:
511: IF (web_exist(p_party_id,p_party_type,'EMAIL',NULL)) then
512: SELECT hcp.contact_point_id, nvl(hcp.object_version_number,0), hcp.email_address
513: INTO l_contact_point_id, l_object_version_number,l_old_email
514: FROM hz_contact_points hcp
515: WHERE hcp.owner_table_name = p_party_type
516: AND hcp.owner_table_id = p_party_id
517: AND hcp.contact_point_type = 'EMAIL'
518: AND hcp.primary_flag = 'Y'

Line 604: l_old_number HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE;

600: profile_id NUMBER;
601: l_number VARCHAR2(40);
602: l_update_date DATE;
603: l_object_version_number number;
604: l_old_number HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE;
605: BEGIN
606: --dbms_output.put_line (' In update party phone.Start');
607: x_status := 'S';
608: x_exception_msg := 'BEGIN: update_party_phone';

Line 614: FROM hz_contact_points hcp

610: --fnd_client_info.set_org_context('-3113');
611: IF (phone_exist(p_party_id,p_party_type,'PHONE', 'GEN')) THEN
612: SELECT hcp.contact_point_id, nvl(hcp.object_version_number,0), hcp.phone_number
613: INTO l_contact_point_id, l_object_version_number, l_old_number
614: FROM hz_contact_points hcp
615: WHERE hcp.owner_table_name = p_party_type
616: AND hcp.owner_table_id = p_party_id
617: AND hcp.contact_point_type = 'PHONE'
618: AND hcp.phone_line_type = 'GEN'

Line 715: l_old_number HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE;

711: profile_id NUMBER;
712: l_number VARCHAR2(40);
713: l_update_date DATE;
714: l_object_version_number number;
715: l_old_number HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE;
716: BEGIN
717: --dbms_output.put_line (' In update party fax.start');
718: x_exception_msg := 'BEGIN: update_party_fax';
719: x_status := 'S';

Line 725: FROM hz_contact_points hcp

721: --fnd_client_info.set_org_context('-3113');
722: IF (phone_exist(p_party_id,p_party_type,'PHONE', 'FAX')) THEN
723: SELECT hcp.contact_point_id, nvl( hcp.object_version_number,0), hcp.phone_number
724: INTO l_contact_point_id, l_object_version_number, l_old_number
725: FROM hz_contact_points hcp
726: WHERE hcp.owner_table_name = p_party_type
727: AND hcp.owner_table_id = p_party_id
728: AND hcp.contact_point_type = 'PHONE'
729: AND hcp.phone_line_type = 'FAX'