APPS.ARP_RECON_REP dependencies on DBMS_UTILITY

Line 727: DBMS_UTILITY.DB_VERSION(l_version, l_compatibility);

723: '||l_source_type_where||'
724: '||l_posting_status_where||'
725: order by company, category, account,adj_gl_date, adjustment_number' ;
726:
727: DBMS_UTILITY.DB_VERSION(l_version, l_compatibility);
728: l_majorVersion := to_number(substr(l_version, 1, instr(l_version,'.')-1));
729:
730: IF (l_majorVersion > 8 and l_majorVersion < 9) THEN
731: BEGIN

Line 1884: DBMS_UTILITY.DB_VERSION(l_version, l_compatibility);

1880: l_xml_build(NVL(l_xml_build.LAST, 0)+ 1) := l_xml_build_sql;
1881: fnd_file.put_line(FND_FILE.LOG, l_xml_build_sql);
1882: l_xml_query := l_xml_query||to_clob(l_xml_build_sql);
1883:
1884: DBMS_UTILITY.DB_VERSION(l_version, l_compatibility);
1885: l_majorVersion := to_number(substr(l_version, 1, instr(l_version,'.')-1));
1886:
1887: IF (l_majorVersion > 8 and l_majorVersion < 11) THEN
1888: BEGIN

Line 2993: DBMS_UTILITY.DB_VERSION(l_version, l_compatibility);

2989: l_xml_build(NVL(l_xml_build.LAST, 0)+ 1) := l_xml_build_sql;
2990: l_xml_query := l_xml_query||to_clob(l_xml_build_sql);
2991: fnd_file.put_line(FND_FILE.LOG, l_xml_build_sql);
2992:
2993: DBMS_UTILITY.DB_VERSION(l_version, l_compatibility);
2994: l_majorVersion := to_number(substr(l_version, 1, instr(l_version,'.')-1));
2995:
2996: IF (l_majorVersion > 8 and l_majorVersion < 11) THEN
2997: BEGIN

Line 3524: DBMS_UTILITY.DB_VERSION(l_version, l_compatibility);

3520: '||l_source_type_where||'
3521: '||l_posting_status_where||'
3522: order by company, category, account,app_gl_date, cm_number' ;
3523:
3524: DBMS_UTILITY.DB_VERSION(l_version, l_compatibility);
3525: l_majorVersion := to_number(substr(l_version, 1, instr(l_version,'.')-1));
3526:
3527: IF (l_majorVersion > 8 and l_majorVersion < 9) THEN
3528: BEGIN

Line 4794: DBMS_UTILITY.DB_VERSION(l_version, l_compatibility);

4790: order by account_type_code,
4791: company,
4792: account';
4793:
4794: DBMS_UTILITY.DB_VERSION(l_version, l_compatibility);
4795: l_majorVersion := to_number(substr(l_version, 1, instr(l_version,'.')-1));
4796:
4797: IF (l_majorVersion > 8 and l_majorVersion < 9) THEN
4798: BEGIN