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');
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:
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';
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:
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: