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, p_show_all_sites VARCHAR2) IS

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

253: /***
254: -- Load the scores in the PL/SQL tables
255: ***/
256:
257: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
258:
259: PROCEDURE load_scores (p_keyword IN VARCHAR2 ) IS
260: l_cus_seq_num BINARY_INTEGER:= 1;
261: l_keyword VARCHAR2(100) DEFAULT '%';

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

940: mo_global.init('AR');
941: mo_global.set_policy_context('M',-1);
942:
943: if(p_org_id is null) then
944: l_org_id := FND_PROFILE.value('ORG_ID');
945: else
946: l_org_id := p_org_id;
947: end if;
948: END IF;

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

1139: mo_global.init('AR');
1140: mo_global.set_policy_context('M',-1);
1141:
1142: if(p_org_id is null) then
1143: l_org_id := FND_PROFILE.value('ORG_ID');
1144: else
1145: l_org_id := p_org_id;
1146: end if;
1147: