APPS.OKI_REFRESH_PVT dependencies on FND_PROFILE

Line 50: fnd_profile.value('OKI_BASE_CURRENCY');

46: -- Variables
47: --
48: l_ind_rec index_info_csr%ROWTYPE;
49: l_base_currency CONSTANT fnd_currencies.currency_code%TYPE :=
50: fnd_profile.value('OKI_BASE_CURRENCY');
51: -- used to limit batch collection sizes
52: l_max_rows CONSTANT binary_integer := 1000;
53:
54: ---------------------------------------------------------------------

Line 1251: fnd_profile.value('OKI_BASE_CURRENCY') base_currency_code,

1247: trunc(khr.start_date)
1248: , l_sysdate
1249: ) conversion_date,
1250: khr.currency_code currency_code,
1251: fnd_profile.value('OKI_BASE_CURRENCY') base_currency_code,
1252: sob.currency_code sob_currency_code,
1253: sob.accounted_period_type,
1254: sob.set_of_books_id,
1255: sob.period_set_name,

Line 1307: l_conv_type := fnd_profile.value('OKI_DEFAULT_CONVERSION_TYPE');

1303:
1304: BEGIN
1305: x_retcode := 0;
1306: l_sysdate := sysdate ;
1307: l_conv_type := fnd_profile.value('OKI_DEFAULT_CONVERSION_TYPE');
1308:
1309: SELECT count(*) INTO l_remainder
1310: FROM
1311: okc_k_headers_b khr,

Line 1914: l_conv_type := fnd_profile.value('OKI_DEFAULT_CONVERSION_TYPE');

1910: l_loc VARCHAR2(200) ;
1911:
1912:
1913: BEGIN
1914: l_conv_type := fnd_profile.value('OKI_DEFAULT_CONVERSION_TYPE');
1915: IF (p_from_currency =p_to_currency) THEN
1916: RETURN 1;
1917: END IF;
1918:

Line 2242: l_conversion_type := fnd_profile.value('OKI_DEFAULT_CONVERSION_TYPE');

2238: AND a.conversion_type = l_conversion_type;
2239: BEGIN
2240:
2241: retcode := '0';
2242: l_conversion_type := fnd_profile.value('OKI_DEFAULT_CONVERSION_TYPE');
2243: /* For all distinct from and to currencies */
2244: FOR r_conversion IN c_conversion
2245: LOOP
2246: --dbms_output.put_line(r_conversion.from_currency || ' '|| r_conversion.to_currency);

Line 4712: l_salesperson_code := fnd_profile.value('OKS_ENABLE_SALES_CREDIT');

4708: CLOSE index_name_csr;
4709: l_errpos := 2;
4710:
4711: /* 11510 Changes Start */
4712: l_salesperson_code := fnd_profile.value('OKS_ENABLE_SALES_CREDIT');
4713: IF l_salesperson_code IN ('YES') THEN
4714: l_salesperson_code := fnd_profile.value('OKS_VENDOR_CONTACT_ROLE');
4715: ELSE
4716: l_salesperson_code := 'SALESPERSON';

Line 4714: l_salesperson_code := fnd_profile.value('OKS_VENDOR_CONTACT_ROLE');

4710:
4711: /* 11510 Changes Start */
4712: l_salesperson_code := fnd_profile.value('OKS_ENABLE_SALES_CREDIT');
4713: IF l_salesperson_code IN ('YES') THEN
4714: l_salesperson_code := fnd_profile.value('OKS_VENDOR_CONTACT_ROLE');
4715: ELSE
4716: l_salesperson_code := 'SALESPERSON';
4717: END IF;
4718: /* 11510 Changes End */

Line 4941: l_salesperson_code := fnd_profile.value('OKS_ENABLE_SALES_CREDIT');

4937: RAISE l_excp_no_processing ;
4938: END IF ;
4939:
4940: /* 11510 Changes Start */
4941: l_salesperson_code := fnd_profile.value('OKS_ENABLE_SALES_CREDIT');
4942: IF l_salesperson_code IN ('YES') THEN
4943: l_salesperson_code := fnd_profile.value('OKS_VENDOR_CONTACT_ROLE');
4944: ELSE
4945: l_salesperson_code := 'SALESPERSON';

Line 4943: l_salesperson_code := fnd_profile.value('OKS_VENDOR_CONTACT_ROLE');

4939:
4940: /* 11510 Changes Start */
4941: l_salesperson_code := fnd_profile.value('OKS_ENABLE_SALES_CREDIT');
4942: IF l_salesperson_code IN ('YES') THEN
4943: l_salesperson_code := fnd_profile.value('OKS_VENDOR_CONTACT_ROLE');
4944: ELSE
4945: l_salesperson_code := 'SALESPERSON';
4946: END IF;
4947: /* 11510 Changes End */