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');
99: x_custom_sql := l_sqltext;
100:
101: l_custom_rec.attribute_name := ':TIME_PERIOD_TYPE';
102: l_custom_rec.attribute_value := l_parameter_rec.page_period_type;
103: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
104: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
105: x_custom_output.extend;
106: x_custom_output(1) := l_custom_rec;
107:
100:
101: l_custom_rec.attribute_name := ':TIME_PERIOD_TYPE';
102: l_custom_rec.attribute_value := l_parameter_rec.page_period_type;
103: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
104: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
105: x_custom_output.extend;
106: x_custom_output(1) := l_custom_rec;
107:
108: l_custom_rec.attribute_name := ':TIME_COMPARISON_TYPE';
106: x_custom_output(1) := l_custom_rec;
107:
108: l_custom_rec.attribute_name := ':TIME_COMPARISON_TYPE';
109: l_custom_rec.attribute_value := l_parameter_rec.time_comparison_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(2) := l_custom_rec;
114:
107:
108: l_custom_rec.attribute_name := ':TIME_COMPARISON_TYPE';
109: l_custom_rec.attribute_value := l_parameter_rec.time_comparison_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(2) := l_custom_rec;
114:
115: l_custom_rec.attribute_name := ':TIME_PERIOD_NUMBER';
113: x_custom_output(2) := l_custom_rec;
114:
115: l_custom_rec.attribute_name := ':TIME_PERIOD_NUMBER';
116: l_custom_rec.attribute_value := l_previous_periods;
117: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
118: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
119: x_custom_output.extend;
120: x_custom_output(3) := l_custom_rec;
121:
114:
115: l_custom_rec.attribute_name := ':TIME_PERIOD_NUMBER';
116: l_custom_rec.attribute_value := l_previous_periods;
117: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
118: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
119: x_custom_output.extend;
120: x_custom_output(3) := l_custom_rec;
121:
122: l_custom_rec.attribute_name := ':MONTHS_MULTIPLIER';
120: x_custom_output(3) := l_custom_rec;
121:
122: l_custom_rec.attribute_name := ':MONTHS_MULTIPLIER';
123: l_custom_rec.attribute_value := 30.42;
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(4) := l_custom_rec;
128:
121:
122: l_custom_rec.attribute_name := ':MONTHS_MULTIPLIER';
123: l_custom_rec.attribute_value := 30.42;
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(4) := l_custom_rec;
128:
129: