APPS.HRI_OLTP_PMV_TRN_BCKT_GRAPH dependencies on BIS_PMV_PARAMETERS_PUB

Line 32: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

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

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

86: x_custom_sql := l_sqltext;
87:
88: l_custom_rec.attribute_name := ':TIME_PERIOD_TYPE';
89: l_custom_rec.attribute_value := l_parameter_rec.page_period_type;
90: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
91: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
92: x_custom_output.extend;
93: x_custom_output(1) := l_custom_rec;
94:

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

87:
88: l_custom_rec.attribute_name := ':TIME_PERIOD_TYPE';
89: l_custom_rec.attribute_value := l_parameter_rec.page_period_type;
90: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
91: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
92: x_custom_output.extend;
93: x_custom_output(1) := l_custom_rec;
94:
95: l_custom_rec.attribute_name := ':TIME_COMPARISON_TYPE';

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

93: x_custom_output(1) := l_custom_rec;
94:
95: l_custom_rec.attribute_name := ':TIME_COMPARISON_TYPE';
96: l_custom_rec.attribute_value := l_parameter_rec.time_comparison_type;
97: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
98: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
99: x_custom_output.extend;
100: x_custom_output(2) := l_custom_rec;
101:

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

94:
95: l_custom_rec.attribute_name := ':TIME_COMPARISON_TYPE';
96: l_custom_rec.attribute_value := l_parameter_rec.time_comparison_type;
97: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
98: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
99: x_custom_output.extend;
100: x_custom_output(2) := l_custom_rec;
101:
102: l_custom_rec.attribute_name := ':TIME_PERIOD_NUMBER';

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

100: x_custom_output(2) := l_custom_rec;
101:
102: l_custom_rec.attribute_name := ':TIME_PERIOD_NUMBER';
103: l_custom_rec.attribute_value := l_previous_periods;
104: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
105: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
106: x_custom_output.extend;
107: x_custom_output(3) := l_custom_rec;
108:

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

101:
102: l_custom_rec.attribute_name := ':TIME_PERIOD_NUMBER';
103: l_custom_rec.attribute_value := l_previous_periods;
104: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
105: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
106: x_custom_output.extend;
107: x_custom_output(3) := l_custom_rec;
108:
109: END get_sql_bckt_perf;

Line 134: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

130:
131: BEGIN
132:
133: /* Initialize out parameters */
134: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
135: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
136:
137: /* Get common parameter values */
138: hri_oltp_pmv_util_param.get_parameters_from_table

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

223: /* Binds Will be inserted Below */
224:
225: l_custom_rec.attribute_name := ':HRI_NO_SEGMENTS_TO_SHOW';
226: l_custom_rec.attribute_value := 5;
227: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
228: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
229: x_custom_output.extend;
230: x_custom_output(1) := l_custom_rec;
231:

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

224:
225: l_custom_rec.attribute_name := ':HRI_NO_SEGMENTS_TO_SHOW';
226: l_custom_rec.attribute_value := 5;
227: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
228: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
229: x_custom_output.extend;
230: x_custom_output(1) := l_custom_rec;
231:
232: END get_sql_rnk_jfn_graph;

Line 256: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

252: l_wcnt_chg_fact_sql VARCHAR2(10000);
253:
254: BEGIN
255: /* Initialize out parameters */
256: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
257: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
258:
259: /* Get common parameter values */
260: hri_oltp_pmv_util_param.get_parameters_from_table

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

355: /* Binds Will be inserted Below */
356:
357: l_custom_rec.attribute_name := ':HRI_NO_SEGMENTS_TO_SHOW';
358: l_custom_rec.attribute_value := 5;
359: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
360: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
361: x_custom_output.extend;
362: x_custom_output(1) := l_custom_rec;
363:

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

356:
357: l_custom_rec.attribute_name := ':HRI_NO_SEGMENTS_TO_SHOW';
358: l_custom_rec.attribute_value := 5;
359: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
360: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
361: x_custom_output.extend;
362: x_custom_output(1) := l_custom_rec;
363:
364: