eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_ACTMETRICS_SEED_PVT dependencies on FND_PROFILE

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 163: G_CALC_LAG_DAYS CONSTANT NUMBER := fnd_profile.value('AMS_METR_SEEDED_CALC_EXP');

159: --sunkumar - 18-Jun-2003 - bug #2948298
160: G_ACTIVITY_EVENTS CONSTANT VARCHAR2(30) := 'EVENTS';
161:
162: -- BUG 4281906: Calculation lag in days.
163: G_CALC_LAG_DAYS CONSTANT NUMBER := fnd_profile.value('AMS_METR_SEEDED_CALC_EXP');
164:
165: AMS_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
166: AMS_DEBUG_LOW_ON BOOLEAN := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
167: AMS_DEBUG_MEDIUM_ON BOOLEAN := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

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 238: l_conversion_type := fnd_profile.VALUE(l_conversion_type_profile);

234: RETURN p_from_amount;
235: END IF;
236:
237: -- condition added to pass conversion types
238: l_conversion_type := fnd_profile.VALUE(l_conversion_type_profile);
239:
240: -- Conversion type cannot be null in profile
241: IF l_conversion_type IS NULL THEN
242: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

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:

Line 306: l_conversion_type := fnd_profile.VALUE(l_conversion_type_profile);

302: RETURN p_from_amount;
303: END IF;
304:
305: -- condition added to pass conversion types
306: l_conversion_type := fnd_profile.VALUE(l_conversion_type_profile);
307:
308: -- Conversion type cannot be null in profile
309: IF l_conversion_type IS NULL THEN
310: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

Line 554: fnd_profile.value('AS_LEAD_LINK_STATUS'),

550: and a.metric_id = b.metric_id;
551:
552: cursor c_get_profiles is
553: select max(max_score),
554: fnd_profile.value('AS_LEAD_LINK_STATUS'),
555: fnd_profile.value('AS_DEAD_LEAD_STATUS')
556: from as_sales_lead_ranks_b
557: where enabled_flag = 'Y';
558:

Line 555: fnd_profile.value('AS_DEAD_LEAD_STATUS')

551:
552: cursor c_get_profiles is
553: select max(max_score),
554: fnd_profile.value('AS_LEAD_LINK_STATUS'),
555: fnd_profile.value('AS_DEAD_LEAD_STATUS')
556: from as_sales_lead_ranks_b
557: where enabled_flag = 'Y';
558:
559: l_max_score number;

Line 1106: fnd_profile.value('AS_LEAD_LINK_STATUS'),

1102: AND a.metric_id = b.metric_id;
1103:
1104: cursor c_get_profiles is
1105: select max(max_score),
1106: fnd_profile.value('AS_LEAD_LINK_STATUS'),
1107: fnd_profile.value('AS_DEAD_LEAD_STATUS')
1108: from as_sales_lead_ranks_b
1109: where enabled_flag = 'Y';
1110:

Line 1107: fnd_profile.value('AS_DEAD_LEAD_STATUS')

1103:
1104: cursor c_get_profiles is
1105: select max(max_score),
1106: fnd_profile.value('AS_LEAD_LINK_STATUS'),
1107: fnd_profile.value('AS_DEAD_LEAD_STATUS')
1108: from as_sales_lead_ranks_b
1109: where enabled_flag = 'Y';
1110:
1111: l_max_score number;

Line 2435: l_inferred_period number := fnd_profile.value('AMS_METR_INFERRED_PERIOD');

2431: and a.act_metric_used_by_id = object_id;
2432:
2433: l_has_enabled NUMBER;
2434: l_today date := sysdate;
2435: l_inferred_period number := fnd_profile.value('AMS_METR_INFERRED_PERIOD');
2436: begin
2437: open c_has_inferred_enabled(p_arc_act_metric_used_by, p_act_metric_used_by_id);
2438: fetch c_has_inferred_enabled into l_has_enabled;
2439: close c_has_inferred_enabled;

Line 2537: l_inferred_period number := fnd_profile.value('AMS_METR_INFERRED_PERIOD');

2533: AND nvl(last_calculated_date,l_today) > l_today - G_CALC_LAG_DAYS;
2534:
2535: l_has_enabled NUMBER;
2536: l_activity_count NUMBER;
2537: l_inferred_period number := fnd_profile.value('AMS_METR_INFERRED_PERIOD');
2538: begin
2539: open c_has_inferred_enabled;
2540: fetch c_has_inferred_enabled into l_has_enabled, l_activity_count;
2541: close c_has_inferred_enabled;

Line 2645: l_inferred_period number := fnd_profile.value('AMS_METR_INFERRED_PERIOD');

2641: and a.act_metric_used_by_id = object_id;
2642:
2643: l_has_enabled NUMBER;
2644: l_today date := sysdate;
2645: l_inferred_period number := fnd_profile.value('AMS_METR_INFERRED_PERIOD');
2646: begin
2647: open c_has_inferred_enabled(p_arc_act_metric_used_by, p_act_metric_used_by_id);
2648: fetch c_has_inferred_enabled into l_has_enabled;
2649: close c_has_inferred_enabled;

Line 2755: l_inferred_period number := fnd_profile.value('AMS_METR_INFERRED_PERIOD');

2751: AND nvl(last_calculated_date,l_today) > l_today - G_CALC_LAG_DAYS;
2752:
2753: l_has_enabled NUMBER;
2754: l_activity_count NUMBER;
2755: l_inferred_period number := fnd_profile.value('AMS_METR_INFERRED_PERIOD');
2756: begin
2757: open c_has_inferred_enabled;
2758: fetch c_has_inferred_enabled into l_has_enabled,l_activity_count;
2759: close c_has_inferred_enabled;

Line 2872: l_inferred_period number := fnd_profile.value('AMS_METR_INFERRED_PERIOD');

2868: and a.act_metric_used_by_id = object_id;
2869:
2870: l_has_enabled NUMBER;
2871: l_today date := sysdate;
2872: l_inferred_period number := fnd_profile.value('AMS_METR_INFERRED_PERIOD');
2873: begin
2874: open c_has_inferred_enabled(p_arc_act_metric_used_by, p_act_metric_used_by_id);
2875: fetch c_has_inferred_enabled into l_has_enabled;
2876: close c_has_inferred_enabled;

Line 3012: l_inferred_period number := fnd_profile.value('AMS_METR_INFERRED_PERIOD');

3008: AND nvl(last_calculated_date,l_today) > l_today - G_CALC_LAG_DAYS;
3009:
3010: l_has_enabled NUMBER;
3011: l_activity_count NUMBER;
3012: l_inferred_period number := fnd_profile.value('AMS_METR_INFERRED_PERIOD');
3013: begin
3014: open c_has_inferred_enabled;
3015: fetch c_has_inferred_enabled into l_has_enabled,l_activity_count;
3016: close c_has_inferred_enabled;

Line 3189: l_inferred_period number := fnd_profile.value('AMS_METR_INFERRED_PERIOD');

3185: AND nvl(last_calculated_date,l_today) > l_today - G_CALC_LAG_DAYS;
3186:
3187: l_has_enabled NUMBER;
3188: l_activity_count NUMBER;
3189: l_inferred_period number := fnd_profile.value('AMS_METR_INFERRED_PERIOD');
3190:
3191:
3192:
3193: begin

Line 3303: l_inferred_period number := fnd_profile.value('AMS_METR_INFERRED_PERIOD');

3299: AND nvl(last_calculated_date,l_today) > l_today - G_CALC_LAG_DAYS;
3300:
3301: l_has_enabled NUMBER;
3302: l_activity_count NUMBER;
3303: l_inferred_period number := fnd_profile.value('AMS_METR_INFERRED_PERIOD');
3304: l_sql_stmt VARCHAR2(2000);
3305:
3306: begin
3307: open c_has_inferred_enabled;

Line 3489: l_inferred_period number := fnd_profile.value('AMS_METR_INFERRED_PERIOD');

3485: AND nvl(last_calculated_date,l_today) > l_today - G_CALC_LAG_DAYS;
3486:
3487: l_has_enabled NUMBER;
3488: l_activity_count NUMBER;
3489: l_inferred_period number := fnd_profile.value('AMS_METR_INFERRED_PERIOD');
3490: begin
3491: open c_has_inferred_enabled;
3492: fetch c_has_inferred_enabled into l_has_enabled,l_activity_count;
3493: close c_has_inferred_enabled;