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_CACAMP_PRTLT_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 37: l_custom_rec BIS_QUERY_ATTRIBUTES := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

33: l_session_where_clause VARCHAR2(3000);
34: l_unknown VARCHAR2(50);
35: l_view_by VARCHAR2(3000);
36:
37: l_custom_rec BIS_QUERY_ATTRIBUTES := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
38:
39: BEGIN
40: --
41: --Initialize p_custom_output

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

205: p_custom_sql := l_sqltext;
206:
207: l_custom_rec.attribute_name := ':l_row_type';
208: l_custom_rec.attribute_value:= 'C';
209: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
210: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
211:
212: p_custom_output.Extend();
213: p_custom_output(p_custom_output.count) := l_custom_rec;

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

206:
207: l_custom_rec.attribute_name := ':l_row_type';
208: l_custom_rec.attribute_value:= 'C';
209: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
210: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
211:
212: p_custom_output.Extend();
213: p_custom_output(p_custom_output.count) := l_custom_rec;
214:

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

214:
215:
216: l_custom_rec.attribute_name := ':l_unknown';
217: l_custom_rec.attribute_value:= l_unknown;
218: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
219: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
220:
221: p_custom_output.Extend();
222: p_custom_output(p_custom_output.count) := l_custom_rec;

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

215:
216: l_custom_rec.attribute_name := ':l_unknown';
217: l_custom_rec.attribute_value:= l_unknown;
218: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
219: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
220:
221: p_custom_output.Extend();
222: p_custom_output(p_custom_output.count) := l_custom_rec;
223:

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

226: IF l_call_center IS NOT NULL
227: THEN
228: l_custom_rec.attribute_name := ':l_call_center';
229: l_custom_rec.attribute_value:= l_call_center;
230: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
231: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
232:
233: p_custom_output.Extend();
234: p_custom_output(p_custom_output.count) := l_custom_rec;

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

227: THEN
228: l_custom_rec.attribute_name := ':l_call_center';
229: l_custom_rec.attribute_value:= l_call_center;
230: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
231: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
232:
233: p_custom_output.Extend();
234: p_custom_output(p_custom_output.count) := l_custom_rec;
235: END IF;

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

237: IF l_campaign_id IS NOT NULL
238: THEN
239: l_custom_rec.attribute_name := ':l_campaign_id';
240: l_custom_rec.attribute_value:= l_campaign_id;
241: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
242: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
243:
244: p_custom_output.Extend();
245: p_custom_output(p_custom_output.count) := l_custom_rec;

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

238: THEN
239: l_custom_rec.attribute_name := ':l_campaign_id';
240: l_custom_rec.attribute_value:= l_campaign_id;
241: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
242: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
243:
244: p_custom_output.Extend();
245: p_custom_output(p_custom_output.count) := l_custom_rec;
246: END IF;

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

248: IF l_schedule_id IS NOT NULL
249: THEN
250: l_custom_rec.attribute_name := ':l_schedule_id';
251: l_custom_rec.attribute_value:= l_schedule_id;
252: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
253: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
254:
255: p_custom_output.Extend();
256: p_custom_output(p_custom_output.count) := l_custom_rec;

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

249: THEN
250: l_custom_rec.attribute_name := ':l_schedule_id';
251: l_custom_rec.attribute_value:= l_schedule_id;
252: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
253: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
254:
255: p_custom_output.Extend();
256: p_custom_output(p_custom_output.count) := l_custom_rec;
257: END IF;

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

258: IF l_source_code_id IS NOT NULL
259: THEN
260: l_custom_rec.attribute_name := ':l_source_code_id';
261: l_custom_rec.attribute_value:= l_source_code_id;
262: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
263: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
264:
265: p_custom_output.Extend();
266: p_custom_output(p_custom_output.count) := l_custom_rec;

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

259: THEN
260: l_custom_rec.attribute_name := ':l_source_code_id';
261: l_custom_rec.attribute_value:= l_source_code_id;
262: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
263: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
264:
265: p_custom_output.Extend();
266: p_custom_output(p_custom_output.count) := l_custom_rec;
267: END IF;

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

267: END IF;
268:
269: l_custom_rec.attribute_name := ':l_period_type_id';
270: l_custom_rec.attribute_value:= 1;
271: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
272: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
273:
274: p_custom_output.Extend();
275: p_custom_output(p_custom_output.count) := l_custom_rec;

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

268:
269: l_custom_rec.attribute_name := ':l_period_type_id';
270: l_custom_rec.attribute_value:= 1;
271: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
272: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
273:
274: p_custom_output.Extend();
275: p_custom_output(p_custom_output.count) := l_custom_rec;
276:

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

275: p_custom_output(p_custom_output.count) := l_custom_rec;
276:
277: l_custom_rec.attribute_name := ':l_unknown';
278: l_custom_rec.attribute_value:= l_unknown;
279: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
280: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
281:
282: p_custom_output.EXTEND;
283: p_custom_output(p_custom_output.COUNT) := l_custom_rec;

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

276:
277: l_custom_rec.attribute_name := ':l_unknown';
278: l_custom_rec.attribute_value:= l_unknown;
279: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
280: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
281:
282: p_custom_output.EXTEND;
283: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
284:

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

283: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
284:
285: l_custom_rec.attribute_name := ':l_application_id';
286: l_custom_rec.attribute_value := 696;
287: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
288: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
289:
290: p_custom_output.EXTEND;
291: p_custom_output(p_custom_output.COUNT) := l_custom_rec;

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

284:
285: l_custom_rec.attribute_name := ':l_application_id';
286: l_custom_rec.attribute_value := 696;
287: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
288: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
289:
290: p_custom_output.EXTEND;
291: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
292:

Line 293: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;

289:
290: p_custom_output.EXTEND;
291: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
292:
293: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
294: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
295: l_custom_rec.attribute_value := 'CAMPAIGN+CAMPAIGN';
296:
297: p_custom_output.EXTEND;

Line 294: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;

290: p_custom_output.EXTEND;
291: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
292:
293: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
294: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
295: l_custom_rec.attribute_value := 'CAMPAIGN+CAMPAIGN';
296:
297: p_custom_output.EXTEND;
298: p_custom_output(p_custom_output.COUNT) := l_custom_rec;