DBA Data[Home] [Help]

PACKAGE: APPS.PER_POSITIONS_PKG

Source


1 PACKAGE PER_POSITIONS_PKG as
2 /* $Header: pepos01t.pkh 120.0 2005/05/31 14:51:40 appldev noship $ */
3 function exists_in_hierarchy(X_Pos_Structure_Version_Id NUMBER,
4 			     X_Position_Id NUMBER) return VARCHAR2;
5 
6 PROCEDURE Insert_Row(X_Rowid                         IN OUT NOCOPY VARCHAR2,
7                      X_Position_Id                   IN OUT NOCOPY NUMBER,
8                      X_Business_Group_Id                    NUMBER,
9                      X_Job_Id                               NUMBER,
10                      X_Organization_Id                      NUMBER,
11                      X_Successor_Position_Id                NUMBER,
12                      X_Relief_Position_Id                   NUMBER,
13                      X_Location_Id                          NUMBER,
14                      X_Position_Definition_Id               NUMBER,
15                      X_Date_Effective                       DATE,
16                      X_Comments                             VARCHAR2,
17                      X_Date_End                             DATE,
18                      X_Frequency                            VARCHAR2,
19                      X_Name                                 VARCHAR2,
20                      X_Probation_Period                     NUMBER,
21                      X_Probation_Period_Units               VARCHAR2,
22                      X_Replacement_Required_Flag            VARCHAR2,
23                      X_Time_Normal_Finish                   VARCHAR2,
24                      X_Time_Normal_Start                    VARCHAR2,
25                      X_Working_Hours                        NUMBER,
26                      X_Status                               VARCHAR2,
27                      X_Attribute_Category                   VARCHAR2,
28                      X_Attribute1                           VARCHAR2,
29                      X_Attribute2                           VARCHAR2,
30                      X_Attribute3                           VARCHAR2,
31                      X_Attribute4                           VARCHAR2,
32                      X_Attribute5                           VARCHAR2,
33                      X_Attribute6                           VARCHAR2,
34                      X_Attribute7                           VARCHAR2,
35                      X_Attribute8                           VARCHAR2,
36                      X_Attribute9                           VARCHAR2,
37                      X_Attribute10                          VARCHAR2,
38                      X_Attribute11                          VARCHAR2,
39                      X_Attribute12                          VARCHAR2,
40                      X_Attribute13                          VARCHAR2,
41                      X_Attribute14                          VARCHAR2,
42                      X_Attribute15                          VARCHAR2,
43                      X_Attribute16                          VARCHAR2,
44                      X_Attribute17                          VARCHAR2,
45                      X_Attribute18                          VARCHAR2,
46                      X_Attribute19                          VARCHAR2,
47                      X_Attribute20                          VARCHAR2,
48                      X_View_All_Psts                        VARCHAR2,
49                      X_Security_Profile_id                  NUMBER
50                      );
51 
52 PROCEDURE Lock_Row(X_Rowid                                  VARCHAR2,
53                    X_Position_Id                            NUMBER,
54                    X_Business_Group_Id                      NUMBER,
55                    X_Job_Id                                 NUMBER,
56                    X_Organization_Id                        NUMBER,
57                    X_Successor_Position_Id                  NUMBER,
58                    X_Relief_Position_Id                     NUMBER,
59                    X_Location_Id                            NUMBER,
60                    X_Position_Definition_Id                 NUMBER,
61                    X_Date_Effective                         DATE,
62                    X_Comments                               VARCHAR2,
63                    X_Date_End                               DATE,
64                    X_Frequency                              VARCHAR2,
65                    X_Name                                   VARCHAR2,
66                    X_Probation_Period                       NUMBER,
67                    X_Probation_Period_Units                 VARCHAR2,
68                    X_Replacement_Required_Flag              VARCHAR2,
69                    X_Time_Normal_Finish                     VARCHAR2,
70                    X_Time_Normal_Start                      VARCHAR2,
71                    X_Working_Hours                          NUMBER,
72                    X_Attribute_Category                     VARCHAR2,
73                    X_Attribute1                             VARCHAR2,
74                    X_Attribute2                             VARCHAR2,
75                    X_Attribute3                             VARCHAR2,
76                    X_Attribute4                             VARCHAR2,
77                    X_Attribute5                             VARCHAR2,
78                    X_Attribute6                             VARCHAR2,
79                    X_Attribute7                             VARCHAR2,
80                    X_Attribute8                             VARCHAR2,
81                    X_Attribute9                             VARCHAR2,
82                    X_Attribute10                            VARCHAR2,
83                    X_Attribute11                            VARCHAR2,
84                    X_Attribute12                            VARCHAR2,
85                    X_Attribute13                            VARCHAR2,
86                    X_Attribute14                            VARCHAR2,
87                    X_Attribute15                            VARCHAR2,
88                    X_Attribute16                            VARCHAR2,
89                    X_Attribute17                            VARCHAR2,
90                    X_Attribute18                            VARCHAR2,
91                    X_Attribute19                            VARCHAR2,
92                    X_Attribute20                            VARCHAR2,
93                    X_Status                                 VARCHAR2
94                    );
95 
96 PROCEDURE Update_Row(X_Rowid                               VARCHAR2,
97                      X_Position_Id                         NUMBER,
98                      X_Business_Group_Id                   NUMBER,
99                      X_Job_Id                              NUMBER,
100                      X_Organization_Id                     NUMBER,
101                      X_Successor_Position_Id               NUMBER,
102                      X_Relief_Position_Id                  NUMBER,
103                      X_Location_Id                         NUMBER,
104                      X_Position_Definition_Id              NUMBER,
105                      X_Date_Effective                      DATE,
106                      X_Comments                            VARCHAR2,
107                      X_Date_End                            DATE,
108                      X_Frequency                           VARCHAR2,
109                      X_Name                                VARCHAR2,
110                      X_Probation_Period                    NUMBER,
111                      X_Probation_Period_Units              VARCHAR2,
112                      X_Replacement_Required_Flag           VARCHAR2,
113                      X_Time_Normal_Finish                  VARCHAR2,
114                      X_Time_Normal_Start                   VARCHAR2,
115                      X_Working_Hours                       NUMBER,
116                      X_Status                               VARCHAR2,
117                      X_Attribute_Category                  VARCHAR2,
118                      X_Attribute1                          VARCHAR2,
119                      X_Attribute2                          VARCHAR2,
120                      X_Attribute3                          VARCHAR2,
121                      X_Attribute4                          VARCHAR2,
122                      X_Attribute5                          VARCHAR2,
123                      X_Attribute6                          VARCHAR2,
124                      X_Attribute7                          VARCHAR2,
125                      X_Attribute8                          VARCHAR2,
126                      X_Attribute9                          VARCHAR2,
127                      X_Attribute10                         VARCHAR2,
128                      X_Attribute11                         VARCHAR2,
129                      X_Attribute12                         VARCHAR2,
130                      X_Attribute13                         VARCHAR2,
131                      X_Attribute14                         VARCHAR2,
132                      X_Attribute15                         VARCHAR2,
133                      X_Attribute16                         VARCHAR2,
134                      X_Attribute17                         VARCHAR2,
135                      X_Attribute18                         VARCHAR2,
136                      X_Attribute19                         VARCHAR2,
137                      X_Attribute20                         VARCHAR2
138                      );
139 
140 PROCEDURE Delete_Row(X_Rowid VARCHAR2,
141                      X_Position_id number,
142                      X_business_group_id number,
143                      X_Hr_Ins varchar2,
144                      X_Po_Ins varchar2,
145 		     X_View_All_Psts varchar2);
146 --
147 PROCEDURE pre_delete_checks(p_rowid                       VARCHAR2,
148                             p_position_id                 NUMBER,
149                             p_business_group_id           NUMBER,
150                             p_hr_ins                      VARCHAR2,
151                             p_po_ins                      VARCHAR2,
152                             p_delete_row              OUT NOCOPY BOOLEAN);
153 --
154 FUNCTION check_id_flex_struct ( p_id_flex_code VARCHAR2,
155                                 p_id_flex_num  NUMBER ) RETURN BOOLEAN;
156 --
157 PROCEDURE check_date_effective ( p_position_id    NUMBER,
158 			         p_date_effective DATE);
159 --
160 PROCEDURE check_valid_grades ( p_position_id NUMBER,
161 		               p_end_of_time DATE,
162 		               p_date_end    DATE,
163 		               p_before_date_to IN OUT NOCOPY BOOLEAN,
164 		               p_before_date_from IN OUT NOCOPY BOOLEAN,
165                                p_end_date_blank IN OUT NOCOPY BOOLEAN,
166                                p_after_date_to  IN OUT NOCOPY BOOLEAN );
167 
168 --
169 PROCEDURE maintain_valid_grades(p_position_id NUMBER,
170 		                p_date_end    DATE,
171 		                p_end_of_time DATE,
172 				p_before_date_to   BOOLEAN,
173 				p_before_date_from BOOLEAN,
174                                 p_end_date_blank   BOOLEAN,
175                                 p_after_date_to    BOOLEAN );
176 
177 --
178 FUNCTION GET_SHARED_POS_WARN_FLAG(p_user_id number) RETURN varchar2;
179 --
180 PROCEDURE SET_SHARED_POS_WARN_FLAG(p_user_id number,
181                                    p_show_again_flag varchar2);
182 --
183 END PER_POSITIONS_PKG;