[Home] [Help]
PACKAGE: APPS.PER_CN_ASG_LEG_HOOK
Source
1 PACKAGE per_cn_asg_leg_hook AUTHID CURRENT_USER AS
2 /* $Header: pecnlhas.pkh 120.0 2005/05/31 06:52:04 appldev noship $ */
3 --
4 g_package VARCHAR2(33);
5
6 --------------------------------------------------------------------------
7 -- --
8 -- Name : CHECK_EMP_ASG_UPDATE --
9 -- Type : Procedure --
10 -- Access : Public --
11 -- Description : Procedure is the driver procedure for the validation--
12 -- of the assignment. --
13 -- This procedure is the hook procedure for update --
14 -- employee assignment. --
15 -- Parameters : --
16 -- IN : p_segment1 IN VARCHAR2 --
17 -- p_segment20 IN VARCHAR2 --
18 -- p_segment21 IN VARCHAR2 --
19 -- p_segment22 IN VARCHAR2 --
20 -- p_segment23 IN VARCHAR2 --
21 -- p_effective_date IN DATE --
22 -- p_assignment_id IN NUMBER --
23 -- --
24 -- Change History : --
25 --------------------------------------------------------------------------
26 -- Rev# Date Userid Description --
27 --------------------------------------------------------------------------
28 -- 1.0 19/12/02 Vikram.N Created this procedure --
29 -- 1.1 18/08/04 snekkala Added p_segment22 and p_segment23 --
30 --------------------------------------------------------------------------
31
32 PROCEDURE check_emp_asg_update(p_segment1 IN VARCHAR2
33 ,P_segment20 IN VARCHAR2
34 ,p_segment21 IN VARCHAR2
35 ,p_segment22 IN VARCHAR2
36 ,p_segment23 IN VARCHAR2
37 ,p_effective_date IN DATE
38 ,p_assignment_id IN NUMBER );
39
40
41
42 --------------------------------------------------------------------------
43 -- --
44 -- Name : CHECK_EMP_ASG_CREATE --
45 -- Type : Procedure --
46 -- Access : Public --
47 -- Description : Procedure is the driver procedure for the validation--
48 -- of the assignment. --
49 -- This procedure is the hook procedure for create --
50 -- secondary employee assignment. --
51 -- Parameters : --
52 -- IN : p_scl_segment1 IN VARCHAR2 --
53 -- p_scl_segment20 IN VARCHAR2 --
54 -- p_scl_segment21 IN VARCHAR2 --
55 -- p_scl_segment22 IN VARCHAR2 --
56 -- p_scl_segment23 IN VARCHAR2 --
57 -- p_effective_date IN DATE --
58 -- p_person_id IN NUMBER --
59 -- --
60 -- Change History : --
61 --------------------------------------------------------------------------
62 -- Rev# Date Userid Description --
63 --------------------------------------------------------------------------
64 -- 1.0 19/12/02 Vikram.N Created this procedure --
65 -- 1.1 18/08/04 snekkala Added p_scl_segment22 and p_scl_segment23 --
66 --------------------------------------------------------------------------
67 PROCEDURE check_emp_asg_create(p_scl_segment1 IN VARCHAR2
68 ,P_scl_segment20 IN VARCHAR2
69 ,p_scl_segment21 IN VARCHAR2
70 ,p_scl_segment22 IN VARCHAR2
71 ,p_scl_segment23 IN VARCHAR2
72 ,p_effective_date IN DATE
73 ,p_person_id IN NUMBER );
74
75
76
77
78 END per_cn_asg_leg_hook;