APPS.HRI_OLTP_PMV_WMV_TRN_CTR dependencies on BIS_PMV_PARAMETERS_PUB

Line 33: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

29:
30: BEGIN
31:
32: /* Initialize out parameters */
33: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
34: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
35:
36: /* Get common parameter values */
37: hri_oltp_pmv_util_param.get_parameters_from_table

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

115: x_custom_sql := l_sqltext;
116:
117: l_custom_rec.attribute_name := ':TIME_PERIOD_TYPE';
118: l_custom_rec.attribute_value := l_parameter_rec.page_period_type;
119: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
120: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
121: x_custom_output.extend;
122: x_custom_output(1) := l_custom_rec;
123:

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

116:
117: l_custom_rec.attribute_name := ':TIME_PERIOD_TYPE';
118: l_custom_rec.attribute_value := l_parameter_rec.page_period_type;
119: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
120: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
121: x_custom_output.extend;
122: x_custom_output(1) := l_custom_rec;
123:
124: l_custom_rec.attribute_name := ':TIME_COMPARISON_TYPE';

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

122: x_custom_output(1) := l_custom_rec;
123:
124: l_custom_rec.attribute_name := ':TIME_COMPARISON_TYPE';
125: l_custom_rec.attribute_value := l_parameter_rec.time_comparison_type;
126: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
127: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
128: x_custom_output.extend;
129: x_custom_output(2) := l_custom_rec;
130:

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

123:
124: l_custom_rec.attribute_name := ':TIME_COMPARISON_TYPE';
125: l_custom_rec.attribute_value := l_parameter_rec.time_comparison_type;
126: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
127: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
128: x_custom_output.extend;
129: x_custom_output(2) := l_custom_rec;
130:
131: l_custom_rec.attribute_name := ':TIME_PERIOD_NUMBER';

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

129: x_custom_output(2) := l_custom_rec;
130:
131: l_custom_rec.attribute_name := ':TIME_PERIOD_NUMBER';
132: l_custom_rec.attribute_value := l_previous_periods;
133: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
134: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
135: x_custom_output.extend;
136: x_custom_output(3) := l_custom_rec;
137:

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

130:
131: l_custom_rec.attribute_name := ':TIME_PERIOD_NUMBER';
132: l_custom_rec.attribute_value := l_previous_periods;
133: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
134: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
135: x_custom_output.extend;
136: x_custom_output(3) := l_custom_rec;
137:
138: l_custom_rec.attribute_name := ':GEO_COUNTRY_CODE1';

Line 140: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

136: x_custom_output(3) := l_custom_rec;
137:
138: l_custom_rec.attribute_name := ':GEO_COUNTRY_CODE1';
139: l_custom_rec.attribute_value := l_country_tab(1);
140: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
141: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
142: x_custom_output.extend;
143: x_custom_output(4) := l_custom_rec;
144:

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

137:
138: l_custom_rec.attribute_name := ':GEO_COUNTRY_CODE1';
139: l_custom_rec.attribute_value := l_country_tab(1);
140: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
141: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
142: x_custom_output.extend;
143: x_custom_output(4) := l_custom_rec;
144:
145: l_custom_rec.attribute_name := ':GEO_COUNTRY_CODE2';

Line 147: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

143: x_custom_output(4) := l_custom_rec;
144:
145: l_custom_rec.attribute_name := ':GEO_COUNTRY_CODE2';
146: l_custom_rec.attribute_value := l_country_tab(2);
147: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
148: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
149: x_custom_output.extend;
150: x_custom_output(5) := l_custom_rec;
151:

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

144:
145: l_custom_rec.attribute_name := ':GEO_COUNTRY_CODE2';
146: l_custom_rec.attribute_value := l_country_tab(2);
147: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
148: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
149: x_custom_output.extend;
150: x_custom_output(5) := l_custom_rec;
151:
152: l_custom_rec.attribute_name := ':GEO_COUNTRY_CODE3';

Line 154: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

150: x_custom_output(5) := l_custom_rec;
151:
152: l_custom_rec.attribute_name := ':GEO_COUNTRY_CODE3';
153: l_custom_rec.attribute_value := l_country_tab(3);
154: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
155: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
156: x_custom_output.extend;
157: x_custom_output(6) := l_custom_rec;
158:

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

151:
152: l_custom_rec.attribute_name := ':GEO_COUNTRY_CODE3';
153: l_custom_rec.attribute_value := l_country_tab(3);
154: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
155: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
156: x_custom_output.extend;
157: x_custom_output(6) := l_custom_rec;
158:
159: l_custom_rec.attribute_name := ':GEO_COUNTRY_CODE4';

Line 161: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

157: x_custom_output(6) := l_custom_rec;
158:
159: l_custom_rec.attribute_name := ':GEO_COUNTRY_CODE4';
160: l_custom_rec.attribute_value := l_country_tab(4);
161: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
162: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
163: x_custom_output.extend;
164: x_custom_output(7) := l_custom_rec;
165:

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

158:
159: l_custom_rec.attribute_name := ':GEO_COUNTRY_CODE4';
160: l_custom_rec.attribute_value := l_country_tab(4);
161: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
162: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
163: x_custom_output.extend;
164: x_custom_output(7) := l_custom_rec;
165:
166: l_custom_rec.attribute_name := ':ANL_FACTOR';

Line 168: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

164: x_custom_output(7) := l_custom_rec;
165:
166: l_custom_rec.attribute_name := ':ANL_FACTOR';
167: l_custom_rec.attribute_value := l_calc_anl_factor;
168: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
169: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
170: x_custom_output.extend;
171: x_custom_output(8) := l_custom_rec;
172:

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

165:
166: l_custom_rec.attribute_name := ':ANL_FACTOR';
167: l_custom_rec.attribute_value := l_calc_anl_factor;
168: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
169: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
170: x_custom_output.extend;
171: x_custom_output(8) := l_custom_rec;
172:
173: END get_sql_ctr_t4;

Line 214: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

210:
211: BEGIN
212:
213: /* Initialize out parameters */
214: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
215: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
216:
217: /* Get common parameter values */
218: hri_oltp_pmv_util_param.get_parameters_from_table

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

432: x_custom_sql := l_SQLText;
433:
434: l_custom_rec.attribute_name := ':HRI_ANL_FACTOR';
435: l_custom_rec.attribute_value := l_calc_anl_factor;
436: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
437: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
438: x_custom_output.extend;
439: x_custom_output(1) := l_custom_rec;
440:

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

433:
434: l_custom_rec.attribute_name := ':HRI_ANL_FACTOR';
435: l_custom_rec.attribute_value := l_calc_anl_factor;
436: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
437: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
438: x_custom_output.extend;
439: x_custom_output(1) := l_custom_rec;
440:
441: l_custom_rec.attribute_name := ':HRI_NO_COUNTRIES_TO_SHOW';

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

439: x_custom_output(1) := l_custom_rec;
440:
441: l_custom_rec.attribute_name := ':HRI_NO_COUNTRIES_TO_SHOW';
442: l_custom_rec.attribute_value := 10;
443: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
444: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
445: x_custom_output.extend;
446: x_custom_output(2) := l_custom_rec;
447:

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

440:
441: l_custom_rec.attribute_name := ':HRI_NO_COUNTRIES_TO_SHOW';
442: l_custom_rec.attribute_value := 10;
443: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
444: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
445: x_custom_output.extend;
446: x_custom_output(2) := l_custom_rec;
447:
448: END GET_SQL_RNK_CTR;