APPS.PO_HR_LOCATION dependencies on HR_LOCATIONS

Line 61: x_town_or_city OUT NOCOPY HR_LOCATIONS.town_or_city%type ,

57: x_location_name OUT NOCOPY Varchar2,
58: x_contact_phone OUT NOCOPY Varchar2,
59: x_contact_fax OUT NOCOPY Varchar2,
60: x_address_line_4 OUT NOCOPY Varchar2,
61: x_town_or_city OUT NOCOPY HR_LOCATIONS.town_or_city%type ,
62: x_postal_code OUT NOCOPY HR_LOCATIONS.postal_code%type,
63: x_state_or_province OUT NOCOPY varchar2 );
64:
65: --Bug#3580225 Start --

Line 62: x_postal_code OUT NOCOPY HR_LOCATIONS.postal_code%type,

58: x_contact_phone OUT NOCOPY Varchar2,
59: x_contact_fax OUT NOCOPY Varchar2,
60: x_address_line_4 OUT NOCOPY Varchar2,
61: x_town_or_city OUT NOCOPY HR_LOCATIONS.town_or_city%type ,
62: x_postal_code OUT NOCOPY HR_LOCATIONS.postal_code%type,
63: x_state_or_province OUT NOCOPY varchar2 );
64:
65: --Bug#3580225 Start --
66: /************************************************************************************

Line 71: HR_LOCATIONS and HZ_LOCATIONS. The fields used in HR_LOCATIONS table is

67: NAME: get_alladdress_lines
68:
69: Description : This procedure has the same code as that of over loaded procedure of
70: get_address and the code to retrieve all the address details from
71: HR_LOCATIONS and HZ_LOCATIONS. The fields used in HR_LOCATIONS table is
72: retreived using fnd_dflex package and for HZ_LOCATIONS,
73: HZ_FORMAT_PUB.FORMAT_ADDRESS procedure is used.
74:
75: Referenced by :

Line 92: x_town_or_city OUT NOCOPY HR_LOCATIONS.town_or_city%type ,

88: x_location_name OUT NOCOPY Varchar2,
89: x_contact_phone OUT NOCOPY Varchar2,
90: x_contact_fax OUT NOCOPY Varchar2,
91: x_address_line_4 OUT NOCOPY Varchar2,
92: x_town_or_city OUT NOCOPY HR_LOCATIONS.town_or_city%type ,
93: x_postal_code OUT NOCOPY HR_LOCATIONS.postal_code%type,
94: x_state_or_province OUT NOCOPY varchar2 );
95:
96:

Line 93: x_postal_code OUT NOCOPY HR_LOCATIONS.postal_code%type,

89: x_contact_phone OUT NOCOPY Varchar2,
90: x_contact_fax OUT NOCOPY Varchar2,
91: x_address_line_4 OUT NOCOPY Varchar2,
92: x_town_or_city OUT NOCOPY HR_LOCATIONS.town_or_city%type ,
93: x_postal_code OUT NOCOPY HR_LOCATIONS.postal_code%type,
94: x_state_or_province OUT NOCOPY varchar2 );
95:
96:
97: /************************************************************************************

Line 134: TYPE addr_prompt_query_rec IS RECORD(address_style hr_locations.style%type,

130: PLS-00507: a PLSQL Table may not contain a table or a record with composite
131: fields when compliled in 8i data base. Replaced the array list l_addr_prompts_array
132: with 20 varibales which holds the prompt names.
133: *******************************************************************************/
134: TYPE addr_prompt_query_rec IS RECORD(address_style hr_locations.style%type,
135: addr_label_1 varchar2(240),
136: addr_label_2 varchar2(240),
137: addr_label_3 varchar2(240),
138: addr_label_4 varchar2(240),