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.21.12020000.4 2013/04/29 12:41:54 shvimal 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 747: l_search_result_table := arw_search_customers.search_by_name_num(

743: END IF;
744:
745: if i_name_num = 'YES' then
746:
747: l_search_result_table := arw_search_customers.search_by_name_num(
748: i_customer_name_number => l_keyword,
749: i_show_all_sites => l_show_all_sites);
750:
751: else

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

760: -- Use search_customers_by_trx if search string prefaced by '#'
761: /* */
762: if l_prefix = '#' then
763: l_keyword := substrb(l_keyword, 2, lengthb(l_keyword)-1);
764: l_search_result_table := arw_search_customers.search_customers_by_trx(i_keyword => l_keyword);
765: else
766: /* */
767: l_search_result_table := arw_search_customers.search_customers(
768: i_keyword => l_keyword,

Line 767: l_search_result_table := arw_search_customers.search_customers(

763: l_keyword := substrb(l_keyword, 2, lengthb(l_keyword)-1);
764: l_search_result_table := arw_search_customers.search_customers_by_trx(i_keyword => l_keyword);
765: else
766: /* */
767: l_search_result_table := arw_search_customers.search_customers(
768: i_keyword => l_keyword,
769: i_show_all_sites => l_show_all_sites);
770: end if;
771:

Line 1338: END arw_search_customers;

1334: commit;
1335:
1336: END update_account_sites;
1337:
1338: END arw_search_customers;