APPS.ARW_SEARCH_CUSTOMERS dependencies on ARW_SEARCH_CUSTOMERS

Line 1: PACKAGE BODY ARW_SEARCH_CUSTOMERS AS

1: PACKAGE BODY ARW_SEARCH_CUSTOMERS AS
2: /*$Header: ARWCUSRB.pls 120.14.12010000.3 2009/01/08 06:57:29 avepati ship $*/
3: --
4: /*=======================================================================+
5: | Package Global Constants

Line 7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ARW_SEARCH_CUSTOMERS';

3: --
4: /*=======================================================================+
5: | Package Global Constants
6: +=======================================================================*/
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ARW_SEARCH_CUSTOMERS';
8:
9: -- bugfix 2235673 - setting query limit to 200
10: MAX_BUFFERED_ROWS BINARY_INTEGER := NVL(FND_PROFILE.value('VO_MAX_FETCH_SIZE'), 200);
11: --

Line 628: l_search_result_table := arw_search_customers.search_by_name_num(

624: END IF;
625:
626: if i_name_num = 'YES' then
627:
628: l_search_result_table := arw_search_customers.search_by_name_num(
629: i_customer_name_number => l_keyword);
630:
631: else
632:

Line 644: l_search_result_table := arw_search_customers.search_customers_by_trx(i_keyword => l_keyword);

640: -- Use search_customers_by_trx if search string prefaced by '#'
641: /* */
642: if l_prefix = '#' then
643: l_keyword := substrb(l_keyword, 2, lengthb(l_keyword)-1);
644: l_search_result_table := arw_search_customers.search_customers_by_trx(i_keyword => l_keyword);
645: else
646: /* */
647: l_search_result_table := arw_search_customers.search_customers(
648: i_keyword => l_keyword);

Line 647: l_search_result_table := arw_search_customers.search_customers(

643: l_keyword := substrb(l_keyword, 2, lengthb(l_keyword)-1);
644: l_search_result_table := arw_search_customers.search_customers_by_trx(i_keyword => l_keyword);
645: else
646: /* */
647: l_search_result_table := arw_search_customers.search_customers(
648: i_keyword => l_keyword);
649: end if;
650:
651: end if;

Line 1111: END arw_search_customers;

1107: commit;
1108:
1109: END update_account_sites;
1110:
1111: END arw_search_customers;