DBA Data[Home] [Help]

APPS.BIS_PMV_ACTUAL_PUB dependencies on BIS_PMV_ACTUAL_PVT

Line 9: ,p_time_parameter IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE

5: (p_region_code IN VARCHAR2
6: ,p_function_name IN VARCHAR2 DEFAULT NULL
7: ,p_user_id IN VARCHAR2 DEFAULT NULL
8: ,p_responsibility_id IN VARCHAR2 DEFAULT NULL
9: ,p_time_parameter IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE
10: ,p_parameters IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE
11: ,p_param_ids IN VARCHAR2 DEFAULT 'N'
12: ,p_actual_attribute_code IN VARCHAR2
13: ,p_compareto_attribute_code IN VARCHAR2 DEFAULT NULL

Line 10: ,p_parameters IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE

6: ,p_function_name IN VARCHAR2 DEFAULT NULL
7: ,p_user_id IN VARCHAR2 DEFAULT NULL
8: ,p_responsibility_id IN VARCHAR2 DEFAULT NULL
9: ,p_time_parameter IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE
10: ,p_parameters IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE
11: ,p_param_ids IN VARCHAR2 DEFAULT 'N'
12: ,p_actual_attribute_code IN VARCHAR2
13: ,p_compareto_attribute_code IN VARCHAR2 DEFAULT NULL
14: ,x_actual_value OUT NOCOPY VARCHAR2

Line 22: BIS_PMV_ACTUAL_PVT.GET_ACTUAL_VALUE

18: ,x_msg_data OUT NOCOPY VARCHAR2
19: ) IS
20: BEGIN
21:
22: BIS_PMV_ACTUAL_PVT.GET_ACTUAL_VALUE
23: (p_region_code => p_region_code
24: ,p_function_name => p_function_name
25: ,p_user_id => p_user_id
26: ,p_responsibility_id => p_responsibility_id

Line 46: ,p_time_parameter IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE

42: ,p_function_name IN VARCHAR2 DEFAULT NULL
43: ,p_user_id IN VARCHAR2 DEFAULT NULL
44: ,p_page_id IN VARCHAR2 DEFAULT NULL
45: ,p_responsibility_id IN VARCHAR2 DEFAULT NULL
46: ,p_time_parameter IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE
47: ,p_parameters IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE
48: ,p_param_ids IN VARCHAR2 DEFAULT 'N'
49: ,p_actual_attribute_code IN VARCHAR2
50: ,p_compareto_attribute_code IN VARCHAR2 DEFAULT NULL

Line 47: ,p_parameters IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE

43: ,p_user_id IN VARCHAR2 DEFAULT NULL
44: ,p_page_id IN VARCHAR2 DEFAULT NULL
45: ,p_responsibility_id IN VARCHAR2 DEFAULT NULL
46: ,p_time_parameter IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE
47: ,p_parameters IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE
48: ,p_param_ids IN VARCHAR2 DEFAULT 'N'
49: ,p_actual_attribute_code IN VARCHAR2
50: ,p_compareto_attribute_code IN VARCHAR2 DEFAULT NULL
51: ,p_ranking_level IN VARCHAR2

Line 52: ,x_actual_value OUT NOCOPY BIS_PMV_ACTUAL_PVT.ACTUAL_VALUE_TBL_TYPE

48: ,p_param_ids IN VARCHAR2 DEFAULT 'N'
49: ,p_actual_attribute_code IN VARCHAR2
50: ,p_compareto_attribute_code IN VARCHAR2 DEFAULT NULL
51: ,p_ranking_level IN VARCHAR2
52: ,x_actual_value OUT NOCOPY BIS_PMV_ACTUAL_PVT.ACTUAL_VALUE_TBL_TYPE
53: ,x_return_status OUT NOCOPY VARCHAR2
54: ,x_msg_count OUT NOCOPY NUMBER
55: ,x_msg_data OUT NOCOPY VARCHAR2
56: )

Line 63: BIS_PMV_ACTUAL_PVT.GET_ACTUAL_VALUE

59: BEGIN
60: --IF (fnd_profile.value('BIS_SQL_TRACE') = 'Y') then
61: x_msg_data := 'Invoking Get Actual method.. *';
62: --END IF;
63: BIS_PMV_ACTUAL_PVT.GET_ACTUAL_VALUE
64: (p_region_code => p_region_code
65: ,p_function_name => p_function_name
66: ,p_user_id => p_user_id
67: ,p_page_id => p_page_id

Line 89: ,p_time_parameter IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE

85: ,p_function_name IN VARCHAR2 DEFAULT NULL
86: ,p_user_id IN VARCHAR2 DEFAULT NULL
87: ,p_page_id IN VARCHAR2 DEFAULT NULL
88: ,p_responsibility_id IN VARCHAR2 DEFAULT NULL
89: ,p_time_parameter IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE
90: ,p_parameters IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE
91: ,p_param_ids IN VARCHAR2 DEFAULT 'N'
92: ,p_measure_attribute_codes IN BIS_PMV_ACTUAL_PVT.MEASURE_ATTR_CODES_TYPE
93: ,p_ranking_level IN VARCHAR2

Line 90: ,p_parameters IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE

86: ,p_user_id IN VARCHAR2 DEFAULT NULL
87: ,p_page_id IN VARCHAR2 DEFAULT NULL
88: ,p_responsibility_id IN VARCHAR2 DEFAULT NULL
89: ,p_time_parameter IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE
90: ,p_parameters IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE
91: ,p_param_ids IN VARCHAR2 DEFAULT 'N'
92: ,p_measure_attribute_codes IN BIS_PMV_ACTUAL_PVT.MEASURE_ATTR_CODES_TYPE
93: ,p_ranking_level IN VARCHAR2
94: ,x_measure_tbl OUT NOCOPY BIS_PMV_ACTUAL_PVT.ACTUAL_VALUE_TBL_TYPE

Line 92: ,p_measure_attribute_codes IN BIS_PMV_ACTUAL_PVT.MEASURE_ATTR_CODES_TYPE

88: ,p_responsibility_id IN VARCHAR2 DEFAULT NULL
89: ,p_time_parameter IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE
90: ,p_parameters IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE
91: ,p_param_ids IN VARCHAR2 DEFAULT 'N'
92: ,p_measure_attribute_codes IN BIS_PMV_ACTUAL_PVT.MEASURE_ATTR_CODES_TYPE
93: ,p_ranking_level IN VARCHAR2
94: ,x_measure_tbl OUT NOCOPY BIS_PMV_ACTUAL_PVT.ACTUAL_VALUE_TBL_TYPE
95: ,x_return_status OUT NOCOPY VARCHAR2
96: ,x_msg_count OUT NOCOPY NUMBER

Line 94: ,x_measure_tbl OUT NOCOPY BIS_PMV_ACTUAL_PVT.ACTUAL_VALUE_TBL_TYPE

90: ,p_parameters IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE
91: ,p_param_ids IN VARCHAR2 DEFAULT 'N'
92: ,p_measure_attribute_codes IN BIS_PMV_ACTUAL_PVT.MEASURE_ATTR_CODES_TYPE
93: ,p_ranking_level IN VARCHAR2
94: ,x_measure_tbl OUT NOCOPY BIS_PMV_ACTUAL_PVT.ACTUAL_VALUE_TBL_TYPE
95: ,x_return_status OUT NOCOPY VARCHAR2
96: ,x_msg_count OUT NOCOPY NUMBER
97: ,x_msg_data OUT NOCOPY VARCHAR2
98: ) IS

Line 100: BIS_PMV_ACTUAL_PVT.GET_ACTUAL_VALUE

96: ,x_msg_count OUT NOCOPY NUMBER
97: ,x_msg_data OUT NOCOPY VARCHAR2
98: ) IS
99: BEGIN
100: BIS_PMV_ACTUAL_PVT.GET_ACTUAL_VALUE
101: (p_region_code => p_region_code
102: ,p_function_name => p_function_name
103: ,p_user_id => p_user_id
104: ,p_page_id => p_page_id