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 HR_API

Line 24: transactionDoc hr_api_transactions.transaction_document%type;

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

Line 28: from hr_api_transactions

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

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

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
444: l_retval:='true';
445: end if;
446: end if;

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

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
444: l_retval:='true';
445: end if;
446: end if;
447: --

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

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
487: l_retval:='true';
488: end if;
489: end if;

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

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
487: l_retval:='true';
488: end if;
489: end if;
490: --

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

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
532: l_retval:='true';
533: end if;
534: --

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

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
532: l_retval:='true';
533: end if;
534: --
535: end if;

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

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
578: l_retval:='true';
579: end if;
580: --

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

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
578: l_retval:='true';
579: end if;
580: --
581: end if;

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

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
624: l_retval:='true';
625: end if;
626: --

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

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
624: l_retval:='true';
625: end if;
626: --
627: end if;

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

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
670: l_retval:='true';
671: end if;
672: end if;

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

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
670: l_retval:='true';
671: end if;
672: end if;
673: --

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

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
716: l_retval:='true';
717: end if;
718: end if;

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

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
716: l_retval:='true';
717: end if;
718: end if;
719: --

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

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
763: l_retval:='true';
764: end if;
765: end if;

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

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
763: l_retval:='true';
764: end if;
765: end if;
766: --

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

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
810: l_retval:='true';
811: end if;
812: end if;

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

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
810: l_retval:='true';
811: end if;
812: end if;
813: --

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

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
857: l_retval:='true';
858: end if;
859: end if;

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

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
857: l_retval:='true';
858: end if;
859: end if;
860: --

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

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
907: l_retval:='true';
908: end if;
909: end if;

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

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
907: l_retval:='true';
908: end if;
909: end if;
910: --

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

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
957: l_retval:='true';
958: end if;
959: end if;

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

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
957: l_retval:='true';
958: end if;
959: end if;
960: --

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

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
1006: l_retval:='true';
1007: end if;
1008: end if;

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

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
1006: l_retval:='true';
1007: end if;
1008: end if;
1009: --

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

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
1055: l_retval:='true';
1056: end if;
1057: end if;

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

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
1055: l_retval:='true';
1056: end if;
1057: end if;
1058: --

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

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
1104: l_retval:='true';
1105: end if;
1106: end if;

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

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
1104: l_retval:='true';
1105: end if;
1106: end if;
1107: --

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

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
1153: l_retval:='true';
1154: end if;
1155: end if;

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

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
1153: l_retval:='true';
1154: end if;
1155: end if;
1156: --

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

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
1204: l_retval:='true';
1205: end if;
1206: --

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

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
1204: l_retval:='true';
1205: end if;
1206: --
1207: end if;

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

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
1251: l_retval:='true';
1252: end if;
1253: --

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

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
1251: l_retval:='true';
1252: end if;
1253: --
1254: end if;

Line 1283: cursor csr_trans(c_transaction_id hr_api_transactions.transaction_id%TYPE) is

1279: and trunc(sysdate)
1280: between effective_start_date
1281: and effective_end_date;
1282: --
1283: cursor csr_trans(c_transaction_id hr_api_transactions.transaction_id%TYPE) is
1284: select creator_person_id
1285: from hr_api_transactions
1286: where transaction_id = c_transaction_id;
1287: --

Line 1285: from hr_api_transactions

1281: and effective_end_date;
1282: --
1283: cursor csr_trans(c_transaction_id hr_api_transactions.transaction_id%TYPE) is
1284: select creator_person_id
1285: from hr_api_transactions
1286: where transaction_id = c_transaction_id;
1287: --
1288: BEGIN
1289: --

Line 1423: l_transaction_id hr_api_transactions.transaction_id%type;

1419: document_type in out nocopy varchar2,
1420: flowmode in varchar2) is
1421: --
1422: l_vacancy_name per_all_vacancies.name%type;
1423: l_transaction_id hr_api_transactions.transaction_id%type;
1424: l_originators_name per_all_people_f.full_name%type;
1425: --
1426: Begin
1427: --

Line 1540: l_transaction_id hr_api_transactions.transaction_id%type;

1536: document_type in out nocopy varchar2,
1537: flowmode in varchar2) is
1538: --
1539: l_vacancy_name per_all_vacancies.name%type;
1540: l_transaction_id hr_api_transactions.transaction_id%type;
1541: l_applicant_name per_all_people_f.full_name%type;
1542: --
1543: Begin
1544: --