1 PACKAGE igs_fi_prc_1098t_data AS
2 /* $Header: IGSFI92S.pls 120.0 2005/09/09 19:18:49 appldev noship $ */
3 /************************************************************************
4 Created By : Umesh Udayaprakash
5 Date Created By : 1-May-2005
6 Purpose : Package Used in 1098t pdf file generation and EFT file generation
7 java concurrent program.
8
9 Known limitations,enhancements,remarks:
10 Change History
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,
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,
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 );
34 END igs_fi_prc_1098t_data;
[Home] [Help]