APPS.HRI_OLTP_PMV_WMV_ABS_SUP_GRAPH dependencies on BIS_PMV_PARAMETERS_PUB

Line 42: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

38:
39: BEGIN
40:
41: /* Initialize out parameters */
42: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
43: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
44:
45: /* Get common parameter values */
46: hri_oltp_pmv_util_param.get_parameters_from_table

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

147: x_custom_sql := l_sqltext;
148:
149: l_custom_rec.attribute_name := ':TIME_PERIOD_TYPE';
150: l_custom_rec.attribute_value := l_parameter_rec.page_period_type;
151: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
152: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
153: x_custom_output.extend;
154: x_custom_output(1) := l_custom_rec;
155:

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

148:
149: l_custom_rec.attribute_name := ':TIME_PERIOD_TYPE';
150: l_custom_rec.attribute_value := l_parameter_rec.page_period_type;
151: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
152: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
153: x_custom_output.extend;
154: x_custom_output(1) := l_custom_rec;
155:
156: l_custom_rec.attribute_name := ':TIME_COMPARISON_TYPE';

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

154: x_custom_output(1) := l_custom_rec;
155:
156: l_custom_rec.attribute_name := ':TIME_COMPARISON_TYPE';
157: l_custom_rec.attribute_value := l_parameter_rec.time_comparison_type;
158: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
159: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
160: x_custom_output.extend;
161: x_custom_output(2) := l_custom_rec;
162:

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

155:
156: l_custom_rec.attribute_name := ':TIME_COMPARISON_TYPE';
157: l_custom_rec.attribute_value := l_parameter_rec.time_comparison_type;
158: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
159: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
160: x_custom_output.extend;
161: x_custom_output(2) := l_custom_rec;
162:
163: l_custom_rec.attribute_name := ':TIME_PERIOD_NUMBER';

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

161: x_custom_output(2) := l_custom_rec;
162:
163: l_custom_rec.attribute_name := ':TIME_PERIOD_NUMBER';
164: l_custom_rec.attribute_value := l_previous_periods;
165: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
166: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
167: x_custom_output.extend;
168: x_custom_output(3) := l_custom_rec;
169:

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

162:
163: l_custom_rec.attribute_name := ':TIME_PERIOD_NUMBER';
164: l_custom_rec.attribute_value := l_previous_periods;
165: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
166: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
167: x_custom_output.extend;
168: x_custom_output(3) := l_custom_rec;
169:
170: END GET_SQL ;