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.BIS_PMV_ACTUAL_PVT dependencies on BIS_PMV_ACTUAL_PVT

Line 1: package body BIS_PMV_ACTUAL_PVT as

1: package body BIS_PMV_ACTUAL_PVT as
2: /* $Header: BISVACLB.pls 120.1 2006/03/28 12:52:27 nbarik noship $ */
3: -- dbdrv: sql ~PROD ~PATH ~FILE none none none package &phase=plb \
4: -- dbdrv: checkfile(115.48=120.1):~PROD:~PATH:~FILE
5:

Line 13: ,p_time_parameter IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE

9: (p_region_code IN VARCHAR2
10: ,p_function_name IN VARCHAR2 DEFAULT NULL
11: ,p_user_id IN VARCHAR2 DEFAULT NULL
12: ,p_responsibility_id IN VARCHAR2 DEFAULT NULL
13: ,p_time_parameter IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE
14: ,p_parameters IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE
15: ,p_param_ids IN VARCHAR2 DEFAULT 'N'
16: ,p_actual_attribute_code IN VARCHAR2
17: ,p_compareto_attribute_code IN VARCHAR2 DEFAULT NULL

Line 14: ,p_parameters IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE

10: ,p_function_name IN VARCHAR2 DEFAULT NULL
11: ,p_user_id IN VARCHAR2 DEFAULT NULL
12: ,p_responsibility_id IN VARCHAR2 DEFAULT NULL
13: ,p_time_parameter IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE
14: ,p_parameters IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE
15: ,p_param_ids IN VARCHAR2 DEFAULT 'N'
16: ,p_actual_attribute_code IN VARCHAR2
17: ,p_compareto_attribute_code IN VARCHAR2 DEFAULT NULL
18: ,x_actual_value OUT NOCOPY VARCHAR2

Line 68: l_debug_msg := l_debug_msg || 'BIS_PMV_ACTUAL_PVT.STORE_PARAMETERS: '||l_return_status||'*'||l_msg_data;

64: ,x_msg_data => l_msg_data
65: );
66:
67: if g_debug_on then
68: l_debug_msg := l_debug_msg || 'BIS_PMV_ACTUAL_PVT.STORE_PARAMETERS: '||l_return_status||'*'||l_msg_data;
69: /*
70: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => 'BIS_PMV_ACTUAL_PVT',
71: p_procedure_name => 'STORE_PARAMETERS',
72: p_error_text => 'status and msg: '||l_return_status||'*'|| l_msg_data);

Line 70: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => 'BIS_PMV_ACTUAL_PVT',

66:
67: if g_debug_on then
68: l_debug_msg := l_debug_msg || 'BIS_PMV_ACTUAL_PVT.STORE_PARAMETERS: '||l_return_status||'*'||l_msg_data;
69: /*
70: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => 'BIS_PMV_ACTUAL_PVT',
71: p_procedure_name => 'STORE_PARAMETERS',
72: p_error_text => 'status and msg: '||l_return_status||'*'|| l_msg_data);
73: */
74: end if;

Line 76: BIS_PMV_ACTUAL_PVT.GET_ACTUAL_VALUE_PLSQL

72: p_error_text => 'status and msg: '||l_return_status||'*'|| l_msg_data);
73: */
74: end if;
75:
76: BIS_PMV_ACTUAL_PVT.GET_ACTUAL_VALUE_PLSQL
77: (p_region_code => p_region_code
78: ,p_function_name => l_function_name
79: ,p_user_id => l_user_id
80: ,p_responsibility_id => p_responsibility_id

Line 93: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => 'BIS_PMV_ACTUAL_PVT',

89: );
90:
91: if g_debug_on then
92: /*
93: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => 'BIS_PMV_ACTUAL_PVT',
94: p_procedure_name => 'GET_ACTUAL_VALUE_PLSQL',
95: p_error_text => 'status and msg: '||x_return_status||'*'|| x_msg_data);
96: */
97: x_msg_data := l_debug_msg || 'BIS_PMV_ACTUAL_PVT.GET_ACTUAL_PLSQL: '||x_return_status||'*'||x_msg_data;

Line 97: x_msg_data := l_debug_msg || 'BIS_PMV_ACTUAL_PVT.GET_ACTUAL_PLSQL: '||x_return_status||'*'||x_msg_data;

93: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => 'BIS_PMV_ACTUAL_PVT',
94: p_procedure_name => 'GET_ACTUAL_VALUE_PLSQL',
95: p_error_text => 'status and msg: '||x_return_status||'*'|| x_msg_data);
96: */
97: x_msg_data := l_debug_msg || 'BIS_PMV_ACTUAL_PVT.GET_ACTUAL_PLSQL: '||x_return_status||'*'||x_msg_data;
98: end if;
99:
100: END GET_ACTUAL_VALUE;
101:

Line 558: ,p_time_parameter IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE

554: ,p_function_name IN VARCHAR2 DEFAULT NULL
555: ,p_user_id IN VARCHAR2 DEFAULT NULL
556: ,p_page_id IN VARCHAR2 DEFAULT NULL
557: ,p_responsibility_id IN VARCHAR2 DEFAULT NULL
558: ,p_time_parameter IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE
559: ,p_parameters IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE
560: ,p_param_ids IN VARCHAR2 DEFAULT 'N'
561: ,p_actual_attribute_code IN VARCHAR2
562: ,p_compareto_attribute_code IN VARCHAR2 DEFAULT NULL

Line 559: ,p_parameters IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE

555: ,p_user_id IN VARCHAR2 DEFAULT NULL
556: ,p_page_id IN VARCHAR2 DEFAULT NULL
557: ,p_responsibility_id IN VARCHAR2 DEFAULT NULL
558: ,p_time_parameter IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE
559: ,p_parameters IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE
560: ,p_param_ids IN VARCHAR2 DEFAULT 'N'
561: ,p_actual_attribute_code IN VARCHAR2
562: ,p_compareto_attribute_code IN VARCHAR2 DEFAULT NULL
563: ,p_ranking_level IN VARCHAR2

Line 564: ,x_actual_value OUT NOCOPY BIS_PMV_ACTUAL_PVT.ACTUAL_VALUE_TBL_TYPE

560: ,p_param_ids IN VARCHAR2 DEFAULT 'N'
561: ,p_actual_attribute_code IN VARCHAR2
562: ,p_compareto_attribute_code IN VARCHAR2 DEFAULT NULL
563: ,p_ranking_level IN VARCHAR2
564: ,x_actual_value OUT NOCOPY BIS_PMV_ACTUAL_PVT.ACTUAL_VALUE_TBL_TYPE
565: ,x_return_status OUT NOCOPY VARCHAR2
566: ,x_msg_count OUT NOCOPY NUMBER
567: ,x_msg_data OUT NOCOPY VARCHAR2
568: )

Line 602: l_actual_rec BIS_PMV_ACTUAL_PVT.ACTUAL_VALUE_REC_TYPE;

598: l_actual_tbl dbms_sql.number_table;
599: l_compareto_tbl dbms_sql.number_table;
600: l_viewbyid_tbl dbms_sql.varchar2_table;
601: l_indx number := 1;
602: l_actual_rec BIS_PMV_ACTUAL_PVT.ACTUAL_VALUE_REC_TYPE;
603: l_function_name VARCHAr2(2000);
604: l_session_id VARCHAR2(2000);
605: l_user_id VARCHAR2(2000);
606: l_num_of_rows_fetched NUMBER;

Line 612: l_parameters BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE;

608: l_disable_viewby VARCHAR2(20);
609: l_viewby_name VARCHAR2(2000);
610: l_paramregion_code VARCHAR2(2000);
611: l_paramfunc_name VARCHAR2(2000);
612: l_parameters BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE;
613: l_parameter_rec BIS_PMV_ACTUAL_PVT.PARAMETER_REC_TYPE;
614: l_ranking_attr varchar2(2000);
615: l_ranking_dim varchar2(2000);
616: l_count number := 0;

Line 613: l_parameter_rec BIS_PMV_ACTUAL_PVT.PARAMETER_REC_TYPE;

609: l_viewby_name VARCHAR2(2000);
610: l_paramregion_code VARCHAR2(2000);
611: l_paramfunc_name VARCHAR2(2000);
612: l_parameters BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE;
613: l_parameter_rec BIS_PMV_ACTUAL_PVT.PARAMETER_REC_TYPE;
614: l_ranking_attr varchar2(2000);
615: l_ranking_dim varchar2(2000);
616: l_count number := 0;
617: l_plsql_function varchar2(2000);

Line 764: l_debug_msg := l_debug_msg || 'BIS_PMV_ACTUAL_PVT.STORE_PARAMETERS: '||x_return_status||'*'||x_msg_data;

760: ,x_msg_data => x_msg_data
761: );
762:
763: if g_debug_on then
764: l_debug_msg := l_debug_msg || 'BIS_PMV_ACTUAL_PVT.STORE_PARAMETERS: '||x_return_status||'*'||x_msg_data;
765: /*
766: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => 'BIS_PMV_ACTUAL_PVT',
767: p_procedure_name => 'STORE_PARAMETERS',
768: p_error_text => 'status and msg: '||x_return_status||'*'|| x_msg_data);

Line 766: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => 'BIS_PMV_ACTUAL_PVT',

762:
763: if g_debug_on then
764: l_debug_msg := l_debug_msg || 'BIS_PMV_ACTUAL_PVT.STORE_PARAMETERS: '||x_return_status||'*'||x_msg_data;
765: /*
766: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => 'BIS_PMV_ACTUAL_PVT',
767: p_procedure_name => 'STORE_PARAMETERS',
768: p_error_text => 'status and msg: '||x_return_status||'*'|| x_msg_data);
769: */
770: end if;

Line 1395: ,p_time_parameter IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE

1391: ,p_function_name IN VARCHAR2 DEFAULT NULL
1392: ,p_session_id IN VARCHAR2 DEFAULT NULL
1393: ,p_user_id IN VARCHAR2 DEFAULT NULL
1394: ,p_responsibility_id IN VARCHAR2 DEFAULT NULL
1395: ,p_time_parameter IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE
1396: ,p_parameters IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE
1397: ,p_param_ids IN VARCHAR2 DEFAULT 'N'
1398: ,x_return_status OUT NOCOPY VARCHAR2
1399: ,x_msg_count OUT NOCOPY NUMBER

Line 1396: ,p_parameters IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE

1392: ,p_session_id IN VARCHAR2 DEFAULT NULL
1393: ,p_user_id IN VARCHAR2 DEFAULT NULL
1394: ,p_responsibility_id IN VARCHAR2 DEFAULT NULL
1395: ,p_time_parameter IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE
1396: ,p_parameters IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE
1397: ,p_param_ids IN VARCHAR2 DEFAULT 'N'
1398: ,x_return_status OUT NOCOPY VARCHAR2
1399: ,x_msg_count OUT NOCOPY NUMBER
1400: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1695: ,p_time_parameter IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE

1691: ,p_function_name IN VARCHAR2 DEFAULT NULL
1692: ,p_user_id IN VARCHAR2 DEFAULT NULL
1693: ,p_page_id IN VARCHAR2 DEFAULT NULL
1694: ,p_responsibility_id IN VARCHAR2 DEFAULT NULL
1695: ,p_time_parameter IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE
1696: ,p_parameters IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE
1697: ,p_param_ids IN VARCHAR2 DEFAULT 'N'
1698: ,p_measure_attribute_codes IN BIS_PMV_ACTUAL_PVT.MEASURE_ATTR_CODES_TYPE
1699: ,p_ranking_level IN VARCHAR2

Line 1696: ,p_parameters IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE

1692: ,p_user_id IN VARCHAR2 DEFAULT NULL
1693: ,p_page_id IN VARCHAR2 DEFAULT NULL
1694: ,p_responsibility_id IN VARCHAR2 DEFAULT NULL
1695: ,p_time_parameter IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE
1696: ,p_parameters IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE
1697: ,p_param_ids IN VARCHAR2 DEFAULT 'N'
1698: ,p_measure_attribute_codes IN BIS_PMV_ACTUAL_PVT.MEASURE_ATTR_CODES_TYPE
1699: ,p_ranking_level IN VARCHAR2
1700: ,x_measure_tbl OUT NOCOPY BIS_PMV_ACTUAL_PVT.ACTUAL_VALUE_TBL_TYPE

Line 1698: ,p_measure_attribute_codes IN BIS_PMV_ACTUAL_PVT.MEASURE_ATTR_CODES_TYPE

1694: ,p_responsibility_id IN VARCHAR2 DEFAULT NULL
1695: ,p_time_parameter IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE
1696: ,p_parameters IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE
1697: ,p_param_ids IN VARCHAR2 DEFAULT 'N'
1698: ,p_measure_attribute_codes IN BIS_PMV_ACTUAL_PVT.MEASURE_ATTR_CODES_TYPE
1699: ,p_ranking_level IN VARCHAR2
1700: ,x_measure_tbl OUT NOCOPY BIS_PMV_ACTUAL_PVT.ACTUAL_VALUE_TBL_TYPE
1701: ,x_return_status OUT NOCOPY VARCHAR2
1702: ,x_msg_count OUT NOCOPY NUMBER

Line 1700: ,x_measure_tbl OUT NOCOPY BIS_PMV_ACTUAL_PVT.ACTUAL_VALUE_TBL_TYPE

1696: ,p_parameters IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE
1697: ,p_param_ids IN VARCHAR2 DEFAULT 'N'
1698: ,p_measure_attribute_codes IN BIS_PMV_ACTUAL_PVT.MEASURE_ATTR_CODES_TYPE
1699: ,p_ranking_level IN VARCHAR2
1700: ,x_measure_tbl OUT NOCOPY BIS_PMV_ACTUAL_PVT.ACTUAL_VALUE_TBL_TYPE
1701: ,x_return_status OUT NOCOPY VARCHAR2
1702: ,x_msg_count OUT NOCOPY NUMBER
1703: ,x_msg_data OUT NOCOPY VARCHAR2
1704: ) IS

Line 1762: l_actual_rec BIS_PMV_ACTUAL_PVT.ACTUAL_VALUE_REC_TYPE;

1758: l_bind_var VARCHAR2(32000);
1759: l_tab_index NUMBER := 1;
1760: l_bind_col VARCHAR2(2000);
1761: l_indx number := 1;
1762: l_actual_rec BIS_PMV_ACTUAL_PVT.ACTUAL_VALUE_REC_TYPE;
1763: l_function_name VARCHAr2(2000);
1764: l_session_id VARCHAR2(2000);
1765: l_user_id VARCHAR2(2000);
1766: l_num_of_rows_fetched NUMBER;

Line 1772: l_parameters BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE;

1768: l_disable_viewby VARCHAR2(20);
1769: l_viewby_name VARCHAR2(2000);
1770: l_paramregion_code VARCHAR2(2000);
1771: l_paramfunc_name VARCHAR2(2000);
1772: l_parameters BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE;
1773: l_parameter_rec BIS_PMV_ACTUAL_PVT.PARAMETER_REC_TYPE;
1774: l_ranking_attr varchar2(2000);
1775: l_ranking_dim varchar2(2000);
1776: l_count number := 0;

Line 1773: l_parameter_rec BIS_PMV_ACTUAL_PVT.PARAMETER_REC_TYPE;

1769: l_viewby_name VARCHAR2(2000);
1770: l_paramregion_code VARCHAR2(2000);
1771: l_paramfunc_name VARCHAR2(2000);
1772: l_parameters BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE;
1773: l_parameter_rec BIS_PMV_ACTUAL_PVT.PARAMETER_REC_TYPE;
1774: l_ranking_attr varchar2(2000);
1775: l_ranking_dim varchar2(2000);
1776: l_count number := 0;
1777:

Line 1884: l_debug_msg := l_debug_msg || 'BIS_PMV_ACTUAL_PVT.STORE_PARAMETERS: '||x_return_status||'*'||x_msg_data;

1880: ,x_msg_data => x_msg_data
1881: );
1882:
1883: if g_debug_on then
1884: l_debug_msg := l_debug_msg || 'BIS_PMV_ACTUAL_PVT.STORE_PARAMETERS: '||x_return_status||'*'||x_msg_data;
1885: end if;
1886:
1887: if g_debug_on then
1888: l_debug_msg := l_debug_msg || 'Successfully stored the parameters...';

Line 2361: END BIS_PMV_ACTUAL_PVT;

2357: END LOOP;
2358: END LOOP;
2359: END SORTBY_BASE_COLUMN_LENGTH;
2360:
2361: END BIS_PMV_ACTUAL_PVT;