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_VACANCIES_PKG dependencies on PER_VACANCIES

Line 1: PACKAGE BODY PER_VACANCIES_PKG as

1: PACKAGE BODY PER_VACANCIES_PKG as
2: /* $Header: pevac01t.pkb 120.2.12000000.2 2007/02/13 09:36:27 sidsaxen ship $ */
3: /* +=======================================================================+
4: | Copyright (c) 1993 Oracle Corporation |
5: | Redwood Shores, California, USA |

Line 9: per_vacancies_pkg

5: | Redwood Shores, California, USA |
6: | All rights reserved. |
7: +=======================================================================+
8: Name
9: per_vacancies_pkg
10: Purpose
11: Supports the VACANCY block in the form PERWSVAC (Define Requistion and
12: Vacancy).
13: Notes

Line 87: FROM PER_VACANCIES PV,

83: --
84: PROCEDURE Check_References(P_vacancy_id NUMBER ) is
85: CURSOR c_check_references1 IS
86: SELECT distinct(PV.NAME)
87: FROM PER_VACANCIES PV,
88: PER_ALL_ASSIGNMENTS_F PAF
89: WHERE PAF.VACANCY_ID = P_vacancy_id
90: AND PV.VACANCY_ID = P_vacancy_id
91: AND PAF.VACANCY_ID = PV.VACANCY_ID;

Line 95: FROM PER_VACANCIES PV

91: AND PAF.VACANCY_ID = PV.VACANCY_ID;
92:
93: CURSOR c_check_ref_2 IS
94: SELECT PV.NAME
95: FROM PER_VACANCIES PV
96: , PER_RECRUITMENT_ACTIVITY_FOR PRAF
97: WHERE PRAF.VACANCY_ID = P_vacancy_id
98: AND PV.VACANCY_ID = P_vacancy_id ;
99:

Line 395: PER_VACANCIES_PKG.D_from_updt_org_chk(

391: ) IS
392:
393: BEGIN
394: IF Pz_organization_id IS NOT NULL THEN
395: PER_VACANCIES_PKG.D_from_updt_org_chk(
396: P_Business_group_id => Pz_business_group_id,
397: P_vac_date_from => Pz_vac_date_from,
398: P_organization_id => Pz_organization_id);
399: END IF;

Line 402: PER_VACANCIES_PKG.D_from_updt_pos_chk(

398: P_organization_id => Pz_organization_id);
399: END IF;
400:
401: IF Pz_position_id IS NOT NULL THEN
402: PER_VACANCIES_PKG.D_from_updt_pos_chk(
403: P_Business_group_id => Pz_business_group_id,
404: P_vac_date_from => Pz_vac_date_from,
405: P_position_id => Pz_position_id);
406: END IF;

Line 409: PER_VACANCIES_PKG.D_from_updt_grp_chk(

405: P_position_id => Pz_position_id);
406: END IF;
407:
408: IF Pz_people_group_id IS NOT NULL THEN
409: PER_VACANCIES_PKG.D_from_updt_grp_chk(
410: P_vac_date_from => Pz_vac_date_from,
411: P_start_of_time => Pz_start_of_time,
412: P_people_group_id => Pz_people_group_id);
413: END IF;

Line 416: PER_VACANCIES_PKG.D_from_updt_job_chk(

412: P_people_group_id => Pz_people_group_id);
413: END IF;
414:
415: IF Pz_job_id IS NOT NULL THEN
416: PER_VACANCIES_PKG.D_from_updt_job_chk(
417: P_vac_date_from => Pz_vac_date_from,
418: P_Business_group_id => Pz_business_group_id,
419: P_job_id => Pz_job_id);
420: END IF;

Line 423: PER_VACANCIES_PKG.D_from_updt_grd_chk

419: P_job_id => Pz_job_id);
420: END IF;
421:
422: IF Pz_grade_id IS NOT NULL THEN
423: PER_VACANCIES_PKG.D_from_updt_grd_chk
424: (P_vac_date_from => Pz_vac_date_from,
425: P_business_group_id => Pz_business_group_id,
426: P_grade_id => Pz_grade_id);
427: END IF;

Line 430: PER_VACANCIES_PKG.D_from_updt_loc_chk(

426: P_grade_id => Pz_grade_id);
427: END IF;
428:
429: IF Pz_location_id IS NOT NULL THEN
430: PER_VACANCIES_PKG.D_from_updt_loc_chk(
431: P_vac_date_from => Pz_vac_date_from,
432: P_end_of_time => Pz_end_of_time,
433: P_location_id => Pz_location_id);
434: END IF;

Line 438: PER_VACANCIES_PKG.D_from_updt_person(

434: END IF;
435:
436:
437: IF Pz_recruiter_id IS NOT NULL THEN
438: PER_VACANCIES_PKG.D_from_updt_person(
439: P_vac_date_from => Pz_vac_date_from,
440: P_recruiter_id => Pz_recruiter_id,
441: P_business_group_id => Pz_business_group_id);
442: END IF;

Line 855: FROM PER_VACANCIES

851: X_Attribute19 VARCHAR2,
852: X_Attribute20 VARCHAR2 )
853: IS
854: CURSOR C IS SELECT rowid
855: FROM PER_VACANCIES
856: WHERE vacancy_id = X_Vacancy_Id;
857:
858:
859: CURSOR C2 IS SELECT per_vacancies_s.nextval

Line 859: CURSOR C2 IS SELECT per_vacancies_s.nextval

855: FROM PER_VACANCIES
856: WHERE vacancy_id = X_Vacancy_Id;
857:
858:
859: CURSOR C2 IS SELECT per_vacancies_s.nextval
860: FROM sys.dual;
861: BEGIN
862:
863: if (X_Vacancy_Id is NULL) then

Line 868: INSERT INTO PER_VACANCIES(

864: OPEN C2;
865: FETCH C2 INTO X_Vacancy_Id;
866: CLOSE C2;
867: end if;
868: INSERT INTO PER_VACANCIES(
869: vacancy_id,
870: business_group_id,
871: position_id,
872: job_id,

Line 959: 'per_vacancies_pkg.insert_row');

955: if (C%NOTFOUND) then
956: CLOSE C;
957: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
958: hr_utility.set_message_token('PROCEDURE',
959: 'per_vacancies_pkg.insert_row');
960: hr_utility.set_message_token('STEP','1');
961: hr_utility.raise_error;
962: end if;
963: CLOSE C;

Line 1026: FROM PER_VACANCIES

1022: X_Attribute20 VARCHAR2)
1023: IS
1024: CURSOR C IS
1025: SELECT *
1026: FROM PER_VACANCIES
1027: WHERE rowid = X_Rowid
1028: FOR UPDATE of Vacancy_Id NOWAIT;
1029: BEGIN
1030: OPEN C;

Line 1036: 'per_vacancies_pkb.lock_row');

1032: if (C%NOTFOUND) then
1033: CLOSE C;
1034: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1035: hr_utility.set_message_token('PROCEDURE',
1036: 'per_vacancies_pkb.lock_row');
1037: hr_utility.set_message_token('STEP','1');
1038: hr_utility.raise_error;
1039: end if;
1040: CLOSE C;

Line 1261: PER_VACANCIES_PKG.D_to_updt_org_chk(P_Business_group_id => X_Business_group_id

1257: ) IS
1258: BEGIN
1259: --
1260: IF X_Organization_Id is not null then
1261: PER_VACANCIES_PKG.D_to_updt_org_chk(P_Business_group_id => X_Business_group_id
1262: ,P_vac_date_to => X_Date_To
1263: ,P_organization_id => X_Organization_Id);
1264: end if;
1265: --

Line 1266: UPDATE PER_VACANCIES

1262: ,P_vac_date_to => X_Date_To
1263: ,P_organization_id => X_Organization_Id);
1264: end if;
1265: --
1266: UPDATE PER_VACANCIES
1267: SET
1268: vacancy_id = X_Vacancy_Id,
1269: business_group_id = X_Business_Group_Id,
1270: position_id = X_Position_Id,

Line 1314: 'per_vacancies_pkb.update_row');

1310:
1311: if (SQL%NOTFOUND) then
1312: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1313: hr_utility.set_message_token('PROCEDURE',
1314: 'per_vacancies_pkb.update_row');
1315: hr_utility.set_message_token('STEP','1');
1316: hr_utility.raise_error;
1317: end if;
1318:

Line 1377: DELETE FROM PER_VACANCIES

1373: --
1374: PROCEDURE Delete_Row(X_Rowid VARCHAR2 , x_vacancy_id in number ) IS
1375: BEGIN
1376: check_references( x_vacancy_id ) ;
1377: DELETE FROM PER_VACANCIES
1378: WHERE rowid = X_Rowid;
1379:
1380: if (SQL%NOTFOUND) then
1381: RAISE NO_DATA_FOUND;

Line 1385: END PER_VACANCIES_PKG;

1381: RAISE NO_DATA_FOUND;
1382: end if;
1383: END Delete_Row;
1384:
1385: END PER_VACANCIES_PKG;