eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_EVENTS_PKG dependencies on PER_EVENTS

Line 1: PACKAGE BODY PER_EVENTS_PKG as

1: PACKAGE BODY PER_EVENTS_PKG as
2: /* $Header: peevt01t.pkb 120.2 2008/05/16 06:51:14 pchowdav ship $ */
3: -- *****************************************************************
4: -- Table Handler for per_events
5: -- *****************************************************************

Line 4: -- Table Handler for per_events

1: PACKAGE BODY PER_EVENTS_PKG as
2: /* $Header: peevt01t.pkb 120.2 2008/05/16 06:51:14 pchowdav ship $ */
3: -- *****************************************************************
4: -- Table Handler for per_events
5: -- *****************************************************************
6:
7: g_dummy number(1); -- dummy variable for 'select 1...' statements
8:

Line 135: hr_utility.set_location ('per_events_pkg.event_causes_assignment_change',1);

131: and effective_start_date = p_event_date;
132: --
133: begin
134: --
135: hr_utility.set_location ('per_events_pkg.event_causes_assignment_change',1);
136: --
137: open csr_assignment;
138: fetch csr_assignment into g_dummy;
139: v_change_exists := csr_assignment%found;

Line 170: from per_events event, per_assignments assignment

166: l_same_time boolean;
167: --
168: cursor csr_double_booking is
169: select event.time_start, nvl(event.time_end,'24:00')
170: from per_events event, per_assignments assignment
171: where (p_rowid is null or p_rowid <> event.rowid)
172: and assignment.person_id = p_person_id
173: and event.assignment_id = assignment.assignment_id
174: and event.event_or_interview = 'I'

Line 181: hr_utility.set_location ('per_events_pkg.interview_double_booked',1);

177: event.date_start);
178: --
179: begin
180: --
181: hr_utility.set_location ('per_events_pkg.interview_double_booked',1);
182: --
183: open csr_double_booking;
184: fetch csr_double_booking into l_time_start, l_time_end;
185: hr_utility.set_location ('per_events_pkg.interview_double_booked',2);

Line 185: hr_utility.set_location ('per_events_pkg.interview_double_booked',2);

181: hr_utility.set_location ('per_events_pkg.interview_double_booked',1);
182: --
183: open csr_double_booking;
184: fetch csr_double_booking into l_time_start, l_time_end;
185: hr_utility.set_location ('per_events_pkg.interview_double_booked',2);
186: v_interview_double_booked := csr_double_booking%found;
187: close csr_double_booking;
188: --
189: hr_utility.set_location ('per_events_pkg.interview_double_booked',3);

Line 189: hr_utility.set_location ('per_events_pkg.interview_double_booked',3);

185: hr_utility.set_location ('per_events_pkg.interview_double_booked',2);
186: v_interview_double_booked := csr_double_booking%found;
187: close csr_double_booking;
188: --
189: hr_utility.set_location ('per_events_pkg.interview_double_booked',3);
190: l_same_time := v_interview_double_booked;
191: if v_interview_double_booked and p_time_start is not null and l_time_start is not null then
192: hr_utility.set_location ('per_events_pkg.interview_double_booked',4);
193: --

Line 192: hr_utility.set_location ('per_events_pkg.interview_double_booked',4);

188: --
189: hr_utility.set_location ('per_events_pkg.interview_double_booked',3);
190: l_same_time := v_interview_double_booked;
191: if v_interview_double_booked and p_time_start is not null and l_time_start is not null then
192: hr_utility.set_location ('per_events_pkg.interview_double_booked',4);
193: --
194: -- If interview has start time entered then compare on basis ofstart and end time.
195: -- The following code checks for the time overlap.
196: --

Line 216: hr_utility.set_location ('per_events_pkg.interview_double_booked',5);

212: ( (substr(p_time_end,1,2) * 60) + substr(p_time_end,4,2))
213: )
214: ) ;
215: --
216: hr_utility.set_location ('per_events_pkg.interview_double_booked',5);
217:
218: end if;
219: hr_utility.set_location ('per_events_pkg.interview_double_booked',99);
220: --

Line 219: hr_utility.set_location ('per_events_pkg.interview_double_booked',99);

215: --
216: hr_utility.set_location ('per_events_pkg.interview_double_booked',5);
217:
218: end if;
219: hr_utility.set_location ('per_events_pkg.interview_double_booked',99);
220: --
221: return l_same_time;
222: --
223: end interview_double_booked;

Line 246: hr_utility.set_location ('per_events_pkg.interviewers_are_booked',1);

242: v_booking_exists boolean := FALSE;
243: --
244: begin
245: --
246: hr_utility.set_location ('per_events_pkg.interviewers_are_booked',1);
247: --
248: open csr_booking;
249: fetch csr_booking into g_dummy;
250: v_booking_exists := csr_booking%found;

Line 305: hr_utility.set_location ('Entering per_events_pkg.check_current_interviewers',1);

301: l_dummy varchar2(1);
302: --
303: begin
304: --
305: hr_utility.set_location ('Entering per_events_pkg.check_current_interviewers',1);
306: --
307: for interview in csr_interview LOOP
308: -- bug fix 2708777 starts here.
309: open csr_person_exists(interview.person_id);

Line 325: hr_utility.set_location ('Leaving per_events_pkg.check_current_interviewers',2);

321: close csr_person_exists;
322: --
323: end loop;
324: --
325: hr_utility.set_location ('Leaving per_events_pkg.check_current_interviewers',2);
326: --
327: end check_current_interviewers;
328: --------------------------------------------------------------------------------
329: procedure REQUEST_LETTER (

Line 375: hr_utility.set_location ('per_events_pkg.request_letter', 1);

371: --fix for bug 7019343 ends here.
372:
373: begin
374: --
375: hr_utility.set_location ('per_events_pkg.request_letter', 1);
376: --
377: open csr_check_letter;
378: fetch csr_check_letter into g_dummy;
379: if csr_check_letter%notfound then

Line 634: SELECT rowid FROM PER_EVENTS

630: L_DUMMY NUMBER;
631: l_party_id number;
632:
633: CURSOR C IS
634: SELECT rowid FROM PER_EVENTS
635: WHERE event_id = X_Event_Id;
636:
637: CURSOR C2 IS
638: SELECT PER_EVENTS_S.NEXTVAL

Line 638: SELECT PER_EVENTS_S.NEXTVAL

634: SELECT rowid FROM PER_EVENTS
635: WHERE event_id = X_Event_Id;
636:
637: CURSOR C2 IS
638: SELECT PER_EVENTS_S.NEXTVAL
639: FROM SYS.DUAL;
640:
641: CURSOR LOCATION_CHECK IS
642: select 1

Line 697: INSERT INTO PER_EVENTS(

693: open csr_get_party_id;
694: fetch csr_get_party_id into l_party_id;
695: close csr_get_party_id;
696: --
697: INSERT INTO PER_EVENTS(
698: event_id,
699: business_group_id,
700: location_id,
701: internal_contact_person_id,

Line 830: FROM PER_EVENTS

826: ) IS
827:
828: CURSOR C IS
829: SELECT *
830: FROM PER_EVENTS
831: WHERE rowid = X_Rowid
832: FOR UPDATE of Event_Id NOWAIT;
833: Recinfo C%ROWTYPE;
834: BEGIN

Line 1075: UPDATE PER_EVENTS

1071: END IF;
1072: END IF;
1073: END IF;
1074:
1075: UPDATE PER_EVENTS
1076: SET
1077:
1078: event_id = X_Event_Id,
1079: business_group_id = X_Business_Group_Id,

Line 1177: DELETE FROM PER_EVENTS

1173: CLOSE PAY_CHANGE_CHECK;
1174: END IF;
1175: END IF;
1176:
1177: DELETE FROM PER_EVENTS
1178: WHERE rowid = X_Rowid;
1179:
1180: if (SQL%NOTFOUND) then
1181: HR_UTILITY.SET_MESSAGE(801,'HR_6153_ALL_PROCEDURE_FAIL');

Line 1188: END PER_EVENTS_PKG;

1184: HR_UTILITY.RAISE_ERROR;
1185: end if;
1186: END Delete_Row;
1187:
1188: END PER_EVENTS_PKG;