1 PACKAGE igs_ad_recruitments_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSAI87S.pls 115.8 2002/11/28 22:18:44 nsidana ship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 x_CERTAINTY_OF_CHOICE_ID IN NUMBER,
6 x_RELIGION_CD IN VARCHAR2,
7 x_ADV_STUDIES_CLASSES IN NUMBER,
8 x_HONORS_CLASSES IN NUMBER,
9 x_CLASS_SIZE IN NUMBER,
10 x_SEC_SCHOOL_LOCATION_ID IN NUMBER,
11 x_PERCENT_PLAN_HIGHER_EDU IN NUMBER,
12 x_RECRUITMENT_ID IN OUT NOCOPY NUMBER,
13 x_PERSON_ID IN NUMBER,
14 x_SPECIAL_INTEREST_ID IN NUMBER,
15 x_PRIORITY IN VARCHAR2,
16 x_VIP IN VARCHAR2,
17 x_DEACTIVATE_RECRUIT_STATUS IN VARCHAR2,
18 x_PROGRAM_INTEREST_ID IN NUMBER,
19 x_INSTITUTION_SIZE_ID IN NUMBER,
20 x_INSTITUTION_CONTROL_ID IN NUMBER,
21 x_INSTITUTION_SETTING_ID IN NUMBER,
22 x_INSTITUTION_LOCATION_ID IN NUMBER,
23 x_SPECIAL_SERVICES_ID IN NUMBER,
24 x_EMPLOYMENT_ID IN NUMBER,
25 x_HOUSING_ID IN NUMBER,
26 x_DEGREE_GOAL_ID IN NUMBER,
27 x_UNIT_SET_ID IN NUMBER,
28 X_MODE in VARCHAR2 default 'R'
29 );
30
31 procedure LOCK_ROW (
32 X_ROWID in VARCHAR2,
33 x_CERTAINTY_OF_CHOICE_ID IN NUMBER,
34 x_RELIGION_CD IN VARCHAR2,
35 x_ADV_STUDIES_CLASSES IN NUMBER,
36 x_HONORS_CLASSES IN NUMBER,
37 x_CLASS_SIZE IN NUMBER,
38 x_SEC_SCHOOL_LOCATION_ID IN NUMBER,
39 x_PERCENT_PLAN_HIGHER_EDU IN NUMBER,
40 x_RECRUITMENT_ID IN NUMBER,
41 x_PERSON_ID IN NUMBER,
42 x_SPECIAL_INTEREST_ID IN NUMBER,
43 x_PRIORITY IN VARCHAR2,
44 x_VIP IN VARCHAR2,
45 x_DEACTIVATE_RECRUIT_STATUS IN VARCHAR2,
46 x_PROGRAM_INTEREST_ID IN NUMBER,
47 x_INSTITUTION_SIZE_ID IN NUMBER,
48 x_INSTITUTION_CONTROL_ID IN NUMBER,
49 x_INSTITUTION_SETTING_ID IN NUMBER,
50 x_INSTITUTION_LOCATION_ID IN NUMBER,
51 x_SPECIAL_SERVICES_ID IN NUMBER,
52 x_EMPLOYMENT_ID IN NUMBER,
53 x_HOUSING_ID IN NUMBER,
54 x_DEGREE_GOAL_ID IN NUMBER,
55 x_UNIT_SET_ID IN NUMBER );
56
57 procedure UPDATE_ROW (
58 X_ROWID in VARCHAR2,
59 x_CERTAINTY_OF_CHOICE_ID IN NUMBER,
60 x_RELIGION_CD IN VARCHAR2,
61 x_ADV_STUDIES_CLASSES IN NUMBER,
62 x_HONORS_CLASSES IN NUMBER,
63 x_CLASS_SIZE IN NUMBER,
64 x_SEC_SCHOOL_LOCATION_ID IN NUMBER,
65 x_PERCENT_PLAN_HIGHER_EDU IN NUMBER,
66 x_RECRUITMENT_ID IN NUMBER,
67 x_PERSON_ID IN NUMBER,
68 x_SPECIAL_INTEREST_ID IN NUMBER,
69 x_PRIORITY IN VARCHAR2,
70 x_VIP IN VARCHAR2,
71 x_DEACTIVATE_RECRUIT_STATUS IN VARCHAR2,
72 x_PROGRAM_INTEREST_ID IN NUMBER,
73 x_INSTITUTION_SIZE_ID IN NUMBER,
74 x_INSTITUTION_CONTROL_ID IN NUMBER,
75 x_INSTITUTION_SETTING_ID IN NUMBER,
76 x_INSTITUTION_LOCATION_ID IN NUMBER,
77 x_SPECIAL_SERVICES_ID IN NUMBER,
78 x_EMPLOYMENT_ID IN NUMBER,
79 x_HOUSING_ID IN NUMBER,
80 x_DEGREE_GOAL_ID IN NUMBER,
81 x_UNIT_SET_ID IN NUMBER,
82 X_MODE in VARCHAR2 default 'R'
83 );
84
85 procedure ADD_ROW (
86 X_ROWID in out NOCOPY VARCHAR2,
87 x_CERTAINTY_OF_CHOICE_ID IN NUMBER,
88 x_RELIGION_CD IN VARCHAR2,
89 x_ADV_STUDIES_CLASSES IN NUMBER,
90 x_HONORS_CLASSES IN NUMBER,
91 x_CLASS_SIZE IN NUMBER,
92 x_SEC_SCHOOL_LOCATION_ID IN NUMBER,
93 x_PERCENT_PLAN_HIGHER_EDU IN NUMBER,
94 x_RECRUITMENT_ID IN OUT NOCOPY NUMBER,
95 x_PERSON_ID IN NUMBER,
96 x_SPECIAL_INTEREST_ID IN NUMBER,
97 x_PRIORITY IN VARCHAR2,
98 x_VIP IN VARCHAR2,
99 x_DEACTIVATE_RECRUIT_STATUS IN VARCHAR2,
100 x_PROGRAM_INTEREST_ID IN NUMBER,
101 x_INSTITUTION_SIZE_ID IN NUMBER,
102 x_INSTITUTION_CONTROL_ID IN NUMBER,
103 x_INSTITUTION_SETTING_ID IN NUMBER,
104 x_INSTITUTION_LOCATION_ID IN NUMBER,
105 x_SPECIAL_SERVICES_ID IN NUMBER,
106 x_EMPLOYMENT_ID IN NUMBER,
107 x_HOUSING_ID IN NUMBER,
108 x_DEGREE_GOAL_ID IN NUMBER,
109 x_UNIT_SET_ID IN NUMBER,
110 X_MODE in VARCHAR2 default 'R'
111 ) ;
112
113 procedure DELETE_ROW (
114 X_ROWID in VARCHAR2
115 ) ;
116 FUNCTION Get_PK_For_Validation (
117 x_recruitment_id IN NUMBER
118 ) RETURN BOOLEAN ;
119
120 FUNCTION Get_UK_For_Validation (
121 x_person_id IN NUMBER
122 ) RETURN BOOLEAN;
123
124 PROCEDURE Get_FK_Igs_Ad_Code_Classes (
125 x_code_id IN NUMBER
126 );
127
128 PROCEDURE Get_FK_Igs_Pe_Person (
129 x_person_id IN NUMBER
130 );
131
132 PROCEDURE Check_Constraints (
133 Column_Name IN VARCHAR2 DEFAULT NULL,
134 Column_Value IN VARCHAR2 DEFAULT NULL ) ;
135 PROCEDURE Before_DML (
136 p_action IN VARCHAR2,
137 x_rowid IN VARCHAR2 DEFAULT NULL,
138 x_certainty_of_choice_id IN NUMBER DEFAULT NULL,
139 x_religion_cd IN VARCHAR2 DEFAULT NULL,
140 x_adv_studies_classes IN NUMBER DEFAULT NULL,
141 x_honors_classes IN NUMBER DEFAULT NULL,
142 x_class_size IN NUMBER DEFAULT NULL,
143 x_sec_school_location_id IN NUMBER DEFAULT NULL,
144 x_percent_plan_higher_edu IN NUMBER DEFAULT NULL,
145 x_recruitment_id IN NUMBER DEFAULT NULL,
146 x_person_id IN NUMBER DEFAULT NULL,
147 x_special_interest_id IN NUMBER DEFAULT NULL,
148 x_priority IN VARCHAR2 DEFAULT NULL,
149 x_vip IN VARCHAR2 DEFAULT NULL,
150 x_deactivate_recruit_status IN VARCHAR2 DEFAULT NULL,
151 x_program_interest_id IN NUMBER DEFAULT NULL,
152 x_institution_size_id IN NUMBER DEFAULT NULL,
153 x_institution_control_id IN NUMBER DEFAULT NULL,
154 x_institution_setting_id IN NUMBER DEFAULT NULL,
155 x_institution_location_id IN NUMBER DEFAULT NULL,
156 x_special_services_id IN NUMBER DEFAULT NULL,
157 x_employment_id IN NUMBER DEFAULT NULL,
158 x_housing_id IN NUMBER DEFAULT NULL,
159 x_degree_goal_id IN NUMBER DEFAULT NULL,
160 x_unit_set_id IN NUMBER DEFAULT NULL,
161 x_creation_date IN DATE DEFAULT NULL,
162 x_created_by IN NUMBER DEFAULT NULL,
163 x_last_update_date IN DATE DEFAULT NULL,
164 x_last_updated_by IN NUMBER DEFAULT NULL,
165 x_last_update_login IN NUMBER DEFAULT NULL
166 );
167 END igs_ad_recruitments_pkg;