DBA Data[Home] [Help]

APPS.ARW_SEARCH_CUSTOMERS dependencies on AR_CUST_SEARCH_GT

Line 613: delete from ar_cust_search_gt;

609: arp_standard.debug(l_debug_info);
610: END IF;
611:
612: -- Delete all entries from the table for the current session
613: delete from ar_cust_search_gt;
614:
615: l_keyword := ltrim(rtrim(i_keyword));
616: l_prefix := substrb(l_keyword,1,1);
617:

Line 684: INSERT INTO ar_cust_search_gt (

680: BEGIN
681: -- Exit if there are no more records
682: EXIT WHEN l_tab_idx IS NULL;
683:
684: INSERT INTO ar_cust_search_gt (
685: customer_id,
686: address_id,
687: bill_to_site_use_id,
688: details_level,