[Home] [Help]
PACKAGE: APPS.PER_RECRUIT_ACTIVITY_FOR_PKG
Source
1 PACKAGE PER_RECRUIT_ACTIVITY_FOR_PKG AUTHID CURRENT_USER as
2 /* $Header: percf01t.pkh 115.1 2003/02/11 11:59:38 eumenyio ship $ */
3 --
4 /* +=======================================================================+
5 | Copyright (c) 1993 Oracle Corporation |
6 | Redwood Shores, California, USA |
7 | All rights reserved. |
8 +=======================================================================+
9 Name
10 per_recruit_activity_for_pkg
11 Purpose
12 Supports the VACANCY block in the form PERWSDRA (Define Recruitment
13 Activity).
14 Notes
15
16 History
17 21-Feb-94 H.Minton 40.0 Date created.
18 29-Jan-95 D.Kerr 70.4 Removed WHO-columns for Set8 changes
19 ============================================================================*/
20 --
21 -----------------------------------------------------------------------------
22 -- Name --
23 -- Check_References --
24 -- Purpose --
25 -- checks that deletes cannot take place of a recruitment activity if --
26 -- there are vacancies i.e recruitment_activities_for the recruitment- --
27 -- activity exist.
28 -----------------------------------------------------------------------------
29 --
30 PROCEDURE check_References(P_recruitment_activity_id NUMBER,
31 P_Business_group_id NUMBER);
32 --
33 -----------------------------------------------------------------------------
34 --
35 -----------------------------------------------------------------------------
36 -- Name --
37 -- Insert_Row --
38 -- Purpose --
39 -- Table handler procedure. Supports the insert of a VACANCY via the --
40 -- Define Recruitment Activity form. --
41 -- Arguments --
42 -- See below. --
43 -- Notes --
44 -- --
45 -----------------------------------------------------------------------------
46 --
47 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
48 X_Recruitment_Activity_For_Id IN OUT NOCOPY NUMBER,
49 X_Business_Group_Id NUMBER,
50 X_Vacancy_Id NUMBER,
51 X_Recruitment_Activity_Id NUMBER
52 );
53 --
54 -----------------------------------------------------------------------------
55 -- Name --
56 -- Lock_Row --
57 -- Purpose --
58 -- Table handler procedure that supports the insert , update and delete --
59 -- of a vacancy by applying a lock on a vacancy in the Define --
60 -- Recruitment Activity form. --
61 -- Arguments --
62 -- Notes --
63 -- None. --
64 -----------------------------------------------------------------------------
65 --
66 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
67 X_Recruitment_Activity_For_Id NUMBER,
68 X_Business_Group_Id NUMBER,
69 X_Vacancy_Id NUMBER,
70 X_Recruitment_Activity_Id NUMBER
71 );
72 --
73 -----------------------------------------------------------------------------
74 -- Name --
75 -- Update_Row --
76 -- Purpose --
77 -- Table handler procedure that supports the update of a VACACNY via --
78 -- Define Recruitment Activity form. --
79 -- Arguments --
80 -- See below. --
81 -- Notes --
82 -- None. --
83 -----------------------------------------------------------------------------
84 --
85 PROCEDURE Update_Row(X_Rowid VARCHAR2,
86 X_Recruitment_Activity_For_Id NUMBER,
87 X_Business_Group_Id NUMBER,
88 X_Vacancy_Id NUMBER,
89 X_Recruitment_Activity_Id NUMBER
90 );
91 --
92 -----------------------------------------------------------------------------
93 -- Name --
94 -- Delete_Row --
95 -- Purpose --
96 -- Table handler procedure that supports the delete of a VACACNY via --
97 -- the Define Recruitment Activity form. --
98 -- Arguments --
99 -- See below. --
100 -- Notes --
101 -- --
102 -----------------------------------------------------------------------------
103 --
104 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
105
106 END PER_RECRUIT_ACTIVITY_FOR_PKG;