APPS.FA_RX_PUBLISH dependencies on ARP_UTIL_TAX

Line 2400: arp_util_tax.debug('BEGIN '||rtrim(ltrim(sqlstmt))||'; END;');

2396: BEGIN
2397: l_cursor := dbms_sql.open_cursor;
2398:
2399: IF (g_print_debug) THEN
2400: arp_util_tax.debug('BEGIN '||rtrim(ltrim(sqlstmt))||'; END;');
2401: END IF;
2402:
2403: dbms_sql.parse(l_cursor,
2404: 'BEGIN '||rtrim(ltrim(sqlstmt))||'; END;', dbms_sql.native);

Line 2410: arp_util_tax.debug('get_select_stmt(-) wrong PL_SQL statement');

2406:
2407: EXCEPTION
2408: WHEN OTHERS THEN
2409: IF (g_print_debug) THEN
2410: arp_util_tax.debug('get_select_stmt(-) wrong PL_SQL statement');
2411: END IF;
2412: END;
2413:
2414: return sqlstmt;

Line 2717: arp_util_tax.debug('get_rows_purged()');

2713:
2714: begin
2715:
2716: IF (g_print_debug) THEN
2717: arp_util_tax.debug('get_rows_purged()');
2718: arp_util_tax.debug('request_id: '||request_id);
2719: END IF;
2720:
2721: select purge_api into l_purge_api

Line 2718: arp_util_tax.debug('request_id: '||request_id);

2714: begin
2715:
2716: IF (g_print_debug) THEN
2717: arp_util_tax.debug('get_rows_purged()');
2718: arp_util_tax.debug('request_id: '||request_id);
2719: END IF;
2720:
2721: select purge_api into l_purge_api
2722: from fa_rx_reports

Line 2726: arp_util_tax.debug('purge_api: '|| l_purge_api);

2722: from fa_rx_reports
2723: where report_id = l_report_id;
2724:
2725: IF (g_print_debug) THEN
2726: arp_util_tax.debug('purge_api: '|| l_purge_api);
2727: END IF;
2728:
2729: if l_purge_api is not null then
2730: plsql_block := 'BEGIN :num := ' || l_purge_api||'(:id); end;';

Line 2734: arp_util_tax.debug('rows purged : '||row_num);

2730: plsql_block := 'BEGIN :num := ' || l_purge_api||'(:id); end;';
2731: execute immediate plsql_block using out row_num, in to_number(request_id);
2732:
2733: IF (g_print_debug) THEN
2734: arp_util_tax.debug('rows purged : '||row_num);
2735: END IF;
2736: end if;
2737: end get_rows_purged;
2738: