eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HRI_OLTP_PMV_ABS_CAT dependencies on BIS_PMV_PARAMETERS_PUB

Line 44: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

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

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

164: x_custom_sql := l_sqltext;
165:
166: l_custom_rec.attribute_name := ':TIME_PERIOD_TYPE';
167: l_custom_rec.attribute_value := l_parameter_rec.page_period_type;
168: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
169: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
170: x_custom_output.extend;
171: x_custom_output(1) := l_custom_rec;
172:

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

165:
166: l_custom_rec.attribute_name := ':TIME_PERIOD_TYPE';
167: l_custom_rec.attribute_value := l_parameter_rec.page_period_type;
168: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
169: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
170: x_custom_output.extend;
171: x_custom_output(1) := l_custom_rec;
172:
173: l_custom_rec.attribute_name := ':TIME_COMPARISON_TYPE';

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

171: x_custom_output(1) := l_custom_rec;
172:
173: l_custom_rec.attribute_name := ':TIME_COMPARISON_TYPE';
174: l_custom_rec.attribute_value := l_parameter_rec.time_comparison_type;
175: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
176: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
177: x_custom_output.extend;
178: x_custom_output(2) := l_custom_rec;
179:

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

172:
173: l_custom_rec.attribute_name := ':TIME_COMPARISON_TYPE';
174: l_custom_rec.attribute_value := l_parameter_rec.time_comparison_type;
175: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
176: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
177: x_custom_output.extend;
178: x_custom_output(2) := l_custom_rec;
179:
180: l_custom_rec.attribute_name := ':TIME_PERIOD_NUMBER';

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

178: x_custom_output(2) := l_custom_rec;
179:
180: l_custom_rec.attribute_name := ':TIME_PERIOD_NUMBER';
181: l_custom_rec.attribute_value := l_previous_periods;
182: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
183: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
184: x_custom_output.extend;
185: x_custom_output(3) := l_custom_rec;
186:

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

179:
180: l_custom_rec.attribute_name := ':TIME_PERIOD_NUMBER';
181: l_custom_rec.attribute_value := l_previous_periods;
182: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
183: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.numeric_bind;
184: x_custom_output.extend;
185: x_custom_output(3) := l_custom_rec;
186:
187: l_custom_rec.attribute_name := ':ABS_CATEGORY_CODE1';

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

185: x_custom_output(3) := l_custom_rec;
186:
187: l_custom_rec.attribute_name := ':ABS_CATEGORY_CODE1';
188: l_custom_rec.attribute_value := l_abs_category_tab(1);
189: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
190: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
191: x_custom_output.extend;
192: x_custom_output(4) := l_custom_rec;
193:

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

186:
187: l_custom_rec.attribute_name := ':ABS_CATEGORY_CODE1';
188: l_custom_rec.attribute_value := l_abs_category_tab(1);
189: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
190: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
191: x_custom_output.extend;
192: x_custom_output(4) := l_custom_rec;
193:
194: l_custom_rec.attribute_name := ':ABS_CATEGORY_CODE2';

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

192: x_custom_output(4) := l_custom_rec;
193:
194: l_custom_rec.attribute_name := ':ABS_CATEGORY_CODE2';
195: l_custom_rec.attribute_value := l_abs_category_tab(2);
196: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
197: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
198: x_custom_output.extend;
199: x_custom_output(5) := l_custom_rec;
200:

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

193:
194: l_custom_rec.attribute_name := ':ABS_CATEGORY_CODE2';
195: l_custom_rec.attribute_value := l_abs_category_tab(2);
196: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
197: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
198: x_custom_output.extend;
199: x_custom_output(5) := l_custom_rec;
200:
201: l_custom_rec.attribute_name := ':ABS_CATEGORY_CODE3';

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

199: x_custom_output(5) := l_custom_rec;
200:
201: l_custom_rec.attribute_name := ':ABS_CATEGORY_CODE3';
202: l_custom_rec.attribute_value := l_abs_category_tab(3);
203: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
204: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
205: x_custom_output.extend;
206: x_custom_output(6) := l_custom_rec;
207:

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

200:
201: l_custom_rec.attribute_name := ':ABS_CATEGORY_CODE3';
202: l_custom_rec.attribute_value := l_abs_category_tab(3);
203: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
204: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
205: x_custom_output.extend;
206: x_custom_output(6) := l_custom_rec;
207:
208: l_custom_rec.attribute_name := ':ABS_CATEGORY_CODE4';

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

206: x_custom_output(6) := l_custom_rec;
207:
208: l_custom_rec.attribute_name := ':ABS_CATEGORY_CODE4';
209: l_custom_rec.attribute_value := l_abs_category_tab(4);
210: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
211: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
212: x_custom_output.extend;
213: x_custom_output(7) := l_custom_rec;
214:

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

207:
208: l_custom_rec.attribute_name := ':ABS_CATEGORY_CODE4';
209: l_custom_rec.attribute_value := l_abs_category_tab(4);
210: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
211: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
212: x_custom_output.extend;
213: x_custom_output(7) := l_custom_rec;
214:
215:

Line 242: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

238: l_debug_header VARCHAR(550);
239:
240: BEGIN
241: /* Initialize out parameters */
242: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
243: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
244:
245: /* Get security clause for Manager based security */
246: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');