APPS.BIL_TX_OPTY_DETL_RPT_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 53: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

49:
50: l_period_set_name := NVL(FND_PROFILE.VALUE('ASN_FRCST_FORECAST_CALENDAR'), 'Accounting');
51: l_conversion_type := nvl(FND_PROFILE.VALUE('CRMBIS:GL_CONVERSION_TYPE'), 'Corporate');
52:
53: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
54: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
55:
56:
57: -- code for a procedure to get parameter values.

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

165: END IF;
166:
167: l_bind_ctr := 1;
168:
169: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
170: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
171: l_custom_rec.attribute_value := l_viewby;
172: x_custom_attr.Extend();
173: x_custom_attr(l_bind_ctr):=l_custom_rec;

Line 170: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

166:
167: l_bind_ctr := 1;
168:
169: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
170: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
171: l_custom_rec.attribute_value := l_viewby;
172: x_custom_attr.Extend();
173: x_custom_attr(l_bind_ctr):=l_custom_rec;
174: l_bind_ctr:=l_bind_ctr+1;

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

175:
176:
177: l_custom_rec.attribute_name :=':l_rpt_str';
178: l_custom_rec.attribute_value :=l_rpt_str;
179: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
180: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
181: x_custom_attr.Extend();
182: x_custom_attr(l_bind_ctr):=l_custom_rec;
183: l_bind_ctr:=l_bind_ctr+1;

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

176:
177: l_custom_rec.attribute_name :=':l_rpt_str';
178: l_custom_rec.attribute_value :=l_rpt_str;
179: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
180: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
181: x_custom_attr.Extend();
182: x_custom_attr(l_bind_ctr):=l_custom_rec;
183: l_bind_ctr:=l_bind_ctr+1;
184:

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

183: l_bind_ctr:=l_bind_ctr+1;
184:
185: l_custom_rec.attribute_name :=':l_lead_id';
186: l_custom_rec.attribute_value := l_lead_id;
187: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
188: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
189: x_custom_attr.Extend();
190: x_custom_attr(l_bind_ctr):=l_custom_rec;
191: l_bind_ctr:=l_bind_ctr+1;

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

184:
185: l_custom_rec.attribute_name :=':l_lead_id';
186: l_custom_rec.attribute_value := l_lead_id;
187: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
188: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
189: x_custom_attr.Extend();
190: x_custom_attr(l_bind_ctr):=l_custom_rec;
191: l_bind_ctr:=l_bind_ctr+1;
192:

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

192:
193:
194: l_custom_rec.attribute_name :=':l_credit_type_id';
195: l_custom_rec.attribute_value := l_credit_type_id;
196: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
197: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
198: x_custom_attr.Extend();
199: x_custom_attr(l_bind_ctr):=l_custom_rec;
200: l_bind_ctr:=l_bind_ctr+1;

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

193:
194: l_custom_rec.attribute_name :=':l_credit_type_id';
195: l_custom_rec.attribute_value := l_credit_type_id;
196: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
197: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
198: x_custom_attr.Extend();
199: x_custom_attr(l_bind_ctr):=l_custom_rec;
200: l_bind_ctr:=l_bind_ctr+1;
201:

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

201:
202:
203: l_custom_rec.attribute_name :=':l_viewby';
204: l_custom_rec.attribute_value := l_viewby;
205: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
206: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
207: x_custom_attr.Extend();
208: x_custom_attr(l_bind_ctr):=l_custom_rec;
209: l_bind_ctr:=l_bind_ctr+1;

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

202:
203: l_custom_rec.attribute_name :=':l_viewby';
204: l_custom_rec.attribute_value := l_viewby;
205: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
206: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
207: x_custom_attr.Extend();
208: x_custom_attr(l_bind_ctr):=l_custom_rec;
209: l_bind_ctr:=l_bind_ctr+1;
210:

Line 256: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

252: p_msg => 'Start of Procedure '|| l_proc );
253: END IF;
254:
255:
256: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
257: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
258:
259:
260: -- code for a procedure to get parameter values.

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

331: END IF;
332:
333: l_bind_ctr := 1;
334:
335: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
336: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
337: l_custom_rec.attribute_value := l_viewby;
338: x_custom_attr.Extend();
339: x_custom_attr(l_bind_ctr):=l_custom_rec;

Line 336: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

332:
333: l_bind_ctr := 1;
334:
335: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
336: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
337: l_custom_rec.attribute_value := l_viewby;
338: x_custom_attr.Extend();
339: x_custom_attr(l_bind_ctr):=l_custom_rec;
340: l_bind_ctr:=l_bind_ctr+1;

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

341:
342:
343: l_custom_rec.attribute_name :=':l_rpt_str';
344: l_custom_rec.attribute_value :=l_rpt_str;
345: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
346: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
347: x_custom_attr.Extend();
348: x_custom_attr(l_bind_ctr):=l_custom_rec;
349: l_bind_ctr:=l_bind_ctr+1;

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

342:
343: l_custom_rec.attribute_name :=':l_rpt_str';
344: l_custom_rec.attribute_value :=l_rpt_str;
345: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
346: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
347: x_custom_attr.Extend();
348: x_custom_attr(l_bind_ctr):=l_custom_rec;
349: l_bind_ctr:=l_bind_ctr+1;
350:

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

349: l_bind_ctr:=l_bind_ctr+1;
350:
351: l_custom_rec.attribute_name :=':l_lead_id';
352: l_custom_rec.attribute_value := l_lead_id;
353: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
354: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
355: x_custom_attr.Extend();
356: x_custom_attr(l_bind_ctr):=l_custom_rec;
357: l_bind_ctr:=l_bind_ctr+1;

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

350:
351: l_custom_rec.attribute_name :=':l_lead_id';
352: l_custom_rec.attribute_value := l_lead_id;
353: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
354: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
355: x_custom_attr.Extend();
356: x_custom_attr(l_bind_ctr):=l_custom_rec;
357: l_bind_ctr:=l_bind_ctr+1;
358:

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

357: l_bind_ctr:=l_bind_ctr+1;
358:
359: l_custom_rec.attribute_name :=':l_viewby';
360: l_custom_rec.attribute_value := l_viewby;
361: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
362: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
363: x_custom_attr.Extend();
364: x_custom_attr(l_bind_ctr):=l_custom_rec;
365: l_bind_ctr:=l_bind_ctr+1;

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

358:
359: l_custom_rec.attribute_name :=':l_viewby';
360: l_custom_rec.attribute_value := l_viewby;
361: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
362: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
363: x_custom_attr.Extend();
364: x_custom_attr(l_bind_ctr):=l_custom_rec;
365: l_bind_ctr:=l_bind_ctr+1;
366:

Line 417: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

413: p_module => g_pkg || l_proc || 'begin',
414: p_msg => 'Start of Procedure '|| l_proc );
415: END IF;
416:
417: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
418: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
419:
420: -- code for a procedure to get parameter values.
421: BIL_TX_UTIL_RPT_PKG.GET_DETAIL_PAGE_PARAMS

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

515: END IF;
516:
517: l_bind_ctr := 1;
518:
519: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
520: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
521: l_custom_rec.attribute_value := l_viewby;
522: x_custom_attr.Extend();
523: x_custom_attr(l_bind_ctr):=l_custom_rec;

Line 520: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

516:
517: l_bind_ctr := 1;
518:
519: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
520: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
521: l_custom_rec.attribute_value := l_viewby;
522: x_custom_attr.Extend();
523: x_custom_attr(l_bind_ctr):=l_custom_rec;
524: l_bind_ctr:=l_bind_ctr+1;

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

524: l_bind_ctr:=l_bind_ctr+1;
525:
526: l_custom_rec.attribute_name :=':l_lead_id';
527: l_custom_rec.attribute_value :=l_lead_id;
528: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
529: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
530: x_custom_attr.Extend();
531: x_custom_attr(l_bind_ctr):=l_custom_rec;
532: l_bind_ctr:=l_bind_ctr+1;

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

525:
526: l_custom_rec.attribute_name :=':l_lead_id';
527: l_custom_rec.attribute_value :=l_lead_id;
528: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
529: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
530: x_custom_attr.Extend();
531: x_custom_attr(l_bind_ctr):=l_custom_rec;
532: l_bind_ctr:=l_bind_ctr+1;
533:

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

534:
535:
536: l_custom_rec.attribute_name :=':l_credit_type_id';
537: l_custom_rec.attribute_value := l_credit_type_id;
538: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
539: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
540: x_custom_attr.Extend();
541: x_custom_attr(l_bind_ctr):=l_custom_rec;
542: l_bind_ctr:=l_bind_ctr+1;

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

535:
536: l_custom_rec.attribute_name :=':l_credit_type_id';
537: l_custom_rec.attribute_value := l_credit_type_id;
538: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
539: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
540: x_custom_attr.Extend();
541: x_custom_attr(l_bind_ctr):=l_custom_rec;
542: l_bind_ctr:=l_bind_ctr+1;
543:

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

544:
545:
546: l_custom_rec.attribute_name :=':l_rpt_str';
547: l_custom_rec.attribute_value :=l_rpt_str;
548: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
549: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
550: x_custom_attr.Extend();
551: x_custom_attr(l_bind_ctr):=l_custom_rec;
552: l_bind_ctr:=l_bind_ctr+1;

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

545:
546: l_custom_rec.attribute_name :=':l_rpt_str';
547: l_custom_rec.attribute_value :=l_rpt_str;
548: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
549: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
550: x_custom_attr.Extend();
551: x_custom_attr(l_bind_ctr):=l_custom_rec;
552: l_bind_ctr:=l_bind_ctr+1;
553:

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

553:
554:
555: l_custom_rec.attribute_name :=':l_viewby';
556: l_custom_rec.attribute_value := l_viewby;
557: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
558: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
559: x_custom_attr.Extend();
560: x_custom_attr(l_bind_ctr):=l_custom_rec;
561: l_bind_ctr:=l_bind_ctr+1;

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

554:
555: l_custom_rec.attribute_name :=':l_viewby';
556: l_custom_rec.attribute_value := l_viewby;
557: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
558: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
559: x_custom_attr.Extend();
560: x_custom_attr(l_bind_ctr):=l_custom_rec;
561: l_bind_ctr:=l_bind_ctr+1;
562:

Line 605: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

601: p_module => g_pkg || l_proc || 'begin',
602: p_msg => 'Start of Procedure '|| l_proc );
603: END IF;
604:
605: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
606: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
607:
608: -- code for a procedure to get parameter values.
609: BIL_TX_UTIL_RPT_PKG.GET_DETAIL_PAGE_PARAMS

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

668: END IF;
669:
670: l_bind_ctr := 1;
671:
672: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
673: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
674: l_custom_rec.attribute_value := l_viewby;
675: x_custom_attr.Extend();
676: x_custom_attr(l_bind_ctr):=l_custom_rec;

Line 673: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

669:
670: l_bind_ctr := 1;
671:
672: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
673: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
674: l_custom_rec.attribute_value := l_viewby;
675: x_custom_attr.Extend();
676: x_custom_attr(l_bind_ctr):=l_custom_rec;
677: l_bind_ctr:=l_bind_ctr+1;

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

677: l_bind_ctr:=l_bind_ctr+1;
678:
679: l_custom_rec.attribute_name :=':l_lead_id';
680: l_custom_rec.attribute_value :=l_lead_id;
681: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
682: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
683: x_custom_attr.Extend();
684: x_custom_attr(l_bind_ctr):=l_custom_rec;
685: l_bind_ctr:=l_bind_ctr+1;

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

678:
679: l_custom_rec.attribute_name :=':l_lead_id';
680: l_custom_rec.attribute_value :=l_lead_id;
681: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
682: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
683: x_custom_attr.Extend();
684: x_custom_attr(l_bind_ctr):=l_custom_rec;
685: l_bind_ctr:=l_bind_ctr+1;
686:

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

685: l_bind_ctr:=l_bind_ctr+1;
686:
687: l_custom_rec.attribute_name :=':l_rpt_str';
688: l_custom_rec.attribute_value :=l_rpt_str;
689: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
690: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
691: x_custom_attr.Extend();
692: x_custom_attr(l_bind_ctr):=l_custom_rec;
693: l_bind_ctr:=l_bind_ctr+1;

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

686:
687: l_custom_rec.attribute_name :=':l_rpt_str';
688: l_custom_rec.attribute_value :=l_rpt_str;
689: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
690: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
691: x_custom_attr.Extend();
692: x_custom_attr(l_bind_ctr):=l_custom_rec;
693: l_bind_ctr:=l_bind_ctr+1;
694:

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

694:
695:
696: l_custom_rec.attribute_name :=':l_viewby';
697: l_custom_rec.attribute_value := l_viewby;
698: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
699: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
700: x_custom_attr.Extend();
701: x_custom_attr(l_bind_ctr):=l_custom_rec;
702: l_bind_ctr:=l_bind_ctr+1;

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

695:
696: l_custom_rec.attribute_name :=':l_viewby';
697: l_custom_rec.attribute_value := l_viewby;
698: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
699: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
700: x_custom_attr.Extend();
701: x_custom_attr(l_bind_ctr):=l_custom_rec;
702: l_bind_ctr:=l_bind_ctr+1;
703:

Line 748: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

744: p_module => g_pkg || l_proc || 'begin',
745: p_msg => 'Start of Procedure '|| l_proc );
746: END IF;
747:
748: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
749: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
750:
751:
752: -- code for a procedure to get parameter values.

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

828:
829:
830: l_bind_ctr := 1;
831:
832: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
833: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
834: l_custom_rec.attribute_value := l_viewby;
835: x_custom_attr.Extend();
836: x_custom_attr(l_bind_ctr):=l_custom_rec;

Line 833: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

829:
830: l_bind_ctr := 1;
831:
832: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
833: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
834: l_custom_rec.attribute_value := l_viewby;
835: x_custom_attr.Extend();
836: x_custom_attr(l_bind_ctr):=l_custom_rec;
837: l_bind_ctr:=l_bind_ctr+1;

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

837: l_bind_ctr:=l_bind_ctr+1;
838:
839: l_custom_rec.attribute_name :=':l_lead_id';
840: l_custom_rec.attribute_value :=l_lead_id;
841: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
842: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
843: x_custom_attr.Extend();
844: x_custom_attr(l_bind_ctr):=l_custom_rec;
845: l_bind_ctr:=l_bind_ctr+1;

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

838:
839: l_custom_rec.attribute_name :=':l_lead_id';
840: l_custom_rec.attribute_value :=l_lead_id;
841: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
842: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
843: x_custom_attr.Extend();
844: x_custom_attr(l_bind_ctr):=l_custom_rec;
845: l_bind_ctr:=l_bind_ctr+1;
846:

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

845: l_bind_ctr:=l_bind_ctr+1;
846:
847: l_custom_rec.attribute_name :=':l_rpt_str';
848: l_custom_rec.attribute_value :=l_rpt_str;
849: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
850: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
851: x_custom_attr.Extend();
852: x_custom_attr(l_bind_ctr):=l_custom_rec;
853: l_bind_ctr:=l_bind_ctr+1;

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

846:
847: l_custom_rec.attribute_name :=':l_rpt_str';
848: l_custom_rec.attribute_value :=l_rpt_str;
849: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
850: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
851: x_custom_attr.Extend();
852: x_custom_attr(l_bind_ctr):=l_custom_rec;
853: l_bind_ctr:=l_bind_ctr+1;
854:

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

854:
855:
856: l_custom_rec.attribute_name :=':l_viewby';
857: l_custom_rec.attribute_value := l_viewby;
858: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
859: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
860: x_custom_attr.Extend();
861: x_custom_attr(l_bind_ctr):=l_custom_rec;
862: l_bind_ctr:=l_bind_ctr+1;

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

855:
856: l_custom_rec.attribute_name :=':l_viewby';
857: l_custom_rec.attribute_value := l_viewby;
858: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
859: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
860: x_custom_attr.Extend();
861: x_custom_attr(l_bind_ctr):=l_custom_rec;
862: l_bind_ctr:=l_bind_ctr+1;
863:

Line 908: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

904: p_module => g_pkg || l_proc || 'begin',
905: p_msg => 'Start of Procedure '|| l_proc );
906: END IF;
907:
908: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
909: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
910:
911:
912: -- code for a procedure to get parameter values.

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

980:
981:
982: l_bind_ctr := 1;
983:
984: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
985: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
986: l_custom_rec.attribute_value := l_viewby;
987: x_custom_attr.Extend();
988: x_custom_attr(l_bind_ctr):=l_custom_rec;

Line 985: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

981:
982: l_bind_ctr := 1;
983:
984: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
985: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
986: l_custom_rec.attribute_value := l_viewby;
987: x_custom_attr.Extend();
988: x_custom_attr(l_bind_ctr):=l_custom_rec;
989: l_bind_ctr:=l_bind_ctr+1;

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

989: l_bind_ctr:=l_bind_ctr+1;
990:
991: l_custom_rec.attribute_name :=':l_lead_id';
992: l_custom_rec.attribute_value :=l_lead_id;
993: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
994: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
995: x_custom_attr.Extend();
996: x_custom_attr(l_bind_ctr):=l_custom_rec;
997: l_bind_ctr:=l_bind_ctr+1;

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

990:
991: l_custom_rec.attribute_name :=':l_lead_id';
992: l_custom_rec.attribute_value :=l_lead_id;
993: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
994: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
995: x_custom_attr.Extend();
996: x_custom_attr(l_bind_ctr):=l_custom_rec;
997: l_bind_ctr:=l_bind_ctr+1;
998:

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

997: l_bind_ctr:=l_bind_ctr+1;
998:
999: l_custom_rec.attribute_name :=':l_customer_id';
1000: l_custom_rec.attribute_value :=l_customer_id;
1001: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1002: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1003: x_custom_attr.Extend();
1004: x_custom_attr(l_bind_ctr):=l_custom_rec;
1005: l_bind_ctr:=l_bind_ctr+1;

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

998:
999: l_custom_rec.attribute_name :=':l_customer_id';
1000: l_custom_rec.attribute_value :=l_customer_id;
1001: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1002: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1003: x_custom_attr.Extend();
1004: x_custom_attr(l_bind_ctr):=l_custom_rec;
1005: l_bind_ctr:=l_bind_ctr+1;
1006:

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

1005: l_bind_ctr:=l_bind_ctr+1;
1006:
1007: l_custom_rec.attribute_name :=':l_rpt_str';
1008: l_custom_rec.attribute_value :=l_rpt_str;
1009: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1010: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1011: x_custom_attr.Extend();
1012: x_custom_attr(l_bind_ctr):=l_custom_rec;
1013: l_bind_ctr:=l_bind_ctr+1;

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

1006:
1007: l_custom_rec.attribute_name :=':l_rpt_str';
1008: l_custom_rec.attribute_value :=l_rpt_str;
1009: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1010: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1011: x_custom_attr.Extend();
1012: x_custom_attr(l_bind_ctr):=l_custom_rec;
1013: l_bind_ctr:=l_bind_ctr+1;
1014:

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

1014:
1015:
1016: l_custom_rec.attribute_name :=':l_viewby';
1017: l_custom_rec.attribute_value := l_viewby;
1018: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1019: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1020: x_custom_attr.Extend();
1021: x_custom_attr(l_bind_ctr):=l_custom_rec;
1022: l_bind_ctr:=l_bind_ctr+1;

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

1015:
1016: l_custom_rec.attribute_name :=':l_viewby';
1017: l_custom_rec.attribute_value := l_viewby;
1018: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1019: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1020: x_custom_attr.Extend();
1021: x_custom_attr(l_bind_ctr):=l_custom_rec;
1022: l_bind_ctr:=l_bind_ctr+1;
1023:

Line 1069: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

1065: p_module => g_pkg || l_proc || 'begin',
1066: p_msg => 'Start of Procedure '|| l_proc );
1067: END IF;
1068:
1069: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
1070: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
1071:
1072:
1073: -- code for a procedure to get parameter values.

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

1127:
1128:
1129: l_bind_ctr := 1;
1130:
1131: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
1132: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
1133: l_custom_rec.attribute_value := l_viewby;
1134: x_custom_attr.Extend();
1135: x_custom_attr(l_bind_ctr):=l_custom_rec;

Line 1132: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

1128:
1129: l_bind_ctr := 1;
1130:
1131: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
1132: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
1133: l_custom_rec.attribute_value := l_viewby;
1134: x_custom_attr.Extend();
1135: x_custom_attr(l_bind_ctr):=l_custom_rec;
1136: l_bind_ctr:=l_bind_ctr+1;

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

1136: l_bind_ctr:=l_bind_ctr+1;
1137:
1138: l_custom_rec.attribute_name :=':l_lead_id';
1139: l_custom_rec.attribute_value :=l_lead_id;
1140: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1141: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1142: x_custom_attr.Extend();
1143: x_custom_attr(l_bind_ctr):=l_custom_rec;
1144: l_bind_ctr:=l_bind_ctr+1;

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

1137:
1138: l_custom_rec.attribute_name :=':l_lead_id';
1139: l_custom_rec.attribute_value :=l_lead_id;
1140: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1141: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1142: x_custom_attr.Extend();
1143: x_custom_attr(l_bind_ctr):=l_custom_rec;
1144: l_bind_ctr:=l_bind_ctr+1;
1145:

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

1144: l_bind_ctr:=l_bind_ctr+1;
1145:
1146: l_custom_rec.attribute_name :=':l_rpt_str';
1147: l_custom_rec.attribute_value :=l_rpt_str;
1148: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1149: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1150: x_custom_attr.Extend();
1151: x_custom_attr(l_bind_ctr):=l_custom_rec;
1152: l_bind_ctr:=l_bind_ctr+1;

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

1145:
1146: l_custom_rec.attribute_name :=':l_rpt_str';
1147: l_custom_rec.attribute_value :=l_rpt_str;
1148: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1149: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1150: x_custom_attr.Extend();
1151: x_custom_attr(l_bind_ctr):=l_custom_rec;
1152: l_bind_ctr:=l_bind_ctr+1;
1153:

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

1153:
1154:
1155: l_custom_rec.attribute_name :=':l_viewby';
1156: l_custom_rec.attribute_value := l_viewby;
1157: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1158: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1159: x_custom_attr.Extend();
1160: x_custom_attr(l_bind_ctr):=l_custom_rec;
1161: l_bind_ctr:=l_bind_ctr+1;

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

1154:
1155: l_custom_rec.attribute_name :=':l_viewby';
1156: l_custom_rec.attribute_value := l_viewby;
1157: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1158: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1159: x_custom_attr.Extend();
1160: x_custom_attr(l_bind_ctr):=l_custom_rec;
1161: l_bind_ctr:=l_bind_ctr+1;
1162:

Line 1210: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

1206: p_module => g_pkg || l_proc || 'begin',
1207: p_msg => 'Start of Procedure '|| l_proc );
1208: END IF;
1209:
1210: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
1211: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
1212:
1213: -- code for a procedure to get parameter values.
1214: BIL_TX_UTIL_RPT_PKG.GET_DETAIL_PAGE_PARAMS

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

1290:
1291:
1292: l_bind_ctr := 1;
1293:
1294: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
1295: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
1296: l_custom_rec.attribute_value := l_viewby;
1297: x_custom_attr.Extend();
1298: x_custom_attr(l_bind_ctr):=l_custom_rec;

Line 1295: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

1291:
1292: l_bind_ctr := 1;
1293:
1294: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
1295: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
1296: l_custom_rec.attribute_value := l_viewby;
1297: x_custom_attr.Extend();
1298: x_custom_attr(l_bind_ctr):=l_custom_rec;
1299: l_bind_ctr:=l_bind_ctr+1;

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

1300:
1301:
1302: l_custom_rec.attribute_name :=':l_rpt_str';
1303: l_custom_rec.attribute_value :=l_rpt_str;
1304: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1305: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1306: x_custom_attr.Extend();
1307: x_custom_attr(l_bind_ctr):=l_custom_rec;
1308: l_bind_ctr:=l_bind_ctr+1;

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

1301:
1302: l_custom_rec.attribute_name :=':l_rpt_str';
1303: l_custom_rec.attribute_value :=l_rpt_str;
1304: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1305: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1306: x_custom_attr.Extend();
1307: x_custom_attr(l_bind_ctr):=l_custom_rec;
1308: l_bind_ctr:=l_bind_ctr+1;
1309:

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

1308: l_bind_ctr:=l_bind_ctr+1;
1309:
1310: l_custom_rec.attribute_name :=':l_lead_id';
1311: l_custom_rec.attribute_value :=l_lead_id;
1312: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1313: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1314: x_custom_attr.Extend();
1315: x_custom_attr(l_bind_ctr):=l_custom_rec;
1316: l_bind_ctr:=l_bind_ctr+1;

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

1309:
1310: l_custom_rec.attribute_name :=':l_lead_id';
1311: l_custom_rec.attribute_value :=l_lead_id;
1312: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1313: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1314: x_custom_attr.Extend();
1315: x_custom_attr(l_bind_ctr):=l_custom_rec;
1316: l_bind_ctr:=l_bind_ctr+1;
1317:

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

1316: l_bind_ctr:=l_bind_ctr+1;
1317:
1318: l_custom_rec.attribute_name :=':l_viewby';
1319: l_custom_rec.attribute_value := l_viewby;
1320: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1321: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1322: x_custom_attr.Extend();
1323: x_custom_attr(l_bind_ctr):=l_custom_rec;
1324: l_bind_ctr:=l_bind_ctr+1;

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

1317:
1318: l_custom_rec.attribute_name :=':l_viewby';
1319: l_custom_rec.attribute_value := l_viewby;
1320: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1321: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1322: x_custom_attr.Extend();
1323: x_custom_attr(l_bind_ctr):=l_custom_rec;
1324: l_bind_ctr:=l_bind_ctr+1;
1325:

Line 1373: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

1369: p_module => g_pkg || l_proc || 'begin',
1370: p_msg => 'Start of Procedure '|| l_proc );
1371: END IF;
1372:
1373: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
1374: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
1375:
1376: -- code for a procedure to get parameter values.
1377: BIL_TX_UTIL_RPT_PKG.GET_DETAIL_PAGE_PARAMS

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

1454:
1455:
1456: l_bind_ctr := 1;
1457:
1458: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
1459: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
1460: l_custom_rec.attribute_value := l_viewby;
1461: x_custom_attr.Extend();
1462: x_custom_attr(l_bind_ctr):=l_custom_rec;

Line 1459: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

1455:
1456: l_bind_ctr := 1;
1457:
1458: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
1459: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
1460: l_custom_rec.attribute_value := l_viewby;
1461: x_custom_attr.Extend();
1462: x_custom_attr(l_bind_ctr):=l_custom_rec;
1463: l_bind_ctr:=l_bind_ctr+1;

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

1464:
1465:
1466: l_custom_rec.attribute_name :=':l_rpt_str';
1467: l_custom_rec.attribute_value :=l_rpt_str;
1468: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1469: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1470: x_custom_attr.Extend();
1471: x_custom_attr(l_bind_ctr):=l_custom_rec;
1472: l_bind_ctr:=l_bind_ctr+1;

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

1465:
1466: l_custom_rec.attribute_name :=':l_rpt_str';
1467: l_custom_rec.attribute_value :=l_rpt_str;
1468: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1469: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1470: x_custom_attr.Extend();
1471: x_custom_attr(l_bind_ctr):=l_custom_rec;
1472: l_bind_ctr:=l_bind_ctr+1;
1473:

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

1473:
1474:
1475: l_custom_rec.attribute_name :=':l_viewby';
1476: l_custom_rec.attribute_value := l_viewby;
1477: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1478: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1479: x_custom_attr.Extend();
1480: x_custom_attr(l_bind_ctr):=l_custom_rec;
1481: l_bind_ctr:=l_bind_ctr+1;

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

1474:
1475: l_custom_rec.attribute_name :=':l_viewby';
1476: l_custom_rec.attribute_value := l_viewby;
1477: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1478: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1479: x_custom_attr.Extend();
1480: x_custom_attr(l_bind_ctr):=l_custom_rec;
1481: l_bind_ctr:=l_bind_ctr+1;
1482:

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

1481: l_bind_ctr:=l_bind_ctr+1;
1482:
1483: l_custom_rec.attribute_name :=':l_lead_id';
1484: l_custom_rec.attribute_value := l_lead_id;
1485: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1486: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1487: x_custom_attr.Extend();
1488: x_custom_attr(l_bind_ctr):=l_custom_rec;
1489: l_bind_ctr:=l_bind_ctr+1;

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

1482:
1483: l_custom_rec.attribute_name :=':l_lead_id';
1484: l_custom_rec.attribute_value := l_lead_id;
1485: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1486: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1487: x_custom_attr.Extend();
1488: x_custom_attr(l_bind_ctr):=l_custom_rec;
1489: l_bind_ctr:=l_bind_ctr+1;
1490:

Line 1536: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

1532: p_module => g_pkg || l_proc || 'begin',
1533: p_msg => 'Start of Procedure '|| l_proc );
1534: END IF;
1535:
1536: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
1537: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
1538:
1539: -- code for a procedure to get parameter values.
1540: BIL_TX_UTIL_RPT_PKG.GET_DETAIL_PAGE_PARAMS

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

1612:
1613:
1614: l_bind_ctr := 1;
1615:
1616: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
1617: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
1618: l_custom_rec.attribute_value := l_viewby;
1619: x_custom_attr.Extend();
1620: x_custom_attr(l_bind_ctr):=l_custom_rec;

Line 1617: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

1613:
1614: l_bind_ctr := 1;
1615:
1616: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
1617: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
1618: l_custom_rec.attribute_value := l_viewby;
1619: x_custom_attr.Extend();
1620: x_custom_attr(l_bind_ctr):=l_custom_rec;
1621: l_bind_ctr:=l_bind_ctr+1;

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

1622:
1623:
1624: l_custom_rec.attribute_name :=':l_rpt_str';
1625: l_custom_rec.attribute_value :=l_rpt_str;
1626: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1627: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1628: x_custom_attr.Extend();
1629: x_custom_attr(l_bind_ctr):=l_custom_rec;
1630: l_bind_ctr:=l_bind_ctr+1;

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

1623:
1624: l_custom_rec.attribute_name :=':l_rpt_str';
1625: l_custom_rec.attribute_value :=l_rpt_str;
1626: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1627: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1628: x_custom_attr.Extend();
1629: x_custom_attr(l_bind_ctr):=l_custom_rec;
1630: l_bind_ctr:=l_bind_ctr+1;
1631:

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

1630: l_bind_ctr:=l_bind_ctr+1;
1631:
1632: l_custom_rec.attribute_name :=':l_lead_id';
1633: l_custom_rec.attribute_value := l_lead_id;
1634: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1635: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1636: x_custom_attr.Extend();
1637: x_custom_attr(l_bind_ctr):=l_custom_rec;
1638: l_bind_ctr:=l_bind_ctr+1;

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

1631:
1632: l_custom_rec.attribute_name :=':l_lead_id';
1633: l_custom_rec.attribute_value := l_lead_id;
1634: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1635: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1636: x_custom_attr.Extend();
1637: x_custom_attr(l_bind_ctr):=l_custom_rec;
1638: l_bind_ctr:=l_bind_ctr+1;
1639:

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

1639:
1640:
1641: l_custom_rec.attribute_name :=':l_viewby';
1642: l_custom_rec.attribute_value := l_viewby;
1643: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1644: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1645: x_custom_attr.Extend();
1646: x_custom_attr(l_bind_ctr):=l_custom_rec;
1647: l_bind_ctr:=l_bind_ctr+1;

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

1640:
1641: l_custom_rec.attribute_name :=':l_viewby';
1642: l_custom_rec.attribute_value := l_viewby;
1643: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1644: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1645: x_custom_attr.Extend();
1646: x_custom_attr(l_bind_ctr):=l_custom_rec;
1647: l_bind_ctr:=l_bind_ctr+1;
1648:

Line 1698: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

1694: p_module => g_pkg || l_proc || 'begin',
1695: p_msg => 'Start of Procedure '|| l_proc );
1696: END IF;
1697:
1698: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
1699: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
1700:
1701: -- code for a procedure to get parameter values.
1702: BIL_TX_UTIL_RPT_PKG.GET_DETAIL_PAGE_PARAMS

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

1772:
1773:
1774: l_bind_ctr := 1;
1775:
1776: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
1777: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
1778: l_custom_rec.attribute_value := l_viewby;
1779: x_custom_attr.Extend();
1780: x_custom_attr(l_bind_ctr):=l_custom_rec;

Line 1777: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

1773:
1774: l_bind_ctr := 1;
1775:
1776: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
1777: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
1778: l_custom_rec.attribute_value := l_viewby;
1779: x_custom_attr.Extend();
1780: x_custom_attr(l_bind_ctr):=l_custom_rec;
1781: l_bind_ctr:=l_bind_ctr+1;

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

1782:
1783:
1784: l_custom_rec.attribute_name :=':l_rpt_str';
1785: l_custom_rec.attribute_value :=l_rpt_str;
1786: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1787: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1788: x_custom_attr.Extend();
1789: x_custom_attr(l_bind_ctr):=l_custom_rec;
1790: l_bind_ctr:=l_bind_ctr+1;

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

1783:
1784: l_custom_rec.attribute_name :=':l_rpt_str';
1785: l_custom_rec.attribute_value :=l_rpt_str;
1786: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1787: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1788: x_custom_attr.Extend();
1789: x_custom_attr(l_bind_ctr):=l_custom_rec;
1790: l_bind_ctr:=l_bind_ctr+1;
1791:

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

1790: l_bind_ctr:=l_bind_ctr+1;
1791:
1792: l_custom_rec.attribute_name :=':l_viewby';
1793: l_custom_rec.attribute_value := l_viewby;
1794: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1795: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1796: x_custom_attr.Extend();
1797: x_custom_attr(l_bind_ctr):=l_custom_rec;
1798: l_bind_ctr:=l_bind_ctr+1;

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

1791:
1792: l_custom_rec.attribute_name :=':l_viewby';
1793: l_custom_rec.attribute_value := l_viewby;
1794: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1795: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1796: x_custom_attr.Extend();
1797: x_custom_attr(l_bind_ctr):=l_custom_rec;
1798: l_bind_ctr:=l_bind_ctr+1;
1799:

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

1798: l_bind_ctr:=l_bind_ctr+1;
1799:
1800: l_custom_rec.attribute_name :=':l_lead_id';
1801: l_custom_rec.attribute_value := l_lead_id;
1802: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1803: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1804: x_custom_attr.Extend();
1805: x_custom_attr(l_bind_ctr):=l_custom_rec;
1806: l_bind_ctr:=l_bind_ctr+1;

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

1799:
1800: l_custom_rec.attribute_name :=':l_lead_id';
1801: l_custom_rec.attribute_value := l_lead_id;
1802: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1803: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1804: x_custom_attr.Extend();
1805: x_custom_attr(l_bind_ctr):=l_custom_rec;
1806: l_bind_ctr:=l_bind_ctr+1;
1807:

Line 1858: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

1854: p_module => g_pkg || l_proc || 'begin',
1855: p_msg => 'Start of Procedure '|| l_proc );
1856: END IF;
1857:
1858: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
1859: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
1860:
1861: -- code for a procedure to get parameter values.
1862: BIL_TX_UTIL_RPT_PKG.GET_DETAIL_PAGE_PARAMS

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

1914:
1915:
1916: l_bind_ctr := 1;
1917:
1918: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
1919: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
1920: l_custom_rec.attribute_value := l_viewby;
1921: x_custom_attr.Extend();
1922: x_custom_attr(l_bind_ctr):=l_custom_rec;

Line 1919: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

1915:
1916: l_bind_ctr := 1;
1917:
1918: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
1919: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
1920: l_custom_rec.attribute_value := l_viewby;
1921: x_custom_attr.Extend();
1922: x_custom_attr(l_bind_ctr):=l_custom_rec;
1923: l_bind_ctr:=l_bind_ctr+1;

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

1924:
1925:
1926: l_custom_rec.attribute_name :=':l_rpt_str';
1927: l_custom_rec.attribute_value :=l_rpt_str;
1928: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1929: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1930: x_custom_attr.Extend();
1931: x_custom_attr(l_bind_ctr):=l_custom_rec;
1932: l_bind_ctr:=l_bind_ctr+1;

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

1925:
1926: l_custom_rec.attribute_name :=':l_rpt_str';
1927: l_custom_rec.attribute_value :=l_rpt_str;
1928: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1929: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1930: x_custom_attr.Extend();
1931: x_custom_attr(l_bind_ctr):=l_custom_rec;
1932: l_bind_ctr:=l_bind_ctr+1;
1933:

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

1932: l_bind_ctr:=l_bind_ctr+1;
1933:
1934: l_custom_rec.attribute_name :=':l_lead_id';
1935: l_custom_rec.attribute_value := l_lead_id;
1936: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1937: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1938: x_custom_attr.Extend();
1939: x_custom_attr(l_bind_ctr):=l_custom_rec;
1940: l_bind_ctr:=l_bind_ctr+1;

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

1933:
1934: l_custom_rec.attribute_name :=':l_lead_id';
1935: l_custom_rec.attribute_value := l_lead_id;
1936: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1937: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1938: x_custom_attr.Extend();
1939: x_custom_attr(l_bind_ctr):=l_custom_rec;
1940: l_bind_ctr:=l_bind_ctr+1;
1941:

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

1941:
1942:
1943: l_custom_rec.attribute_name :=':l_viewby';
1944: l_custom_rec.attribute_value := l_viewby;
1945: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1946: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1947: x_custom_attr.Extend();
1948: x_custom_attr(l_bind_ctr):=l_custom_rec;
1949: l_bind_ctr:=l_bind_ctr+1;

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

1942:
1943: l_custom_rec.attribute_name :=':l_viewby';
1944: l_custom_rec.attribute_value := l_viewby;
1945: l_custom_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1946: l_custom_rec.attribute_type :=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1947: x_custom_attr.Extend();
1948: x_custom_attr(l_bind_ctr):=l_custom_rec;
1949: l_bind_ctr:=l_bind_ctr+1;
1950: