APPS.HRI_OLTP_PMV_WMV_SAL_SUP_GRAPH dependencies on BIS_PMV_PARAMETERS_PUB

Line 31: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

27:
28: BEGIN
29:
30: /* Initialize table/record variables */
31: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
32: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
33:
34: /* Get security clause for Manager based security */
35: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');

Line 81: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;

77: x_custom_sql := l_sqltext;
78:
79: l_custom_rec.attribute_name := ':TIME_PERIOD_TYPE';
80: l_custom_rec.attribute_value := l_parameter_rec.page_period_type;
81: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
82: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
83: x_custom_output.extend;
84: x_custom_output(1) := l_custom_rec;
85:

Line 82: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

78:
79: l_custom_rec.attribute_name := ':TIME_PERIOD_TYPE';
80: l_custom_rec.attribute_value := l_parameter_rec.page_period_type;
81: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
82: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
83: x_custom_output.extend;
84: x_custom_output(1) := l_custom_rec;
85:
86: l_custom_rec.attribute_name := ':TIME_COMPARISON_TYPE';

Line 88: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;

84: x_custom_output(1) := l_custom_rec;
85:
86: l_custom_rec.attribute_name := ':TIME_COMPARISON_TYPE';
87: l_custom_rec.attribute_value := l_parameter_rec.time_comparison_type;
88: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
89: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
90: x_custom_output.extend;
91: x_custom_output(2) := l_custom_rec;
92:

Line 89: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

85:
86: l_custom_rec.attribute_name := ':TIME_COMPARISON_TYPE';
87: l_custom_rec.attribute_value := l_parameter_rec.time_comparison_type;
88: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
89: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
90: x_custom_output.extend;
91: x_custom_output(2) := l_custom_rec;
92:
93: l_custom_rec.attribute_name := ':TIME_PERIOD_NUMBER';

Line 95: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;

91: x_custom_output(2) := l_custom_rec;
92:
93: l_custom_rec.attribute_name := ':TIME_PERIOD_NUMBER';
94: l_custom_rec.attribute_value := l_previous_periods;
95: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
96: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
97: x_custom_output.extend;
98: x_custom_output(3) := l_custom_rec;
99:

Line 96: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;

92:
93: l_custom_rec.attribute_name := ':TIME_PERIOD_NUMBER';
94: l_custom_rec.attribute_value := l_previous_periods;
95: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
96: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
97: x_custom_output.extend;
98: x_custom_output(3) := l_custom_rec;
99:
100: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';

Line 102: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;

98: x_custom_output(3) := l_custom_rec;
99:
100: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';
101: l_custom_rec.attribute_value := l_parameter_rec.currency_code;
102: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
103: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
104: x_custom_output.extend;
105: x_custom_output(4) := l_custom_rec;
106:

Line 103: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

99:
100: l_custom_rec.attribute_name := ':GLOBAL_CURRENCY';
101: l_custom_rec.attribute_value := l_parameter_rec.currency_code;
102: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
103: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
104: x_custom_output.extend;
105: x_custom_output(4) := l_custom_rec;
106:
107: l_custom_rec.attribute_name := ':GLOBAL_RATE';

Line 109: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;

105: x_custom_output(4) := l_custom_rec;
106:
107: l_custom_rec.attribute_name := ':GLOBAL_RATE';
108: l_custom_rec.attribute_value := l_parameter_rec.rate_type;
109: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
110: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
111: x_custom_output.extend;
112: x_custom_output(5) := l_custom_rec;
113:

Line 110: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

106:
107: l_custom_rec.attribute_name := ':GLOBAL_RATE';
108: l_custom_rec.attribute_value := l_parameter_rec.rate_type;
109: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
110: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
111: x_custom_output.extend;
112: x_custom_output(5) := l_custom_rec;
113:
114: END;