[Home] [Help]
PACKAGE: APPS.HR_BPL_ALERT_ADDRESS
Source
1 PACKAGE HR_BPL_ALERT_ADDRESS AUTHID CURRENT_USER AS
2 /* $Header: perbaadr.pkh 115.1 2003/06/03 17:04:50 akmistry noship $ */
3 --
4 -- -------------------------------------------------------------------------
5 -- globals variables
6 -- -------------------------------------------------------------------------
7 g_person_id NUMBER;
8 g_addr_address_style VARCHAR2(240);
9 g_addr_address_line1 VARCHAR2(240);
10 g_addr_address_line2 VARCHAR2(240);
11 g_addr_address_line3 VARCHAR2(240);
12 g_addr_address_type VARCHAR2(30);
13 g_addr_country VARCHAR2(60);
14 g_addr_postal_code VARCHAR2(30);
15 g_addr_region_1 VARCHAR2(120);
16 g_addr_region_2 VARCHAR2(120);
17 g_addr_region_3 VARCHAR2(120);
18 g_addr_town_or_city VARCHAR2(30);
19 g_addr_add_information13 VARCHAR2(150);
20 g_addr_add_information14 VARCHAR2(150);
21 g_addr_add_information15 VARCHAR2(150);
22 g_addr_add_information16 VARCHAR2(150);
23 g_addr_add_information17 VARCHAR2(150);
24 g_addr_add_information18 VARCHAR2(150);
25 g_addr_add_information19 VARCHAR2(150);
26 g_addr_add_information20 VARCHAR2(150);
27 g_addr_address VARCHAR2(1000);
28 g_addr_col_name VARCHAR2(120);
29 --
30 -- -------------------------------------------------------------------------
31 -- globals variables (get_psn_emrg_contacts)
32 -- -------------------------------------------------------------------------
33 g_emrg_person_id NUMBER := NUll;
34 g_emrg_contacts VARCHAR2(2000) := NULL;
35 g_emrg_full_name VARCHAR2(240) := NULL;
36 g_emrg_phone_number VARCHAR2(60) := NULL;
37 g_emrg_phone_type VARCHAR2(30) := NULL;
38 --
39 -- -------------------------------------------------------------------------
40 -- functions
41 -- -------------------------------------------------------------------------
42 --
43 FUNCTION get_psn_addrss(p_person_id IN NUMBER) RETURN VARCHAR2;
44 --
45 FUNCTION get_psn_emrg_contacts(p_person_id IN NUMBER) RETURN VARCHAR2;
46 --
47 END HR_BPL_ALERT_ADDRESS;