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.IGS_FI_PRC_1098T_DATA dependencies on HZ_CONTACT_POINTS

Line 15: p_n_contact_point_id IN hz_contact_points.contact_point_id%type,

11: Who When What
12: *************************************************************************/
13: PROCEDURE contactdetails ( p_n_party_site_id IN hz_party_sites.party_site_id%type,
14: p_n_relationship_id IN hz_relationships.relationship_id%type,
15: p_n_contact_point_id IN hz_contact_points.contact_point_id%type,
16: p_v_phone_country_code OUT NOCOPY hz_contact_points.phone_country_code%type,
17: p_v_phone_area_code OUT NOCOPY hz_contact_points.phone_area_code%type,
18: p_v_phone_number OUT NOCOPY hz_contact_points.phone_number%type,
19: p_v_phone_extension OUT NOCOPY hz_contact_points.phone_extension%type,

Line 16: p_v_phone_country_code OUT NOCOPY hz_contact_points.phone_country_code%type,

12: *************************************************************************/
13: PROCEDURE contactdetails ( p_n_party_site_id IN hz_party_sites.party_site_id%type,
14: p_n_relationship_id IN hz_relationships.relationship_id%type,
15: p_n_contact_point_id IN hz_contact_points.contact_point_id%type,
16: p_v_phone_country_code OUT NOCOPY hz_contact_points.phone_country_code%type,
17: p_v_phone_area_code OUT NOCOPY hz_contact_points.phone_area_code%type,
18: p_v_phone_number OUT NOCOPY hz_contact_points.phone_number%type,
19: p_v_phone_extension OUT NOCOPY hz_contact_points.phone_extension%type,
20: p_v_con_party_name OUT NOCOPY hz_parties.party_name%type,

Line 17: p_v_phone_area_code OUT NOCOPY hz_contact_points.phone_area_code%type,

13: PROCEDURE contactdetails ( p_n_party_site_id IN hz_party_sites.party_site_id%type,
14: p_n_relationship_id IN hz_relationships.relationship_id%type,
15: p_n_contact_point_id IN hz_contact_points.contact_point_id%type,
16: p_v_phone_country_code OUT NOCOPY hz_contact_points.phone_country_code%type,
17: p_v_phone_area_code OUT NOCOPY hz_contact_points.phone_area_code%type,
18: p_v_phone_number OUT NOCOPY hz_contact_points.phone_number%type,
19: p_v_phone_extension OUT NOCOPY hz_contact_points.phone_extension%type,
20: p_v_con_party_name OUT NOCOPY hz_parties.party_name%type,
21: p_v_party_name OUT NOCOPY hz_parties.party_name%type,

Line 18: p_v_phone_number OUT NOCOPY hz_contact_points.phone_number%type,

14: p_n_relationship_id IN hz_relationships.relationship_id%type,
15: p_n_contact_point_id IN hz_contact_points.contact_point_id%type,
16: p_v_phone_country_code OUT NOCOPY hz_contact_points.phone_country_code%type,
17: p_v_phone_area_code OUT NOCOPY hz_contact_points.phone_area_code%type,
18: p_v_phone_number OUT NOCOPY hz_contact_points.phone_number%type,
19: p_v_phone_extension OUT NOCOPY hz_contact_points.phone_extension%type,
20: p_v_con_party_name OUT NOCOPY hz_parties.party_name%type,
21: p_v_party_name OUT NOCOPY hz_parties.party_name%type,
22: p_v_email_address OUT NOCOPY hz_parties.email_address%type,

Line 19: p_v_phone_extension OUT NOCOPY hz_contact_points.phone_extension%type,

15: p_n_contact_point_id IN hz_contact_points.contact_point_id%type,
16: p_v_phone_country_code OUT NOCOPY hz_contact_points.phone_country_code%type,
17: p_v_phone_area_code OUT NOCOPY hz_contact_points.phone_area_code%type,
18: p_v_phone_number OUT NOCOPY hz_contact_points.phone_number%type,
19: p_v_phone_extension OUT NOCOPY hz_contact_points.phone_extension%type,
20: p_v_con_party_name OUT NOCOPY hz_parties.party_name%type,
21: p_v_party_name OUT NOCOPY hz_parties.party_name%type,
22: p_v_email_address OUT NOCOPY hz_parties.email_address%type,
23: p_v_country OUT NOCOPY hz_locations.country%type,

Line 70: FROM hz_contact_points

66:
67:
68: CURSOR c_phone_details IS
69: SELECT phone_country_code, phone_area_code, phone_number,phone_extension
70: FROM hz_contact_points
71: WHERE contact_point_id = p_n_contact_point_id;
72: BEGIN
73:
74: OPEN c_party_loc_id(p_n_party_site_id);