APPS.OZF_REFRESH_SALES_PVT dependencies on FND_PROFILE

Line 56: l_global_start_date DATE := TO_DATE(FND_PROFILE.VALUE('OZF_TP_GLOBAL_START_DATE'), 'MM/DD/YYYY');

52: l_api_name CONSTANT VARCHAR2(30) := 'full_load';
53: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
54: l_return_status VARCHAR2(1);
55:
56: l_global_start_date DATE := TO_DATE(FND_PROFILE.VALUE('OZF_TP_GLOBAL_START_DATE'), 'MM/DD/YYYY');
57: l_common_uom VARCHAR2(30) := FND_PROFILE.VALUE('OZF_TP_COMMON_UOM');
58: l_common_currency_code VARCHAR2(30) := FND_PROFILE.VALUE('OZF_TP_COMMON_CURRENCY');
59: l_curr_conv_type VARCHAR2(30) := FND_PROFILE.VALUE('OZF_CURR_CONVERSION_TYPE');
60:

Line 57: l_common_uom VARCHAR2(30) := FND_PROFILE.VALUE('OZF_TP_COMMON_UOM');

53: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
54: l_return_status VARCHAR2(1);
55:
56: l_global_start_date DATE := TO_DATE(FND_PROFILE.VALUE('OZF_TP_GLOBAL_START_DATE'), 'MM/DD/YYYY');
57: l_common_uom VARCHAR2(30) := FND_PROFILE.VALUE('OZF_TP_COMMON_UOM');
58: l_common_currency_code VARCHAR2(30) := FND_PROFILE.VALUE('OZF_TP_COMMON_CURRENCY');
59: l_curr_conv_type VARCHAR2(30) := FND_PROFILE.VALUE('OZF_CURR_CONVERSION_TYPE');
60:
61: l_profile_option_name VARCHAR2(80);

Line 58: l_common_currency_code VARCHAR2(30) := FND_PROFILE.VALUE('OZF_TP_COMMON_CURRENCY');

54: l_return_status VARCHAR2(1);
55:
56: l_global_start_date DATE := TO_DATE(FND_PROFILE.VALUE('OZF_TP_GLOBAL_START_DATE'), 'MM/DD/YYYY');
57: l_common_uom VARCHAR2(30) := FND_PROFILE.VALUE('OZF_TP_COMMON_UOM');
58: l_common_currency_code VARCHAR2(30) := FND_PROFILE.VALUE('OZF_TP_COMMON_CURRENCY');
59: l_curr_conv_type VARCHAR2(30) := FND_PROFILE.VALUE('OZF_CURR_CONVERSION_TYPE');
60:
61: l_profile_option_name VARCHAR2(80);
62: l_user_profile_option_name VARCHAR2(240);

Line 59: l_curr_conv_type VARCHAR2(30) := FND_PROFILE.VALUE('OZF_CURR_CONVERSION_TYPE');

55:
56: l_global_start_date DATE := TO_DATE(FND_PROFILE.VALUE('OZF_TP_GLOBAL_START_DATE'), 'MM/DD/YYYY');
57: l_common_uom VARCHAR2(30) := FND_PROFILE.VALUE('OZF_TP_COMMON_UOM');
58: l_common_currency_code VARCHAR2(30) := FND_PROFILE.VALUE('OZF_TP_COMMON_CURRENCY');
59: l_curr_conv_type VARCHAR2(30) := FND_PROFILE.VALUE('OZF_CURR_CONVERSION_TYPE');
60:
61: l_profile_option_name VARCHAR2(80);
62: l_user_profile_option_name VARCHAR2(240);
63:

Line 66: FROM fnd_profile_options_vl

62: l_user_profile_option_name VARCHAR2(240);
63:
64: CURSOR prf_name_csr IS
65: SELECT user_profile_option_name
66: FROM fnd_profile_options_vl
67: WHERE profile_option_name = l_profile_option_name;
68:
69: CURSOR error_csr IS
70: SELECT distinct