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.BIX_PMV_AO_ORR_RPT_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 51: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

47: --Initialize p_custom_output
48: --
49:
50: p_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
51: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
52:
53: -- Get the parameters
54: BIX_PMV_DBI_UTL_PKG.get_ao_page_params( p_page_parameter_tbl,
55: l_as_of_date,

Line 151: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

147: -- insert Period Type ID bind variable
148:
149: l_custom_rec.attribute_name := ':l_period_type_id' ;
150: l_custom_rec.attribute_value:= 1;
151: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
152: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
153:
154: p_custom_output.Extend();
155: p_custom_output(p_custom_output.count) := l_custom_rec;

Line 152: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

148:
149: l_custom_rec.attribute_name := ':l_period_type_id' ;
150: l_custom_rec.attribute_value:= 1;
151: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
152: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
153:
154: p_custom_output.Extend();
155: p_custom_output(p_custom_output.count) := l_custom_rec;
156:

Line 159: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

155: p_custom_output(p_custom_output.count) := l_custom_rec;
156:
157: l_custom_rec.attribute_name := ':l_outcome_filter' ;
158: l_custom_rec.attribute_value:= l_outcome_filter;
159: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
160: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
161:
162: p_custom_output.Extend();
163: p_custom_output(p_custom_output.count) := l_custom_rec;

Line 160: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

156:
157: l_custom_rec.attribute_name := ':l_outcome_filter' ;
158: l_custom_rec.attribute_value:= l_outcome_filter;
159: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
160: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
161:
162: p_custom_output.Extend();
163: p_custom_output(p_custom_output.count) := l_custom_rec;
164:

Line 167: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

163: p_custom_output(p_custom_output.count) := l_custom_rec;
164:
165: l_custom_rec.attribute_name := ':l_row_type' ;
166: l_custom_rec.attribute_value:= l_row_type;
167: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
168: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
169:
170: p_custom_output.Extend();
171: p_custom_output(p_custom_output.count) := l_custom_rec;

Line 168: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

164:
165: l_custom_rec.attribute_name := ':l_row_type' ;
166: l_custom_rec.attribute_value:= l_row_type;
167: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
168: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
169:
170: p_custom_output.Extend();
171: p_custom_output(p_custom_output.count) := l_custom_rec;
172:

Line 176: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

172:
173:
174: l_custom_rec.attribute_name := ':l_subtotal' ;
175: l_custom_rec.attribute_value:= l_subtotal;
176: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
177: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
178:
179: p_custom_output.Extend();
180: p_custom_output(p_custom_output.count) := l_custom_rec;

Line 177: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

173:
174: l_custom_rec.attribute_name := ':l_subtotal' ;
175: l_custom_rec.attribute_value:= l_subtotal;
176: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
177: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
178:
179: p_custom_output.Extend();
180: p_custom_output(p_custom_output.count) := l_custom_rec;
181:

Line 185: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

181:
182:
183: l_custom_rec.attribute_name := ':l_unknown' ;
184: l_custom_rec.attribute_value:= l_unknown;
185: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
186: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
187:
188: p_custom_output.Extend();
189: p_custom_output(p_custom_output.count) := l_custom_rec;

Line 186: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

182:
183: l_custom_rec.attribute_name := ':l_unknown' ;
184: l_custom_rec.attribute_value:= l_unknown;
185: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
186: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
187:
188: p_custom_output.Extend();
189: p_custom_output(p_custom_output.count) := l_custom_rec;
190:

Line 195: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

191: IF l_call_center IS NOT NULL
192: THEN
193: l_custom_rec.attribute_name := ':l_call_center';
194: l_custom_rec.attribute_value:= l_call_center;
195: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
196: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
197:
198: p_custom_output.Extend();
199: p_custom_output(p_custom_output.count) := l_custom_rec;

Line 196: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

192: THEN
193: l_custom_rec.attribute_name := ':l_call_center';
194: l_custom_rec.attribute_value:= l_call_center;
195: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
196: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
197:
198: p_custom_output.Extend();
199: p_custom_output(p_custom_output.count) := l_custom_rec;
200: END IF;

Line 205: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

201: IF l_campaign_id IS NOT NULL
202: THEN
203: l_custom_rec.attribute_name := ':l_campaign_id';
204: l_custom_rec.attribute_value:= l_campaign_id;
205: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
206: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
207:
208: p_custom_output.Extend();
209: p_custom_output(p_custom_output.count) := l_custom_rec;

Line 206: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

202: THEN
203: l_custom_rec.attribute_name := ':l_campaign_id';
204: l_custom_rec.attribute_value:= l_campaign_id;
205: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
206: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
207:
208: p_custom_output.Extend();
209: p_custom_output(p_custom_output.count) := l_custom_rec;
210: END IF;

Line 216: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

212: IF l_schedule_id IS NOT NULL
213: THEN
214: l_custom_rec.attribute_name := ':l_schedule_id';
215: l_custom_rec.attribute_value:= l_schedule_id;
216: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
217: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
218:
219: p_custom_output.Extend();
220: p_custom_output(p_custom_output.count) := l_custom_rec;

Line 217: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

213: THEN
214: l_custom_rec.attribute_name := ':l_schedule_id';
215: l_custom_rec.attribute_value:= l_schedule_id;
216: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
217: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
218:
219: p_custom_output.Extend();
220: p_custom_output(p_custom_output.count) := l_custom_rec;
221: END IF;

Line 226: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

222: IF l_source_code_id IS NOT NULL
223: THEN
224: l_custom_rec.attribute_name := ':l_source_code_id';
225: l_custom_rec.attribute_value:= l_source_code_id;
226: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
227: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
228:
229: p_custom_output.Extend();
230: p_custom_output(p_custom_output.count) := l_custom_rec;

Line 227: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

223: THEN
224: l_custom_rec.attribute_name := ':l_source_code_id';
225: l_custom_rec.attribute_value:= l_source_code_id;
226: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
227: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
228:
229: p_custom_output.Extend();
230: p_custom_output(p_custom_output.count) := l_custom_rec;
231: END IF;