DBA Data[Home] [Help]

PACKAGE: APPS.PER_EMPDIR_LEG_OVERRIDE

Source


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;