APPS.IRC_APPROVALS dependencies on DBMS_LOB

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

896: open get_old_value(l_posting_content_id);
897: fetch get_old_value into l_clob_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: --

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

946: open get_old_value(l_posting_content_id);
947: fetch get_old_value into l_clob_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: --

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

995: --
996: open get_old_value(l_posting_content_id);
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: --

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

1044: --
1045: open get_old_value(l_posting_content_id);
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: --

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

1093: --
1094: open get_old_value(l_posting_content_id);
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: --

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

1142: --
1143: open get_old_value(l_posting_content_id);
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: --

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

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;
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: --