APPS.FA_RX_PUBLISH dependencies on ARP_UTIL_TAX

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

2328: BEGIN
2329: l_cursor := dbms_sql.open_cursor;
2330:
2331: IF (g_print_debug) THEN
2332: arp_util_tax.debug('BEGIN '||rtrim(ltrim(sqlstmt))||'; END;');
2333: END IF;
2334:
2335: dbms_sql.parse(l_cursor,
2336: 'BEGIN '||rtrim(ltrim(sqlstmt))||'; END;', dbms_sql.native);

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

2338:
2339: EXCEPTION
2340: WHEN OTHERS THEN
2341: IF (g_print_debug) THEN
2342: arp_util_tax.debug('get_select_stmt(-) wrong PL_SQL statement');
2343: END IF;
2344: END;
2345:
2346: return sqlstmt;

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

2645:
2646: begin
2647:
2648: IF (g_print_debug) THEN
2649: arp_util_tax.debug('get_rows_purged()');
2650: arp_util_tax.debug('request_id: '||request_id);
2651: END IF;
2652:
2653: select purge_api into l_purge_api

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

2646: begin
2647:
2648: IF (g_print_debug) THEN
2649: arp_util_tax.debug('get_rows_purged()');
2650: arp_util_tax.debug('request_id: '||request_id);
2651: END IF;
2652:
2653: select purge_api into l_purge_api
2654: from fa_rx_reports

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

2654: from fa_rx_reports
2655: where report_id = l_report_id;
2656:
2657: IF (g_print_debug) THEN
2658: arp_util_tax.debug('purge_api: '|| l_purge_api);
2659: END IF;
2660:
2661: if l_purge_api is not null then
2662: plsql_block := 'BEGIN :num := ' || l_purge_api||'(:id); end;';

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

2662: plsql_block := 'BEGIN :num := ' || l_purge_api||'(:id); end;';
2663: execute immediate plsql_block using out row_num, in to_number(request_id);
2664:
2665: IF (g_print_debug) THEN
2666: arp_util_tax.debug('rows purged : '||row_num);
2667: END IF;
2668: end if;
2669: end get_rows_purged;
2670: