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_LOCATIONS

Line 23: p_v_country OUT NOCOPY hz_locations.country%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,
24: p_v_address1 OUT NOCOPY hz_locations.address1%type,
25: p_v_address2 OUT NOCOPY hz_locations.address2%type,
26: p_v_address3 OUT NOCOPY hz_locations.address3%type,
27: p_v_address4 OUT NOCOPY hz_locations.address4%type,

Line 24: p_v_address1 OUT NOCOPY hz_locations.address1%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,
24: p_v_address1 OUT NOCOPY hz_locations.address1%type,
25: p_v_address2 OUT NOCOPY hz_locations.address2%type,
26: p_v_address3 OUT NOCOPY hz_locations.address3%type,
27: p_v_address4 OUT NOCOPY hz_locations.address4%type,
28: p_v_city OUT NOCOPY hz_locations.city%type,

Line 25: p_v_address2 OUT NOCOPY hz_locations.address2%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,
24: p_v_address1 OUT NOCOPY hz_locations.address1%type,
25: p_v_address2 OUT NOCOPY hz_locations.address2%type,
26: p_v_address3 OUT NOCOPY hz_locations.address3%type,
27: p_v_address4 OUT NOCOPY hz_locations.address4%type,
28: p_v_city OUT NOCOPY hz_locations.city%type,
29: p_v_postal_code OUT NOCOPY hz_locations.postal_code%type,

Line 26: p_v_address3 OUT NOCOPY hz_locations.address3%type,

22: p_v_email_address OUT NOCOPY hz_parties.email_address%type,
23: p_v_country OUT NOCOPY hz_locations.country%type,
24: p_v_address1 OUT NOCOPY hz_locations.address1%type,
25: p_v_address2 OUT NOCOPY hz_locations.address2%type,
26: p_v_address3 OUT NOCOPY hz_locations.address3%type,
27: p_v_address4 OUT NOCOPY hz_locations.address4%type,
28: p_v_city OUT NOCOPY hz_locations.city%type,
29: p_v_postal_code OUT NOCOPY hz_locations.postal_code%type,
30: p_v_state OUT NOCOPY hz_locations.state%type,

Line 27: p_v_address4 OUT NOCOPY hz_locations.address4%type,

23: p_v_country OUT NOCOPY hz_locations.country%type,
24: p_v_address1 OUT NOCOPY hz_locations.address1%type,
25: p_v_address2 OUT NOCOPY hz_locations.address2%type,
26: p_v_address3 OUT NOCOPY hz_locations.address3%type,
27: p_v_address4 OUT NOCOPY hz_locations.address4%type,
28: p_v_city OUT NOCOPY hz_locations.city%type,
29: p_v_postal_code OUT NOCOPY hz_locations.postal_code%type,
30: p_v_state OUT NOCOPY hz_locations.state%type,
31: p_v_province OUT NOCOPY hz_locations.province%type,

Line 28: p_v_city OUT NOCOPY hz_locations.city%type,

24: p_v_address1 OUT NOCOPY hz_locations.address1%type,
25: p_v_address2 OUT NOCOPY hz_locations.address2%type,
26: p_v_address3 OUT NOCOPY hz_locations.address3%type,
27: p_v_address4 OUT NOCOPY hz_locations.address4%type,
28: p_v_city OUT NOCOPY hz_locations.city%type,
29: p_v_postal_code OUT NOCOPY hz_locations.postal_code%type,
30: p_v_state OUT NOCOPY hz_locations.state%type,
31: p_v_province OUT NOCOPY hz_locations.province%type,
32: p_v_county OUT NOCOPY hz_locations.county%type

Line 29: p_v_postal_code OUT NOCOPY hz_locations.postal_code%type,

25: p_v_address2 OUT NOCOPY hz_locations.address2%type,
26: p_v_address3 OUT NOCOPY hz_locations.address3%type,
27: p_v_address4 OUT NOCOPY hz_locations.address4%type,
28: p_v_city OUT NOCOPY hz_locations.city%type,
29: p_v_postal_code OUT NOCOPY hz_locations.postal_code%type,
30: p_v_state OUT NOCOPY hz_locations.state%type,
31: p_v_province OUT NOCOPY hz_locations.province%type,
32: p_v_county OUT NOCOPY hz_locations.county%type
33: ) as

Line 30: p_v_state OUT NOCOPY hz_locations.state%type,

26: p_v_address3 OUT NOCOPY hz_locations.address3%type,
27: p_v_address4 OUT NOCOPY hz_locations.address4%type,
28: p_v_city OUT NOCOPY hz_locations.city%type,
29: p_v_postal_code OUT NOCOPY hz_locations.postal_code%type,
30: p_v_state OUT NOCOPY hz_locations.state%type,
31: p_v_province OUT NOCOPY hz_locations.province%type,
32: p_v_county OUT NOCOPY hz_locations.county%type
33: ) as
34: /************************************************************************

Line 31: p_v_province OUT NOCOPY hz_locations.province%type,

27: p_v_address4 OUT NOCOPY hz_locations.address4%type,
28: p_v_city OUT NOCOPY hz_locations.city%type,
29: p_v_postal_code OUT NOCOPY hz_locations.postal_code%type,
30: p_v_state OUT NOCOPY hz_locations.state%type,
31: p_v_province OUT NOCOPY hz_locations.province%type,
32: p_v_county OUT NOCOPY hz_locations.county%type
33: ) as
34: /************************************************************************
35: Created By : Umesh Udayaprakash

Line 32: p_v_county OUT NOCOPY hz_locations.county%type

28: p_v_city OUT NOCOPY hz_locations.city%type,
29: p_v_postal_code OUT NOCOPY hz_locations.postal_code%type,
30: p_v_state OUT NOCOPY hz_locations.state%type,
31: p_v_province OUT NOCOPY hz_locations.province%type,
32: p_v_county OUT NOCOPY hz_locations.county%type
33: ) as
34: /************************************************************************
35: Created By : Umesh Udayaprakash
36: Date Created By : 1-May-2005

Line 53: CURSOR c_location_details (c_n_LOCATION_ID in HZ_LOCATIONS.LOCATION_ID%TYPE ) IS

49: SELECT party_name FROM
50: hz_parties
51: WHERE party_id = c_n_party_id;
52:
53: CURSOR c_location_details (c_n_LOCATION_ID in HZ_LOCATIONS.LOCATION_ID%TYPE ) IS
54: SELECT country,address1,address2,address3,address4,city,
55: postal_code,state,province,county
56: FROM hz_locations
57: WHERE location_id = c_n_LOCATION_ID;

Line 56: FROM hz_locations

52:
53: CURSOR c_location_details (c_n_LOCATION_ID in HZ_LOCATIONS.LOCATION_ID%TYPE ) IS
54: SELECT country,address1,address2,address3,address4,city,
55: postal_code,state,province,county
56: FROM hz_locations
57: WHERE location_id = c_n_LOCATION_ID;
58:
59: CURSOR c_name_mailid IS
60: SELECT hp_name.party_name, hp_email.email_address