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_ENGINE_PVT dependencies on AMS_ACTMETRIC_PVT

Line 1382: Ams_Actmetric_Pvt.CONVERT_CURRENCY2(

1378: AND l_func_currency_code <> p_default_currency
1379: THEN
1380: -- IF l_func_currency_code IS NOT NULL AND
1381: -- l_func_currency_code <> p_default_currency THEN
1382: Ams_Actmetric_Pvt.CONVERT_CURRENCY2(
1383: x_return_status => l_return_status,
1384: p_from_currency => l_func_currency_code,
1385: p_to_currency => p_default_currency,
1386: p_conv_date => l_current_date,

Line 1547: l_default_currency := ams_actmetric_pvt.default_func_currency;

1543: BEGIN
1544: IF AMS_DEBUG_HIGH_ON THEN
1545: write_msg(L_API_NAME, 'START: '||p_calc_type||': COUNT='||x_dirty_actmet.COUNT);
1546: END IF;
1547: l_default_currency := ams_actmetric_pvt.default_func_currency;
1548: --
1549: -- Phase 4, convert all currencies to transactional amount
1550: --
1551: l_id := x_dirty_actmet.FIRST;

Line 1568: Ams_Actmetric_Pvt.GET_TRANS_CURR_CODE(

1564: l_arc_act_metric_used_by THEN
1565: l_trans_currency_code :=
1566: l_obj_currencies(l_act_metric_used_by_id).currency;
1567: ELSE
1568: Ams_Actmetric_Pvt.GET_TRANS_CURR_CODE(
1569: p_obj_id => l_act_metric_used_by_id,
1570: p_obj_type => l_arc_act_metric_used_by,
1571: x_trans_curr_code => l_trans_currency_code
1572: );

Line 1583: Ams_Actmetric_Pvt.Convert_Currency2 (

1579: -- x_dirty_actmet(l_id).trans_currency_code := l_trans_currency_code;
1580: x_dirty_actmet(l_id).trans_currency_code :=
1581: nvl(l_trans_currency_code, l_default_currency);
1582: -- BUG 3484528: END
1583: Ams_Actmetric_Pvt.Convert_Currency2 (
1584: x_return_status => x_return_status,
1585: p_from_currency => x_dirty_actmet(l_id).func_currency_code,
1586: p_to_currency => x_dirty_actmet(l_id).trans_currency_code,
1587: p_conv_date => x_dirty_actmet(l_id).last_calculated_date,

Line 1791: l_default_currency VARCHAR2(15) := Ams_Actmetric_Pvt.DEFAULT_FUNC_CURRENCY;

1787: l_obj_version num_table_type;
1788: **/
1789: l_first NUMBER;
1790: l_last NUMBER;
1791: l_default_currency VARCHAR2(15) := Ams_Actmetric_Pvt.DEFAULT_FUNC_CURRENCY;
1792: l_current_date date := SYSDATE;
1793:
1794: BEGIN
1795: x_retcode := 0;

Line 1996: l_default_currency VARCHAR2(15) := Ams_Actmetric_Pvt.DEFAULT_FUNC_CURRENCY;

1992: l_obj_version num_table_type;
1993: **/
1994: l_first NUMBER;
1995: l_last NUMBER;
1996: l_default_currency VARCHAR2(15) := Ams_Actmetric_Pvt.DEFAULT_FUNC_CURRENCY;
1997: l_current_date date := SYSDATE;
1998:
1999: l_object_list object_currency_table;
2000:

Line 2570: l_act_metrics_rec Ams_Actmetric_Pvt.act_metric_rec_type;

2566: l_parent_obj_type VARCHAR2(30);
2567: l_parent_obj_id NUMBER;
2568:
2569: l_parent_act_metric_id NUMBER;
2570: l_act_metrics_rec Ams_Actmetric_Pvt.act_metric_rec_type;
2571:
2572: l_parent_metric_id NUMBER;
2573: l_new_act_metric_id NUMBER;
2574:

Line 2757: Ams_Actmetric_Pvt.Create_ActMetric (

2753:
2754: IF AMS_DEBUG_MEDIUM_ON THEN
2755: write_msg(L_API_NAME,'creating parent: metric_id='||p_metric_parent_id);
2756: END IF;
2757: Ams_Actmetric_Pvt.Create_ActMetric (
2758: p_api_version => l_api_version,
2759: p_init_msg_list => FND_API.G_FALSE,
2760: p_act_metric_rec => l_act_metrics_rec,
2761: x_return_status => l_return_status,

Line 2961: -- l_act_metric_rec Ams_Actmetric_Pvt.Act_Metric_Rec_Type;

2957: IS
2958: L_API_NAME VARCHAR2(30) := 'Run_Functions';
2959: L_FULL_NAME CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
2960: l_new_func_value AMS_ACT_METRICS_ALL.FUNC_ACTUAL_VALUE%TYPE;
2961: -- l_act_metric_rec Ams_Actmetric_Pvt.Act_Metric_Rec_Type;
2962:
2963: l_return_status VARCHAR2(1);
2964: l_msg_count NUMBER;
2965: l_msg_data VARCHAR2(4000);

Line 3203: Ams_Actmetric_Pvt.Convert_Currency (

3199: l_days_since_last_refreshs(l_count) :=
3200: l_current_date - l_last_calculated_dates(l_index);
3201: l_new_trans_actuals(l_count) := l_new_func_value;
3202: IF l_func_currencies(l_count) IS NOT NULL THEN
3203: Ams_Actmetric_Pvt.Convert_Currency (
3204: x_return_status => l_return_status,
3205: p_from_currency => l_func_currencies(l_count),
3206: p_to_currency => l_trans_currencies(l_count),
3207: p_conv_date => l_current_date,

Line 3314: l_default_currency VARCHAR2(15) := Ams_Actmetric_Pvt.DEFAULT_FUNC_CURRENCY;

3310: l_retcode VARCHAR2(10);
3311: l_index number;
3312: l_object_list object_currency_table;
3313: l_current_date date := sysdate;
3314: l_default_currency VARCHAR2(15) := Ams_Actmetric_Pvt.DEFAULT_FUNC_CURRENCY;
3315: begin
3316:
3317: savepoint sp_run_functions;
3318:

Line 3891: l_func_currency_code varchar2(30) := Ams_Actmetric_Pvt.DEFAULT_FUNC_CURRENCY;

3887: l_new_func_actual_values num_table_type;
3888: l_new_forecast_variable_values num_table_type;
3889:
3890: l_current_date date := SYSDATE;
3891: l_func_currency_code varchar2(30) := Ams_Actmetric_Pvt.DEFAULT_FUNC_CURRENCY;
3892: l_return_status varchar2(10);
3893: l_first number;
3894: l_last number;
3895:

Line 4002: ams_actmetric_pvt.Convert_Currency2 (

3998: END IF;
3999:
4000: IF l_trans_currencies(l_index) IS NOT NULL THEN
4001: l_new_func_currencies(l_index) := l_func_currency_code;
4002: ams_actmetric_pvt.Convert_Currency2 (
4003: x_return_status => l_return_status,
4004: p_from_currency => l_trans_currencies(l_index),
4005: p_to_currency => l_new_func_currencies(l_index),
4006: p_conv_date => l_current_date,

Line 4120: l_default_currency VARCHAR2(15) := Ams_Actmetric_Pvt.DEFAULT_FUNC_CURRENCY;

4116: l_retcode VARCHAR2(10);
4117: l_index number;
4118: l_object_list object_currency_table;
4119: l_current_date date := sysdate;
4120: l_default_currency VARCHAR2(15) := Ams_Actmetric_Pvt.DEFAULT_FUNC_CURRENCY;
4121: begin
4122:
4123: savepoint sp_Update_Variable;
4124:

Line 4254: SELECT G_ALIST, act_list_header_id, Ams_Actmetric_Pvt.DEFAULT_FUNC_CURRENCY,

4250: WHERE deliverable_id = l_act_metric_used_by_id;
4251:
4252: CURSOR c_check_act_list(l_act_metric_used_by_id NUMBER)
4253: return object_detail_type IS
4254: SELECT G_ALIST, act_list_header_id, Ams_Actmetric_Pvt.DEFAULT_FUNC_CURRENCY,
4255: NULL, NULL, Fnd_Api.G_FALSE cancelled_flag,
4256: G_SHOW
4257: FROM ams_act_lists
4258: WHERE act_list_header_id = l_act_metric_used_by_id;

Line 4492: SELECT act_list_header_id obj_id, G_ALIST obj_type, Ams_Actmetric_Pvt.DEFAULT_FUNC_CURRENCY currency

4488: FROM ams_deliverables_all_b
4489: WHERE deliverable_id = p_deliverable_id;
4490:
4491: CURSOR c_get_act_list (p_act_list_header_id NUMBER) IS
4492: SELECT act_list_header_id obj_id, G_ALIST obj_type, Ams_Actmetric_Pvt.DEFAULT_FUNC_CURRENCY currency
4493: FROM ams_act_lists
4494: WHERE act_list_header_id = p_act_list_header_id;
4495:
4496: /*** BUG2845365: Removed dialogue Components.

Line 4584: l_is_locked := ams_actmetric_pvt.lock_object(

4580: /***** NOT REQUIRED *******
4581: ***** Locking is only required when created new metrics *****
4582: --Sunkumar Bug# 3106033
4583: IF l_obj_item.obj_id IS NOT NULL THEN
4584: l_is_locked := ams_actmetric_pvt.lock_object(
4585: p_api_version => 1 ,
4586: p_init_msg_list => Fnd_Api.G_FALSE,
4587: p_arc_act_metric_used_by => l_obj_item.obj_type,
4588: p_act_metric_used_by_id => l_obj_item.obj_id,

Line 6279: Ams_Actmetric_Pvt.GET_TRANS_CURR_CODE(

6275: THEN
6276: l_transactional_currency_codes(l_index) :=
6277: l_obj_currencies(l_act_metric_used_by_ids(l_index)).currency;
6278: ELSE
6279: Ams_Actmetric_Pvt.GET_TRANS_CURR_CODE(
6280: p_obj_id => l_act_metric_used_by_ids(l_index),
6281: p_obj_type => l_arc_act_metric_used_bys(l_index),
6282: x_trans_curr_code => l_transactional_currency_codes(l_index)
6283: );

Line 6291: ams_actmetric_pvt.Convert_Currency2 (

6287: NVL(l_transactional_currency_codes(l_index),p_func_currency);
6288: l_obj_currencies(l_act_metric_used_by_ids(l_index)) :=
6289: l_obj_currency;
6290: END IF;
6291: ams_actmetric_pvt.Convert_Currency2 (
6292: x_return_status => l_return_status,
6293: p_from_currency => l_functional_currency_codes(l_index),
6294: p_to_currency => l_transactional_currency_codes(l_index),
6295: p_conv_date => p_current_date,

Line 6403: l_default_currency VARCHAR2(15) := Ams_Actmetric_Pvt.DEFAULT_FUNC_CURRENCY;

6399: l_retcode VARCHAR2(10);
6400: l_index number;
6401: l_object_list object_currency_table;
6402: l_current_date date := sysdate;
6403: l_default_currency VARCHAR2(15) := Ams_Actmetric_Pvt.DEFAULT_FUNC_CURRENCY;
6404: begin
6405:
6406: savepoint sp_Update_formulas;
6407: