DBA Data[Home] [Help]

APPS.ARP_RECON_REP dependencies on DBMS_UTILITY

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

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

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

1315: '||l_account_where ||'
1316: '||l_account_seg_where ||'
1317: '||l_posting_status_ard_where;
1318:
1319: DBMS_UTILITY.DB_VERSION(l_version, l_compatibility);
1320: l_majorVersion := to_number(substr(l_version, 1, instr(l_version,'.')-1));
1321:
1322: IF (l_majorVersion > 8 and l_majorVersion < 9) THEN
1323: BEGIN

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

1835: '||l_account_seg_where ||'
1836: '||l_source_type_where||'
1837: '||l_posting_status_where;
1838:
1839: DBMS_UTILITY.DB_VERSION(l_version, l_compatibility);
1840: l_majorVersion := to_number(substr(l_version, 1, instr(l_version,'.')-1));
1841:
1842: IF (l_majorVersion > 8 and l_majorVersion < 9) THEN
1843: BEGIN

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

2307: '||l_source_type_where||'
2308: '||l_posting_status_where||'
2309: order by company, category, account,app_gl_date, cm_number' ;
2310:
2311: DBMS_UTILITY.DB_VERSION(l_version, l_compatibility);
2312: l_majorVersion := to_number(substr(l_version, 1, instr(l_version,'.')-1));
2313:
2314: IF (l_majorVersion > 8 and l_majorVersion < 9) THEN
2315: BEGIN

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

3016: ar_calc_aging.get_value(101,''GL#'',
3017: arp_recon_rep.get_chart_of_accounts_id(),
3018: ''GL_ACCOUNT'',code_combination_id)';
3019:
3020: DBMS_UTILITY.DB_VERSION(l_version, l_compatibility);
3021: l_majorVersion := to_number(substr(l_version, 1, instr(l_version,'.')-1));
3022:
3023: IF (l_majorVersion > 8 and l_majorVersion < 9) THEN
3024: BEGIN