1 PACKAGE per_in_add_leg_hook as
2 /* $Header: peinlhad.pkh 120.1.12010000.1 2008/07/28 04:52:04 appldev ship $ */
3 --
4
5 --
6 -- declare types needed globally
7 --
8
9
10 TYPE r_pin_code IS RECORD(state_code hr_lookups.lookup_code%TYPE,
11 pin_code hr_lookups.meaning%TYPE);
12 TYPE t_pin_code IS TABLE OF r_pin_code INDEX BY BINARY_INTEGER;
13 tab_pin_code t_pin_code;
14
15
16
17
18
19 --------------------------------------------------------------------------
20 -- --
21 -- Name : CHECK_PER_ADDRESS_INS --
22 -- Type : Procedure --
23 -- Access : Public --
24 -- Description : Procedure is the driver procedure for the validation--
25 -- of the address of a person. --
26 -- This is the hook procedure for the --
27 -- address when personal address is inserted. --
28 -- Parameters : --
29 -- IN : p_style IN VARCHAR2 --
30 -- p_address_id IN VARCHAR2 --
31 -- p_add_information14 IN VARCHAR2 --
32 -- p_add_information15 IN VARCHAR2 --
33 -- p_postal_code IN VARCHAR2 --
34 ---------------------------------------------------------------------------
35
36 PROCEDURE check_per_address_ins(p_style IN VARCHAR2
37 ,p_address_id IN NUMBER
38 ,p_add_information14 IN VARCHAR2
39 ,p_add_information15 IN VARCHAR2 -- State
40 ,p_postal_code IN VARCHAR2);
41
42 ---------------------------------------------------------------------------
43 -- --
44 -- Name : CHECK_LOC_ADDRESS_INS --
45 -- Type : Procedure --
46 -- Access : Public --
47 -- Description : Procedure is the driver procedure for the validation--
48 -- of the address of a location. --
49 -- This is the hook procedure for the address --
50 -- when a location address is inserted. --
51 -- Parameters : --
52 -- IN : p_style IN VARCHAR2 --
53 -- p_loc_information16 IN VARCHAR2 --
54 -- p_postal_code IN VARCHAR2 --
55 ---------------------------------------------------------------------------
56
57 PROCEDURE check_loc_address_ins(p_style IN VARCHAR2
58 ,p_loc_information16 IN VARCHAR2 -- State
59 ,p_postal_code IN VARCHAR2);
60
61
62 --------------------------------------------------------------------------
63 -- --
64 -- Name : CHECK_PER_ADDRESS_UPD --
65 -- Type : Procedure --
66 -- Access : Public --
67 -- Description : Procedure is the driver procedure for the validation--
68 -- of the address of a location. --
69 -- This is the hook procedure for the address when --
70 -- personal address is updated. --
71 -- Parameters : --
72 -- IN : p_address_id IN NUMBER --
73 -- p_add_information14 IN VARCHAR2 --
74 -- p_add_information15 IN VARCHAR2 --
75 -- p_postal_code IN VARCHAR2 --
76 -- --
77 ----------------------------------------------------------------------------
78
79 PROCEDURE check_per_address_upd(p_address_id IN NUMBER
80 ,p_add_information14 IN VARCHAR2
81 ,p_add_information15 IN VARCHAR2
82 ,p_postal_code IN VARCHAR2);
83 ---------------------------------------------------------------------------
84 -- --
85 -- Name : CHECK_LOC_ADDRESS_UPD --
86 -- Type : Procedure --
87 -- Access : Public --
88 -- Description : Procedure is the driver procedure for the validation--
89 -- of address of a location. --
90 -- This procedure is the hook procedure for the address--
91 -- when location address is updated. --
92 -- Parameters : --
93 -- IN : p_location_id IN NUMBER --
94 -- p_loc_information16 IN VARCHAR2 --
95 -- p_postal_code IN VARCHAR2 --
96 -- --
97
98 --------------------------------------------------------------------------
99 PROCEDURE check_loc_address_upd(p_location_id IN NUMBER
100 ,p_loc_information16 IN VARCHAR2 -- State
101 ,p_postal_code IN VARCHAR2);
102
103 END per_in_add_leg_hook;