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.3.12010000.9 2010/04/08 10:23:05 karthmoh 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 78: per_all_assignments_f in per_vacancies_pkg.update_row

74: for bug 6497289
75: 24-Feb-09 lbodired 115.19 Modified the procedure UPDATE_ROW
76: for the bug 7592739
77: 01-Jun-09 sidsaxen 115.23 bug 8518955, handled NULL while updating
78: per_all_assignments_f in per_vacancies_pkg.update_row
79: 08-APR-10 karthmoh 120.3.12010000.9 Modified/Added Procedures for ER#8530112
80: ============================================================================*/
81: ----------------------------------------------------------------------------
82: --

Line 95: FROM PER_VACANCIES PV,

91: --
92: PROCEDURE Check_References(P_vacancy_id NUMBER ) is
93: CURSOR c_check_references1 IS
94: SELECT distinct(PV.NAME)
95: FROM PER_VACANCIES PV,
96: PER_ALL_ASSIGNMENTS_F PAF
97: WHERE PAF.VACANCY_ID = P_vacancy_id
98: AND PV.VACANCY_ID = P_vacancy_id
99: AND PAF.VACANCY_ID = PV.VACANCY_ID;

Line 103: FROM PER_VACANCIES PV

99: AND PAF.VACANCY_ID = PV.VACANCY_ID;
100:
101: CURSOR c_check_ref_2 IS
102: SELECT PV.NAME
103: FROM PER_VACANCIES PV
104: , PER_RECRUITMENT_ACTIVITY_FOR PRAF
105: WHERE PRAF.VACANCY_ID = P_vacancy_id
106: AND PV.VACANCY_ID = P_vacancy_id ;
107:

Line 403: PER_VACANCIES_PKG.D_from_updt_org_chk(

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

Line 410: PER_VACANCIES_PKG.D_from_updt_pos_chk(

406: P_organization_id => Pz_organization_id);
407: END IF;
408:
409: IF Pz_position_id IS NOT NULL THEN
410: PER_VACANCIES_PKG.D_from_updt_pos_chk(
411: P_Business_group_id => Pz_business_group_id,
412: P_vac_date_from => Pz_vac_date_from,
413: P_position_id => Pz_position_id);
414: END IF;

Line 417: PER_VACANCIES_PKG.D_from_updt_grp_chk(

413: P_position_id => Pz_position_id);
414: END IF;
415:
416: IF Pz_people_group_id IS NOT NULL THEN
417: PER_VACANCIES_PKG.D_from_updt_grp_chk(
418: P_vac_date_from => Pz_vac_date_from,
419: P_start_of_time => Pz_start_of_time,
420: P_people_group_id => Pz_people_group_id);
421: END IF;

Line 424: PER_VACANCIES_PKG.D_from_updt_job_chk(

420: P_people_group_id => Pz_people_group_id);
421: END IF;
422:
423: IF Pz_job_id IS NOT NULL THEN
424: PER_VACANCIES_PKG.D_from_updt_job_chk(
425: P_vac_date_from => Pz_vac_date_from,
426: P_Business_group_id => Pz_business_group_id,
427: P_job_id => Pz_job_id);
428: END IF;

Line 431: PER_VACANCIES_PKG.D_from_updt_grd_chk

427: P_job_id => Pz_job_id);
428: END IF;
429:
430: IF Pz_grade_id IS NOT NULL THEN
431: PER_VACANCIES_PKG.D_from_updt_grd_chk
432: (P_vac_date_from => Pz_vac_date_from,
433: P_business_group_id => Pz_business_group_id,
434: P_grade_id => Pz_grade_id);
435: END IF;

Line 438: PER_VACANCIES_PKG.D_from_updt_loc_chk(

434: P_grade_id => Pz_grade_id);
435: END IF;
436:
437: IF Pz_location_id IS NOT NULL THEN
438: PER_VACANCIES_PKG.D_from_updt_loc_chk(
439: P_vac_date_from => Pz_vac_date_from,
440: P_end_of_time => Pz_end_of_time,
441: P_location_id => Pz_location_id);
442: END IF;

Line 446: PER_VACANCIES_PKG.D_from_updt_person(

442: END IF;
443:
444:
445: IF Pz_recruiter_id IS NOT NULL THEN
446: PER_VACANCIES_PKG.D_from_updt_person(
447: P_vac_date_from => Pz_vac_date_from,
448: P_recruiter_id => Pz_recruiter_id,
449: P_business_group_id => Pz_business_group_id);
450: END IF;

Line 868: FROM PER_VACANCIES

864: X_Attribute19 VARCHAR2,
865: X_Attribute20 VARCHAR2 )
866: IS
867: CURSOR C IS SELECT rowid
868: FROM PER_VACANCIES
869: WHERE vacancy_id = X_Vacancy_Id;
870:
871:
872: CURSOR C2 IS SELECT per_vacancies_s.nextval

Line 872: CURSOR C2 IS SELECT per_vacancies_s.nextval

868: FROM PER_VACANCIES
869: WHERE vacancy_id = X_Vacancy_Id;
870:
871:
872: CURSOR C2 IS SELECT per_vacancies_s.nextval
873: FROM sys.dual;
874: BEGIN
875:
876: if (X_Vacancy_Id is NULL) then

Line 882: INSERT INTO PER_VACANCIES(

878: FETCH C2 INTO X_Vacancy_Id;
879: CLOSE C2;
880: end if;
881: CHK_POS_BUDGET_VAL(X_Position_Id,X_Date_From,X_Organization_Id,X_Number_Of_Openings,X_Vacancy_Id);
882: INSERT INTO PER_VACANCIES(
883: vacancy_id,
884: business_group_id,
885: position_id,
886: job_id,

Line 973: 'per_vacancies_pkg.insert_row');

969: if (C%NOTFOUND) then
970: CLOSE C;
971: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
972: hr_utility.set_message_token('PROCEDURE',
973: 'per_vacancies_pkg.insert_row');
974: hr_utility.set_message_token('STEP','1');
975: hr_utility.raise_error;
976: end if;
977: CLOSE C;

Line 1040: FROM PER_VACANCIES

1036: X_Attribute20 VARCHAR2)
1037: IS
1038: CURSOR C IS
1039: SELECT *
1040: FROM PER_VACANCIES
1041: WHERE rowid = X_Rowid
1042: FOR UPDATE of Vacancy_Id NOWAIT;
1043: BEGIN
1044: OPEN C;

Line 1050: 'per_vacancies_pkb.lock_row');

1046: if (C%NOTFOUND) then
1047: CLOSE C;
1048: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1049: hr_utility.set_message_token('PROCEDURE',
1050: 'per_vacancies_pkb.lock_row');
1051: hr_utility.set_message_token('STEP','1');
1052: hr_utility.raise_error;
1053: end if;
1054: CLOSE C;

Line 1276: PER_VACANCIES_PKG.D_to_updt_org_chk(P_Business_group_id => X_Business_group_id

1272: l_end_of_time date := hr_api.g_eot;
1273: BEGIN
1274: --
1275: IF X_Organization_Id is not null then
1276: PER_VACANCIES_PKG.D_to_updt_org_chk(P_Business_group_id => X_Business_group_id
1277: ,P_vac_date_to => X_Date_To
1278: ,P_organization_id => X_Organization_Id);
1279: end if;
1280: --

Line 1282: UPDATE PER_VACANCIES

1278: ,P_organization_id => X_Organization_Id);
1279: end if;
1280: --
1281: CHK_POS_BUDGET_VAL(X_Position_Id,X_Date_From,X_Organization_Id,X_Number_Of_Openings,X_Vacancy_Id);
1282: UPDATE PER_VACANCIES
1283: SET
1284: vacancy_id = X_Vacancy_Id,
1285: business_group_id = X_Business_Group_Id,
1286: position_id = X_Position_Id,

Line 1330: 'per_vacancies_pkb.update_row');

1326:
1327: if (SQL%NOTFOUND) then
1328: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1329: hr_utility.set_message_token('PROCEDURE',
1330: 'per_vacancies_pkb.update_row');
1331: hr_utility.set_message_token('STEP','1');
1332: hr_utility.raise_error;
1333: end if;
1334:

Line 1407: DELETE FROM PER_VACANCIES

1403: --
1404: PROCEDURE Delete_Row(X_Rowid VARCHAR2 , x_vacancy_id in number ) IS
1405: BEGIN
1406: check_references( x_vacancy_id ) ;
1407: DELETE FROM PER_VACANCIES
1408: WHERE rowid = X_Rowid;
1409:
1410: if (SQL%NOTFOUND) then
1411: RAISE NO_DATA_FOUND;

Line 1696: Per_vacancies

1692: p_vacancy_id in number) return number IS
1693:
1694: CURSOR csr_get_sum_of_open is
1695: Select sum(number_of_openings) from
1696: Per_vacancies
1697: WHERE position_id = p_position_id
1698: and vacancy_id <> p_vacancy_id
1699: AND p_effective_date BETWEEN date_from AND
1700: nvl(date_to,to_date('31/12/4712','DD/MM/YYYY'))

Line 1750: END PER_VACANCIES_PKG;

1746:
1747: End;
1748: -- End - Changes for ER#8530112
1749:
1750: END PER_VACANCIES_PKG;