DBA Data[Home] [Help]

APPS.ARW_SEARCH_CUSTOMERS dependencies on AR_CUST_SEARCH_GT

Line 727: delete from ar_cust_search_gt;

723: arp_standard.debug(l_debug_info);
724: END IF;
725:
726: -- Delete all entries from the table for the current session
727: delete from ar_cust_search_gt;
728:
729: l_keyword := ltrim(rtrim(i_keyword));
730: l_prefix := substrb(l_keyword,1,1);
731:

Line 819: INSERT INTO ar_cust_search_gt (

815: BEGIN
816: -- Exit if there are no more records
817: EXIT WHEN l_tab_idx IS NULL;
818:
819: INSERT INTO ar_cust_search_gt (
820: customer_id,
821: address_id,
822: bill_to_site_use_id,
823: details_level,