eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_REGISTRANTS_PVT dependencies on HZ_CONTACT_POINTS

Line 206: SELECT 'Y' FROM hz_contact_points

202: AND location_id = x_location_id;
203: */
204: CURSOR phone_exists (party_id_in number, phone_number VARCHAR2, country_code in VARCHAR2, area_code in VARCHAR2,
205: extension in VARCHAR2 ) IS
206: SELECT 'Y' FROM hz_contact_points
207: WHERE contact_point_type = 'PHONE'
208: AND phone_line_type = 'GEN'
209: AND owner_table_name = 'HZ_PARTIES'
210: AND owner_table_id = party_id_in

Line 219: FROM hz_contact_points

215:
216:
217: CURSOR email_exists (email_address_in VARCHAR2) IS
218: SELECT owner_table_id
219: FROM hz_contact_points
220: WHERE contact_point_type = 'EMAIL'
221: AND owner_table_name = 'HZ_PARTIES'
222: AND upper(email_address) = upper(email_address_in);
223:

Line 438: SELECT 'Y' FROM hz_contact_points

434: WHERE party_id = x_party_rel_party_id
435: AND location_id = x_location_id;
436:
437: CURSOR phone_exists (x_hz_party_id number) IS
438: SELECT 'Y' FROM hz_contact_points
439: WHERE contact_point_type = 'PHONE'
440: AND phone_line_type = 'GEN'
441: AND owner_table_name = 'HZ_PARTIES'
442: AND owner_table_id = x_hz_party_id

Line 450: SELECT 'Y' FROM hz_contact_points

446: AND NVL(phone_extension,'x') = NVL(x_phone_extention,'x');
447:
448:
449: CURSOR email_exists (x_hz_party_id number) IS
450: SELECT 'Y' FROM hz_contact_points
451: WHERE contact_point_type = 'EMAIL'
452: AND owner_table_name = 'HZ_PARTIES'
453: AND owner_table_id = x_hz_party_id
454: AND email_address = x_email_address;

Line 1166: SELECT hz_contact_points_s.nextval into x_contact_point_id from dual;

1162:
1163: -- Create contact points Phone
1164:
1165: if x_phone_number is not NULL and x_party_rel_party_id is not null then
1166: SELECT hz_contact_points_s.nextval into x_contact_point_id from dual;
1167: x_return_status := null;
1168: x_msg_count := null;
1169: x_msg_data := null;
1170: cpoint_rec.contact_point_id := x_contact_point_id;

Line 1233: SELECT hz_contact_points_s.nextval into x_contact_point_id from dual;

1229:
1230: -- Create contact points Email
1231:
1232: if x_email_address is not NULL and x_party_rel_party_id is not null then
1233: SELECT hz_contact_points_s.nextval into x_contact_point_id from dual;
1234:
1235: x_return_status := null;
1236: x_msg_count := null;
1237: x_msg_data := null;

Line 1660: SELECT hz_contact_points_s.nextval into x_contact_point_id from dual;

1656: -- ***************************************************8
1657: -- Create contact points Phone
1658:
1659: if x_phone_number is not NULL and x_per_party_id is not null then
1660: SELECT hz_contact_points_s.nextval into x_contact_point_id from dual;
1661:
1662: x_return_status := null;
1663: x_msg_count := null;
1664: x_msg_data := null;

Line 1731: SELECT hz_contact_points_s.nextval into x_contact_point_id from dual;

1727:
1728: -- Create contact points Email
1729:
1730: if x_email_address is not NULL and x_per_party_id is not null then
1731: SELECT hz_contact_points_s.nextval into x_contact_point_id from dual;
1732:
1733: x_return_status := null;
1734: x_msg_count := null;
1735: x_msg_data := null;

Line 1843: from hz_contact_points cp,

1839: l_ret_status varchar(1);
1840:
1841: cursor c_email_address is
1842: select max(p.party_id)
1843: from hz_contact_points cp,
1844: hz_parties p
1845: where p.customer_key = l_party_key
1846: and p.party_type = 'PERSON'
1847: and cp.owner_table_id = p.party_id

Line 1854: from hz_contact_points cp,

1850: and cp.primary_flag = 'Y';
1851:
1852: cursor c_ph_number is
1853: select max(p.party_id)
1854: from hz_contact_points cp,
1855: hz_parties p
1856: where p.customer_key = l_party_key
1857: and p.party_type = 'PERSON'
1858: and cp.owner_table_id = p.party_id

Line 2176: hz_contact_points cpoint

2172: select max(per.party_id) from
2173: hz_parties org,
2174: hz_parties per,
2175: hz_relationships rel,
2176: hz_contact_points cpoint
2177: where org.party_id = p_org_party_id
2178: and org.party_type = 'ORGANIZATION'
2179: and rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2180: and rel.SUBJECT_TYPE = 'PERSON'

Line 2198: hz_contact_points cpoint,

2194: select max(per.party_id) from
2195: hz_parties org,
2196: hz_parties per,
2197: hz_relationships rel,
2198: hz_contact_points cpoint,
2199: hz_contact_points cpoint1
2200: where org.party_id = p_org_party_id
2201: and org.party_type = 'ORGANIZATION'
2202: and rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 2199: hz_contact_points cpoint1

2195: hz_parties org,
2196: hz_parties per,
2197: hz_relationships rel,
2198: hz_contact_points cpoint,
2199: hz_contact_points cpoint1
2200: where org.party_id = p_org_party_id
2201: and org.party_type = 'ORGANIZATION'
2202: and rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2203: and rel.SUBJECT_TYPE = 'PERSON'

Line 2228: hz_contact_points cpoint

2224: select max(per.party_id) from
2225: hz_parties org,
2226: hz_parties per,
2227: hz_relationships rel,
2228: hz_contact_points cpoint
2229: where org.party_id = p_org_party_id
2230: and org.party_type = 'ORGANIZATION'
2231: and rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2232: and rel.SUBJECT_TYPE = 'PERSON'