APPS.ARW_SEARCH_CUSTOMERS dependencies on FND_PROFILE

Line 10: MAX_BUFFERED_ROWS BINARY_INTEGER := NVL(FND_PROFILE.value('VO_MAX_FETCH_SIZE'), 200);

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: --
12: -- Cursor to get all site records for given customer
13: --
14: CURSOR cust_cur (p_customer_id VARCHAR2) IS

Line 148: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

144: /***
145: -- Load the scores in the PL/SQL tables
146: ***/
147:
148: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
149:
150: PROCEDURE load_scores (p_keyword IN VARCHAR2 ) IS
151: l_cus_seq_num BINARY_INTEGER:= 1;
152: l_keyword VARCHAR2(100) DEFAULT '%';

Line 937: l_org_id := FND_PROFILE.value('ORG_ID');

933: delete from ar_irec_user_acct_sites_all where (session_id=p_session_id
934: or trunc(CREATION_DATE)<=trunc(sysdate-2));
935:
936: if(p_org_id is null) then
937: l_org_id := FND_PROFILE.value('ORG_ID');
938: else
939: l_org_id := p_org_id;
940: end if;
941: