DBA Data[Home] [Help]

APPS.ENI_DBI_PDT_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 334: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

330:
331:
332:
333:
334: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
335: x_custom_output := bis_query_attributes_tbl();
336:
337: x_custom_output.extend;
338: l_custom_rec.attribute_name := ':ITEM';

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

336:
337: x_custom_output.extend;
338: l_custom_rec.attribute_name := ':ITEM';
339: l_custom_rec.attribute_value := l_item;
340: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
341: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
342: x_custom_output(1) := l_custom_rec;
343:
344: x_custom_output.extend;

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

337: x_custom_output.extend;
338: l_custom_rec.attribute_name := ':ITEM';
339: l_custom_rec.attribute_value := l_item;
340: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
341: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
342: x_custom_output(1) := l_custom_rec;
343:
344: x_custom_output.extend;
345: l_custom_rec.attribute_name := ':ORG';

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

343:
344: x_custom_output.extend;
345: l_custom_rec.attribute_name := ':ORG';
346: l_custom_rec.attribute_value := replace(l_org,'''');
347: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
348: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
349: x_custom_output(2) := l_custom_rec;
350:
351: x_custom_output.extend;

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

344: x_custom_output.extend;
345: l_custom_rec.attribute_name := ':ORG';
346: l_custom_rec.attribute_value := replace(l_org,'''');
347: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
348: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
349: x_custom_output(2) := l_custom_rec;
350:
351: x_custom_output.extend;
352: l_custom_rec.attribute_name := ':REASON';

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

350:
351: x_custom_output.extend;
352: l_custom_rec.attribute_name := ':REASON';
353: l_custom_rec.attribute_value := l_reason;
354: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
355: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
356: x_custom_output(3) := l_custom_rec;
357:
358: x_custom_output.extend;

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

351: x_custom_output.extend;
352: l_custom_rec.attribute_name := ':REASON';
353: l_custom_rec.attribute_value := l_reason;
354: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
355: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
356: x_custom_output(3) := l_custom_rec;
357:
358: x_custom_output.extend;
359: l_custom_rec.attribute_name := ':PRIORITY';

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

357:
358: x_custom_output.extend;
359: l_custom_rec.attribute_name := ':PRIORITY';
360: l_custom_rec.attribute_value := l_priority;
361: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
362: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
363: x_custom_output(4) := l_custom_rec;
364:
365: x_custom_output.extend;

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

358: x_custom_output.extend;
359: l_custom_rec.attribute_name := ':PRIORITY';
360: l_custom_rec.attribute_value := l_priority;
361: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
362: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
363: x_custom_output(4) := l_custom_rec;
364:
365: x_custom_output.extend;
366: l_custom_rec.attribute_name := ':TYPE';

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

364:
365: x_custom_output.extend;
366: l_custom_rec.attribute_name := ':TYPE';
367: l_custom_rec.attribute_value := replace(l_type,'''');
368: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
369: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
370: x_custom_output(5) := l_custom_rec;
371:
372: x_custom_output.extend;

Line 369: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

365: x_custom_output.extend;
366: l_custom_rec.attribute_name := ':TYPE';
367: l_custom_rec.attribute_value := replace(l_type,'''');
368: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
369: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
370: x_custom_output(5) := l_custom_rec;
371:
372: x_custom_output.extend;
373: l_custom_rec.attribute_name := ':STATUS';

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

371:
372: x_custom_output.extend;
373: l_custom_rec.attribute_name := ':STATUS';
374: l_custom_rec.attribute_value := replace(l_status,'''');
375: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
376: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
377: x_custom_output(6) := l_custom_rec;
378:
379: --Bug 5083652 -- Start Code

Line 376: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

372: x_custom_output.extend;
373: l_custom_rec.attribute_name := ':STATUS';
374: l_custom_rec.attribute_value := replace(l_status,'''');
375: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
376: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
377: x_custom_output(6) := l_custom_rec;
378:
379: --Bug 5083652 -- Start Code
380:

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

380:
381: x_custom_output.extend;
382: l_custom_rec.attribute_name := ':PERIODTYPE';
383: l_custom_rec.attribute_value := REPLACE(l_period_type,'''');
384: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
385: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
386: x_custom_output(7) := l_custom_rec;
387:
388: x_custom_output.extend;

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

381: x_custom_output.extend;
382: l_custom_rec.attribute_name := ':PERIODTYPE';
383: l_custom_rec.attribute_value := REPLACE(l_period_type,'''');
384: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
385: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
386: x_custom_output(7) := l_custom_rec;
387:
388: x_custom_output.extend;
389: l_custom_rec.attribute_name := ':COMPARETYPE';

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

387:
388: x_custom_output.extend;
389: l_custom_rec.attribute_name := ':COMPARETYPE';
390: l_custom_rec.attribute_value := REPLACE(l_comp_type,'''');
391: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
392: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
393: x_custom_output(8) := l_custom_rec;
394:
395:

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

388: x_custom_output.extend;
389: l_custom_rec.attribute_name := ':COMPARETYPE';
390: l_custom_rec.attribute_value := REPLACE(l_comp_type,'''');
391: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
392: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
393: x_custom_output(8) := l_custom_rec;
394:
395:
396: x_custom_output.extend;

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

395:
396: x_custom_output.extend;
397: l_custom_rec.attribute_name := ':PERIODAND';
398: l_custom_rec.attribute_value := REPLACE(l_period_bitand,'''');
399: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
400: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
401: x_custom_output(9) := l_custom_rec;
402:
403: x_custom_output.extend;

Line 400: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

396: x_custom_output.extend;
397: l_custom_rec.attribute_name := ':PERIODAND';
398: l_custom_rec.attribute_value := REPLACE(l_period_bitand,'''');
399: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
400: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
401: x_custom_output(9) := l_custom_rec;
402:
403: x_custom_output.extend;
404: l_custom_rec.attribute_name := ':CUR_PERIOD_ID';

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

402:
403: x_custom_output.extend;
404: l_custom_rec.attribute_name := ':CUR_PERIOD_ID';
405: l_custom_rec.attribute_value := REPLACE(l_cur_period,'''');
406: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
407: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
408: x_custom_output(10) := l_custom_rec;
409:
410: --Bug 5083652 -- End Code

Line 407: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

403: x_custom_output.extend;
404: l_custom_rec.attribute_name := ':CUR_PERIOD_ID';
405: l_custom_rec.attribute_value := REPLACE(l_cur_period,'''');
406: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
407: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
408: x_custom_output(10) := l_custom_rec;
409:
410: --Bug 5083652 -- End Code
411: