APPS.IRC_VACANCY_APPROVALS dependencies on DBMS_LOB

Line 697: l_old_value := dbms_lob.substr(l_clob_old_value);

693: open get_old_value(l_posting_content_id);
694: fetch get_old_value into l_clob_old_value;
695: close get_old_value;
696: --
697: l_old_value := dbms_lob.substr(l_clob_old_value);
698: --
699: irc_vacancy_approvals.show('Comparing old org value :' || l_old_value
700: || ': to new org value :' || l_new_value || ':');
701: --

Line 747: l_old_value := dbms_lob.substr(l_clob_old_value);

743: open get_old_value(l_posting_content_id);
744: fetch get_old_value into l_clob_old_value;
745: close get_old_value;
746:
747: l_old_value := dbms_lob.substr(l_clob_old_value);
748: --
749: irc_vacancy_approvals.show('Comparing old org value :' || l_old_value
750: || ': to new org value :' || l_new_value || ':');
751: --

Line 796: l_old_value := dbms_lob.substr(l_clob_old_value);

792: --
793: open get_old_value(l_posting_content_id);
794: fetch get_old_value into l_clob_old_value;
795: close get_old_value;
796: l_old_value := dbms_lob.substr(l_clob_old_value);
797: --
798: irc_vacancy_approvals.show('Comparing old org value :' || l_old_value
799: || ': to new org value :' || l_new_value || ':');
800: --

Line 845: l_old_value := dbms_lob.substr(l_clob_old_value);

841: --
842: open get_old_value(l_posting_content_id);
843: fetch get_old_value into l_clob_old_value;
844: close get_old_value;
845: l_old_value := dbms_lob.substr(l_clob_old_value);
846: --
847: irc_vacancy_approvals.show('Comparing old org value :' || l_old_value
848: || ': to new org value :' || l_new_value || ':');
849: --

Line 894: l_old_value := dbms_lob.substr(l_clob_old_value);

890: --
891: open get_old_value(l_posting_content_id);
892: fetch get_old_value into l_clob_old_value;
893: close get_old_value;
894: l_old_value := dbms_lob.substr(l_clob_old_value);
895: --
896: irc_vacancy_approvals.show('Comparing old org value :' || l_old_value
897: || ': to new org value :' || l_new_value || ':');
898: --

Line 943: l_old_value := dbms_lob.substr(l_clob_old_value);

939: --
940: open get_old_value(l_posting_content_id);
941: fetch get_old_value into l_clob_old_value;
942: close get_old_value;
943: l_old_value := dbms_lob.substr(l_clob_old_value);
944: --
945: irc_vacancy_approvals.show('Comparing old org value :' || l_old_value
946: || ': to new org value :' || l_new_value || ':');
947: --

Line 994: l_old_value := dbms_lob.substr(l_clob_old_value);

990: (transaction_id=>transaction_id, data_name=>'PostingContentId');
991: open get_old_value(l_posting_content_id);
992: fetch get_old_value into l_clob_old_value;
993: close get_old_value;
994: l_old_value := dbms_lob.substr(l_clob_old_value);
995: --
996: irc_vacancy_approvals.show('Comparing old org value :' || l_old_value
997: || ': to new org value :' || l_new_value || ':');
998: --