APPS.HRI_OLTP_PMV_WMV_WF_SUP_GRAPH dependencies on BIS_PMV_PARAMETERS_PUB

Line 36: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

32:
33: BEGIN
34:
35: /* Initialize table/record variables */
36: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
37: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
38:
39: /* Get security clause for Manager based security */
40: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');

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

106: x_custom_sql := l_sqltext;
107:
108: l_custom_rec.attribute_name := ':TIME_PERIOD_TYPE';
109: l_custom_rec.attribute_value := l_parameter_rec.page_period_type;
110: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
111: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
112: x_custom_output.extend;
113: x_custom_output(1) := l_custom_rec;
114:

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

107:
108: l_custom_rec.attribute_name := ':TIME_PERIOD_TYPE';
109: l_custom_rec.attribute_value := l_parameter_rec.page_period_type;
110: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
111: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
112: x_custom_output.extend;
113: x_custom_output(1) := l_custom_rec;
114:
115: l_custom_rec.attribute_name := ':TIME_COMPARISON_TYPE';

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

113: x_custom_output(1) := l_custom_rec;
114:
115: l_custom_rec.attribute_name := ':TIME_COMPARISON_TYPE';
116: l_custom_rec.attribute_value := l_parameter_rec.time_comparison_type;
117: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
118: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
119: x_custom_output.extend;
120: x_custom_output(2) := l_custom_rec;
121:

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

114:
115: l_custom_rec.attribute_name := ':TIME_COMPARISON_TYPE';
116: l_custom_rec.attribute_value := l_parameter_rec.time_comparison_type;
117: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
118: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
119: x_custom_output.extend;
120: x_custom_output(2) := l_custom_rec;
121:
122: l_custom_rec.attribute_name := ':TIME_PERIOD_NUMBER';

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

120: x_custom_output(2) := l_custom_rec;
121:
122: l_custom_rec.attribute_name := ':TIME_PERIOD_NUMBER';
123: l_custom_rec.attribute_value := l_previous_periods;
124: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
125: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
126: x_custom_output.extend;
127: x_custom_output(3) := l_custom_rec;
128:

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

121:
122: l_custom_rec.attribute_name := ':TIME_PERIOD_NUMBER';
123: l_custom_rec.attribute_value := l_previous_periods;
124: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
125: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
126: x_custom_output.extend;
127: x_custom_output(3) := l_custom_rec;
128:
129: END GET_SQL2;