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_VACANCY_APPROVALS dependencies on HR_API

Line 22: transactionDoc hr_api_transactions.transaction_document%type;

18: ,p_path in varchar2)
19: return varchar2 is
20: --
21: l_retval varchar2(32000);
22: transactionDoc hr_api_transactions.transaction_document%type;
23: --
24: cursor get_doc is
25: select transaction_document
26: from hr_api_transactions

Line 26: from hr_api_transactions

22: transactionDoc hr_api_transactions.transaction_document%type;
23: --
24: cursor get_doc is
25: select transaction_document
26: from hr_api_transactions
27: where transaction_id = p_transaction_id;
28: --
29: begin
30: --

Line 239: if(nvl(l_new_id,hr_api.g_number)

235: --
236: irc_vacancy_approvals.show('Comparing old org id :' || to_char(l_old_id)
237: || ': to new org id :' || to_char(l_new_id) || ':');
238: --
239: if(nvl(l_new_id,hr_api.g_number)
240: <> nvl(l_old_id,hr_api.g_number) ) then
241: l_retval:='true';
242: end if;
243: end if;

Line 240: <> nvl(l_old_id,hr_api.g_number) ) then

236: irc_vacancy_approvals.show('Comparing old org id :' || to_char(l_old_id)
237: || ': to new org id :' || to_char(l_new_id) || ':');
238: --
239: if(nvl(l_new_id,hr_api.g_number)
240: <> nvl(l_old_id,hr_api.g_number) ) then
241: l_retval:='true';
242: end if;
243: end if;
244: --

Line 282: if(nvl(l_new_id,hr_api.g_number)

278: --
279: irc_vacancy_approvals.show('Comparing old job id :' || to_char(l_old_id)
280: || ': to new job id :' || to_char(l_new_id) || ':');
281: --
282: if(nvl(l_new_id,hr_api.g_number)
283: <> nvl(l_old_id,hr_api.g_number) ) then
284: l_retval:='true';
285: end if;
286: end if;

Line 283: <> nvl(l_old_id,hr_api.g_number) ) then

279: irc_vacancy_approvals.show('Comparing old job id :' || to_char(l_old_id)
280: || ': to new job id :' || to_char(l_new_id) || ':');
281: --
282: if(nvl(l_new_id,hr_api.g_number)
283: <> nvl(l_old_id,hr_api.g_number) ) then
284: l_retval:='true';
285: end if;
286: end if;
287: --

Line 327: if(nvl(l_new_id,hr_api.g_number)

323: --
324: irc_vacancy_approvals.show('Comparing old org id :' || to_char(l_old_id)
325: || ': to new org id :' || to_char(l_new_id) || ':');
326: --
327: if(nvl(l_new_id,hr_api.g_number)
328: <> nvl(l_old_id,hr_api.g_number) ) then
329: l_retval:='true';
330: end if;
331: --

Line 328: <> nvl(l_old_id,hr_api.g_number) ) then

324: irc_vacancy_approvals.show('Comparing old org id :' || to_char(l_old_id)
325: || ': to new org id :' || to_char(l_new_id) || ':');
326: --
327: if(nvl(l_new_id,hr_api.g_number)
328: <> nvl(l_old_id,hr_api.g_number) ) then
329: l_retval:='true';
330: end if;
331: --
332: end if;

Line 373: if(nvl(l_new_id,hr_api.g_number)

369: --
370: irc_vacancy_approvals.show('Comparing old org id :' || to_char(l_old_id)
371: || ': to new org id :' || to_char(l_new_id) || ':');
372: --
373: if(nvl(l_new_id,hr_api.g_number)
374: <>nvl(l_old_id,hr_api.g_number) ) then
375: l_retval:='true';
376: end if;
377: --

Line 374: <>nvl(l_old_id,hr_api.g_number) ) then

370: irc_vacancy_approvals.show('Comparing old org id :' || to_char(l_old_id)
371: || ': to new org id :' || to_char(l_new_id) || ':');
372: --
373: if(nvl(l_new_id,hr_api.g_number)
374: <>nvl(l_old_id,hr_api.g_number) ) then
375: l_retval:='true';
376: end if;
377: --
378: end if;

Line 419: if(nvl(l_new_id,hr_api.g_number)

415: --
416: irc_vacancy_approvals.show('Comparing old org id :' || to_char(l_old_id)
417: || ': to new org id :' || to_char(l_new_id) || ':');
418: --
419: if(nvl(l_new_id,hr_api.g_number)
420: <>nvl(l_old_id,hr_api.g_number) ) then
421: l_retval:='true';
422: end if;
423: --

Line 420: <>nvl(l_old_id,hr_api.g_number) ) then

416: irc_vacancy_approvals.show('Comparing old org id :' || to_char(l_old_id)
417: || ': to new org id :' || to_char(l_new_id) || ':');
418: --
419: if(nvl(l_new_id,hr_api.g_number)
420: <>nvl(l_old_id,hr_api.g_number) ) then
421: l_retval:='true';
422: end if;
423: --
424: end if;

Line 465: if(nvl(l_new_value,hr_api.g_varchar2)

461: --
462: irc_vacancy_approvals.show('Comparing old org value :' || l_old_value
463: || ': to new org value :' || l_new_value || ':');
464: --
465: if(nvl(l_new_value,hr_api.g_varchar2)
466: <> nvl(l_old_value,hr_api.g_varchar2) ) then
467: l_retval:='true';
468: end if;
469: end if;

Line 466: <> nvl(l_old_value,hr_api.g_varchar2) ) then

462: irc_vacancy_approvals.show('Comparing old org value :' || l_old_value
463: || ': to new org value :' || l_new_value || ':');
464: --
465: if(nvl(l_new_value,hr_api.g_varchar2)
466: <> nvl(l_old_value,hr_api.g_varchar2) ) then
467: l_retval:='true';
468: end if;
469: end if;
470: --

Line 511: if(nvl(l_new_value,hr_api.g_varchar2)

507: --
508: irc_vacancy_approvals.show('Comparing old org value :' || l_old_value
509: || ': to new org value :' || l_new_value || ':');
510: --
511: if(nvl(l_new_value,hr_api.g_varchar2)
512: <> nvl(l_old_value,hr_api.g_varchar2) ) then
513: l_retval:='true';
514: end if;
515: end if;

Line 512: <> nvl(l_old_value,hr_api.g_varchar2) ) then

508: irc_vacancy_approvals.show('Comparing old org value :' || l_old_value
509: || ': to new org value :' || l_new_value || ':');
510: --
511: if(nvl(l_new_value,hr_api.g_varchar2)
512: <> nvl(l_old_value,hr_api.g_varchar2) ) then
513: l_retval:='true';
514: end if;
515: end if;
516: --

Line 558: if(nvl(l_new_value,hr_api.g_varchar2)

554: --
555: irc_vacancy_approvals.show('Comparing old org value :' || l_old_value
556: || ': to new org value :' || l_new_value || ':');
557: --
558: if(nvl(l_new_value,hr_api.g_varchar2)
559: <> nvl(l_old_value,hr_api.g_varchar2) ) then
560: l_retval:='true';
561: end if;
562: end if;

Line 559: <> nvl(l_old_value,hr_api.g_varchar2) ) then

555: irc_vacancy_approvals.show('Comparing old org value :' || l_old_value
556: || ': to new org value :' || l_new_value || ':');
557: --
558: if(nvl(l_new_value,hr_api.g_varchar2)
559: <> nvl(l_old_value,hr_api.g_varchar2) ) then
560: l_retval:='true';
561: end if;
562: end if;
563: --

Line 605: if(nvl(l_new_value,hr_api.g_varchar2)

601: --
602: irc_vacancy_approvals.show('Comparing old org value :' || l_old_value
603: || ': to new org value :' || l_new_value || ':');
604: --
605: if(nvl(l_new_value,hr_api.g_varchar2)
606: <> nvl(l_old_value,hr_api.g_varchar2) ) then
607: l_retval:='true';
608: end if;
609: end if;

Line 606: <> nvl(l_old_value,hr_api.g_varchar2) ) then

602: irc_vacancy_approvals.show('Comparing old org value :' || l_old_value
603: || ': to new org value :' || l_new_value || ':');
604: --
605: if(nvl(l_new_value,hr_api.g_varchar2)
606: <> nvl(l_old_value,hr_api.g_varchar2) ) then
607: l_retval:='true';
608: end if;
609: end if;
610: --

Line 652: if(nvl(l_new_value,hr_api.g_varchar2)

648: --
649: irc_vacancy_approvals.show('Comparing old org value :' || l_old_value
650: || ': to new org value :' || l_new_value || ':');
651: --
652: if(nvl(l_new_value,hr_api.g_varchar2)
653: <> nvl(l_old_value,hr_api.g_varchar2) ) then
654: l_retval:='true';
655: end if;
656: end if;

Line 653: <> nvl(l_old_value,hr_api.g_varchar2) ) then

649: irc_vacancy_approvals.show('Comparing old org value :' || l_old_value
650: || ': to new org value :' || l_new_value || ':');
651: --
652: if(nvl(l_new_value,hr_api.g_varchar2)
653: <> nvl(l_old_value,hr_api.g_varchar2) ) then
654: l_retval:='true';
655: end if;
656: end if;
657: --

Line 702: if(nvl(l_new_value,hr_api.g_varchar2)

698: --
699: irc_vacancy_approvals.show('Comparing old org value :' || l_old_value
700: || ': to new org value :' || l_new_value || ':');
701: --
702: if(nvl(l_new_value,hr_api.g_varchar2)
703: <> nvl(l_old_value,hr_api.g_varchar2) ) then
704: l_retval:='true';
705: end if;
706: end if;

Line 703: <> nvl(l_old_value,hr_api.g_varchar2) ) then

699: irc_vacancy_approvals.show('Comparing old org value :' || l_old_value
700: || ': to new org value :' || l_new_value || ':');
701: --
702: if(nvl(l_new_value,hr_api.g_varchar2)
703: <> nvl(l_old_value,hr_api.g_varchar2) ) then
704: l_retval:='true';
705: end if;
706: end if;
707: --

Line 752: if(nvl(l_new_value,hr_api.g_varchar2)

748: --
749: irc_vacancy_approvals.show('Comparing old org value :' || l_old_value
750: || ': to new org value :' || l_new_value || ':');
751: --
752: if(nvl(l_new_value,hr_api.g_varchar2)
753: <> nvl(l_old_value,hr_api.g_varchar2) ) then
754: l_retval:='true';
755: end if;
756: end if;

Line 753: <> nvl(l_old_value,hr_api.g_varchar2) ) then

749: irc_vacancy_approvals.show('Comparing old org value :' || l_old_value
750: || ': to new org value :' || l_new_value || ':');
751: --
752: if(nvl(l_new_value,hr_api.g_varchar2)
753: <> nvl(l_old_value,hr_api.g_varchar2) ) then
754: l_retval:='true';
755: end if;
756: end if;
757: --

Line 801: if(nvl(l_new_value,hr_api.g_varchar2)

797: --
798: irc_vacancy_approvals.show('Comparing old org value :' || l_old_value
799: || ': to new org value :' || l_new_value || ':');
800: --
801: if(nvl(l_new_value,hr_api.g_varchar2)
802: <> nvl(l_old_value,hr_api.g_varchar2) ) then
803: l_retval:='true';
804: end if;
805: end if;

Line 802: <> nvl(l_old_value,hr_api.g_varchar2) ) then

798: irc_vacancy_approvals.show('Comparing old org value :' || l_old_value
799: || ': to new org value :' || l_new_value || ':');
800: --
801: if(nvl(l_new_value,hr_api.g_varchar2)
802: <> nvl(l_old_value,hr_api.g_varchar2) ) then
803: l_retval:='true';
804: end if;
805: end if;
806: --

Line 850: if(nvl(l_new_value,hr_api.g_varchar2)

846: --
847: irc_vacancy_approvals.show('Comparing old org value :' || l_old_value
848: || ': to new org value :' || l_new_value || ':');
849: --
850: if(nvl(l_new_value,hr_api.g_varchar2)
851: <> nvl(l_old_value,hr_api.g_varchar2) ) then
852: l_retval:='true';
853: end if;
854: end if;

Line 851: <> nvl(l_old_value,hr_api.g_varchar2) ) then

847: irc_vacancy_approvals.show('Comparing old org value :' || l_old_value
848: || ': to new org value :' || l_new_value || ':');
849: --
850: if(nvl(l_new_value,hr_api.g_varchar2)
851: <> nvl(l_old_value,hr_api.g_varchar2) ) then
852: l_retval:='true';
853: end if;
854: end if;
855: --

Line 899: if(nvl(l_new_value,hr_api.g_varchar2)

895: --
896: irc_vacancy_approvals.show('Comparing old org value :' || l_old_value
897: || ': to new org value :' || l_new_value || ':');
898: --
899: if(nvl(l_new_value,hr_api.g_varchar2)
900: <> nvl(l_old_value,hr_api.g_varchar2) ) then
901: l_retval:='true';
902: end if;
903: end if;

Line 900: <> nvl(l_old_value,hr_api.g_varchar2) ) then

896: irc_vacancy_approvals.show('Comparing old org value :' || l_old_value
897: || ': to new org value :' || l_new_value || ':');
898: --
899: if(nvl(l_new_value,hr_api.g_varchar2)
900: <> nvl(l_old_value,hr_api.g_varchar2) ) then
901: l_retval:='true';
902: end if;
903: end if;
904: --

Line 948: if(nvl(l_new_value,hr_api.g_varchar2)

944: --
945: irc_vacancy_approvals.show('Comparing old org value :' || l_old_value
946: || ': to new org value :' || l_new_value || ':');
947: --
948: if(nvl(l_new_value,hr_api.g_varchar2)
949: <> nvl(l_old_value,hr_api.g_varchar2) ) then
950: l_retval:='true';
951: end if;
952: end if;

Line 949: <> nvl(l_old_value,hr_api.g_varchar2) ) then

945: irc_vacancy_approvals.show('Comparing old org value :' || l_old_value
946: || ': to new org value :' || l_new_value || ':');
947: --
948: if(nvl(l_new_value,hr_api.g_varchar2)
949: <> nvl(l_old_value,hr_api.g_varchar2) ) then
950: l_retval:='true';
951: end if;
952: end if;
953: --

Line 999: if(nvl(l_new_value,hr_api.g_varchar2)

995: --
996: irc_vacancy_approvals.show('Comparing old org value :' || l_old_value
997: || ': to new org value :' || l_new_value || ':');
998: --
999: if(nvl(l_new_value,hr_api.g_varchar2)
1000: <> nvl(l_old_value,hr_api.g_varchar2) ) then
1001: l_retval:='true';
1002: end if;
1003: --

Line 1000: <> nvl(l_old_value,hr_api.g_varchar2) ) then

996: irc_vacancy_approvals.show('Comparing old org value :' || l_old_value
997: || ': to new org value :' || l_new_value || ':');
998: --
999: if(nvl(l_new_value,hr_api.g_varchar2)
1000: <> nvl(l_old_value,hr_api.g_varchar2) ) then
1001: l_retval:='true';
1002: end if;
1003: --
1004: end if;