[Home] [Help]
PACKAGE: APPS.PER_CN_ADD_LEG_HOOK
Source
1 PACKAGE per_cn_add_leg_hook AS
2 /* $Header: pecnlhpa.pkh 120.0 2005/05/31 06:54:07 appldev noship $ */
3 --
4 g_package VARCHAR2(33) := 'per_cn_add_leg_hook.';
5
6 --------------------------------------------------------------------------
7 -- Name : CHECK_ADDRESS --
8 -- Type : Procedure --
9 -- Access : Public --
10 -- Description : Procedure is the driver procedure for the validation--
11 -- of the address. --
12 -- This procedure is the hook procedure for the --
13 -- address. --
14 -- Parameters : --
15 -- IN : p_address_line1 IN VARCHAR2 --
16 -- p_town_or_city IN VARCHAR2 --
17 -- p_country IN VARCHAR2 --
18 -- p_postal_code IN VARCHAR2 --
19 -- --
20 -- Change History : --
21 --------------------------------------------------------------------------
22 -- Rev# Date Userid Description --
23 --------------------------------------------------------------------------
24 -- 1.0 29/11/02 saikrish Created this procedure --
25 -- 1.1 10/04/03 statkar Nulled out this procedure - 2893334 --
26 --------------------------------------------------------------------------
27 PROCEDURE check_address(p_address_line1 IN VARCHAR2
28 ,p_town_or_city IN VARCHAR2
29 ,p_country IN VARCHAR2
30 ,p_postal_code IN VARCHAR2);
31
32 --------------------------------------------------------------------------
33 -- --
34 -- Name : CHECK_ADDRESS_INS --
35 -- Type : Procedure --
36 -- Access : Public --
37 -- Description : Procedure is the driver procedure for the validation--
38 -- of the applicant. --
39 -- This procedure is the hook procedure for the --
40 -- address when address in inserted. --
41 -- Parameters : --
42 -- IN : p_style IN VARCHAR2 --
43 -- p_address_line1 IN VARCHAR2 --
44 -- p_town_or_city IN VARCHAR2 --
45 -- p_country IN VARCHAR2 --
46 -- p_postal_code IN VARCHAR2 --
47 -- --
48 -- Change History : --
49 --------------------------------------------------------------------------
50 -- Rev# Date Userid Description --
51 --------------------------------------------------------------------------
52 -- 1.0 29/11/02 saikrish Created this procedure --
53 -- 1.1 9/4/2003 bramajey Changed name from CHECK_ADDRESS to --
54 -- CHECK_ADDRESS_INS and included 1 more --
55 -- parameter p_style --
56 --------------------------------------------------------------------------
57 PROCEDURE check_address_ins(p_style IN VARCHAR2
58 ,p_address_line1 IN VARCHAR2
59 ,p_town_or_city IN VARCHAR2
60 ,p_country IN VARCHAR2
61 ,p_postal_code IN VARCHAR2);
62
63 --------------------------------------------------------------------------
64 -- --
65 -- Name : CHECK_ADDRESS_UPD --
66 -- Type : Procedure --
67 -- Access : Public --
68 -- Description : Procedure is the driver procedure for the validation--
69 -- of the applicant. --
70 -- This procedure is the hook procedure for the --
71 -- address when address in updated. --
72 -- Parameters : --
73 -- IN : p_address_id IN NUMBER --
74 -- p_address_line1 IN VARCHAR2 --
75 -- p_town_or_city IN VARCHAR2 --
76 -- p_country IN VARCHAR2 --
77 -- p_postal_code IN VARCHAR2 --
78 -- --
79 -- Change History : --
80 --------------------------------------------------------------------------
81 -- Rev# Date Userid Description --
82 --------------------------------------------------------------------------
83 -- 1.0 9/4/2003 bramajey Created this procedure --
84 -- 1.1 14/01/04 sshankar Added parameter 'address_id'.(Bug 3371417)--
85 --------------------------------------------------------------------------
86 PROCEDURE check_address_upd
87 (p_address_id IN NUMBER
88 ,p_address_line1 IN VARCHAR2
89 ,p_town_or_city IN VARCHAR2
90 ,p_country IN VARCHAR2
91 ,p_postal_code IN VARCHAR2);
92
93 END per_cn_add_leg_hook;