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

Line 271: inv_graph_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

267: -- l_gid := 4;
268:
269: l_week_num := 13;
270: inv_graph_output := BIS_QUERY_ATTRIBUTES_TBL();
271: inv_graph_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
272:
273: IF (p_page_parameter_tbl.count > 0) THEN
274: i:= p_page_parameter_tbl.first;
275: FOR cnt in 1..p_page_parameter_tbl.count LOOP

Line 310: inv_graph_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;

306: CASE l_page_period_type
307: WHEN 'FII_TIME_WEEK' THEN
308: l_period_type := 16;
309: l_pk := 'week_id';
310: inv_graph_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
311: inv_graph_rec.attribute_value := 'TIME+FII_TIME_WEEK';
312: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
313: l_name := 'replace(fnd_message.get_string(''FII'',''FII_WEEK_LABEL''),''&WEEK_NUMBER'',t.sequence)';
314: select nvl(fii_time_api.pwk_END(l_as_of_date), l_start_date) into l_cy_period_END from dual;

Line 312: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

308: l_period_type := 16;
309: l_pk := 'week_id';
310: inv_graph_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
311: inv_graph_rec.attribute_value := 'TIME+FII_TIME_WEEK';
312: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
313: l_name := 'replace(fnd_message.get_string(''FII'',''FII_WEEK_LABEL''),''&WEEK_NUMBER'',t.sequence)';
314: select nvl(fii_time_api.pwk_END(l_as_of_date), l_start_date) into l_cy_period_END from dual;
315: select nvl(fii_time_api.sd_lyswk(l_as_of_date), l_start_date) into l_p_as_of_date from dual;
316: select nvl(fii_time_api.sd_lyswk(l_p_as_of_date), l_start_date) into l_start from dual;

Line 327: inv_graph_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;

323: l_period_type := 32;
324: l_pk := 'ent_period_id';
325: -- l_bis_map_rec.key:= BIS_PMV_QUERY_PVT.VIEW_BY_KEY;
326: -- l_bis_map_rec.value:= 'TIME+FII_TIME_ENT_PERIOD';
327: inv_graph_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
328: inv_graph_rec.attribute_value :='TIME+FII_TIME_ENT_PERIOD';
329: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
330: l_name := 'to_char(t.start_date,''Mon'')';
331: select nvl(fii_time_api.ent_pper_END(l_as_of_date), l_start_date) into l_cy_period_END from dual;

Line 329: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

325: -- l_bis_map_rec.key:= BIS_PMV_QUERY_PVT.VIEW_BY_KEY;
326: -- l_bis_map_rec.value:= 'TIME+FII_TIME_ENT_PERIOD';
327: inv_graph_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
328: inv_graph_rec.attribute_value :='TIME+FII_TIME_ENT_PERIOD';
329: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
330: l_name := 'to_char(t.start_date,''Mon'')';
331: select nvl(fii_time_api.ent_pper_END(l_as_of_date), l_start_date) into l_cy_period_END from dual;
332: select nvl(fii_time_api.ent_sd_lysper_END(l_as_of_date), l_start_date) into l_p_as_of_date from dual;
333: select nvl(fii_time_api.ent_sd_lysper_END(l_p_as_of_date), l_start_date) into l_start from dual;

Line 344: inv_graph_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;

340: l_period_type := 64;
341: l_pk := 'ent_qtr_id';
342: -- l_bis_map_rec.key:= BIS_PMV_QUERY_PVT.VIEW_BY_KEY;
343: -- l_bis_map_rec.value:= 'TIME+FII_TIME_ENT_QTR';
344: inv_graph_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
345: inv_graph_rec.attribute_value :='TIME+FII_TIME_ENT_QTR';
346: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
347: l_name :=
348: 'replace(fnd_message.get_string(''FII'',''FII_QUARTER_LABEL''),''&QUARTER_NUMBER'',t.sequence)';

Line 346: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

342: -- l_bis_map_rec.key:= BIS_PMV_QUERY_PVT.VIEW_BY_KEY;
343: -- l_bis_map_rec.value:= 'TIME+FII_TIME_ENT_QTR';
344: inv_graph_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
345: inv_graph_rec.attribute_value :='TIME+FII_TIME_ENT_QTR';
346: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
347: l_name :=
348: 'replace(fnd_message.get_string(''FII'',''FII_QUARTER_LABEL''),''&QUARTER_NUMBER'',t.sequence)';
349: select nvl(fii_time_api.ent_pqtr_END(l_as_of_date), l_start_date) into l_cy_period_END from dual;
350: IF (l_time_comp = 'SEQUENTIAL') THEN

Line 371: inv_graph_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;

367: l_period_type := 128;
368: l_pk := 'ent_year_id';
369: -- l_bis_map_rec.key:= BIS_PMV_QUERY_PVT.VIEW_BY_KEY;
370: -- l_bis_map_rec.value:= 'TIME+FII_TIME_ENT_YEAR';
371: inv_graph_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
372: inv_graph_rec.attribute_value :='TIME+FII_TIME_ENT_YEAR';
373: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
374:
375: select nvl(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(l_ent_cyr_start))), l_start_date) into l_begin_date from dual;

Line 373: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

369: -- l_bis_map_rec.key:= BIS_PMV_QUERY_PVT.VIEW_BY_KEY;
370: -- l_bis_map_rec.value:= 'TIME+FII_TIME_ENT_YEAR';
371: inv_graph_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
372: inv_graph_rec.attribute_value :='TIME+FII_TIME_ENT_YEAR';
373: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
374:
375: select nvl(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(l_ent_cyr_start))), l_start_date) into l_begin_date from dual;
376: END CASE;
377:

Line 381: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

377:
378: -- p_bis_map_tbl.extEND;
379: -- p_bis_map_tbl(p_bis_map_tbl.count) := l_bis_map_rec;
380: -- l_bis_map_rec.key := BIS_PMV_QUERY_PVT.QUERY_STR_KEY;
381: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
382: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
383: inv_graph_output.EXTEND;
384: inv_graph_output(inv_graph_output.COUNT) := inv_graph_rec;
385:

Line 382: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

378: -- p_bis_map_tbl.extEND;
379: -- p_bis_map_tbl(p_bis_map_tbl.count) := l_bis_map_rec;
380: -- l_bis_map_rec.key := BIS_PMV_QUERY_PVT.QUERY_STR_KEY;
381: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
382: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
383: inv_graph_output.EXTEND;
384: inv_graph_output(inv_graph_output.COUNT) := inv_graph_rec;
385:
386: /*------------------------------------------------------+

Line 614: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

610:
611: inv_graph_output.EXTEND;
612: inv_graph_rec.attribute_name := ':FII_BIND1';
613: inv_graph_rec.attribute_value := TO_CHAR(l_actual_period_type);
614: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
615: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
616: inv_graph_output(inv_graph_output.COUNT) := inv_graph_rec;
617: inv_graph_output.EXTEND;
618: inv_graph_rec.attribute_name := ':FII_BIND5';

Line 615: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

611: inv_graph_output.EXTEND;
612: inv_graph_rec.attribute_name := ':FII_BIND1';
613: inv_graph_rec.attribute_value := TO_CHAR(l_actual_period_type);
614: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
615: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
616: inv_graph_output(inv_graph_output.COUNT) := inv_graph_rec;
617: inv_graph_output.EXTEND;
618: inv_graph_rec.attribute_name := ':FII_BIND5';
619: inv_graph_rec.attribute_value := TO_CHAR(l_curr_effective_num);

Line 620: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

616: inv_graph_output(inv_graph_output.COUNT) := inv_graph_rec;
617: inv_graph_output.EXTEND;
618: inv_graph_rec.attribute_name := ':FII_BIND5';
619: inv_graph_rec.attribute_value := TO_CHAR(l_curr_effective_num);
620: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
621: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
622: inv_graph_output(inv_graph_output.COUNT) := inv_graph_rec;
623: inv_graph_output.EXTEND;
624: inv_graph_rec.attribute_name := ':FII_BIND6';

Line 621: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

617: inv_graph_output.EXTEND;
618: inv_graph_rec.attribute_name := ':FII_BIND5';
619: inv_graph_rec.attribute_value := TO_CHAR(l_curr_effective_num);
620: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
621: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
622: inv_graph_output(inv_graph_output.COUNT) := inv_graph_rec;
623: inv_graph_output.EXTEND;
624: inv_graph_rec.attribute_name := ':FII_BIND6';
625: inv_graph_rec.attribute_value := TO_CHAR(l_period_type);

Line 626: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

622: inv_graph_output(inv_graph_output.COUNT) := inv_graph_rec;
623: inv_graph_output.EXTEND;
624: inv_graph_rec.attribute_name := ':FII_BIND6';
625: inv_graph_rec.attribute_value := TO_CHAR(l_period_type);
626: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
627: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
628: inv_graph_output(inv_graph_output.COUNT) := inv_graph_rec;
629: inv_graph_output.EXTEND;
630: inv_graph_rec.attribute_name := ':FII_BIND7';

Line 627: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

623: inv_graph_output.EXTEND;
624: inv_graph_rec.attribute_name := ':FII_BIND6';
625: inv_graph_rec.attribute_value := TO_CHAR(l_period_type);
626: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
627: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
628: inv_graph_output(inv_graph_output.COUNT) := inv_graph_rec;
629: inv_graph_output.EXTEND;
630: inv_graph_rec.attribute_name := ':FII_BIND7';
631: inv_graph_rec.attribute_value := TO_CHAR(l_p_as_of_date,'DD/MM/YYYY');

Line 632: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

628: inv_graph_output(inv_graph_output.COUNT) := inv_graph_rec;
629: inv_graph_output.EXTEND;
630: inv_graph_rec.attribute_name := ':FII_BIND7';
631: inv_graph_rec.attribute_value := TO_CHAR(l_p_as_of_date,'DD/MM/YYYY');
632: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
633: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
634: inv_graph_output(inv_graph_output.COUNT) := inv_graph_rec;
635: inv_graph_output.EXTEND;
636: inv_graph_rec.attribute_name := ':FII_BIND8';

Line 633: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

629: inv_graph_output.EXTEND;
630: inv_graph_rec.attribute_name := ':FII_BIND7';
631: inv_graph_rec.attribute_value := TO_CHAR(l_p_as_of_date,'DD/MM/YYYY');
632: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
633: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
634: inv_graph_output(inv_graph_output.COUNT) := inv_graph_rec;
635: inv_graph_output.EXTEND;
636: inv_graph_rec.attribute_name := ':FII_BIND8';
637: inv_graph_rec.attribute_value := TO_CHAR(l_cy_period_END,'DD/MM/YYYY');

Line 638: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

634: inv_graph_output(inv_graph_output.COUNT) := inv_graph_rec;
635: inv_graph_output.EXTEND;
636: inv_graph_rec.attribute_name := ':FII_BIND8';
637: inv_graph_rec.attribute_value := TO_CHAR(l_cy_period_END,'DD/MM/YYYY');
638: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
639: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
640: inv_graph_output(inv_graph_output.COUNT) := inv_graph_rec;
641: inv_graph_output.EXTEND;
642: inv_graph_rec.attribute_name := ':FII_BIND9';

Line 639: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

635: inv_graph_output.EXTEND;
636: inv_graph_rec.attribute_name := ':FII_BIND8';
637: inv_graph_rec.attribute_value := TO_CHAR(l_cy_period_END,'DD/MM/YYYY');
638: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
639: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
640: inv_graph_output(inv_graph_output.COUNT) := inv_graph_rec;
641: inv_graph_output.EXTEND;
642: inv_graph_rec.attribute_name := ':FII_BIND9';
643: inv_graph_rec.attribute_value := TO_CHAR(l_ent_pyr_start,'DD/MM/YYYY');

Line 644: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

640: inv_graph_output(inv_graph_output.COUNT) := inv_graph_rec;
641: inv_graph_output.EXTEND;
642: inv_graph_rec.attribute_name := ':FII_BIND9';
643: inv_graph_rec.attribute_value := TO_CHAR(l_ent_pyr_start,'DD/MM/YYYY');
644: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
645: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
646: inv_graph_output(inv_graph_output.COUNT) := inv_graph_rec;
647: inv_graph_output.EXTEND;
648: inv_graph_rec.attribute_name := ':FII_BIND10';

Line 645: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

641: inv_graph_output.EXTEND;
642: inv_graph_rec.attribute_name := ':FII_BIND9';
643: inv_graph_rec.attribute_value := TO_CHAR(l_ent_pyr_start,'DD/MM/YYYY');
644: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
645: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
646: inv_graph_output(inv_graph_output.COUNT) := inv_graph_rec;
647: inv_graph_output.EXTEND;
648: inv_graph_rec.attribute_name := ':FII_BIND10';
649: inv_graph_rec.attribute_value := TO_CHAR(l_ent_pyr_END,'DD/MM/YYYY');

Line 650: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

646: inv_graph_output(inv_graph_output.COUNT) := inv_graph_rec;
647: inv_graph_output.EXTEND;
648: inv_graph_rec.attribute_name := ':FII_BIND10';
649: inv_graph_rec.attribute_value := TO_CHAR(l_ent_pyr_END,'DD/MM/YYYY');
650: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
651: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
652: inv_graph_output(inv_graph_output.COUNT) := inv_graph_rec;
653: inv_graph_output.EXTEND;
654: inv_graph_rec.attribute_name := ':FII_BIND11';

Line 651: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

647: inv_graph_output.EXTEND;
648: inv_graph_rec.attribute_name := ':FII_BIND10';
649: inv_graph_rec.attribute_value := TO_CHAR(l_ent_pyr_END,'DD/MM/YYYY');
650: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
651: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
652: inv_graph_output(inv_graph_output.COUNT) := inv_graph_rec;
653: inv_graph_output.EXTEND;
654: inv_graph_rec.attribute_name := ':FII_BIND11';
655: inv_graph_rec.attribute_value := TO_CHAR(l_ent_cyr_start,'DD/MM/YYYY');

Line 656: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

652: inv_graph_output(inv_graph_output.COUNT) := inv_graph_rec;
653: inv_graph_output.EXTEND;
654: inv_graph_rec.attribute_name := ':FII_BIND11';
655: inv_graph_rec.attribute_value := TO_CHAR(l_ent_cyr_start,'DD/MM/YYYY');
656: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
657: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
658: inv_graph_output(inv_graph_output.COUNT) := inv_graph_rec;
659: inv_graph_output.EXTEND;
660: inv_graph_rec.attribute_name := ':FII_BIND12';

Line 657: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

653: inv_graph_output.EXTEND;
654: inv_graph_rec.attribute_name := ':FII_BIND11';
655: inv_graph_rec.attribute_value := TO_CHAR(l_ent_cyr_start,'DD/MM/YYYY');
656: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
657: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
658: inv_graph_output(inv_graph_output.COUNT) := inv_graph_rec;
659: inv_graph_output.EXTEND;
660: inv_graph_rec.attribute_name := ':FII_BIND12';
661: inv_graph_rec.attribute_value := TO_CHAR(l_ent_cyr_END,'DD/MM/YYYY');

Line 662: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

658: inv_graph_output(inv_graph_output.COUNT) := inv_graph_rec;
659: inv_graph_output.EXTEND;
660: inv_graph_rec.attribute_name := ':FII_BIND12';
661: inv_graph_rec.attribute_value := TO_CHAR(l_ent_cyr_END,'DD/MM/YYYY');
662: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
663: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
664: inv_graph_output(inv_graph_output.COUNT) := inv_graph_rec;
665: inv_graph_output.EXTEND;
666: inv_graph_rec.attribute_name := ':FII_BIND13';

Line 663: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

659: inv_graph_output.EXTEND;
660: inv_graph_rec.attribute_name := ':FII_BIND12';
661: inv_graph_rec.attribute_value := TO_CHAR(l_ent_cyr_END,'DD/MM/YYYY');
662: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
663: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
664: inv_graph_output(inv_graph_output.COUNT) := inv_graph_rec;
665: inv_graph_output.EXTEND;
666: inv_graph_rec.attribute_name := ':FII_BIND13';
667: inv_graph_rec.attribute_value := TO_CHAR(l_start,'DD/MM/YYYY');

Line 668: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

664: inv_graph_output(inv_graph_output.COUNT) := inv_graph_rec;
665: inv_graph_output.EXTEND;
666: inv_graph_rec.attribute_name := ':FII_BIND13';
667: inv_graph_rec.attribute_value := TO_CHAR(l_start,'DD/MM/YYYY');
668: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
669: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
670: inv_graph_output(inv_graph_output.COUNT) := inv_graph_rec;
671: inv_graph_output.EXTEND;
672: inv_graph_rec.attribute_name := ':FII_BIND14';

Line 669: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

665: inv_graph_output.EXTEND;
666: inv_graph_rec.attribute_name := ':FII_BIND13';
667: inv_graph_rec.attribute_value := TO_CHAR(l_start,'DD/MM/YYYY');
668: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
669: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
670: inv_graph_output(inv_graph_output.COUNT) := inv_graph_rec;
671: inv_graph_output.EXTEND;
672: inv_graph_rec.attribute_name := ':FII_BIND14';
673: inv_graph_rec.attribute_value := TO_CHAR(l_begin_date,'DD/MM/YYYY');

Line 674: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

670: inv_graph_output(inv_graph_output.COUNT) := inv_graph_rec;
671: inv_graph_output.EXTEND;
672: inv_graph_rec.attribute_name := ':FII_BIND14';
673: inv_graph_rec.attribute_value := TO_CHAR(l_begin_date,'DD/MM/YYYY');
674: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
675: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
676: inv_graph_output(inv_graph_output.COUNT) := inv_graph_rec;
677: inv_graph_output.EXTEND;
678: inv_graph_rec.attribute_name := ':GID';

Line 675: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

671: inv_graph_output.EXTEND;
672: inv_graph_rec.attribute_name := ':FII_BIND14';
673: inv_graph_rec.attribute_value := TO_CHAR(l_begin_date,'DD/MM/YYYY');
674: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
675: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
676: inv_graph_output(inv_graph_output.COUNT) := inv_graph_rec;
677: inv_graph_output.EXTEND;
678: inv_graph_rec.attribute_name := ':GID';
679: inv_graph_rec.attribute_value := to_char(l_gid);

Line 680: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

676: inv_graph_output(inv_graph_output.COUNT) := inv_graph_rec;
677: inv_graph_output.EXTEND;
678: inv_graph_rec.attribute_name := ':GID';
679: inv_graph_rec.attribute_value := to_char(l_gid);
680: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
681: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
682: inv_graph_output(inv_graph_output.COUNT) := inv_graph_rec;
683: inv_graph_output.EXTEND;
684: inv_graph_rec.attribute_name := ':SEC_ID';

Line 681: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

677: inv_graph_output.EXTEND;
678: inv_graph_rec.attribute_name := ':GID';
679: inv_graph_rec.attribute_value := to_char(l_gid);
680: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
681: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
682: inv_graph_output(inv_graph_output.COUNT) := inv_graph_rec;
683: inv_graph_output.EXTEND;
684: inv_graph_rec.attribute_name := ':SEC_ID';
685: inv_graph_rec.attribute_value := fii_pmv_util.get_sec_profile;

Line 686: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

682: inv_graph_output(inv_graph_output.COUNT) := inv_graph_rec;
683: inv_graph_output.EXTEND;
684: inv_graph_rec.attribute_name := ':SEC_ID';
685: inv_graph_rec.attribute_value := fii_pmv_util.get_sec_profile;
686: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
687: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
688: inv_graph_output(inv_graph_output.COUNT) := inv_graph_rec;
689: inv_graph_output.EXTEND;
690:

Line 687: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

683: inv_graph_output.EXTEND;
684: inv_graph_rec.attribute_name := ':SEC_ID';
685: inv_graph_rec.attribute_value := fii_pmv_util.get_sec_profile;
686: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
687: inv_graph_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
688: inv_graph_output(inv_graph_output.COUNT) := inv_graph_rec;
689: inv_graph_output.EXTEND;
690:
691: END get_inv_graph;

Line 759: elec_late_payment_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

755:
756:
757: l_week_num := 13;
758: elec_late_payment_output := BIS_QUERY_ATTRIBUTES_TBL();
759: elec_late_payment_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
760:
761: IF (p_page_parameter_tbl.count > 0) THEN
762: i:= p_page_parameter_tbl.first;
763: FOR cnt in 1..p_page_parameter_tbl.count LOOP

Line 801: elec_late_payment_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;

797: WHEN 'FII_TIME_WEEK' THEN
798: l_period_type := 16;
799: l_pk := 'week_id';
800: ltd := '_WTD';
801: elec_late_payment_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
802: elec_late_payment_rec.attribute_value := 'TIME+FII_TIME_WEEK';
803: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
804: l_name := 'replace(fnd_message.get_string(''FII'',''FII_WEEK_LABEL''),
805: ''&WEEK_NUMBER'',t.sequence)';

Line 803: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

799: l_pk := 'week_id';
800: ltd := '_WTD';
801: elec_late_payment_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
802: elec_late_payment_rec.attribute_value := 'TIME+FII_TIME_WEEK';
803: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
804: l_name := 'replace(fnd_message.get_string(''FII'',''FII_WEEK_LABEL''),
805: ''&WEEK_NUMBER'',t.sequence)';
806: select nvl(fii_time_api.pwk_END(l_as_of_date), l_start_date) into l_cy_period_END from dual;
807: select nvl(fii_time_api.sd_lyswk(l_as_of_date), l_start_date) into l_p_as_of_date from dual;

Line 821: elec_late_payment_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;

817: l_pk := 'ent_period_id';
818: ltd := '_MTD';
819: -- l_bis_map_rec.key:= BIS_PMV_QUERY_PVT.VIEW_BY_KEY;
820: -- l_bis_map_rec.value:= 'TIME+FII_TIME_ENT_PERIOD';
821: elec_late_payment_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
822: elec_late_payment_rec.attribute_value :='TIME+FII_TIME_ENT_PERIOD';
823: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
824: l_name := 'to_char(t.start_date,''Mon'')';
825: select nvl(fii_time_api.ent_pper_END(l_as_of_date), l_start_date) into l_cy_period_END from dual;

Line 823: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

819: -- l_bis_map_rec.key:= BIS_PMV_QUERY_PVT.VIEW_BY_KEY;
820: -- l_bis_map_rec.value:= 'TIME+FII_TIME_ENT_PERIOD';
821: elec_late_payment_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
822: elec_late_payment_rec.attribute_value :='TIME+FII_TIME_ENT_PERIOD';
823: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
824: l_name := 'to_char(t.start_date,''Mon'')';
825: select nvl(fii_time_api.ent_pper_END(l_as_of_date), l_start_date) into l_cy_period_END from dual;
826: select nvl(fii_time_api.ent_sd_lysper_END(l_as_of_date), l_start_date) into l_p_as_of_date from dual;
827: select nvl(fii_time_api.ent_sd_lysper_END(l_p_as_of_date), l_start_date) into l_start from dual;

Line 840: elec_late_payment_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;

836: l_pk := 'ent_qtr_id';
837: ltd := '_QTD';
838: -- l_bis_map_rec.key:= BIS_PMV_QUERY_PVT.VIEW_BY_KEY;
839: -- l_bis_map_rec.value:= 'TIME+FII_TIME_ENT_QTR';
840: elec_late_payment_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
841: elec_late_payment_rec.attribute_value :='TIME+FII_TIME_ENT_QTR';
842: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
843: l_name :=
844: 'replace(fnd_message.get_string(''FII'',''FII_QUARTER_LABEL''),''&QUARTER_NUMBER'',t.sequence)';

Line 842: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

838: -- l_bis_map_rec.key:= BIS_PMV_QUERY_PVT.VIEW_BY_KEY;
839: -- l_bis_map_rec.value:= 'TIME+FII_TIME_ENT_QTR';
840: elec_late_payment_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
841: elec_late_payment_rec.attribute_value :='TIME+FII_TIME_ENT_QTR';
842: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
843: l_name :=
844: 'replace(fnd_message.get_string(''FII'',''FII_QUARTER_LABEL''),''&QUARTER_NUMBER'',t.sequence)';
845: select nvl(fii_time_api.ent_pqtr_END(l_as_of_date), l_start_date) into l_cy_period_END from dual;
846: IF (l_time_comp = 'SEQUENTIAL') THEN

Line 878: elec_late_payment_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;

874: l_pk := 'ent_year_id';
875: ltd := '_YTD';
876: -- l_bis_map_rec.key:= BIS_PMV_QUERY_PVT.VIEW_BY_KEY;
877: -- l_bis_map_rec.value:= 'TIME+FII_TIME_ENT_YEAR';
878: elec_late_payment_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
879: elec_late_payment_rec.attribute_value :='TIME+FII_TIME_ENT_YEAR';
880: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
881:
882: END CASE;

Line 880: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

876: -- l_bis_map_rec.key:= BIS_PMV_QUERY_PVT.VIEW_BY_KEY;
877: -- l_bis_map_rec.value:= 'TIME+FII_TIME_ENT_YEAR';
878: elec_late_payment_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
879: elec_late_payment_rec.attribute_value :='TIME+FII_TIME_ENT_YEAR';
880: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
881:
882: END CASE;
883:
884: -- p_bis_map_tbl.extEND;

Line 887: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

883:
884: -- p_bis_map_tbl.extEND;
885: -- p_bis_map_tbl(p_bis_map_tbl.count) := l_bis_map_rec;
886: -- l_bis_map_rec.key := BIS_PMV_QUERY_PVT.QUERY_STR_KEY;
887: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
888: elec_late_payment_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
889: elec_late_payment_output.EXTEND;
890: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
891:

Line 888: elec_late_payment_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

884: -- p_bis_map_tbl.extEND;
885: -- p_bis_map_tbl(p_bis_map_tbl.count) := l_bis_map_rec;
886: -- l_bis_map_rec.key := BIS_PMV_QUERY_PVT.QUERY_STR_KEY;
887: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
888: elec_late_payment_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
889: elec_late_payment_output.EXTEND;
890: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
891:
892: l_period_suffix:=FII_PMV_UTIL.get_period_type_suffix(l_page_period_type);

Line 1427: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1423:
1424: elec_late_payment_output.EXTEND;
1425: elec_late_payment_rec.attribute_name := ':FII_BIND1';
1426: elec_late_payment_rec.attribute_value := TO_CHAR(l_actual_period_type);
1427: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1428: elec_late_payment_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1429: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
1430: elec_late_payment_output.EXTEND;
1431: elec_late_payment_rec.attribute_name := ':FII_BIND5';

Line 1428: elec_late_payment_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

1424: elec_late_payment_output.EXTEND;
1425: elec_late_payment_rec.attribute_name := ':FII_BIND1';
1426: elec_late_payment_rec.attribute_value := TO_CHAR(l_actual_period_type);
1427: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1428: elec_late_payment_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1429: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
1430: elec_late_payment_output.EXTEND;
1431: elec_late_payment_rec.attribute_name := ':FII_BIND5';
1432: elec_late_payment_rec.attribute_value := TO_CHAR(l_curr_effective_num);

Line 1433: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1429: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
1430: elec_late_payment_output.EXTEND;
1431: elec_late_payment_rec.attribute_name := ':FII_BIND5';
1432: elec_late_payment_rec.attribute_value := TO_CHAR(l_curr_effective_num);
1433: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1434: elec_late_payment_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1435: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
1436: elec_late_payment_output.EXTEND;
1437: elec_late_payment_rec.attribute_name := ':FII_BIND6';

Line 1434: elec_late_payment_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

1430: elec_late_payment_output.EXTEND;
1431: elec_late_payment_rec.attribute_name := ':FII_BIND5';
1432: elec_late_payment_rec.attribute_value := TO_CHAR(l_curr_effective_num);
1433: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1434: elec_late_payment_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1435: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
1436: elec_late_payment_output.EXTEND;
1437: elec_late_payment_rec.attribute_name := ':FII_BIND6';
1438: elec_late_payment_rec.attribute_value := TO_CHAR(l_period_type);

Line 1439: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1435: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
1436: elec_late_payment_output.EXTEND;
1437: elec_late_payment_rec.attribute_name := ':FII_BIND6';
1438: elec_late_payment_rec.attribute_value := TO_CHAR(l_period_type);
1439: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1440: elec_late_payment_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1441: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
1442: elec_late_payment_output.EXTEND;
1443: elec_late_payment_rec.attribute_name := ':FII_BIND7';

Line 1440: elec_late_payment_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

1436: elec_late_payment_output.EXTEND;
1437: elec_late_payment_rec.attribute_name := ':FII_BIND6';
1438: elec_late_payment_rec.attribute_value := TO_CHAR(l_period_type);
1439: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1440: elec_late_payment_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1441: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
1442: elec_late_payment_output.EXTEND;
1443: elec_late_payment_rec.attribute_name := ':FII_BIND7';
1444: elec_late_payment_rec.attribute_value := TO_CHAR(l_p_as_of_date,'DD/MM/YYYY');

Line 1445: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1441: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
1442: elec_late_payment_output.EXTEND;
1443: elec_late_payment_rec.attribute_name := ':FII_BIND7';
1444: elec_late_payment_rec.attribute_value := TO_CHAR(l_p_as_of_date,'DD/MM/YYYY');
1445: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1446: elec_late_payment_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1447: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
1448: elec_late_payment_output.EXTEND;
1449: elec_late_payment_rec.attribute_name := ':FII_BIND8';

Line 1446: elec_late_payment_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

1442: elec_late_payment_output.EXTEND;
1443: elec_late_payment_rec.attribute_name := ':FII_BIND7';
1444: elec_late_payment_rec.attribute_value := TO_CHAR(l_p_as_of_date,'DD/MM/YYYY');
1445: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1446: elec_late_payment_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1447: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
1448: elec_late_payment_output.EXTEND;
1449: elec_late_payment_rec.attribute_name := ':FII_BIND8';
1450: elec_late_payment_rec.attribute_value := TO_CHAR(l_cy_period_END,'DD/MM/YYYY');

Line 1451: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1447: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
1448: elec_late_payment_output.EXTEND;
1449: elec_late_payment_rec.attribute_name := ':FII_BIND8';
1450: elec_late_payment_rec.attribute_value := TO_CHAR(l_cy_period_END,'DD/MM/YYYY');
1451: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1452: elec_late_payment_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1453: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
1454: elec_late_payment_output.EXTEND;
1455: elec_late_payment_rec.attribute_name := ':FII_BIND10';

Line 1452: elec_late_payment_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

1448: elec_late_payment_output.EXTEND;
1449: elec_late_payment_rec.attribute_name := ':FII_BIND8';
1450: elec_late_payment_rec.attribute_value := TO_CHAR(l_cy_period_END,'DD/MM/YYYY');
1451: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1452: elec_late_payment_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1453: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
1454: elec_late_payment_output.EXTEND;
1455: elec_late_payment_rec.attribute_name := ':FII_BIND10';
1456: elec_late_payment_rec.attribute_value := TO_CHAR(l_ent_pyr_END,'DD/MM/YYYY');

Line 1457: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1453: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
1454: elec_late_payment_output.EXTEND;
1455: elec_late_payment_rec.attribute_name := ':FII_BIND10';
1456: elec_late_payment_rec.attribute_value := TO_CHAR(l_ent_pyr_END,'DD/MM/YYYY');
1457: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1458: elec_late_payment_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1459: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
1460: elec_late_payment_output.EXTEND;
1461: elec_late_payment_rec.attribute_name := ':FII_BIND12';

Line 1458: elec_late_payment_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

1454: elec_late_payment_output.EXTEND;
1455: elec_late_payment_rec.attribute_name := ':FII_BIND10';
1456: elec_late_payment_rec.attribute_value := TO_CHAR(l_ent_pyr_END,'DD/MM/YYYY');
1457: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1458: elec_late_payment_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1459: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
1460: elec_late_payment_output.EXTEND;
1461: elec_late_payment_rec.attribute_name := ':FII_BIND12';
1462: elec_late_payment_rec.attribute_value := TO_CHAR(l_ent_cyr_END,'DD/MM/YYYY');

Line 1463: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1459: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
1460: elec_late_payment_output.EXTEND;
1461: elec_late_payment_rec.attribute_name := ':FII_BIND12';
1462: elec_late_payment_rec.attribute_value := TO_CHAR(l_ent_cyr_END,'DD/MM/YYYY');
1463: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1464: elec_late_payment_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1465: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
1466: elec_late_payment_output.EXTEND;
1467: elec_late_payment_rec.attribute_name := ':FII_BIND13';

Line 1464: elec_late_payment_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

1460: elec_late_payment_output.EXTEND;
1461: elec_late_payment_rec.attribute_name := ':FII_BIND12';
1462: elec_late_payment_rec.attribute_value := TO_CHAR(l_ent_cyr_END,'DD/MM/YYYY');
1463: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1464: elec_late_payment_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1465: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
1466: elec_late_payment_output.EXTEND;
1467: elec_late_payment_rec.attribute_name := ':FII_BIND13';
1468: elec_late_payment_rec.attribute_value := TO_CHAR(l_start,'DD/MM/YYYY');

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

1465: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
1466: elec_late_payment_output.EXTEND;
1467: elec_late_payment_rec.attribute_name := ':FII_BIND13';
1468: elec_late_payment_rec.attribute_value := TO_CHAR(l_start,'DD/MM/YYYY');
1469: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1470: elec_late_payment_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1471: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
1472: elec_late_payment_output.EXTEND;
1473: elec_late_payment_rec.attribute_name := ':FII_BIND14';

Line 1470: elec_late_payment_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

1466: elec_late_payment_output.EXTEND;
1467: elec_late_payment_rec.attribute_name := ':FII_BIND13';
1468: elec_late_payment_rec.attribute_value := TO_CHAR(l_start,'DD/MM/YYYY');
1469: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1470: elec_late_payment_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1471: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
1472: elec_late_payment_output.EXTEND;
1473: elec_late_payment_rec.attribute_name := ':FII_BIND14';
1474: elec_late_payment_rec.attribute_value := TO_CHAR(l_begin_date,'DD/MM/YYYY');

Line 1475: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1471: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
1472: elec_late_payment_output.EXTEND;
1473: elec_late_payment_rec.attribute_name := ':FII_BIND14';
1474: elec_late_payment_rec.attribute_value := TO_CHAR(l_begin_date,'DD/MM/YYYY');
1475: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1476: elec_late_payment_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1477: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
1478: elec_late_payment_output.EXTEND;
1479: elec_late_payment_rec.attribute_name := ':FII_BIND15';

Line 1476: elec_late_payment_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

1472: elec_late_payment_output.EXTEND;
1473: elec_late_payment_rec.attribute_name := ':FII_BIND14';
1474: elec_late_payment_rec.attribute_value := TO_CHAR(l_begin_date,'DD/MM/YYYY');
1475: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1476: elec_late_payment_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1477: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
1478: elec_late_payment_output.EXTEND;
1479: elec_late_payment_rec.attribute_name := ':FII_BIND15';
1480: elec_late_payment_rec.attribute_value := TO_CHAR(l_ent_year_st1,'DD/MM/YYYY');

Line 1481: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1477: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
1478: elec_late_payment_output.EXTEND;
1479: elec_late_payment_rec.attribute_name := ':FII_BIND15';
1480: elec_late_payment_rec.attribute_value := TO_CHAR(l_ent_year_st1,'DD/MM/YYYY');
1481: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1482: elec_late_payment_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1483: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
1484: elec_late_payment_output.EXTEND;
1485: elec_late_payment_rec.attribute_name := ':FII_BIND16';

Line 1482: elec_late_payment_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

1478: elec_late_payment_output.EXTEND;
1479: elec_late_payment_rec.attribute_name := ':FII_BIND15';
1480: elec_late_payment_rec.attribute_value := TO_CHAR(l_ent_year_st1,'DD/MM/YYYY');
1481: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1482: elec_late_payment_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1483: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
1484: elec_late_payment_output.EXTEND;
1485: elec_late_payment_rec.attribute_name := ':FII_BIND16';
1486: elec_late_payment_rec.attribute_value := TO_CHAR(l_ent_year_st2,'DD/MM/YYYY');

Line 1487: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1483: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
1484: elec_late_payment_output.EXTEND;
1485: elec_late_payment_rec.attribute_name := ':FII_BIND16';
1486: elec_late_payment_rec.attribute_value := TO_CHAR(l_ent_year_st2,'DD/MM/YYYY');
1487: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1488: elec_late_payment_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1489: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
1490: elec_late_payment_output.EXTEND;
1491: elec_late_payment_rec.attribute_name := ':GID';

Line 1488: elec_late_payment_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

1484: elec_late_payment_output.EXTEND;
1485: elec_late_payment_rec.attribute_name := ':FII_BIND16';
1486: elec_late_payment_rec.attribute_value := TO_CHAR(l_ent_year_st2,'DD/MM/YYYY');
1487: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1488: elec_late_payment_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1489: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
1490: elec_late_payment_output.EXTEND;
1491: elec_late_payment_rec.attribute_name := ':GID';
1492: elec_late_payment_rec.attribute_value := to_char(l_gid);

Line 1493: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1489: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
1490: elec_late_payment_output.EXTEND;
1491: elec_late_payment_rec.attribute_name := ':GID';
1492: elec_late_payment_rec.attribute_value := to_char(l_gid);
1493: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1494: elec_late_payment_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1495: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
1496: elec_late_payment_output.EXTEND;
1497: elec_late_payment_rec.attribute_name := ':SEC_ID';

Line 1494: elec_late_payment_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

1490: elec_late_payment_output.EXTEND;
1491: elec_late_payment_rec.attribute_name := ':GID';
1492: elec_late_payment_rec.attribute_value := to_char(l_gid);
1493: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1494: elec_late_payment_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1495: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
1496: elec_late_payment_output.EXTEND;
1497: elec_late_payment_rec.attribute_name := ':SEC_ID';
1498: elec_late_payment_rec.attribute_value := fii_pmv_util.get_sec_profile;

Line 1499: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1495: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
1496: elec_late_payment_output.EXTEND;
1497: elec_late_payment_rec.attribute_name := ':SEC_ID';
1498: elec_late_payment_rec.attribute_value := fii_pmv_util.get_sec_profile;
1499: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1500: elec_late_payment_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1501: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
1502: elec_late_payment_output.EXTEND;
1503:

Line 1500: elec_late_payment_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

1496: elec_late_payment_output.EXTEND;
1497: elec_late_payment_rec.attribute_name := ':SEC_ID';
1498: elec_late_payment_rec.attribute_value := fii_pmv_util.get_sec_profile;
1499: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1500: elec_late_payment_rec.attribute_data_type :=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1501: elec_late_payment_output(elec_late_payment_output.COUNT) := elec_late_payment_rec;
1502: elec_late_payment_output.EXTEND;
1503:
1504: END get_elec_late_payment;