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.IRC_APPROVALS dependencies on IRC_APPROVALS

Line 1: Package BODY IRC_APPROVALS as

1: Package BODY IRC_APPROVALS as
2: /* $Header: ircame.pkb 120.22.12020000.2 2012/12/13 06:13:57 serrabha ship $ */
3:
4: g_posting_path varchar2(250) :=
5: '/Transaction/TransCache/AM/TXN/EO/IrcPostingContentsVlEORow';

Line 33: irc_approvals.log('Entering get_transaction_data for transaction_id :' || p_transaction_id || ':');

29: where transaction_id = p_transaction_id;
30: --
31: begin
32: --
33: irc_approvals.log('Entering get_transaction_data for transaction_id :' || p_transaction_id || ':');
34: irc_approvals.log('Access path :' || p_path || ':');
35: --
36: open get_doc;
37: fetch get_doc into transactionDoc;

Line 34: irc_approvals.log('Access path :' || p_path || ':');

30: --
31: begin
32: --
33: irc_approvals.log('Entering get_transaction_data for transaction_id :' || p_transaction_id || ':');
34: irc_approvals.log('Access path :' || p_path || ':');
35: --
36: open get_doc;
37: fetch get_doc into transactionDoc;
38: if get_doc %notfound then

Line 46: irc_approvals.log('Exiting get_transaction_data returning :' || l_retval || ':');

42: close get_doc;
43: l_retval:=irc_xml_util.valueOf(transactionDoc,p_path);
44: end if;
45: --
46: irc_approvals.log('Exiting get_transaction_data returning :' || l_retval || ':');
47: --
48: return l_retval;
49: --
50: end get_transaction_data;

Line 65: irc_approvals.log('Entering get_transaction_number_data');

61: ln_retval number;
62: --
63: begin
64: --
65: irc_approvals.log('Entering get_transaction_number_data');
66: --
67: l_retval:=irc_approvals.get_transaction_data
68: (p_transaction_id =>transaction_id
69: ,p_path =>p_path);

Line 67: l_retval:=irc_approvals.get_transaction_data

63: begin
64: --
65: irc_approvals.log('Entering get_transaction_number_data');
66: --
67: l_retval:=irc_approvals.get_transaction_data
68: (p_transaction_id =>transaction_id
69: ,p_path =>p_path);
70: ln_retval:=to_number(l_retval);
71: --

Line 72: irc_approvals.log('Exiting get_transaction_number_data');

68: (p_transaction_id =>transaction_id
69: ,p_path =>p_path);
70: ln_retval:=to_number(l_retval);
71: --
72: irc_approvals.log('Exiting get_transaction_number_data');
73: --
74: return ln_retval;
75: end get_transaction_number_data;
76: --

Line 85: irc_approvals.log('Entering get_posting_content_id');

81: return number is
82: l_retval number;
83: begin
84: --
85: irc_approvals.log('Entering get_posting_content_id');
86: --
87: l_retval:=irc_approvals.get_transaction_number_data
88: (transaction_id=>transaction_id,p_path => g_posting_path || '/' || data_name);
89: --

Line 87: l_retval:=irc_approvals.get_transaction_number_data

83: begin
84: --
85: irc_approvals.log('Entering get_posting_content_id');
86: --
87: l_retval:=irc_approvals.get_transaction_number_data
88: (transaction_id=>transaction_id,p_path => g_posting_path || '/' || data_name);
89: --
90: irc_approvals.log('Exiting get_posting_content_id');
91: --

Line 90: irc_approvals.log('Exiting get_posting_content_id');

86: --
87: l_retval:=irc_approvals.get_transaction_number_data
88: (transaction_id=>transaction_id,p_path => g_posting_path || '/' || data_name);
89: --
90: irc_approvals.log('Exiting get_posting_content_id');
91: --
92: return l_retval;
93: end get_posting_data_number;
94: --

Line 103: irc_approvals.log('Entering get_posting_content_id');

99: return varchar2 is
100: l_retval varchar2(32000);
101: begin
102: --
103: irc_approvals.log('Entering get_posting_content_id');
104: --
105: l_retval:=irc_approvals.get_transaction_data
106: (p_transaction_id=>transaction_id,p_path => g_posting_path || '/' || data_name);
107: --

Line 105: l_retval:=irc_approvals.get_transaction_data

101: begin
102: --
103: irc_approvals.log('Entering get_posting_content_id');
104: --
105: l_retval:=irc_approvals.get_transaction_data
106: (p_transaction_id=>transaction_id,p_path => g_posting_path || '/' || data_name);
107: --
108: irc_approvals.log('Exiting get_posting_content_id');
109: --

Line 108: irc_approvals.log('Exiting get_posting_content_id');

104: --
105: l_retval:=irc_approvals.get_transaction_data
106: (p_transaction_id=>transaction_id,p_path => g_posting_path || '/' || data_name);
107: --
108: irc_approvals.log('Exiting get_posting_content_id');
109: --
110: return l_retval;
111: end get_posting_data_varchar;
112: --

Line 121: irc_approvals.log('Entering get_vac_business_group_id');

117: return number is
118: l_retval number;
119: begin
120: --
121: irc_approvals.log('Entering get_vac_business_group_id');
122: --
123: l_retval:=irc_approvals.get_transaction_number_data
124: (transaction_id=>transaction_id
125: ,p_path => g_vacancy_path || '/' || data_name);

Line 123: l_retval:=irc_approvals.get_transaction_number_data

119: begin
120: --
121: irc_approvals.log('Entering get_vac_business_group_id');
122: --
123: l_retval:=irc_approvals.get_transaction_number_data
124: (transaction_id=>transaction_id
125: ,p_path => g_vacancy_path || '/' || data_name);
126: --
127: irc_approvals.log('Exiting get_vac_business_group_id');

Line 127: irc_approvals.log('Exiting get_vac_business_group_id');

123: l_retval:=irc_approvals.get_transaction_number_data
124: (transaction_id=>transaction_id
125: ,p_path => g_vacancy_path || '/' || data_name);
126: --
127: irc_approvals.log('Exiting get_vac_business_group_id');
128: --
129: return l_retval;
130: end get_vacancy_data_number;
131: --

Line 140: irc_approvals.log('Entering get_vac_budget_type');

136: return varchar2 is
137: l_retval varchar2(200);
138: begin
139: --
140: irc_approvals.log('Entering get_vac_budget_type');
141: --
142: l_retval:=irc_approvals.get_transaction_data
143: (p_transaction_id=>transaction_id
144: ,p_path => g_vacancy_path || '/' || data_name);

Line 142: l_retval:=irc_approvals.get_transaction_data

138: begin
139: --
140: irc_approvals.log('Entering get_vac_budget_type');
141: --
142: l_retval:=irc_approvals.get_transaction_data
143: (p_transaction_id=>transaction_id
144: ,p_path => g_vacancy_path || '/' || data_name);
145: --
146: irc_approvals.log('Exiting get_vac_budget_type');

Line 146: irc_approvals.log('Exiting get_vac_budget_type');

142: l_retval:=irc_approvals.get_transaction_data
143: (p_transaction_id=>transaction_id
144: ,p_path => g_vacancy_path || '/' || data_name);
145: --
146: irc_approvals.log('Exiting get_vac_budget_type');
147: --
148: return l_retval;
149: end get_vacancy_data_varchar;
150: --

Line 159: irc_approvals.log('Entering get_search_data_number');

155: return number is
156: l_retval number;
157: begin
158: --
159: irc_approvals.log('Entering get_search_data_number');
160: --
161: l_retval:=irc_approvals.get_transaction_number_data
162: (transaction_id=>transaction_id,p_path => g_search_path || '/' || data_name);
163: --

Line 161: l_retval:=irc_approvals.get_transaction_number_data

157: begin
158: --
159: irc_approvals.log('Entering get_search_data_number');
160: --
161: l_retval:=irc_approvals.get_transaction_number_data
162: (transaction_id=>transaction_id,p_path => g_search_path || '/' || data_name);
163: --
164: irc_approvals.log('Exiting get_search_data_number');
165: --

Line 164: irc_approvals.log('Exiting get_search_data_number');

160: --
161: l_retval:=irc_approvals.get_transaction_number_data
162: (transaction_id=>transaction_id,p_path => g_search_path || '/' || data_name);
163: --
164: irc_approvals.log('Exiting get_search_data_number');
165: --
166: return l_retval;
167: end get_search_data_number;
168: --

Line 177: irc_approvals.log('Entering get_search_data_varchar');

173: return varchar2 is
174: l_retval varchar2(200);
175: begin
176: --
177: irc_approvals.log('Entering get_search_data_varchar');
178: --
179: l_retval:=irc_approvals.get_transaction_data
180: (p_transaction_id=>transaction_id,p_path => g_search_path || '/' || data_name);
181: --

Line 179: l_retval:=irc_approvals.get_transaction_data

175: begin
176: --
177: irc_approvals.log('Entering get_search_data_varchar');
178: --
179: l_retval:=irc_approvals.get_transaction_data
180: (p_transaction_id=>transaction_id,p_path => g_search_path || '/' || data_name);
181: --
182: irc_approvals.log('Exiting get_search_data_varchar');
183: --

Line 182: irc_approvals.log('Exiting get_search_data_varchar');

178: --
179: l_retval:=irc_approvals.get_transaction_data
180: (p_transaction_id=>transaction_id,p_path => g_search_path || '/' || data_name);
181: --
182: irc_approvals.log('Exiting get_search_data_varchar');
183: --
184: return l_retval;
185: end get_search_data_varchar;
186: --

Line 198: irc_approvals.log('Entering get_transaction_mode');

194: --
195: l_retval varchar2(200);
196: begin
197: --
198: irc_approvals.log('Entering get_transaction_mode');
199: --
200: l_retval:=irc_approvals.get_transaction_data
201: (p_transaction_id=>transaction_id
202: ,p_path => '/Transaction/TransCtx/CNode/dmlMode');

Line 200: l_retval:=irc_approvals.get_transaction_data

196: begin
197: --
198: irc_approvals.log('Entering get_transaction_mode');
199: --
200: l_retval:=irc_approvals.get_transaction_data
201: (p_transaction_id=>transaction_id
202: ,p_path => '/Transaction/TransCtx/CNode/dmlMode');
203: --
204: irc_approvals.log('Exiting get_transaction_mode');

Line 204: irc_approvals.log('Exiting get_transaction_mode');

200: l_retval:=irc_approvals.get_transaction_data
201: (p_transaction_id=>transaction_id
202: ,p_path => '/Transaction/TransCtx/CNode/dmlMode');
203: --
204: irc_approvals.log('Exiting get_transaction_mode');
205: --
206: return l_retval;
207: end get_transaction_mode;
208: --

Line 218: return irc_approvals.get_vacancy_data_number(transaction_id, 'VacancyId');

214: function get_vacancy_id
215: (transaction_id in varchar2)
216: return number is
217: BEGIN
218: return irc_approvals.get_vacancy_data_number(transaction_id, 'VacancyId');
219: end get_vacancy_id;
220: --
221: -- -------------------------------------------------------------------------
222: -- |----------------------< get_posting_content_id >-----------------------|

Line 229: return irc_approvals.get_posting_data_number(transaction_id, 'PostingContentId');

225: function get_posting_content_id
226: (transaction_id in varchar2)
227: return number is
228: begin
229: return irc_approvals.get_posting_data_number(transaction_id, 'PostingContentId');
230: end get_posting_content_id;
231: --
232: -- -------------------------------------------------------------------------
233: -- |-----------------------< get_vac_business_group_id >-------------------|

Line 240: return irc_approvals.get_vacancy_data_number(transaction_id, 'BusinessGroupId');

236: function get_vac_business_group_id
237: (transaction_id in varchar2)
238: return number is
239: begin
240: return irc_approvals.get_vacancy_data_number(transaction_id, 'BusinessGroupId');
241: end get_vac_business_group_id;
242: --
243: -- -------------------------------------------------------------------------
244: -- |-------------------------< get_vac_organization_id >-------------------|

Line 251: return irc_approvals.get_vacancy_data_number(transaction_id, 'OrganizationId');

247: function get_vac_organization_id
248: (transaction_id in varchar2)
249: return number is
250: begin
251: return irc_approvals.get_vacancy_data_number(transaction_id, 'OrganizationId');
252: end get_vac_organization_id;
253: --
254: -- -------------------------------------------------------------------------
255: -- |----------------------------< get_vac_grade_id >-----------------------|

Line 262: return irc_approvals.get_vacancy_data_number(transaction_id, 'GradeId');

258: function get_vac_grade_id
259: (transaction_id in varchar2)
260: return number is
261: begin
262: return irc_approvals.get_vacancy_data_number(transaction_id, 'GradeId');
263: end get_vac_grade_id;
264: --
265: -- -------------------------------------------------------------------------
266: -- |----------------------------< get_vac_job_id >-------------------------|

Line 273: return irc_approvals.get_vacancy_data_number(transaction_id, 'JobId');

269: function get_vac_job_id
270: (transaction_id in varchar2)
271: return number is
272: begin
273: return irc_approvals.get_vacancy_data_number(transaction_id, 'JobId');
274: end get_vac_job_id;
275: --
276: -- -------------------------------------------------------------------------
277: -- |--------------------------< get_vac_location_id >----------------------|

Line 284: return irc_approvals.get_vacancy_data_number(transaction_id, 'LocationId');

280: function get_vac_location_id
281: (transaction_id in varchar2)
282: return number is
283: begin
284: return irc_approvals.get_vacancy_data_number(transaction_id, 'LocationId');
285: end get_vac_location_id;
286: --
287: -- -------------------------------------------------------------------------
288: -- |--------------------------< get_vac_budget_value >----------------------|

Line 295: return irc_approvals.get_vacancy_data_number(transaction_id, 'BudgetMeasurementValue');

291: function get_vac_budget_value
292: (transaction_id in varchar2)
293: return number is
294: begin
295: return irc_approvals.get_vacancy_data_number(transaction_id, 'BudgetMeasurementValue');
296: end get_vac_budget_value;
297: --
298: -- -------------------------------------------------------------------------
299: -- |--------------------------< get_vac_budget_type >----------------------|

Line 306: return irc_approvals.get_vacancy_data_varchar(transaction_id, 'BudgetMeasurementType');

302: function get_vac_budget_type
303: (transaction_id in varchar2)
304: return varchar2 is
305: begin
306: return irc_approvals.get_vacancy_data_varchar(transaction_id, 'BudgetMeasurementType');
307: end get_vac_budget_type;
308: --
309: -- -------------------------------------------------------------------------
310: -- |----------------------------< get_vac_status >-------------------------|

Line 317: return irc_approvals.get_vacancy_data_varchar(transaction_id, 'Status');

313: function get_vac_status
314: (transaction_id in varchar2)
315: return varchar2 is
316: begin
317: return irc_approvals.get_vacancy_data_varchar(transaction_id, 'Status');
318: end get_vac_status;
319: --
320: -- -------------------------------------------------------------------------
321: -- |-------------------------< get_vac_professional_area >-----------------|

Line 328: return irc_approvals.get_search_data_varchar(transaction_id, 'ProfessionalArea');

324: function get_vac_professional_area
325: (transaction_id in varchar2)
326: return varchar2 is
327: begin
328: return irc_approvals.get_search_data_varchar(transaction_id, 'ProfessionalArea');
329: end get_vac_professional_area;
330: --
331: -- -------------------------------------------------------------------------
332: -- |-------------------------< get_vac_for_emp >---------------------------|

Line 339: return irc_approvals.get_search_data_varchar(transaction_id, 'Employee');

335: function get_vac_for_emp
336: (transaction_id in varchar2)
337: return varchar2 is
338: begin
339: return irc_approvals.get_search_data_varchar(transaction_id, 'Employee');
340: end get_vac_for_emp;
341: --
342: -- -------------------------------------------------------------------------
343: -- |-------------------------< get_vac_for_con >---------------------------|

Line 350: return irc_approvals.get_search_data_varchar(transaction_id, 'Contractor');

346: function get_vac_for_con
347: (transaction_id in varchar2)
348: return varchar2 is
349: begin
350: return irc_approvals.get_search_data_varchar(transaction_id, 'Contractor');
351: end get_vac_for_con;
352: --
353: -- -------------------------------------------------------------------------
354: -- |--------------------< get_vac_employment_category >--------------------|

Line 361: return irc_approvals.get_search_data_varchar(transaction_id, 'EmploymentCategory');

357: function get_vac_employment_category
358: (transaction_id in varchar2)
359: return varchar2 is
360: begin
361: return irc_approvals.get_search_data_varchar(transaction_id, 'EmploymentCategory');
362: end get_vac_employment_category;
363: --
364: -- -------------------------------------------------------------------------
365: -- |--------------------------< get_vac_min_salary >-----------------------|

Line 372: return irc_approvals.get_search_data_number(transaction_id, 'MinSalary');

368: function get_vac_min_salary
369: (transaction_id in varchar2)
370: return number is
371: begin
372: return irc_approvals.get_search_data_number(transaction_id, 'MinSalary');
373: end get_vac_min_salary;
374: --
375: -- -------------------------------------------------------------------------
376: -- |--------------------------< get_vac_max_salary >-----------------------|

Line 383: return irc_approvals.get_search_data_number(transaction_id, 'MaxSalary');

379: function get_vac_max_salary
380: (transaction_id in varchar2)
381: return number is
382: begin
383: return irc_approvals.get_search_data_number(transaction_id, 'MaxSalary');
384: end get_vac_max_salary;
385: --
386: -- -------------------------------------------------------------------------
387: -- |------------------------< get_salary_currency >------------------------|

Line 394: return irc_approvals.get_search_data_varchar(transaction_id, 'SalaryCurrency');

390: function get_salary_currency
391: (transaction_id in varchar2)
392: return varchar2 is
393: begin
394: return irc_approvals.get_search_data_varchar(transaction_id, 'SalaryCurrency');
395: end get_salary_currency;
396: --
397: -- -------------------------------------------------------------------------
398: -- |--------------------------< get_work_at_home >-------------------------|

Line 405: return irc_approvals.get_search_data_varchar(transaction_id, 'WorkAtHome');

401: function get_work_at_home
402: (transaction_id in varchar2)
403: return varchar2 is
404: begin
405: return irc_approvals.get_search_data_varchar(transaction_id, 'WorkAtHome');
406: end get_work_at_home;
407: --
408: -- -------------------------------------------------------------------------
409: -- |----------------------< get_vac_organization_changed >-----------------|

Line 426: irc_approvals.log('Entering get_vac_organization_changed');

422: from per_all_vacancies
423: where vacancy_id=p_vacancy_id;
424: begin
425: --
426: irc_approvals.log('Entering get_vac_organization_changed');
427: --
428: l_retval := 'false';
429: --
430: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then

Line 430: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then

426: irc_approvals.log('Entering get_vac_organization_changed');
427: --
428: l_retval := 'false';
429: --
430: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
431: --
432: l_new_id := irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'OrganizationId');
433: --
434: l_vacancy_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'VacancyId');

Line 432: l_new_id := irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'OrganizationId');

428: l_retval := 'false';
429: --
430: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
431: --
432: l_new_id := irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'OrganizationId');
433: --
434: l_vacancy_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'VacancyId');
435: open get_old_id(l_vacancy_id);
436: fetch get_old_id into l_old_id;

Line 434: l_vacancy_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'VacancyId');

430: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
431: --
432: l_new_id := irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'OrganizationId');
433: --
434: l_vacancy_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'VacancyId');
435: open get_old_id(l_vacancy_id);
436: fetch get_old_id into l_old_id;
437: close get_old_id;
438: --

Line 439: irc_approvals.log('Comparing old org id :' || to_char(l_old_id)

435: open get_old_id(l_vacancy_id);
436: fetch get_old_id into l_old_id;
437: close get_old_id;
438: --
439: irc_approvals.log('Comparing old org id :' || to_char(l_old_id)
440: || ': to new org id :' || to_char(l_new_id) || ':');
441: --
442: if(nvl(l_new_id,hr_api.g_number)
443: <> nvl(l_old_id,hr_api.g_number) ) then

Line 448: irc_approvals.log('Exiting get_vac_organization_changed returning :' || l_retval || ':');

444: l_retval:='true';
445: end if;
446: end if;
447: --
448: irc_approvals.log('Exiting get_vac_organization_changed returning :' || l_retval || ':');
449: --
450: return l_retval;
451: end get_vac_organization_changed;
452: --

Line 471: irc_approvals.log('Entering get_vac_job_changed');

467: from per_all_vacancies
468: where vacancy_id=p_vacancy_id;
469: begin
470: --
471: irc_approvals.log('Entering get_vac_job_changed');
472: --
473: l_retval := 'false';
474: --
475: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then

Line 475: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then

471: irc_approvals.log('Entering get_vac_job_changed');
472: --
473: l_retval := 'false';
474: --
475: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
476: l_vacancy_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'VacancyId');
477: l_new_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'JobId');
478: open get_old_id(l_vacancy_id);
479: fetch get_old_id into l_old_id;

Line 476: l_vacancy_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'VacancyId');

472: --
473: l_retval := 'false';
474: --
475: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
476: l_vacancy_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'VacancyId');
477: l_new_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'JobId');
478: open get_old_id(l_vacancy_id);
479: fetch get_old_id into l_old_id;
480: close get_old_id;

Line 477: l_new_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'JobId');

473: l_retval := 'false';
474: --
475: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
476: l_vacancy_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'VacancyId');
477: l_new_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'JobId');
478: open get_old_id(l_vacancy_id);
479: fetch get_old_id into l_old_id;
480: close get_old_id;
481: --

Line 482: irc_approvals.log('Comparing old job id :' || to_char(l_old_id)

478: open get_old_id(l_vacancy_id);
479: fetch get_old_id into l_old_id;
480: close get_old_id;
481: --
482: irc_approvals.log('Comparing old job id :' || to_char(l_old_id)
483: || ': to new job id :' || to_char(l_new_id) || ':');
484: --
485: if(nvl(l_new_id,hr_api.g_number)
486: <> nvl(l_old_id,hr_api.g_number) ) then

Line 491: irc_approvals.log('Exiting get_vac_job_changed returning :' || l_retval || ':');

487: l_retval:='true';
488: end if;
489: end if;
490: --
491: irc_approvals.log('Exiting get_vac_job_changed returning :' || l_retval || ':');
492: --
493: return l_retval;
494: end get_vac_job_changed;
495: --

Line 514: irc_approvals.log('Entering get_vac_grade_changed');

510: from per_all_vacancies
511: where vacancy_id=p_vacancy_id;
512: begin
513: --
514: irc_approvals.log('Entering get_vac_grade_changed');
515: --
516: l_retval := 'false';
517: --
518: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then

Line 518: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then

514: irc_approvals.log('Entering get_vac_grade_changed');
515: --
516: l_retval := 'false';
517: --
518: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
519: --
520: l_new_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'GradeId');
521: --
522: l_vacancy_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'VacancyId');

Line 520: l_new_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'GradeId');

516: l_retval := 'false';
517: --
518: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
519: --
520: l_new_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'GradeId');
521: --
522: l_vacancy_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'VacancyId');
523: open get_old_id(l_vacancy_id);
524: fetch get_old_id into l_old_id;

Line 522: l_vacancy_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'VacancyId');

518: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
519: --
520: l_new_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'GradeId');
521: --
522: l_vacancy_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'VacancyId');
523: open get_old_id(l_vacancy_id);
524: fetch get_old_id into l_old_id;
525: close get_old_id;
526: --

Line 527: irc_approvals.log('Comparing old org id :' || to_char(l_old_id)

523: open get_old_id(l_vacancy_id);
524: fetch get_old_id into l_old_id;
525: close get_old_id;
526: --
527: irc_approvals.log('Comparing old org id :' || to_char(l_old_id)
528: || ': to new org id :' || to_char(l_new_id) || ':');
529: --
530: if(nvl(l_new_id,hr_api.g_number)
531: <> nvl(l_old_id,hr_api.g_number) ) then

Line 537: irc_approvals.log('Exiting get_vac_grade_changed returning :' || l_retval || ':');

533: end if;
534: --
535: end if;
536: --
537: irc_approvals.log('Exiting get_vac_grade_changed returning :' || l_retval || ':');
538: --
539: return l_retval;
540: end get_vac_grade_changed;
541: --

Line 560: irc_approvals.log('Entering get_vac_position_changed');

556: from per_all_vacancies
557: where vacancy_id=p_vacancy_id;
558: begin
559: --
560: irc_approvals.log('Entering get_vac_position_changed');
561: --
562: l_retval := 'false';
563: --
564: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then

Line 564: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then

560: irc_approvals.log('Entering get_vac_position_changed');
561: --
562: l_retval := 'false';
563: --
564: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
565: --
566: l_new_id := irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'PositionId');
567: --
568: l_vacancy_id := irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'VacancyId');

Line 566: l_new_id := irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'PositionId');

562: l_retval := 'false';
563: --
564: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
565: --
566: l_new_id := irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'PositionId');
567: --
568: l_vacancy_id := irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'VacancyId');
569: open get_old_id(l_vacancy_id);
570: fetch get_old_id into l_old_id;

Line 568: l_vacancy_id := irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'VacancyId');

564: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
565: --
566: l_new_id := irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'PositionId');
567: --
568: l_vacancy_id := irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'VacancyId');
569: open get_old_id(l_vacancy_id);
570: fetch get_old_id into l_old_id;
571: close get_old_id;
572: --

Line 573: irc_approvals.log('Comparing old org id :' || to_char(l_old_id)

569: open get_old_id(l_vacancy_id);
570: fetch get_old_id into l_old_id;
571: close get_old_id;
572: --
573: irc_approvals.log('Comparing old org id :' || to_char(l_old_id)
574: || ': to new org id :' || to_char(l_new_id) || ':');
575: --
576: if(nvl(l_new_id,hr_api.g_number)
577: <>nvl(l_old_id,hr_api.g_number) ) then

Line 583: irc_approvals.log('Exiting get_vac_position_changed returning :' || l_retval || ':');

579: end if;
580: --
581: end if;
582: --
583: irc_approvals.log('Exiting get_vac_position_changed returning :' || l_retval || ':');
584: --
585: return l_retval;
586: end get_vac_position_changed;
587: --

Line 606: irc_approvals.log('Entering get_vac_budget_value_changed');

602: from per_all_vacancies
603: where vacancy_id=p_vacancy_id;
604: begin
605: --
606: irc_approvals.log('Entering get_vac_budget_value_changed');
607: --
608: l_retval := 'false';
609: --
610: if irc_approvals.get_transaction_mode(transaction_id)<>'INSERT' then

Line 610: if irc_approvals.get_transaction_mode(transaction_id)<>'INSERT' then

606: irc_approvals.log('Entering get_vac_budget_value_changed');
607: --
608: l_retval := 'false';
609: --
610: if irc_approvals.get_transaction_mode(transaction_id)<>'INSERT' then
611: --
612: l_new_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'BudgetMeasurementValue');
613: --
614: l_vacancy_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'VacancyId');

Line 612: l_new_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'BudgetMeasurementValue');

608: l_retval := 'false';
609: --
610: if irc_approvals.get_transaction_mode(transaction_id)<>'INSERT' then
611: --
612: l_new_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'BudgetMeasurementValue');
613: --
614: l_vacancy_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'VacancyId');
615: open get_old_id(l_vacancy_id);
616: fetch get_old_id into l_old_id;

Line 614: l_vacancy_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'VacancyId');

610: if irc_approvals.get_transaction_mode(transaction_id)<>'INSERT' then
611: --
612: l_new_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'BudgetMeasurementValue');
613: --
614: l_vacancy_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'VacancyId');
615: open get_old_id(l_vacancy_id);
616: fetch get_old_id into l_old_id;
617: close get_old_id;
618: --

Line 619: irc_approvals.log('Comparing old org id :' || to_char(l_old_id)

615: open get_old_id(l_vacancy_id);
616: fetch get_old_id into l_old_id;
617: close get_old_id;
618: --
619: irc_approvals.log('Comparing old org id :' || to_char(l_old_id)
620: || ': to new org id :' || to_char(l_new_id) || ':');
621: --
622: if(nvl(l_new_id,hr_api.g_number)
623: <>nvl(l_old_id,hr_api.g_number) ) then

Line 629: irc_approvals.log('Exiting get_vac_budget_value_changed returning :' || l_retval || ':');

625: end if;
626: --
627: end if;
628: --
629: irc_approvals.log('Exiting get_vac_budget_value_changed returning :' || l_retval || ':');
630: --
631: return l_retval;
632: end get_vac_budget_value_changed;
633: --

Line 652: irc_approvals.log('Entering get_vac_budget_type_changed');

648: from per_all_vacancies
649: where vacancy_id=p_vacancy_id;
650: begin
651: --
652: irc_approvals.log('Entering get_vac_budget_type_changed');
653: --
654: l_retval := 'false';
655: --
656: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then

Line 656: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then

652: irc_approvals.log('Entering get_vac_budget_type_changed');
653: --
654: l_retval := 'false';
655: --
656: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
657: --
658: l_new_value:=irc_approvals.get_vacancy_data_varchar(transaction_id=>transaction_id,data_name=>'BudgetMeasurementType');
659: --
660: l_vacancy_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'VacancyId');

Line 658: l_new_value:=irc_approvals.get_vacancy_data_varchar(transaction_id=>transaction_id,data_name=>'BudgetMeasurementType');

654: l_retval := 'false';
655: --
656: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
657: --
658: l_new_value:=irc_approvals.get_vacancy_data_varchar(transaction_id=>transaction_id,data_name=>'BudgetMeasurementType');
659: --
660: l_vacancy_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'VacancyId');
661: open get_old_value(l_vacancy_id);
662: fetch get_old_value into l_old_value;

Line 660: l_vacancy_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'VacancyId');

656: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
657: --
658: l_new_value:=irc_approvals.get_vacancy_data_varchar(transaction_id=>transaction_id,data_name=>'BudgetMeasurementType');
659: --
660: l_vacancy_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'VacancyId');
661: open get_old_value(l_vacancy_id);
662: fetch get_old_value into l_old_value;
663: close get_old_value;
664: --

Line 665: irc_approvals.log('Comparing old org value :' || l_old_value

661: open get_old_value(l_vacancy_id);
662: fetch get_old_value into l_old_value;
663: close get_old_value;
664: --
665: irc_approvals.log('Comparing old org value :' || l_old_value
666: || ': to new org value :' || l_new_value || ':');
667: --
668: if(nvl(l_new_value,hr_api.g_varchar2)
669: <> nvl(l_old_value,hr_api.g_varchar2) ) then

Line 674: irc_approvals.log('Exiting get_vac_budget_type_changed returning :' || l_retval || ':');

670: l_retval:='true';
671: end if;
672: end if;
673: --
674: irc_approvals.log('Exiting get_vac_budget_type_changed returning :' || l_retval || ':');
675: --
676: return l_retval;
677: --
678: end get_vac_budget_type_changed;

Line 698: irc_approvals.log('Entering get_vac_status_changed');

694: from per_all_vacancies
695: where vacancy_id=p_vacancy_id;
696: begin
697: --
698: irc_approvals.log('Entering get_vac_status_changed');
699: --
700: l_retval := 'false';
701: --
702: if irc_approvals.get_transaction_mode(transaction_id)<> 'INSERT' then

Line 702: if irc_approvals.get_transaction_mode(transaction_id)<> 'INSERT' then

698: irc_approvals.log('Entering get_vac_status_changed');
699: --
700: l_retval := 'false';
701: --
702: if irc_approvals.get_transaction_mode(transaction_id)<> 'INSERT' then
703: --
704: l_new_value:=irc_approvals.get_vacancy_data_varchar(transaction_id=>transaction_id,data_name=>'Status');
705: --
706: l_vacancy_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'VacancyId');

Line 704: l_new_value:=irc_approvals.get_vacancy_data_varchar(transaction_id=>transaction_id,data_name=>'Status');

700: l_retval := 'false';
701: --
702: if irc_approvals.get_transaction_mode(transaction_id)<> 'INSERT' then
703: --
704: l_new_value:=irc_approvals.get_vacancy_data_varchar(transaction_id=>transaction_id,data_name=>'Status');
705: --
706: l_vacancy_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'VacancyId');
707: open get_old_value(l_vacancy_id);
708: fetch get_old_value into l_old_value;

Line 706: l_vacancy_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'VacancyId');

702: if irc_approvals.get_transaction_mode(transaction_id)<> 'INSERT' then
703: --
704: l_new_value:=irc_approvals.get_vacancy_data_varchar(transaction_id=>transaction_id,data_name=>'Status');
705: --
706: l_vacancy_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'VacancyId');
707: open get_old_value(l_vacancy_id);
708: fetch get_old_value into l_old_value;
709: close get_old_value;
710: --

Line 711: irc_approvals.log('Comparing old org value :' || l_old_value

707: open get_old_value(l_vacancy_id);
708: fetch get_old_value into l_old_value;
709: close get_old_value;
710: --
711: irc_approvals.log('Comparing old org value :' || l_old_value
712: || ': to new org value :' || l_new_value || ':');
713: --
714: if(nvl(l_new_value,hr_api.g_varchar2)
715: <> nvl(l_old_value,hr_api.g_varchar2) ) then

Line 720: irc_approvals.log('Exiting get_vac_status_changed returning :' || l_retval || ':');

716: l_retval:='true';
717: end if;
718: end if;
719: --
720: irc_approvals.log('Exiting get_vac_status_changed returning :' || l_retval || ':');
721: --
722: return l_retval;
723: end get_vac_status_changed;
724: --

Line 742: irc_approvals.log('Entering get_posting_title_changed');

738: from irc_posting_contents_vl
739: where posting_content_id=p_posting_content_id;
740: begin
741: --
742: irc_approvals.log('Entering get_posting_title_changed');
743: --
744: l_retval := 'false';
745: --
746: if irc_approvals.get_transaction_mode(transaction_id)<> 'INSERT' then

Line 746: if irc_approvals.get_transaction_mode(transaction_id)<> 'INSERT' then

742: irc_approvals.log('Entering get_posting_title_changed');
743: --
744: l_retval := 'false';
745: --
746: if irc_approvals.get_transaction_mode(transaction_id)<> 'INSERT' then
747: --
748: l_posting_content_id := irc_approvals.get_posting_data_number
749: (transaction_id=>transaction_id, data_name=>'PostingContentId');
750: --

Line 748: l_posting_content_id := irc_approvals.get_posting_data_number

744: l_retval := 'false';
745: --
746: if irc_approvals.get_transaction_mode(transaction_id)<> 'INSERT' then
747: --
748: l_posting_content_id := irc_approvals.get_posting_data_number
749: (transaction_id=>transaction_id, data_name=>'PostingContentId');
750: --
751: l_new_value:=irc_approvals.get_posting_data_varchar
752: (transaction_id=>transaction_id, data_name => 'Name');

Line 751: l_new_value:=irc_approvals.get_posting_data_varchar

747: --
748: l_posting_content_id := irc_approvals.get_posting_data_number
749: (transaction_id=>transaction_id, data_name=>'PostingContentId');
750: --
751: l_new_value:=irc_approvals.get_posting_data_varchar
752: (transaction_id=>transaction_id, data_name => 'Name');
753:
754: open get_old_value(l_posting_content_id);
755: fetch get_old_value into l_old_value;

Line 758: irc_approvals.log('Comparing old org value :' || l_old_value

754: open get_old_value(l_posting_content_id);
755: fetch get_old_value into l_old_value;
756: close get_old_value;
757: --
758: irc_approvals.log('Comparing old org value :' || l_old_value
759: || ': to new org value :' || l_new_value || ':');
760: --
761: if(nvl(l_new_value,hr_api.g_varchar2)
762: <> nvl(l_old_value,hr_api.g_varchar2) ) then

Line 767: irc_approvals.log('Exiting get_posting_title_changed returning :' || l_retval || ':');

763: l_retval:='true';
764: end if;
765: end if;
766: --
767: irc_approvals.log('Exiting get_posting_title_changed returning :' || l_retval || ':');
768: --
769: return l_retval;
770: end get_posting_title_changed;
771: --

Line 789: irc_approvals.log('Entering get_posting_job_title_changed');

785: from irc_posting_contents_vl
786: where posting_content_id=p_posting_content_id;
787: begin
788: --
789: irc_approvals.log('Entering get_posting_job_title_changed');
790: --
791: l_retval := 'false';
792: --
793: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then

Line 793: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then

789: irc_approvals.log('Entering get_posting_job_title_changed');
790: --
791: l_retval := 'false';
792: --
793: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
794: --
795: l_posting_content_id := irc_approvals.get_posting_data_number
796: (transaction_id=>transaction_id, data_name=>'PostingContentId');
797: --

Line 795: l_posting_content_id := irc_approvals.get_posting_data_number

791: l_retval := 'false';
792: --
793: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
794: --
795: l_posting_content_id := irc_approvals.get_posting_data_number
796: (transaction_id=>transaction_id, data_name=>'PostingContentId');
797: --
798: l_new_value:=irc_approvals.get_posting_data_varchar
799: (transaction_id=>transaction_id, data_name => 'JobTitle');

Line 798: l_new_value:=irc_approvals.get_posting_data_varchar

794: --
795: l_posting_content_id := irc_approvals.get_posting_data_number
796: (transaction_id=>transaction_id, data_name=>'PostingContentId');
797: --
798: l_new_value:=irc_approvals.get_posting_data_varchar
799: (transaction_id=>transaction_id, data_name => 'JobTitle');
800: --
801: open get_old_value(l_posting_content_id);
802: fetch get_old_value into l_old_value;

Line 805: irc_approvals.log('Comparing old org value :' || l_old_value

801: open get_old_value(l_posting_content_id);
802: fetch get_old_value into l_old_value;
803: close get_old_value;
804: --
805: irc_approvals.log('Comparing old org value :' || l_old_value
806: || ': to new org value :' || l_new_value || ':');
807: --
808: if(nvl(l_new_value,hr_api.g_varchar2)
809: <> nvl(l_old_value,hr_api.g_varchar2) ) then

Line 814: irc_approvals.log('Exiting get_posting_job_title_changed returning :' || l_retval || ':');

810: l_retval:='true';
811: end if;
812: end if;
813: --
814: irc_approvals.log('Exiting get_posting_job_title_changed returning :' || l_retval || ':');
815: --
816: return l_retval;
817: end get_posting_job_title_changed;
818: --

Line 836: irc_approvals.log('Entering get_posting_department_changed');

832: from irc_posting_contents_vl
833: where posting_content_id=p_posting_content_id;
834: begin
835: --
836: irc_approvals.log('Entering get_posting_department_changed');
837: --
838: l_retval := 'false';
839: --
840: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then

Line 840: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then

836: irc_approvals.log('Entering get_posting_department_changed');
837: --
838: l_retval := 'false';
839: --
840: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
841: --
842: l_posting_content_id := irc_approvals.get_posting_data_number
843: (transaction_id=>transaction_id, data_name=>'PostingContentId');
844: --

Line 842: l_posting_content_id := irc_approvals.get_posting_data_number

838: l_retval := 'false';
839: --
840: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
841: --
842: l_posting_content_id := irc_approvals.get_posting_data_number
843: (transaction_id=>transaction_id, data_name=>'PostingContentId');
844: --
845: l_new_value:=irc_approvals.get_posting_data_varchar
846: (transaction_id=>transaction_id, data_name => 'OrgName');

Line 845: l_new_value:=irc_approvals.get_posting_data_varchar

841: --
842: l_posting_content_id := irc_approvals.get_posting_data_number
843: (transaction_id=>transaction_id, data_name=>'PostingContentId');
844: --
845: l_new_value:=irc_approvals.get_posting_data_varchar
846: (transaction_id=>transaction_id, data_name => 'OrgName');
847: --
848: open get_old_value(l_posting_content_id);
849: fetch get_old_value into l_old_value;

Line 852: irc_approvals.log('Comparing old org value :' || l_old_value

848: open get_old_value(l_posting_content_id);
849: fetch get_old_value into l_old_value;
850: close get_old_value;
851: --
852: irc_approvals.log('Comparing old org value :' || l_old_value
853: || ': to new org value :' || l_new_value || ':');
854: --
855: if(nvl(l_new_value,hr_api.g_varchar2)
856: <> nvl(l_old_value,hr_api.g_varchar2) ) then

Line 861: irc_approvals.log('Exiting get_posting_department_changed returning :' || l_retval || ':');

857: l_retval:='true';
858: end if;
859: end if;
860: --
861: irc_approvals.log('Exiting get_posting_department_changed returning :' || l_retval || ':');
862: --
863: return l_retval;
864: end get_posting_department_changed;
865: --

Line 884: irc_approvals.log('Entering get_posting_dept_desc_changed');

880: from irc_posting_contents_vl
881: where posting_content_id=p_posting_content_id;
882: begin
883: --
884: irc_approvals.log('Entering get_posting_dept_desc_changed');
885: --
886: l_retval := 'false';
887: --
888: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then

Line 888: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then

884: irc_approvals.log('Entering get_posting_dept_desc_changed');
885: --
886: l_retval := 'false';
887: --
888: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
889: --
890: l_posting_content_id := irc_approvals.get_posting_data_number
891: (transaction_id=>transaction_id, data_name=>'PostingContentId');
892: --

Line 890: l_posting_content_id := irc_approvals.get_posting_data_number

886: l_retval := 'false';
887: --
888: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
889: --
890: l_posting_content_id := irc_approvals.get_posting_data_number
891: (transaction_id=>transaction_id, data_name=>'PostingContentId');
892: --
893: l_new_value:=irc_approvals.get_posting_data_varchar
894: (transaction_id=>transaction_id, data_name => 'OrgDescription');

Line 893: l_new_value:=irc_approvals.get_posting_data_varchar

889: --
890: l_posting_content_id := irc_approvals.get_posting_data_number
891: (transaction_id=>transaction_id, data_name=>'PostingContentId');
892: --
893: l_new_value:=irc_approvals.get_posting_data_varchar
894: (transaction_id=>transaction_id, data_name => 'OrgDescription');
895: --
896: open get_old_value(l_posting_content_id);
897: fetch get_old_value into l_clob_old_value;

Line 902: irc_approvals.log('Comparing old org value :' || l_old_value

898: close get_old_value;
899: --
900: l_old_value := dbms_lob.substr(l_clob_old_value);
901: --
902: irc_approvals.log('Comparing old org value :' || l_old_value
903: || ': to new org value :' || l_new_value || ':');
904: --
905: if(nvl(l_new_value,hr_api.g_varchar2)
906: <> nvl(l_old_value,hr_api.g_varchar2) ) then

Line 911: irc_approvals.log('Exiting get_posting_dept_desc_changed returning :' || l_retval || ':');

907: l_retval:='true';
908: end if;
909: end if;
910: --
911: irc_approvals.log('Exiting get_posting_dept_desc_changed returning :' || l_retval || ':');
912: --
913: return l_retval;
914: end get_posting_dept_desc_changed;
915: --

Line 934: irc_approvals.log('Entering get_brief_description_changed');

930: from irc_posting_contents_vl
931: where posting_content_id=p_posting_content_id;
932: begin
933: --
934: irc_approvals.log('Entering get_brief_description_changed');
935: --
936: l_retval := 'false';
937: --
938: if irc_approvals.get_transaction_mode(transaction_id)<> 'INSERT' then

Line 938: if irc_approvals.get_transaction_mode(transaction_id)<> 'INSERT' then

934: irc_approvals.log('Entering get_brief_description_changed');
935: --
936: l_retval := 'false';
937: --
938: if irc_approvals.get_transaction_mode(transaction_id)<> 'INSERT' then
939: --
940: l_posting_content_id := irc_approvals.get_posting_data_number
941: (transaction_id=>transaction_id, data_name=>'PostingContentId');
942: --

Line 940: l_posting_content_id := irc_approvals.get_posting_data_number

936: l_retval := 'false';
937: --
938: if irc_approvals.get_transaction_mode(transaction_id)<> 'INSERT' then
939: --
940: l_posting_content_id := irc_approvals.get_posting_data_number
941: (transaction_id=>transaction_id, data_name=>'PostingContentId');
942: --
943: l_new_value:=irc_approvals.get_posting_data_varchar
944: (transaction_id=>transaction_id ,data_name => 'BriefDescription');

Line 943: l_new_value:=irc_approvals.get_posting_data_varchar

939: --
940: l_posting_content_id := irc_approvals.get_posting_data_number
941: (transaction_id=>transaction_id, data_name=>'PostingContentId');
942: --
943: l_new_value:=irc_approvals.get_posting_data_varchar
944: (transaction_id=>transaction_id ,data_name => 'BriefDescription');
945: --
946: open get_old_value(l_posting_content_id);
947: fetch get_old_value into l_clob_old_value;

Line 952: irc_approvals.log('Comparing old org value :' || l_old_value

948: close get_old_value;
949:
950: l_old_value := dbms_lob.substr(l_clob_old_value);
951: --
952: irc_approvals.log('Comparing old org value :' || l_old_value
953: || ': to new org value :' || l_new_value || ':');
954: --
955: if(nvl(l_new_value,hr_api.g_varchar2)
956: <> nvl(l_old_value,hr_api.g_varchar2) ) then

Line 961: irc_approvals.log('Exiting get_brief_description_changed returning :' || l_retval || ':');

957: l_retval:='true';
958: end if;
959: end if;
960: --
961: irc_approvals.log('Exiting get_brief_description_changed returning :' || l_retval || ':');
962: --
963: return l_retval;
964: end get_brief_description_changed;
965: --

Line 984: irc_approvals.log('Entering get_detailed_desc_changed');

980: from irc_posting_contents_vl
981: where posting_content_id=p_posting_content_id;
982: begin
983: --
984: irc_approvals.log('Entering get_detailed_desc_changed');
985: --
986: l_retval := 'false';
987: --
988: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then

Line 988: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then

984: irc_approvals.log('Entering get_detailed_desc_changed');
985: --
986: l_retval := 'false';
987: --
988: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
989: --
990: l_posting_content_id := irc_approvals.get_posting_data_number
991: (transaction_id=>transaction_id, data_name=>'PostingContentId');
992: --

Line 990: l_posting_content_id := irc_approvals.get_posting_data_number

986: l_retval := 'false';
987: --
988: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
989: --
990: l_posting_content_id := irc_approvals.get_posting_data_number
991: (transaction_id=>transaction_id, data_name=>'PostingContentId');
992: --
993: l_new_value:=irc_approvals.get_posting_data_varchar
994: (transaction_id=>transaction_id ,data_name => 'DetailedDescription');

Line 993: l_new_value:=irc_approvals.get_posting_data_varchar

989: --
990: l_posting_content_id := irc_approvals.get_posting_data_number
991: (transaction_id=>transaction_id, data_name=>'PostingContentId');
992: --
993: l_new_value:=irc_approvals.get_posting_data_varchar
994: (transaction_id=>transaction_id ,data_name => 'DetailedDescription');
995: --
996: open get_old_value(l_posting_content_id);
997: fetch get_old_value into l_clob_old_value;

Line 1001: irc_approvals.log('Comparing old org value :' || l_old_value

997: fetch get_old_value into l_clob_old_value;
998: close get_old_value;
999: l_old_value := dbms_lob.substr(l_clob_old_value);
1000: --
1001: irc_approvals.log('Comparing old org value :' || l_old_value
1002: || ': to new org value :' || l_new_value || ':');
1003: --
1004: if(nvl(l_new_value,hr_api.g_varchar2)
1005: <> nvl(l_old_value,hr_api.g_varchar2) ) then

Line 1010: irc_approvals.log('Exiting get_detailed_desc_changed returning :' || l_retval || ':');

1006: l_retval:='true';
1007: end if;
1008: end if;
1009: --
1010: irc_approvals.log('Exiting get_detailed_desc_changed returning :' || l_retval || ':');
1011: --
1012: return l_retval;
1013: end get_detailed_desc_changed;
1014: --

Line 1033: irc_approvals.log('Entering get_job_requirements_changed');

1029: from irc_posting_contents_vl
1030: where posting_content_id=p_posting_content_id;
1031: begin
1032: --
1033: irc_approvals.log('Entering get_job_requirements_changed');
1034: --
1035: l_retval := 'false';
1036: --
1037: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then

Line 1037: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then

1033: irc_approvals.log('Entering get_job_requirements_changed');
1034: --
1035: l_retval := 'false';
1036: --
1037: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
1038: --
1039: l_posting_content_id := irc_approvals.get_posting_data_number
1040: (transaction_id=>transaction_id, data_name=>'PostingContentId');
1041: --

Line 1039: l_posting_content_id := irc_approvals.get_posting_data_number

1035: l_retval := 'false';
1036: --
1037: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
1038: --
1039: l_posting_content_id := irc_approvals.get_posting_data_number
1040: (transaction_id=>transaction_id, data_name=>'PostingContentId');
1041: --
1042: l_new_value:=irc_approvals.get_posting_data_varchar
1043: (transaction_id=>transaction_id ,data_name => 'JobRequirements');

Line 1042: l_new_value:=irc_approvals.get_posting_data_varchar

1038: --
1039: l_posting_content_id := irc_approvals.get_posting_data_number
1040: (transaction_id=>transaction_id, data_name=>'PostingContentId');
1041: --
1042: l_new_value:=irc_approvals.get_posting_data_varchar
1043: (transaction_id=>transaction_id ,data_name => 'JobRequirements');
1044: --
1045: open get_old_value(l_posting_content_id);
1046: fetch get_old_value into l_clob_old_value;

Line 1050: irc_approvals.log('Comparing old org value :' || l_old_value

1046: fetch get_old_value into l_clob_old_value;
1047: close get_old_value;
1048: l_old_value := dbms_lob.substr(l_clob_old_value);
1049: --
1050: irc_approvals.log('Comparing old org value :' || l_old_value
1051: || ': to new org value :' || l_new_value || ':');
1052: --
1053: if(nvl(l_new_value,hr_api.g_varchar2)
1054: <> nvl(l_old_value,hr_api.g_varchar2) ) then

Line 1059: irc_approvals.log('Exiting get_job_requirements_changed returning :' || l_retval || ':');

1055: l_retval:='true';
1056: end if;
1057: end if;
1058: --
1059: irc_approvals.log('Exiting get_job_requirements_changed returning :' || l_retval || ':');
1060: --
1061: return l_retval;
1062: end get_job_requirements_changed;
1063: --

Line 1082: irc_approvals.log('Entering get_additional_details_changed');

1078: from irc_posting_contents_vl
1079: where posting_content_id=p_posting_content_id;
1080: begin
1081: --
1082: irc_approvals.log('Entering get_additional_details_changed');
1083: --
1084: l_retval := 'false';
1085: --
1086: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then

Line 1086: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then

1082: irc_approvals.log('Entering get_additional_details_changed');
1083: --
1084: l_retval := 'false';
1085: --
1086: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
1087: --
1088: l_posting_content_id := irc_approvals.get_posting_data_number
1089: (transaction_id=>transaction_id, data_name=>'PostingContentId');
1090: --

Line 1088: l_posting_content_id := irc_approvals.get_posting_data_number

1084: l_retval := 'false';
1085: --
1086: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
1087: --
1088: l_posting_content_id := irc_approvals.get_posting_data_number
1089: (transaction_id=>transaction_id, data_name=>'PostingContentId');
1090: --
1091: l_new_value:=irc_approvals.get_posting_data_varchar
1092: (transaction_id=>transaction_id ,data_name => 'AdditionalDetails');

Line 1091: l_new_value:=irc_approvals.get_posting_data_varchar

1087: --
1088: l_posting_content_id := irc_approvals.get_posting_data_number
1089: (transaction_id=>transaction_id, data_name=>'PostingContentId');
1090: --
1091: l_new_value:=irc_approvals.get_posting_data_varchar
1092: (transaction_id=>transaction_id ,data_name => 'AdditionalDetails');
1093: --
1094: open get_old_value(l_posting_content_id);
1095: fetch get_old_value into l_clob_old_value;

Line 1099: irc_approvals.log('Comparing old org value :' || l_old_value

1095: fetch get_old_value into l_clob_old_value;
1096: close get_old_value;
1097: l_old_value := dbms_lob.substr(l_clob_old_value);
1098: --
1099: irc_approvals.log('Comparing old org value :' || l_old_value
1100: || ': to new org value :' || l_new_value || ':');
1101: --
1102: if(nvl(l_new_value,hr_api.g_varchar2)
1103: <> nvl(l_old_value,hr_api.g_varchar2) ) then

Line 1108: irc_approvals.log('Exiting get_additional_details_changed returning :' || l_retval || ':');

1104: l_retval:='true';
1105: end if;
1106: end if;
1107: --
1108: irc_approvals.log('Exiting get_additional_details_changed returning :' || l_retval || ':');
1109: --
1110: return l_retval;
1111: end get_additional_details_changed;
1112: --

Line 1131: irc_approvals.log('Entering get_how_to_apply_changed');

1127: from irc_posting_contents_vl
1128: where posting_content_id=p_posting_content_id;
1129: begin
1130: --
1131: irc_approvals.log('Entering get_how_to_apply_changed');
1132: --
1133: l_retval := 'false';
1134: --
1135: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then

Line 1135: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then

1131: irc_approvals.log('Entering get_how_to_apply_changed');
1132: --
1133: l_retval := 'false';
1134: --
1135: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
1136: --
1137: l_posting_content_id := irc_approvals.get_posting_data_number
1138: (transaction_id=>transaction_id, data_name=>'PostingContentId');
1139: --

Line 1137: l_posting_content_id := irc_approvals.get_posting_data_number

1133: l_retval := 'false';
1134: --
1135: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
1136: --
1137: l_posting_content_id := irc_approvals.get_posting_data_number
1138: (transaction_id=>transaction_id, data_name=>'PostingContentId');
1139: --
1140: l_new_value:=irc_approvals.get_posting_data_varchar
1141: (transaction_id=>transaction_id ,data_name => 'HowToApply');

Line 1140: l_new_value:=irc_approvals.get_posting_data_varchar

1136: --
1137: l_posting_content_id := irc_approvals.get_posting_data_number
1138: (transaction_id=>transaction_id, data_name=>'PostingContentId');
1139: --
1140: l_new_value:=irc_approvals.get_posting_data_varchar
1141: (transaction_id=>transaction_id ,data_name => 'HowToApply');
1142: --
1143: open get_old_value(l_posting_content_id);
1144: fetch get_old_value into l_clob_old_value;

Line 1148: irc_approvals.log('Comparing old org value :' || l_old_value

1144: fetch get_old_value into l_clob_old_value;
1145: close get_old_value;
1146: l_old_value := dbms_lob.substr(l_clob_old_value);
1147: --
1148: irc_approvals.log('Comparing old org value :' || l_old_value
1149: || ': to new org value :' || l_new_value || ':');
1150: --
1151: if(nvl(l_new_value,hr_api.g_varchar2)
1152: <> nvl(l_old_value,hr_api.g_varchar2) ) then

Line 1157: irc_approvals.log('Exiting get_how_to_apply_changed returning :' || l_retval || ':');

1153: l_retval:='true';
1154: end if;
1155: end if;
1156: --
1157: irc_approvals.log('Exiting get_how_to_apply_changed returning :' || l_retval || ':');
1158: --
1159: return l_retval;
1160: end get_how_to_apply_changed;
1161: --

Line 1183: irc_approvals.log('Entering get_posting_graphic_changed');

1179: where posting_content_id=p_posting_content_id;
1180: --
1181: BEGIN
1182: --
1183: irc_approvals.log('Entering get_posting_graphic_changed');
1184: --
1185: l_retval := 'false';
1186: --
1187: if irc_approvals.get_transaction_mode(transaction_id)<> 'INSERT' then

Line 1187: if irc_approvals.get_transaction_mode(transaction_id)<> 'INSERT' then

1183: irc_approvals.log('Entering get_posting_graphic_changed');
1184: --
1185: l_retval := 'false';
1186: --
1187: if irc_approvals.get_transaction_mode(transaction_id)<> 'INSERT' then
1188: --
1189: l_new_value := irc_approvals.get_posting_data_varchar
1190: (transaction_id=>transaction_id ,data_name => 'ImageUrl');
1191: --

Line 1189: l_new_value := irc_approvals.get_posting_data_varchar

1185: l_retval := 'false';
1186: --
1187: if irc_approvals.get_transaction_mode(transaction_id)<> 'INSERT' then
1188: --
1189: l_new_value := irc_approvals.get_posting_data_varchar
1190: (transaction_id=>transaction_id ,data_name => 'ImageUrl');
1191: --
1192: l_posting_content_id := irc_approvals.get_posting_data_number
1193: (transaction_id=>transaction_id, data_name=>'PostingContentId');

Line 1192: l_posting_content_id := irc_approvals.get_posting_data_number

1188: --
1189: l_new_value := irc_approvals.get_posting_data_varchar
1190: (transaction_id=>transaction_id ,data_name => 'ImageUrl');
1191: --
1192: l_posting_content_id := irc_approvals.get_posting_data_number
1193: (transaction_id=>transaction_id, data_name=>'PostingContentId');
1194: open get_old_value(l_posting_content_id);
1195: fetch get_old_value into l_clob_old_value;
1196: close get_old_value;

Line 1199: irc_approvals.log('Comparing old org value :' || l_old_value

1195: fetch get_old_value into l_clob_old_value;
1196: close get_old_value;
1197: l_old_value := dbms_lob.substr(l_clob_old_value);
1198: --
1199: irc_approvals.log('Comparing old org value :' || l_old_value
1200: || ': to new org value :' || l_new_value || ':');
1201: --
1202: if(nvl(l_new_value,hr_api.g_varchar2)
1203: <> nvl(l_old_value,hr_api.g_varchar2) ) then

Line 1209: irc_approvals.log('Exiting get_posting_graphic_changed returning :' || l_retval || ':');

1205: end if;
1206: --
1207: end if;
1208: --
1209: irc_approvals.log('Exiting get_posting_graphic_changed returning :' || l_retval || ':');
1210: --
1211: return l_retval;
1212: --
1213: end get_posting_graphic_changed;

Line 1233: irc_approvals.log('Entering get_ovn_changed');

1229: from per_all_vacancies
1230: where vacancy_id=p_vacancy_id;
1231: begin
1232: --
1233: irc_approvals.log('Entering get_ovn_changed');
1234: --
1235: l_retval := 'false';
1236: --
1237: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then

Line 1237: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then

1233: irc_approvals.log('Entering get_ovn_changed');
1234: --
1235: l_retval := 'false';
1236: --
1237: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
1238: --
1239: l_new_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'ObjectVersionNumber');
1240: --
1241: l_vacancy_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'VacancyId');

Line 1239: l_new_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'ObjectVersionNumber');

1235: l_retval := 'false';
1236: --
1237: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
1238: --
1239: l_new_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'ObjectVersionNumber');
1240: --
1241: l_vacancy_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'VacancyId');
1242: open get_old_id(l_vacancy_id);
1243: fetch get_old_id into l_old_id;

Line 1241: l_vacancy_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'VacancyId');

1237: if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
1238: --
1239: l_new_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'ObjectVersionNumber');
1240: --
1241: l_vacancy_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'VacancyId');
1242: open get_old_id(l_vacancy_id);
1243: fetch get_old_id into l_old_id;
1244: close get_old_id;
1245: --

Line 1246: irc_approvals.log('Comparing old org id :' || to_char(l_old_id)

1242: open get_old_id(l_vacancy_id);
1243: fetch get_old_id into l_old_id;
1244: close get_old_id;
1245: --
1246: irc_approvals.log('Comparing old org id :' || to_char(l_old_id)
1247: || ': to new org id :' || to_char(l_new_id) || ':');
1248: --
1249: if(nvl(l_new_id,hr_api.g_number)
1250: <> nvl(l_old_id,hr_api.g_number) ) then

Line 1256: irc_approvals.log('Exiting get_ovn_changed returning :' || l_retval || ':');

1252: end if;
1253: --
1254: end if;
1255: --
1256: irc_approvals.log('Exiting get_ovn_changed returning :' || l_retval || ':');
1257: --
1258: return l_retval;
1259: end get_ovn_changed;
1260: --

Line 1343: irc_approvals.log('Entering check_self_approval');

1339: approvers ame_util.approversTable2;
1340:
1341: begin
1342: --
1343: irc_approvals.log('Entering check_self_approval');
1344: --
1345: ame_api2.getAllApprovers7
1346: (applicationIdIn => p_application_id
1347: ,transactionTypeIn => p_transaction_type

Line 1358: irc_approvals.log('Exiting check_self_approval');

1354: if fnd_global.user_name = approvers(1).name then
1355: p_number_of_approvers := 0;
1356: end if;
1357: end if;
1358: irc_approvals.log('Exiting check_self_approval');
1359: --
1360: end check_self_approval;
1361: --
1362: procedure getNotifSubjectForCreate

Line 1422: irc_approvals.get_vacancy_data_varchar(

1418: --
1419: else
1420: --
1421: l_vacancy_name :=
1422: irc_approvals.get_vacancy_data_varchar(
1423: transaction_id => l_transaction_id,
1424: data_name => 'Name');
1425: --
1426: l_originators_name :=

Line 1428: irc_approvals.get_transaction_number_data (

1424: data_name => 'Name');
1425: --
1426: l_originators_name :=
1427: getPersonNameFromID(
1428: irc_approvals.get_transaction_number_data (
1429: transaction_id => to_char(l_transaction_id),
1430: p_path => '/Transaction/TransCtx/CNode/loggedInPersonId'));
1431: --
1432: if(wf_notification.isFYI(document_id))then

Line 1549: irc_approvals.get_transaction_number_data (

1545: --
1546: l_vacancy_name :=
1547: getVacancyNameFromId(
1548: getVacancyIdFromAssignmentId(
1549: irc_approvals.get_transaction_number_data (
1550: transaction_id => to_char(l_transaction_id),
1551: p_path => '/Transaction/TransCtx/PrsnAssignmentId')));
1552: --
1553: l_applicant_name :=

Line 1555: irc_approvals.get_transaction_number_data (

1551: p_path => '/Transaction/TransCtx/PrsnAssignmentId')));
1552: --
1553: l_applicant_name :=
1554: getPersonNameFromID(
1555: irc_approvals.get_transaction_number_data (
1556: transaction_id => to_char(l_transaction_id),
1557: p_path => '/Transaction/TransCtx/PrsnId'));
1558: --
1559: if flowmode = 'CREATE' then

Line 1618: END IRC_APPROVALS;

1614:
1615: end getVacancyIdFromAssignmentId;
1616:
1617:
1618: END IRC_APPROVALS;