1 PACKAGE PER_EMPDIR_LEG_OVERRIDE AUTHID CURRENT_USER AS
2 /* $Header: peredlor.pkh 115.0 2003/08/03 01:17 smallina noship $ */
3
4
5 -- Global Variables
6 g_package CONSTANT Varchar2(30):='PER_EMPDIR_LEG_OVERRIDE';
7 g_people_override_flg BOOLEAN:= FALSE;
8 g_asg_override_flg BOOLEAN:= FALSE;
9 g_jobs_override_flg BOOLEAN:= FALSE;
10 g_orgs_override_flg BOOLEAN:= FALSE;
11 g_locations_override_flg BOOLEAN:= TRUE;
12 g_positions_override_flg BOOLEAN:= FALSE;
13
14 -- ---------------------------------------------------------------------------
15 -- ---------------------------- < isOverrideEnabled > ------------------------
16 -- ---------------------------------------------------------------------------
17 -- Purpose: This function is used for determining if override is enabled at
18 -- either legislation or customer level for the given p_entity
19 -- p_entity: {PEOPLE, ASSIGNMENTS, JOBS, ORGANIZATIONS, LOCATIONS, POSITIONS}
20 -- returns: TRUE if either leg or customer level orride is being enabled.
21 -- ---------------------------------------------------------------------------
22
23 FUNCTION isOverrideEnabled(
24 p_entity VARCHAR2
25 ) RETURN BOOLEAN;
26
27 -- ---------------------------------------------------------------------------
28 -- ---------------------------- < people > -----------------------------------
29 -- ---------------------------------------------------------------------------
30 -- Purpose: This procedure holds the legislation specific ovveride code
31 -- for people and branches to customer override if enabled.
32 -- errbuf, retcode are used for concurrent prg. logging
33 -- p_eff_date: Effective date of processing
34 -- p_cnt: Holds the # of rows in the collection at the point
35 -- p_srcSystem: Refrences the source system being processed.
36 -- ---------------------------------------------------------------------------
37
38 PROCEDURE people(
39 errbuf OUT NOCOPY VARCHAR2
40 ,retcode OUT NOCOPY VARCHAR2
41 ,p_eff_date IN DATE
42 ,p_cnt IN NUMBER
43 ,p_srcSystem IN VARCHAR2);
44
45 -- ---------------------------------------------------------------------------
46 -- ---------------------------- < asg > --------------------------------------
47 -- ---------------------------------------------------------------------------
48 -- Purpose: This procedure holds the legislation specific ovveride code
49 -- for assignments and branches to customer override if enabled.
50 -- errbuf, retcode are used for concurrent prg. logging
51 -- p_eff_date: Effective date of processing
52 -- p_cnt: Holds the # of rows in the collection at the point
53 -- p_srcSystem: Refrences the source system being processed.
54 -- ---------------------------------------------------------------------------
55
56 PROCEDURE asg(
57 errbuf OUT NOCOPY VARCHAR2
58 ,retcode OUT NOCOPY VARCHAR2
59 ,p_eff_date IN DATE
60 ,p_cnt IN NUMBER
61 ,p_srcSystem IN VARCHAR2);
62
63 -- ---------------------------------------------------------------------------
64 -- ---------------------------- < jobs > -------------------------------------
65 -- ---------------------------------------------------------------------------
66 -- Purpose: This procedure holds the legislation specific ovveride code
67 -- for jobs and branches to customer override if enabled.
68 -- errbuf, retcode are used for concurrent prg. logging
69 -- p_eff_date: Effective date of processing
70 -- p_cnt: Holds the # of rows in the collection at the point
71 -- p_srcSystem: Refrences the source system being processed.
72 -- ---------------------------------------------------------------------------
73
74 PROCEDURE jobs(
75 errbuf OUT NOCOPY VARCHAR2
76 ,retcode OUT NOCOPY VARCHAR2
77 ,p_eff_date IN DATE
78 ,p_cnt IN NUMBER
79 ,p_srcSystem IN VARCHAR2);
80
81 -- ---------------------------------------------------------------------------
82 -- ---------------------------- < orgs > -------------------------------------
83 -- ---------------------------------------------------------------------------
84 -- Purpose: This procedure holds the legislation specific ovveride code
85 -- for orgs and branches to customer override if enabled.
86 -- errbuf, retcode are used for concurrent prg. logging
87 -- p_eff_date: Effective date of processing
88 -- p_cnt: Holds the # of rows in the collection at the point
89 -- p_srcSystem: Refrences the source system being processed.
90 -- ---------------------------------------------------------------------------
91
92 PROCEDURE orgs(
93 errbuf OUT NOCOPY VARCHAR2
94 ,retcode OUT NOCOPY VARCHAR2
95 ,p_eff_date IN DATE
96 ,p_cnt IN NUMBER
97 ,p_srcSystem IN VARCHAR2);
98
99 -- ---------------------------------------------------------------------------
100 -- ---------------------------- < locations > --------------------------------
101 -- ---------------------------------------------------------------------------
102 -- Purpose: This procedure holds the legislation specific ovveride code
103 -- for locations and branches to customer override if enabled.
104 -- errbuf, retcode are used for concurrent prg. logging
105 -- p_eff_date: Effective date of processing
106 -- p_cnt: Holds the # of rows in the collection at the point
107 -- p_srcSystem: Refrences the source system being processed.
108 -- ---------------------------------------------------------------------------
109
110 PROCEDURE locations(
111 errbuf OUT NOCOPY VARCHAR2
112 ,retcode OUT NOCOPY VARCHAR2
113 ,p_eff_date IN DATE
114 ,p_cnt IN NUMBER
115 ,p_srcSystem IN VARCHAR2);
116
117 -- ---------------------------------------------------------------------------
118 -- ---------------------------- < positions > --------------------------------
119 -- ---------------------------------------------------------------------------
120 -- Purpose: This procedure holds the legislation specific ovveride code
121 -- for positions and branches to customer override if enabled.
122 -- errbuf, retcode are used for concurrent prg. logging
123 -- p_eff_date: Effective date of processing
124 -- p_cnt: Holds the # of rows in the collection at the point
125 -- p_srcSystem: Refrences the source system being processed.
126 -- ---------------------------------------------------------------------------
127
128 PROCEDURE positions(
129 errbuf OUT NOCOPY VARCHAR2
130 ,retcode OUT NOCOPY VARCHAR2
131 ,p_eff_date IN DATE
132 ,p_cnt IN NUMBER
133 ,p_srcSystem IN VARCHAR2);
134
135 END per_empdir_leg_override;