DBA Data[Home] [Help]

APPS.AMS_ACTMETRICS_SEED_PVT dependencies on FND_PROFILE_OPTION_VALUES

Line 80: G_DEAD_LEAD_STATUS fnd_profile_option_values.profile_option_value%TYPE := fnd_profile.value('AS_DEAD_LEAD_STATUS');

76: -- sunkumar Added 11.5.10: 05-August-2003
77: G_TARGET_FUNCTION_NAME CONSTANT VARCHAR2(80) :='AMS_ACTMETRICS_SEED_PVT.CALCULATE_TARGET_GROUP';
78: G_LIST_FUNCTION_NAME CONSTANT VARCHAR2(80) := 'AMS_ACTMETRICS_SEED_PVT.CALCULATE_SEEDED_LIST_METRICS';
79:
80: G_DEAD_LEAD_STATUS fnd_profile_option_values.profile_option_value%TYPE := fnd_profile.value('AS_DEAD_LEAD_STATUS');
81: G_LEAD_LINK_STATUS fnd_profile_option_values.profile_option_value%TYPE := fnd_profile.value('AS_LEAD_LINK_STATUS');
82: -- sunkumar end additions
83:
84: G_FUNC_CURRENCY fnd_profile_option_values.profile_option_value%TYPE := fnd_profile.value('AMS_DEFAULT_CURR_CODE');

Line 81: G_LEAD_LINK_STATUS fnd_profile_option_values.profile_option_value%TYPE := fnd_profile.value('AS_LEAD_LINK_STATUS');

77: G_TARGET_FUNCTION_NAME CONSTANT VARCHAR2(80) :='AMS_ACTMETRICS_SEED_PVT.CALCULATE_TARGET_GROUP';
78: G_LIST_FUNCTION_NAME CONSTANT VARCHAR2(80) := 'AMS_ACTMETRICS_SEED_PVT.CALCULATE_SEEDED_LIST_METRICS';
79:
80: G_DEAD_LEAD_STATUS fnd_profile_option_values.profile_option_value%TYPE := fnd_profile.value('AS_DEAD_LEAD_STATUS');
81: G_LEAD_LINK_STATUS fnd_profile_option_values.profile_option_value%TYPE := fnd_profile.value('AS_LEAD_LINK_STATUS');
82: -- sunkumar end additions
83:
84: G_FUNC_CURRENCY fnd_profile_option_values.profile_option_value%TYPE := fnd_profile.value('AMS_DEFAULT_CURR_CODE');
85:

Line 84: G_FUNC_CURRENCY fnd_profile_option_values.profile_option_value%TYPE := fnd_profile.value('AMS_DEFAULT_CURR_CODE');

80: G_DEAD_LEAD_STATUS fnd_profile_option_values.profile_option_value%TYPE := fnd_profile.value('AS_DEAD_LEAD_STATUS');
81: G_LEAD_LINK_STATUS fnd_profile_option_values.profile_option_value%TYPE := fnd_profile.value('AS_LEAD_LINK_STATUS');
82: -- sunkumar end additions
83:
84: G_FUNC_CURRENCY fnd_profile_option_values.profile_option_value%TYPE := fnd_profile.value('AMS_DEFAULT_CURR_CODE');
85:
86:
87: -- sunkumar Added 11.5.10: 05-August-2003
88: G_ACCOUNTING_INFO VARCHAR2(30) := 'Accounting Information';

Line 226: l_conversion_type fnd_profile_option_values.profile_option_value%TYPE; -- Curr conversion type; see API doc for details.

222: p_from_currency VARCHAR2
223: ,p_from_amount NUMBER) RETURN NUMBER
224: IS
225: l_conversion_type_profile CONSTANT VARCHAR2(30) := 'AMS_CURR_CONVERSION_TYPE';
226: l_conversion_type fnd_profile_option_values.profile_option_value%TYPE; -- Curr conversion type; see API doc for details.
227: l_to_amount NUMBER;
228: x_return_status VARCHAR2(1);
229: BEGIN
230:

Line 294: l_conversion_type fnd_profile_option_values.profile_option_value%TYPE; -- Curr conversion type; see API doc for details.

290: p_trans_currency VARCHAR2
291: ,p_from_amount NUMBER) RETURN NUMBER
292: IS
293: l_conversion_type_profile CONSTANT VARCHAR2(30) := 'AMS_CURR_CONVERSION_TYPE';
294: l_conversion_type fnd_profile_option_values.profile_option_value%TYPE; -- Curr conversion type; see API doc for details.
295: l_to_amount NUMBER;
296: x_return_status VARCHAR2(1);
297: BEGIN
298: