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.
PACKAGE BODY: APPS.IRC_PENDING_DATA_BK1

Source


1 package body IRC_PENDING_DATA_BK1 as
2 /* $Header: iripdapi.pkb 120.15 2008/01/21 14:58:20 generated noship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2008/11/06 00:45:36 (YYYY/MM/DD HH24:MI:SS)
5 procedure CREATE_PENDING_DATA_A
6 (P_EMAIL_ADDRESS in VARCHAR2
7 ,P_LAST_NAME in VARCHAR2
8 ,P_VACANCY_ID in NUMBER
9 ,P_FIRST_NAME in VARCHAR2
10 ,P_USER_PASSWORD in VARCHAR2
11 ,P_RESUME_FILE_NAME in VARCHAR2
12 ,P_RESUME_DESCRIPTION in VARCHAR2
13 ,P_RESUME_MIME_TYPE in VARCHAR2
14 ,P_SOURCE_TYPE in VARCHAR2
15 ,P_JOB_POST_SOURCE_NAME in VARCHAR2
16 ,P_POSTING_CONTENT_ID in NUMBER
17 ,P_PERSON_ID in NUMBER
18 ,P_PROCESSED in VARCHAR2
19 ,P_SEX in VARCHAR2
20 ,P_DATE_OF_BIRTH in DATE
21 ,P_PER_INFORMATION_CATEGORY in VARCHAR2
22 ,P_PER_INFORMATION1 in VARCHAR2
23 ,P_PER_INFORMATION2 in VARCHAR2
24 ,P_PER_INFORMATION3 in VARCHAR2
25 ,P_PER_INFORMATION4 in VARCHAR2
26 ,P_PER_INFORMATION5 in VARCHAR2
27 ,P_PER_INFORMATION6 in VARCHAR2
28 ,P_PER_INFORMATION7 in VARCHAR2
29 ,P_PER_INFORMATION8 in VARCHAR2
30 ,P_PER_INFORMATION9 in VARCHAR2
31 ,P_PER_INFORMATION10 in VARCHAR2
32 ,P_PER_INFORMATION11 in VARCHAR2
33 ,P_PER_INFORMATION12 in VARCHAR2
34 ,P_PER_INFORMATION13 in VARCHAR2
35 ,P_PER_INFORMATION14 in VARCHAR2
36 ,P_PER_INFORMATION15 in VARCHAR2
37 ,P_PER_INFORMATION16 in VARCHAR2
38 ,P_PER_INFORMATION17 in VARCHAR2
39 ,P_PER_INFORMATION18 in VARCHAR2
40 ,P_PER_INFORMATION19 in VARCHAR2
41 ,P_PER_INFORMATION20 in VARCHAR2
42 ,P_PER_INFORMATION21 in VARCHAR2
43 ,P_PER_INFORMATION22 in VARCHAR2
44 ,P_PER_INFORMATION23 in VARCHAR2
45 ,P_PER_INFORMATION24 in VARCHAR2
46 ,P_PER_INFORMATION25 in VARCHAR2
47 ,P_PER_INFORMATION26 in VARCHAR2
48 ,P_PER_INFORMATION27 in VARCHAR2
49 ,P_PER_INFORMATION28 in VARCHAR2
50 ,P_PER_INFORMATION29 in VARCHAR2
51 ,P_PER_INFORMATION30 in VARCHAR2
52 ,P_ERROR_MESSAGE in VARCHAR2
53 ,P_CREATION_DATE in DATE
54 ,P_LAST_UPDATE_DATE in DATE
55 ,P_ALLOW_ACCESS in VARCHAR2
56 ,P_VISITOR_RESP_KEY in VARCHAR2
57 ,P_VISITOR_RESP_APPL_ID in NUMBER
58 ,P_SECURITY_GROUP_KEY in VARCHAR2
59 )is
60 l_commit_unit_number number;
61 l_legislation_code   varchar2(30);
62 begin
63 hr_utility.set_location('Entering: IRC_PENDING_DATA_BK1.CREATE_PENDING_DATA_A', 10);
64 l_commit_unit_number := hr_api.return_commit_unit;
65 if hr_api.call_app_hooks then
66 irc_pending_data_be1.CREATE_PENDING_DATA_A
67 (P_EMAIL_ADDRESS => P_EMAIL_ADDRESS
68 ,P_LAST_NAME => P_LAST_NAME
69 ,P_VACANCY_ID => P_VACANCY_ID
70 ,P_FIRST_NAME => P_FIRST_NAME
71 ,P_USER_PASSWORD => P_USER_PASSWORD
72 ,P_RESUME_FILE_NAME => P_RESUME_FILE_NAME
73 ,P_RESUME_DESCRIPTION => P_RESUME_DESCRIPTION
74 ,P_RESUME_MIME_TYPE => P_RESUME_MIME_TYPE
75 ,P_SOURCE_TYPE => P_SOURCE_TYPE
76 ,P_JOB_POST_SOURCE_NAME => P_JOB_POST_SOURCE_NAME
77 ,P_POSTING_CONTENT_ID => P_POSTING_CONTENT_ID
78 ,P_PERSON_ID => P_PERSON_ID
79 ,P_PROCESSED => P_PROCESSED
80 ,P_SEX => P_SEX
81 ,P_DATE_OF_BIRTH => P_DATE_OF_BIRTH
82 ,P_PER_INFORMATION_CATEGORY => P_PER_INFORMATION_CATEGORY
83 ,P_PER_INFORMATION1 => P_PER_INFORMATION1
84 ,P_PER_INFORMATION2 => P_PER_INFORMATION2
85 ,P_PER_INFORMATION3 => P_PER_INFORMATION3
86 ,P_PER_INFORMATION4 => P_PER_INFORMATION4
87 ,P_PER_INFORMATION5 => P_PER_INFORMATION5
88 ,P_PER_INFORMATION6 => P_PER_INFORMATION6
89 ,P_PER_INFORMATION7 => P_PER_INFORMATION7
90 ,P_PER_INFORMATION8 => P_PER_INFORMATION8
91 ,P_PER_INFORMATION9 => P_PER_INFORMATION9
92 ,P_PER_INFORMATION10 => P_PER_INFORMATION10
93 ,P_PER_INFORMATION11 => P_PER_INFORMATION11
94 ,P_PER_INFORMATION12 => P_PER_INFORMATION12
95 ,P_PER_INFORMATION13 => P_PER_INFORMATION13
96 ,P_PER_INFORMATION14 => P_PER_INFORMATION14
97 ,P_PER_INFORMATION15 => P_PER_INFORMATION15
98 ,P_PER_INFORMATION16 => P_PER_INFORMATION16
99 ,P_PER_INFORMATION17 => P_PER_INFORMATION17
100 ,P_PER_INFORMATION18 => P_PER_INFORMATION18
101 ,P_PER_INFORMATION19 => P_PER_INFORMATION19
102 ,P_PER_INFORMATION20 => P_PER_INFORMATION20
103 ,P_PER_INFORMATION21 => P_PER_INFORMATION21
104 ,P_PER_INFORMATION22 => P_PER_INFORMATION22
105 ,P_PER_INFORMATION23 => P_PER_INFORMATION23
106 ,P_PER_INFORMATION24 => P_PER_INFORMATION24
107 ,P_PER_INFORMATION25 => P_PER_INFORMATION25
108 ,P_PER_INFORMATION26 => P_PER_INFORMATION26
109 ,P_PER_INFORMATION27 => P_PER_INFORMATION27
110 ,P_PER_INFORMATION28 => P_PER_INFORMATION28
111 ,P_PER_INFORMATION29 => P_PER_INFORMATION29
112 ,P_PER_INFORMATION30 => P_PER_INFORMATION30
113 ,P_ERROR_MESSAGE => P_ERROR_MESSAGE
114 ,P_CREATION_DATE => P_CREATION_DATE
115 ,P_LAST_UPDATE_DATE => P_LAST_UPDATE_DATE
116 ,P_ALLOW_ACCESS => P_ALLOW_ACCESS
117 ,P_VISITOR_RESP_KEY => P_VISITOR_RESP_KEY
118 ,P_VISITOR_RESP_APPL_ID => P_VISITOR_RESP_APPL_ID
119 ,P_SECURITY_GROUP_KEY => P_SECURITY_GROUP_KEY
120 );
121 end if;
122 hr_multi_message.end_validation_set;
123 hr_api.validate_commit_unit(l_commit_unit_number, 'CREATE_PENDING_DATA', 'AP');
124 hr_utility.set_location(' Leaving: IRC_PENDING_DATA_BK1.CREATE_PENDING_DATA_A', 20);
125 end CREATE_PENDING_DATA_A;
126 procedure CREATE_PENDING_DATA_B
127 (P_EMAIL_ADDRESS in VARCHAR2
128 ,P_LAST_NAME in VARCHAR2
129 ,P_VACANCY_ID in NUMBER
130 ,P_FIRST_NAME in VARCHAR2
131 ,P_USER_PASSWORD in VARCHAR2
132 ,P_RESUME_FILE_NAME in VARCHAR2
133 ,P_RESUME_DESCRIPTION in VARCHAR2
134 ,P_RESUME_MIME_TYPE in VARCHAR2
135 ,P_SOURCE_TYPE in VARCHAR2
136 ,P_JOB_POST_SOURCE_NAME in VARCHAR2
137 ,P_POSTING_CONTENT_ID in NUMBER
138 ,P_PERSON_ID in NUMBER
139 ,P_PROCESSED in VARCHAR2
140 ,P_SEX in VARCHAR2
141 ,P_DATE_OF_BIRTH in DATE
142 ,P_PER_INFORMATION_CATEGORY in VARCHAR2
143 ,P_PER_INFORMATION1 in VARCHAR2
144 ,P_PER_INFORMATION2 in VARCHAR2
145 ,P_PER_INFORMATION3 in VARCHAR2
146 ,P_PER_INFORMATION4 in VARCHAR2
147 ,P_PER_INFORMATION5 in VARCHAR2
148 ,P_PER_INFORMATION6 in VARCHAR2
149 ,P_PER_INFORMATION7 in VARCHAR2
150 ,P_PER_INFORMATION8 in VARCHAR2
151 ,P_PER_INFORMATION9 in VARCHAR2
152 ,P_PER_INFORMATION10 in VARCHAR2
153 ,P_PER_INFORMATION11 in VARCHAR2
154 ,P_PER_INFORMATION12 in VARCHAR2
155 ,P_PER_INFORMATION13 in VARCHAR2
156 ,P_PER_INFORMATION14 in VARCHAR2
157 ,P_PER_INFORMATION15 in VARCHAR2
158 ,P_PER_INFORMATION16 in VARCHAR2
159 ,P_PER_INFORMATION17 in VARCHAR2
160 ,P_PER_INFORMATION18 in VARCHAR2
161 ,P_PER_INFORMATION19 in VARCHAR2
162 ,P_PER_INFORMATION20 in VARCHAR2
163 ,P_PER_INFORMATION21 in VARCHAR2
164 ,P_PER_INFORMATION22 in VARCHAR2
165 ,P_PER_INFORMATION23 in VARCHAR2
166 ,P_PER_INFORMATION24 in VARCHAR2
167 ,P_PER_INFORMATION25 in VARCHAR2
168 ,P_PER_INFORMATION26 in VARCHAR2
169 ,P_PER_INFORMATION27 in VARCHAR2
170 ,P_PER_INFORMATION28 in VARCHAR2
171 ,P_PER_INFORMATION29 in VARCHAR2
172 ,P_PER_INFORMATION30 in VARCHAR2
173 ,P_ERROR_MESSAGE in VARCHAR2
174 ,P_CREATION_DATE in DATE
175 ,P_LAST_UPDATE_DATE in DATE
176 ,P_ALLOW_ACCESS in VARCHAR2
177 ,P_VISITOR_RESP_KEY in VARCHAR2
178 ,P_VISITOR_RESP_APPL_ID in NUMBER
179 ,P_SECURITY_GROUP_KEY in VARCHAR2
180 )is
181 begin
182 hr_utility.set_location('Entering: IRC_PENDING_DATA_BK1.CREATE_PENDING_DATA_B', 10);
183 hr_utility.set_location(' Leaving: IRC_PENDING_DATA_BK1.CREATE_PENDING_DATA_B', 20);
184 end CREATE_PENDING_DATA_B;
185 end IRC_PENDING_DATA_BK1;