APPS.PER_RECRUITMENT_ACTIVITIES_PKG dependencies on PER_RECRUITMENT_ACTIVITIES

Line 1: PACKAGE BODY PER_RECRUITMENT_ACTIVITIES_PKG as

1: PACKAGE BODY PER_RECRUITMENT_ACTIVITIES_PKG as
2: /* $Header: perca01t.pkb 115.4 2003/02/11 11:55:00 eumenyio ship $ */
3: --
4: /* +=======================================================================+
5: | Copyright (c) 1993 Oracle Corporation |

Line 10: per_recruitment_activities_pkg

6: | Redwood Shores, California, USA |
7: | All rights reserved. |
8: +=======================================================================+
9: Name
10: per_recruitment_activities_pkg
11: Purpose
12: Supports the ACTIVITY block in the form PERWSDRA (Define Recruitment
13: Activity).
14: Notes

Line 53: FROM per_recruitment_activities rec

49: P_rowid VARCHAR2) IS
50:
51: CURSOR name_exists IS
52: SELECT 1
53: FROM per_recruitment_activities rec
54: WHERE upper(rec.NAME) = upper(p_Name)
55: AND rec.business_group_id + 0 = P_business_group_id
56: AND (P_rowid <> rec.rowid
57: or P_rowid is NULL);

Line 109: FROM per_recruitment_activities acts

105: P_recruitment_activity_id NUMBER,
106: P_Business_group_id NUMBER
107: ) IS
108: SELECT acts.recruitment_activity_id
109: FROM per_recruitment_activities acts
110: WHERE acts.parent_recruitment_activity_id = P_recruitment_activity_id
111: AND acts.business_group_id + 0 = P_Business_group_id;
112: --
113: --

Line 300: FROM per_recruitment_activities

296: --
297: CURSOR csr_par_rec_dates IS
298:
299: SELECT recruitment_activity_id
300: FROM per_recruitment_activities
301: WHERE recruitment_activity_id = P_parent_rec_id
302: AND business_group_id + 0 = P_Business_Group_id
303: AND date_start <= P_date_start
304: AND ((date_end is null) or

Line 384: FROM per_recruitment_activities

380: P_rec_act_id NUMBER) IS
381: --
382: CURSOR csr_chk_exist_child IS
383: SELECT 1
384: FROM per_recruitment_activities
385: WHERE parent_recruitment_activity_id = P_rec_act_id
386: AND business_group_id + 0 = P_Business_Group_id;
387: --
388:

Line 391: FROM per_recruitment_activities

387: --
388:
389: CURSOR csr_child_dates IS
390: SELECT parent_recruitment_activity_id
391: FROM per_recruitment_activities
392: WHERE parent_recruitment_activity_id = P_rec_act_id
393: AND business_group_id + 0 = P_Business_Group_id
394: AND P_date_start > date_start;
395: --

Line 438: FROM per_recruitment_activities

434: P_rec_act_id NUMBER) IS
435: --
436: CURSOR csr_chk_exist_child IS
437: SELECT 1
438: FROM per_recruitment_activities
439: WHERE parent_recruitment_activity_id = P_rec_act_id
440: AND business_group_id + 0 = P_Business_Group_id;
441: --
442:

Line 445: FROM per_recruitment_activities

441: --
442:
443: CURSOR csr_child_dates IS
444: SELECT parent_recruitment_activity_id
445: FROM per_recruitment_activities
446: WHERE parent_recruitment_activity_id = P_rec_act_id
447: AND business_group_id + 0 = P_Business_Group_id
448: AND P_date_end < date_start;
449: --

Line 560: FROM PER_RECRUITMENT_ACTIVITIES

556: X_Attribute20 VARCHAR2
557: ) IS
558: CURSOR C IS
559: SELECT rowid
560: FROM PER_RECRUITMENT_ACTIVITIES
561: WHERE recruitment_activity_id = X_Recruitment_Activity_Id;
562:
563:
564:

Line 566: SELECT per_recruitment_activities_s.nextval

562:
563:
564:
565: CURSOR C2 IS
566: SELECT per_recruitment_activities_s.nextval
567: FROM sys.dual;
568:
569: BEGIN
570: IF (X_Recruitment_Activity_Id is NULL) then

Line 575: INSERT INTO PER_RECRUITMENT_ACTIVITIES(

571: OPEN C2;
572: FETCH C2 INTO X_Recruitment_Activity_Id;
573: CLOSE C2;
574: end IF;
575: INSERT INTO PER_RECRUITMENT_ACTIVITIES(
576: recruitment_activity_id,
577: business_group_id,
578: authorising_person_id,
579: run_by_organization_id,

Line 723: FROM PER_RECRUITMENT_ACTIVITIES

719: X_Attribute20 VARCHAR2
720: ) IS
721: CURSOR C IS
722: SELECT *
723: FROM PER_RECRUITMENT_ACTIVITIES
724: WHERE rowid = X_Rowid
725: FOR UPDATE of Recruitment_Activity_Id NOWAIT;
726: Recinfo C%ROWTYPE;
727: BEGIN

Line 950: UPDATE PER_RECRUITMENT_ACTIVITIES

946: X_Attribute19 VARCHAR2,
947: X_Attribute20 VARCHAR2
948: ) IS
949: BEGIN
950: UPDATE PER_RECRUITMENT_ACTIVITIES
951: SET
952:
953: recruitment_activity_id = X_Recruitment_Activity_Id,
954: business_group_id = X_Business_Group_Id,

Line 996: 'per_recruitment_activities_pkg.update_row');

992:
993: IF (SQL%NOTFOUND) then
994: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
995: hr_utility.set_message_token('PROCEDURE',
996: 'per_recruitment_activities_pkg.update_row');
997: hr_utility.set_message_token('STEP','1');
998: hr_utility.raise_error;
999: end IF;
1000:

Line 1017: DELETE FROM PER_RECRUITMENT_ACTIVITIES

1013: -----------------------------------------------------------------------------
1014: --
1015: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
1016: BEGIN
1017: DELETE FROM PER_RECRUITMENT_ACTIVITIES
1018: WHERE rowid = X_Rowid;
1019:
1020: IF (SQL%NOTFOUND) then
1021: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 1029: END PER_RECRUITMENT_ACTIVITIES_PKG;

1025: hr_utility.raise_error;
1026: end IF;
1027: END Delete_Row;
1028:
1029: END PER_RECRUITMENT_ACTIVITIES_PKG;