[Home] [Help]
PACKAGE: APPS.PER_EVENTS_PKG
Source
1 PACKAGE PER_EVENTS_PKG as
2 /* $Header: peevt01t.pkh 120.0.12010000.1 2008/07/28 04:39:39 appldev ship $ */
3
4 -- *****************************************************************
5 -- * Table handler for per_events
6 -- *****************************************************************
7
8 PROCEDURE CHECK_VALIDITY(X_INTERNAL_CONTACT_PERSON_ID NUMBER,
9 X_DATE_START DATE,
10 X_ORGANIZATION_RUN_BY_ID NUMBER,
11 X_BUSINESS_GROUP_ID NUMBER,
12 X_CTL_GLOBALS_END_OF_TIME DATE,
13 X_LOCATION_ID NUMBER,
14 X_EVENT_ID NUMBER);
15
16 --------------------------------------------------------------------------------
17 function INTERVIEWERS_ARE_BOOKED ( p_event_id number,
18 p_error_if_true boolean default FALSE)
19 return boolean;
20 --------------------------------------------------------------------------------
21 procedure CHECK_CURRENT_INTERVIEWERS ( p_event_id number,
22 p_new_interview_start_date date);
23 --------------------------------------------------------------------------------
24 procedure REQUEST_LETTER (
25 p_business_group_id number,
26 p_session_date date,
27 p_user number,
28 p_login_id number,
29 p_assignment_status_type_id number,
30 p_person_id number,
31 p_assignment_id number);
32 --------------------------------------------------------------------------------
33 function EVENT_CAUSES_ASSIGNMENT_CHANGE ( p_event_date date,
34 p_assignment_id number)
35 return boolean;
36 --------------------------------------------------------------------------------
37 function INTERVIEW_DOUBLE_BOOKED (
38 --
39 --******************************************************************************
40 --* Returns TRUE if the applicant already has an interview at the time required*
41 --******************************************************************************
42 --
43 p_person_id number,
44 p_interview_start_date date,
45 p_time_start varchar2, -- Added for bug 3270091.
46 p_time_end varchar2, -- Added for bug 3270091.
47 p_rowid varchar2 default null) return boolean;
48 --------------------------------------------------------------------------------
49
50
51 PROCEDURE INSERT_ROW(X_Rowid IN OUT NOCOPY VARCHAR2,
52 X_Event_Id IN OUT NOCOPY NUMBER,
53 X_Business_Group_Id NUMBER,
54 X_Location_Id NUMBER,
55 X_Internal_Contact_Person_Id NUMBER,
56 X_Organization_Run_By_Id NUMBER,
57 X_Assignment_Id NUMBER,
58 X_Date_Start DATE,
59 X_Type VARCHAR2,
60 X_Comments VARCHAR2,
61 X_Contact_Telephone_Number VARCHAR2,
62 X_Date_End DATE,
63 X_Emp_Or_Apl VARCHAR2,
64 X_Event_Or_Interview VARCHAR2,
65 X_External_Contact VARCHAR2,
66 X_Time_End VARCHAR2,
67 X_Time_Start VARCHAR2,
68 X_Attribute_Category VARCHAR2,
69 X_Attribute1 VARCHAR2,
70 X_Attribute2 VARCHAR2,
71 X_Attribute3 VARCHAR2,
72 X_Attribute4 VARCHAR2,
73 X_Attribute5 VARCHAR2,
74 X_Attribute6 VARCHAR2,
75 X_Attribute7 VARCHAR2,
76 X_Attribute8 VARCHAR2,
77 X_Attribute9 VARCHAR2,
78 X_Attribute10 VARCHAR2,
79 X_Attribute11 VARCHAR2,
80 X_Attribute12 VARCHAR2,
81 X_Attribute13 VARCHAR2,
82 X_Attribute14 VARCHAR2,
83 X_Attribute15 VARCHAR2,
84 X_Attribute16 VARCHAR2,
85 X_Attribute17 VARCHAR2,
86 X_Attribute18 VARCHAR2,
87 X_Attribute19 VARCHAR2,
88 X_Attribute20 VARCHAR2,
89 X_ctl_globals_end_of_time DATE);
90
91 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
92 X_Event_Id NUMBER,
93 X_Business_Group_Id NUMBER,
94 X_Location_Id NUMBER,
95 X_Internal_Contact_Person_Id NUMBER,
96 X_Organization_Run_By_Id NUMBER,
97 X_Assignment_Id NUMBER,
98 X_Date_Start DATE,
99 X_Type VARCHAR2,
100 X_Comments VARCHAR2,
101 X_Contact_Telephone_Number VARCHAR2,
102 X_Date_End DATE,
103 X_Emp_Or_Apl VARCHAR2,
104 X_Event_Or_Interview VARCHAR2,
105 X_External_Contact VARCHAR2,
106 X_Time_End VARCHAR2,
107 X_Time_Start VARCHAR2,
108 X_Attribute_Category VARCHAR2,
109 X_Attribute1 VARCHAR2,
110 X_Attribute2 VARCHAR2,
111 X_Attribute3 VARCHAR2,
112 X_Attribute4 VARCHAR2,
113 X_Attribute5 VARCHAR2,
114 X_Attribute6 VARCHAR2,
115 X_Attribute7 VARCHAR2,
116 X_Attribute8 VARCHAR2,
117 X_Attribute9 VARCHAR2,
118 X_Attribute10 VARCHAR2,
119 X_Attribute11 VARCHAR2,
120 X_Attribute12 VARCHAR2,
121 X_Attribute13 VARCHAR2,
122 X_Attribute14 VARCHAR2,
123 X_Attribute15 VARCHAR2,
124 X_Attribute16 VARCHAR2,
125 X_Attribute17 VARCHAR2,
126 X_Attribute18 VARCHAR2,
127 X_Attribute19 VARCHAR2,
128 X_Attribute20 VARCHAR2
129 );
130
131 PROCEDURE Update_Row(X_Rowid VARCHAR2,
132 X_Event_Id NUMBER,
133 X_Business_Group_Id NUMBER,
134 X_Location_Id NUMBER,
135 X_Internal_Contact_Person_Id NUMBER,
136 X_Organization_Run_By_Id NUMBER,
137 X_Assignment_Id NUMBER,
138 X_Date_Start DATE,
139 X_Type VARCHAR2,
140 X_Comments VARCHAR2,
141 X_Contact_Telephone_Number VARCHAR2,
142 X_Date_End DATE,
143 X_Emp_Or_Apl VARCHAR2,
144 X_Event_Or_Interview VARCHAR2,
145 X_External_Contact VARCHAR2,
146 X_Time_End VARCHAR2,
147 X_Time_Start VARCHAR2,
148 X_Attribute_Category VARCHAR2,
149 X_Attribute1 VARCHAR2,
150 X_Attribute2 VARCHAR2,
151 X_Attribute3 VARCHAR2,
152 X_Attribute4 VARCHAR2,
153 X_Attribute5 VARCHAR2,
154 X_Attribute6 VARCHAR2,
155 X_Attribute7 VARCHAR2,
156 X_Attribute8 VARCHAR2,
157 X_Attribute9 VARCHAR2,
158 X_Attribute10 VARCHAR2,
159 X_Attribute11 VARCHAR2,
160 X_Attribute12 VARCHAR2,
161 X_Attribute13 VARCHAR2,
162 X_Attribute14 VARCHAR2,
163 X_Attribute15 VARCHAR2,
164 X_Attribute16 VARCHAR2,
165 X_Attribute17 VARCHAR2,
166 X_Attribute18 VARCHAR2,
167 X_Attribute19 VARCHAR2,
168 X_Attribute20 VARCHAR2,
169 X_ctl_globals_end_of_time DATE);
170
171 PROCEDURE Delete_Row(X_Rowid VARCHAR2,
172 X_Event_Id NUMBER,
173 X_Business_Group_Id NUMBER,
174 X_Message VARCHAR2,
175 X_Form VARCHAR2);
176
177 END PER_EVENTS_PKG;