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.ICX_ON_UTILITIES2 dependencies on AK_QUERY_PKG

Line 250: procedure printText( p_item_rec in ak_query_pkg.item_rec,

246: htp.tableClose;
247:
248: end;
249:
250: procedure printText( p_item_rec in ak_query_pkg.item_rec,
251: p_data_type in varchar2,
252: p_value in varchar2,
253: p_rowid in rowid,
254: p_goto in varchar2,

Line 360: procedure printButton( p_item_rec in ak_query_pkg.item_rec,

356: end if;
357:
358: end;
359:
360: procedure printButton( p_item_rec in ak_query_pkg.item_rec,
361: p_rowid in rowid,
362: p_goto in varchar2,
363: p_session_id in number,
364: p_rowspan in number,

Line 429: procedure printImage( p_item_rec in ak_query_pkg.item_rec,

425: end if;
426:
427: end;
428:
429: procedure printImage( p_item_rec in ak_query_pkg.item_rec,
430: p_value in varchar2,
431: p_rowid in rowid,
432: p_goto in varchar2,
433: p_session_id in number,

Line 487: ak_query_pkg.exec_query('','','','',p_region_application_id,p_region_code,'','','','','','','','','','','','','','','',l_responsibility_id,l_user_id,'T','F','F','F');

483:
484: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
485: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
486:
487: ak_query_pkg.exec_query('','','','',p_region_application_id,p_region_code,'','','','','','','','','','','','','','','',l_responsibility_id,l_user_id,'T','F','F','F');
488:
489: -- icx_on_utilities2.printPLSQLtables;
490:
491: if p_value_id is null

Line 495: for r in ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST loop

491: if p_value_id is null
492: then
493:
494: l_poplist := htf.formSelectOpen('s');
495: for r in ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST loop
496: l_poplist := l_poplist||('

Line 496: l_poplist := l_poplist||('

492: then
493:
494: l_poplist := htf.formSelectOpen('s');
495: for r in ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST loop
496: l_poplist := l_poplist||('497: end loop;
498: l_poplist := l_poplist||htf.formSelectClose;
499:
500: htp.tableData(cvalue => l_poplist, crowspan => p_rowspan);

Line 505: for r in ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST loop

501:
502: else
503:
504: l_poplist := htf.formSelectOpen('s');
505: for r in ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST loop
506: if ak_query_pkg.g_results_table(r).value2 = p_value
507: then
508: l_poplist := l_poplist||('

Line 506: if ak_query_pkg.g_results_table(r).value2 = p_value

502: else
503:
504: l_poplist := htf.formSelectOpen('s');
505: for r in ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST loop
506: if ak_query_pkg.g_results_table(r).value2 = p_value
507: then
508: l_poplist := l_poplist||('

Line 508: l_poplist := l_poplist||('

504: l_poplist := htf.formSelectOpen('s');
505: for r in ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST loop
506: if ak_query_pkg.g_results_table(r).value2 = p_value
507: then
508: l_poplist := l_poplist||('509: else
510: l_poplist := l_poplist||('

Line 510: l_poplist := l_poplist||('

506: if ak_query_pkg.g_results_table(r).value2 = p_value
507: then
508: l_poplist := l_poplist||('

Line 577: -- l_uk_column_tab ak_query_pkg.rel_key_tab;

573: l_item_styles icx_on_utilities.v30_table;
574: l_data_types icx_on_utilities.v30_table;
575: l_rowids icx_on_utilities.rowid_table;
576: l_url_display_sequence icx_on_utilities.number_table;
577: -- l_uk_column_tab ak_query_pkg.rel_key_tab;
578:
579: l_continue boolean;
580: l_update boolean;
581: l_rowspan number;

Line 650: l_flow_appl_id := ak_query_pkg.g_regions_table(p_region_rec_id).flow_application_id;

646: and b.TO_URL_ATTRIBUTE_CODE = a.ATTRIBUTE_CODE
647: and b.TO_URL_ATTRIBUTE_APPL_ID = a.ATTRIBUTE_APPLICATION_ID;
648: begin
649:
650: l_flow_appl_id := ak_query_pkg.g_regions_table(p_region_rec_id).flow_application_id;
651: l_flow_code := ak_query_pkg.g_regions_table(p_region_rec_id).flow_code;
652: l_page_appl_id := ak_query_pkg.g_regions_table(p_region_rec_id).page_application_id;
653: l_page_code := ak_query_pkg.g_regions_table(p_region_rec_id).page_code;
654: l_region_appl_id := ak_query_pkg.g_regions_table(p_region_rec_id).region_application_id;

Line 651: l_flow_code := ak_query_pkg.g_regions_table(p_region_rec_id).flow_code;

647: and b.TO_URL_ATTRIBUTE_APPL_ID = a.ATTRIBUTE_APPLICATION_ID;
648: begin
649:
650: l_flow_appl_id := ak_query_pkg.g_regions_table(p_region_rec_id).flow_application_id;
651: l_flow_code := ak_query_pkg.g_regions_table(p_region_rec_id).flow_code;
652: l_page_appl_id := ak_query_pkg.g_regions_table(p_region_rec_id).page_application_id;
653: l_page_code := ak_query_pkg.g_regions_table(p_region_rec_id).page_code;
654: l_region_appl_id := ak_query_pkg.g_regions_table(p_region_rec_id).region_application_id;
655: l_region_code := ak_query_pkg.g_regions_table(p_region_rec_id).region_code;

Line 652: l_page_appl_id := ak_query_pkg.g_regions_table(p_region_rec_id).page_application_id;

648: begin
649:
650: l_flow_appl_id := ak_query_pkg.g_regions_table(p_region_rec_id).flow_application_id;
651: l_flow_code := ak_query_pkg.g_regions_table(p_region_rec_id).flow_code;
652: l_page_appl_id := ak_query_pkg.g_regions_table(p_region_rec_id).page_application_id;
653: l_page_code := ak_query_pkg.g_regions_table(p_region_rec_id).page_code;
654: l_region_appl_id := ak_query_pkg.g_regions_table(p_region_rec_id).region_application_id;
655: l_region_code := ak_query_pkg.g_regions_table(p_region_rec_id).region_code;
656: l_region_name := ak_query_pkg.g_regions_table(p_region_rec_id).name;

Line 653: l_page_code := ak_query_pkg.g_regions_table(p_region_rec_id).page_code;

649:
650: l_flow_appl_id := ak_query_pkg.g_regions_table(p_region_rec_id).flow_application_id;
651: l_flow_code := ak_query_pkg.g_regions_table(p_region_rec_id).flow_code;
652: l_page_appl_id := ak_query_pkg.g_regions_table(p_region_rec_id).page_application_id;
653: l_page_code := ak_query_pkg.g_regions_table(p_region_rec_id).page_code;
654: l_region_appl_id := ak_query_pkg.g_regions_table(p_region_rec_id).region_application_id;
655: l_region_code := ak_query_pkg.g_regions_table(p_region_rec_id).region_code;
656: l_region_name := ak_query_pkg.g_regions_table(p_region_rec_id).name;
657: l_region_style := ak_query_pkg.g_regions_table(p_region_rec_id).region_style;

Line 654: l_region_appl_id := ak_query_pkg.g_regions_table(p_region_rec_id).region_application_id;

650: l_flow_appl_id := ak_query_pkg.g_regions_table(p_region_rec_id).flow_application_id;
651: l_flow_code := ak_query_pkg.g_regions_table(p_region_rec_id).flow_code;
652: l_page_appl_id := ak_query_pkg.g_regions_table(p_region_rec_id).page_application_id;
653: l_page_code := ak_query_pkg.g_regions_table(p_region_rec_id).page_code;
654: l_region_appl_id := ak_query_pkg.g_regions_table(p_region_rec_id).region_application_id;
655: l_region_code := ak_query_pkg.g_regions_table(p_region_rec_id).region_code;
656: l_region_name := ak_query_pkg.g_regions_table(p_region_rec_id).name;
657: l_region_style := ak_query_pkg.g_regions_table(p_region_rec_id).region_style;
658: l_num_columns := nvl(ak_query_pkg.g_regions_table(p_region_rec_id).number_of_format_columns,2);

Line 655: l_region_code := ak_query_pkg.g_regions_table(p_region_rec_id).region_code;

651: l_flow_code := ak_query_pkg.g_regions_table(p_region_rec_id).flow_code;
652: l_page_appl_id := ak_query_pkg.g_regions_table(p_region_rec_id).page_application_id;
653: l_page_code := ak_query_pkg.g_regions_table(p_region_rec_id).page_code;
654: l_region_appl_id := ak_query_pkg.g_regions_table(p_region_rec_id).region_application_id;
655: l_region_code := ak_query_pkg.g_regions_table(p_region_rec_id).region_code;
656: l_region_name := ak_query_pkg.g_regions_table(p_region_rec_id).name;
657: l_region_style := ak_query_pkg.g_regions_table(p_region_rec_id).region_style;
658: l_num_columns := nvl(ak_query_pkg.g_regions_table(p_region_rec_id).number_of_format_columns,2);
659: l_total_result_count := ak_query_pkg.g_regions_table(p_region_rec_id).total_result_count;

Line 656: l_region_name := ak_query_pkg.g_regions_table(p_region_rec_id).name;

652: l_page_appl_id := ak_query_pkg.g_regions_table(p_region_rec_id).page_application_id;
653: l_page_code := ak_query_pkg.g_regions_table(p_region_rec_id).page_code;
654: l_region_appl_id := ak_query_pkg.g_regions_table(p_region_rec_id).region_application_id;
655: l_region_code := ak_query_pkg.g_regions_table(p_region_rec_id).region_code;
656: l_region_name := ak_query_pkg.g_regions_table(p_region_rec_id).name;
657: l_region_style := ak_query_pkg.g_regions_table(p_region_rec_id).region_style;
658: l_num_columns := nvl(ak_query_pkg.g_regions_table(p_region_rec_id).number_of_format_columns,2);
659: l_total_result_count := ak_query_pkg.g_regions_table(p_region_rec_id).total_result_count;
660:

Line 657: l_region_style := ak_query_pkg.g_regions_table(p_region_rec_id).region_style;

653: l_page_code := ak_query_pkg.g_regions_table(p_region_rec_id).page_code;
654: l_region_appl_id := ak_query_pkg.g_regions_table(p_region_rec_id).region_application_id;
655: l_region_code := ak_query_pkg.g_regions_table(p_region_rec_id).region_code;
656: l_region_name := ak_query_pkg.g_regions_table(p_region_rec_id).name;
657: l_region_style := ak_query_pkg.g_regions_table(p_region_rec_id).region_style;
658: l_num_columns := nvl(ak_query_pkg.g_regions_table(p_region_rec_id).number_of_format_columns,2);
659: l_total_result_count := ak_query_pkg.g_regions_table(p_region_rec_id).total_result_count;
660:
661: l_region_items_start := -1;

Line 658: l_num_columns := nvl(ak_query_pkg.g_regions_table(p_region_rec_id).number_of_format_columns,2);

654: l_region_appl_id := ak_query_pkg.g_regions_table(p_region_rec_id).region_application_id;
655: l_region_code := ak_query_pkg.g_regions_table(p_region_rec_id).region_code;
656: l_region_name := ak_query_pkg.g_regions_table(p_region_rec_id).name;
657: l_region_style := ak_query_pkg.g_regions_table(p_region_rec_id).region_style;
658: l_num_columns := nvl(ak_query_pkg.g_regions_table(p_region_rec_id).number_of_format_columns,2);
659: l_total_result_count := ak_query_pkg.g_regions_table(p_region_rec_id).total_result_count;
660:
661: l_region_items_start := -1;
662: l_region_items_end := 0;

Line 659: l_total_result_count := ak_query_pkg.g_regions_table(p_region_rec_id).total_result_count;

655: l_region_code := ak_query_pkg.g_regions_table(p_region_rec_id).region_code;
656: l_region_name := ak_query_pkg.g_regions_table(p_region_rec_id).name;
657: l_region_style := ak_query_pkg.g_regions_table(p_region_rec_id).region_style;
658: l_num_columns := nvl(ak_query_pkg.g_regions_table(p_region_rec_id).number_of_format_columns,2);
659: l_total_result_count := ak_query_pkg.g_regions_table(p_region_rec_id).total_result_count;
660:
661: l_region_items_start := -1;
662: l_region_items_end := 0;
663:

Line 664: for i in 0..(ak_query_pkg.g_items_table.COUNT - 1) loop

660:
661: l_region_items_start := -1;
662: l_region_items_end := 0;
663:
664: for i in 0..(ak_query_pkg.g_items_table.COUNT - 1) loop
665: if ak_query_pkg.g_items_table(i).region_rec_id = p_region_rec_id
666: then
667: if l_region_items_start < 0
668: then

Line 665: if ak_query_pkg.g_items_table(i).region_rec_id = p_region_rec_id

661: l_region_items_start := -1;
662: l_region_items_end := 0;
663:
664: for i in 0..(ak_query_pkg.g_items_table.COUNT - 1) loop
665: if ak_query_pkg.g_items_table(i).region_rec_id = p_region_rec_id
666: then
667: if l_region_items_start < 0
668: then
669: l_region_items_start := i;

Line 673: end loop; -- ak_query_pkg.g_items_table

669: l_region_items_start := i;
670: end if;
671: l_region_items_end := i;
672: end if;
673: end loop; -- ak_query_pkg.g_items_table
674:
675: l_region_results_start := -1;
676: l_region_results_end := 0;
677:

Line 678: for i in 0..(ak_query_pkg.g_results_table.COUNT - 1) loop

674:
675: l_region_results_start := -1;
676: l_region_results_end := 0;
677:
678: for i in 0..(ak_query_pkg.g_results_table.COUNT - 1) loop
679: if ak_query_pkg.g_results_table(i).region_rec_id = p_region_rec_id
680: then
681: if l_region_results_start < 0
682: then

Line 679: if ak_query_pkg.g_results_table(i).region_rec_id = p_region_rec_id

675: l_region_results_start := -1;
676: l_region_results_end := 0;
677:
678: for i in 0..(ak_query_pkg.g_results_table.COUNT - 1) loop
679: if ak_query_pkg.g_results_table(i).region_rec_id = p_region_rec_id
680: then
681: if l_region_results_start < 0
682: then
683: l_region_results_start := i;

Line 699: l_display_sequences(ak_query_pkg.g_items_table(i).display_sequence) := i;

695: l_language_code := icx_sec.getID(icx_sec.pv_language_code);
696: l_session_id := icx_sec.getID(icx_sec.pv_session_id);
697:
698: for i in l_region_items_start..l_region_items_end loop
699: l_display_sequences(ak_query_pkg.g_items_table(i).display_sequence) := i;
700: end loop;
701:
702: l_update := FALSE;
703: l_rowspan := 1;

Line 709: if ak_query_pkg.g_items_table(i).update_flag = 'X'

705: l_X := '';
706:
707: for i in l_region_items_start..l_region_items_end loop
708: -- nlbarlow disable ON form support
709: if ak_query_pkg.g_items_table(i).update_flag = 'X'
710: then
711: l_update := TRUE;
712: l_update_count := l_update_count + 1;
713: l_X := l_X||ak_query_pkg.g_items_table(i).attribute_code||'*';

Line 713: l_X := l_X||ak_query_pkg.g_items_table(i).attribute_code||'*';

709: if ak_query_pkg.g_items_table(i).update_flag = 'X'
710: then
711: l_update := TRUE;
712: l_update_count := l_update_count + 1;
713: l_X := l_X||ak_query_pkg.g_items_table(i).attribute_code||'*';
714: end if;
715: if ak_query_pkg.g_items_table(i).attribute_label_length = 0
716: then
717: ak_query_pkg.g_items_table(i).attribute_label_long := '
';

Line 715: if ak_query_pkg.g_items_table(i).attribute_label_length = 0

711: l_update := TRUE;
712: l_update_count := l_update_count + 1;
713: l_X := l_X||ak_query_pkg.g_items_table(i).attribute_code||'*';
714: end if;
715: if ak_query_pkg.g_items_table(i).attribute_label_length = 0
716: then
717: ak_query_pkg.g_items_table(i).attribute_label_long := '
';
718: end if;
719: l_value_id(i) := ak_query_pkg.g_items_table(i).value_id;

Line 717: ak_query_pkg.g_items_table(i).attribute_label_long := '
';

713: l_X := l_X||ak_query_pkg.g_items_table(i).attribute_code||'*';
714: end if;
715: if ak_query_pkg.g_items_table(i).attribute_label_length = 0
716: then
717: ak_query_pkg.g_items_table(i).attribute_label_long := '
';
718: end if;
719: l_value_id(i) := ak_query_pkg.g_items_table(i).value_id;
720: l_item_styles(i) := ak_query_pkg.g_items_table(i).item_style;
721: if l_item_styles(i) = 'HIDDEN'

Line 719: l_value_id(i) := ak_query_pkg.g_items_table(i).value_id;

715: if ak_query_pkg.g_items_table(i).attribute_label_length = 0
716: then
717: ak_query_pkg.g_items_table(i).attribute_label_long := '
';
718: end if;
719: l_value_id(i) := ak_query_pkg.g_items_table(i).value_id;
720: l_item_styles(i) := ak_query_pkg.g_items_table(i).item_style;
721: if l_item_styles(i) = 'HIDDEN'
722: then
723: l_update_count := l_update_count + 1;

Line 720: l_item_styles(i) := ak_query_pkg.g_items_table(i).item_style;

716: then
717: ak_query_pkg.g_items_table(i).attribute_label_long := '
';
718: end if;
719: l_value_id(i) := ak_query_pkg.g_items_table(i).value_id;
720: l_item_styles(i) := ak_query_pkg.g_items_table(i).item_style;
721: if l_item_styles(i) = 'HIDDEN'
722: then
723: l_update_count := l_update_count + 1;
724: l_X := l_X||ak_query_pkg.g_items_table(i).attribute_code||'*';

Line 724: l_X := l_X||ak_query_pkg.g_items_table(i).attribute_code||'*';

720: l_item_styles(i) := ak_query_pkg.g_items_table(i).item_style;
721: if l_item_styles(i) = 'HIDDEN'
722: then
723: l_update_count := l_update_count + 1;
724: l_X := l_X||ak_query_pkg.g_items_table(i).attribute_code||'*';
725: elsif l_item_styles(i) = 'SPINBOX'
726: then
727: l_rowspan := 2;
728: l_update_counts(i) := l_update_count;

Line 730: l_attribute_appl_id := ak_query_pkg.g_items_table(i).attribute_application_id;

726: then
727: l_rowspan := 2;
728: l_update_counts(i) := l_update_count;
729: end if;
730: l_attribute_appl_id := ak_query_pkg.g_items_table(i).attribute_application_id;
731: l_attribute_code := ak_query_pkg.g_items_table(i).attribute_code;
732: l_attribute_codes := l_attribute_codes||ak_query_pkg.g_items_table(i).attribute_code||'*';
733: select DATA_TYPE
734: into l_data_types(i)

Line 731: l_attribute_code := ak_query_pkg.g_items_table(i).attribute_code;

727: l_rowspan := 2;
728: l_update_counts(i) := l_update_count;
729: end if;
730: l_attribute_appl_id := ak_query_pkg.g_items_table(i).attribute_application_id;
731: l_attribute_code := ak_query_pkg.g_items_table(i).attribute_code;
732: l_attribute_codes := l_attribute_codes||ak_query_pkg.g_items_table(i).attribute_code||'*';
733: select DATA_TYPE
734: into l_data_types(i)
735: from AK_ATTRIBUTES

Line 732: l_attribute_codes := l_attribute_codes||ak_query_pkg.g_items_table(i).attribute_code||'*';

728: l_update_counts(i) := l_update_count;
729: end if;
730: l_attribute_appl_id := ak_query_pkg.g_items_table(i).attribute_application_id;
731: l_attribute_code := ak_query_pkg.g_items_table(i).attribute_code;
732: l_attribute_codes := l_attribute_codes||ak_query_pkg.g_items_table(i).attribute_code||'*';
733: select DATA_TYPE
734: into l_data_types(i)
735: from AK_ATTRIBUTES
736: where ATTRIBUTE_APPLICATION_ID = l_attribute_appl_id

Line 756: if ak_query_pkg.g_items_table(i).region_defaulting_api_pkg is not null

752: l_item_styles(i) := 'URL';
753: l_url_display_sequence(i) := l_display_sequences(u.DISPLAY_SEQUENCE);
754: end loop; -- urls
755:
756: if ak_query_pkg.g_items_table(i).region_defaulting_api_pkg is not null
757: then
758: l_item_styles(i) := 'DEFAULT_PKG';
759: end if;
760:

Line 761: -- htp.p('DEBUG '||i||' '||ak_query_pkg.g_items_table(i).attribute_label_long||' '||l_attribute_code||' '||l_item_styles(i)||' '||l_url_display_sequence(i));htp.nl;

757: then
758: l_item_styles(i) := 'DEFAULT_PKG';
759: end if;
760:
761: -- htp.p('DEBUG '||i||' '||ak_query_pkg.g_items_table(i).attribute_label_long||' '||l_attribute_code||' '||l_item_styles(i)||' '||l_url_display_sequence(i));htp.nl;
762:
763: end loop; -- region_items
764:
765: l_attribute_codes := l_attribute_codes||']';

Line 841: htp.formOpen(curl => icx_cabo.g_plsql_agent||ak_query_pkg.g_regions_table(p_region_rec_id).region_validation_api_pkg||'.'||ak_query_pkg.g_regions_table(p_region_rec_id).region_validation_api_proc, cattributes => 'NAME="submitForm"');

837:
838: htp.p('// -->');
839: htp.p('');
840:
841: htp.formOpen(curl => icx_cabo.g_plsql_agent||ak_query_pkg.g_regions_table(p_region_rec_id).region_validation_api_pkg||'.'||ak_query_pkg.g_regions_table(p_region_rec_id).region_validation_api_proc, cattributes => 'NAME="submitForm"');
842: htp.formHidden('X',l_X);
843: htp.formHidden('Y',l_Y);
844: htp.formHidden('Z');
845: htp.formClose;

Line 911: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

907:
908: htp.tableOpen(cborder => 'BORDER=2', cattributes => 'CELLPADDING=2');
909: htp.p('');
910: for i in l_region_items_start..l_region_items_end loop
911: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
912: and ak_query_pkg.g_items_table(i).secured_column = 'F'
913: then
914: if l_item_styles(i) = 'BUTTON'
915: then

Line 912: and ak_query_pkg.g_items_table(i).secured_column = 'F'

908: htp.tableOpen(cborder => 'BORDER=2', cattributes => 'CELLPADDING=2');
909: htp.p('');
910: for i in l_region_items_start..l_region_items_end loop
911: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
912: and ak_query_pkg.g_items_table(i).secured_column = 'F'
913: then
914: if l_item_styles(i) = 'BUTTON'
915: then
916: htp.tableData(cvalue => '
');

Line 922: htp.tableData(cvalue => ''||ak_query_pkg.g_items_table(i).attribute_label_long||'', calign => 'CENTER', ccolspan => 2);

918: then
919: l_title := '';
920: elsif l_item_styles(i) = 'SPINBOX' and l_data_types(i) = 'NUMBER'
921: then
922: htp.tableData(cvalue => ''||ak_query_pkg.g_items_table(i).attribute_label_long||'', calign => 'CENTER', ccolspan => 2);
923: else
924: htp.tableData(''||ak_query_pkg.g_items_table(i).attribute_label_long||'', calign => 'CENTER');
925: end if;
926: end if;

Line 924: htp.tableData(''||ak_query_pkg.g_items_table(i).attribute_label_long||'', calign => 'CENTER');

920: elsif l_item_styles(i) = 'SPINBOX' and l_data_types(i) = 'NUMBER'
921: then
922: htp.tableData(cvalue => ''||ak_query_pkg.g_items_table(i).attribute_label_long||'', calign => 'CENTER', ccolspan => 2);
923: else
924: htp.tableData(''||ak_query_pkg.g_items_table(i).attribute_label_long||'', calign => 'CENTER');
925: end if;
926: end if;
927: end loop; -- region_items
928: htp.tableRowClose;

Line 940: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),l_values);

936: for r in l_region_results_start..l_region_results_end loop
937:
938: l_row_count := l_row_count + 1;
939:
940: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),l_values);
941:
942: -- ak_query_pkg.get_uk_columns(ak_query_pkg.g_regions_table(p_region_rec_id).primary_key_name, l_uk_column_tab);
943: l_goto := ak_query_pkg.g_regions_table(p_region_rec_id).primary_key_name
944: ||'*'||ak_query_pkg.g_results_table(r).key1

Line 942: -- ak_query_pkg.get_uk_columns(ak_query_pkg.g_regions_table(p_region_rec_id).primary_key_name, l_uk_column_tab);

938: l_row_count := l_row_count + 1;
939:
940: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),l_values);
941:
942: -- ak_query_pkg.get_uk_columns(ak_query_pkg.g_regions_table(p_region_rec_id).primary_key_name, l_uk_column_tab);
943: l_goto := ak_query_pkg.g_regions_table(p_region_rec_id).primary_key_name
944: ||'*'||ak_query_pkg.g_results_table(r).key1
945: ||'*'||ak_query_pkg.g_results_table(r).key2
946: ||'*'||ak_query_pkg.g_results_table(r).key3

Line 943: l_goto := ak_query_pkg.g_regions_table(p_region_rec_id).primary_key_name

939:
940: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),l_values);
941:
942: -- ak_query_pkg.get_uk_columns(ak_query_pkg.g_regions_table(p_region_rec_id).primary_key_name, l_uk_column_tab);
943: l_goto := ak_query_pkg.g_regions_table(p_region_rec_id).primary_key_name
944: ||'*'||ak_query_pkg.g_results_table(r).key1
945: ||'*'||ak_query_pkg.g_results_table(r).key2
946: ||'*'||ak_query_pkg.g_results_table(r).key3
947: ||'*'||ak_query_pkg.g_results_table(r).key4

Line 944: ||'*'||ak_query_pkg.g_results_table(r).key1

940: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),l_values);
941:
942: -- ak_query_pkg.get_uk_columns(ak_query_pkg.g_regions_table(p_region_rec_id).primary_key_name, l_uk_column_tab);
943: l_goto := ak_query_pkg.g_regions_table(p_region_rec_id).primary_key_name
944: ||'*'||ak_query_pkg.g_results_table(r).key1
945: ||'*'||ak_query_pkg.g_results_table(r).key2
946: ||'*'||ak_query_pkg.g_results_table(r).key3
947: ||'*'||ak_query_pkg.g_results_table(r).key4
948: ||'*'||ak_query_pkg.g_results_table(r).key5

Line 945: ||'*'||ak_query_pkg.g_results_table(r).key2

941:
942: -- ak_query_pkg.get_uk_columns(ak_query_pkg.g_regions_table(p_region_rec_id).primary_key_name, l_uk_column_tab);
943: l_goto := ak_query_pkg.g_regions_table(p_region_rec_id).primary_key_name
944: ||'*'||ak_query_pkg.g_results_table(r).key1
945: ||'*'||ak_query_pkg.g_results_table(r).key2
946: ||'*'||ak_query_pkg.g_results_table(r).key3
947: ||'*'||ak_query_pkg.g_results_table(r).key4
948: ||'*'||ak_query_pkg.g_results_table(r).key5
949: ||'*'||ak_query_pkg.g_results_table(r).key6

Line 946: ||'*'||ak_query_pkg.g_results_table(r).key3

942: -- ak_query_pkg.get_uk_columns(ak_query_pkg.g_regions_table(p_region_rec_id).primary_key_name, l_uk_column_tab);
943: l_goto := ak_query_pkg.g_regions_table(p_region_rec_id).primary_key_name
944: ||'*'||ak_query_pkg.g_results_table(r).key1
945: ||'*'||ak_query_pkg.g_results_table(r).key2
946: ||'*'||ak_query_pkg.g_results_table(r).key3
947: ||'*'||ak_query_pkg.g_results_table(r).key4
948: ||'*'||ak_query_pkg.g_results_table(r).key5
949: ||'*'||ak_query_pkg.g_results_table(r).key6
950: ||'*'||ak_query_pkg.g_results_table(r).key7

Line 947: ||'*'||ak_query_pkg.g_results_table(r).key4

943: l_goto := ak_query_pkg.g_regions_table(p_region_rec_id).primary_key_name
944: ||'*'||ak_query_pkg.g_results_table(r).key1
945: ||'*'||ak_query_pkg.g_results_table(r).key2
946: ||'*'||ak_query_pkg.g_results_table(r).key3
947: ||'*'||ak_query_pkg.g_results_table(r).key4
948: ||'*'||ak_query_pkg.g_results_table(r).key5
949: ||'*'||ak_query_pkg.g_results_table(r).key6
950: ||'*'||ak_query_pkg.g_results_table(r).key7
951: ||'*'||ak_query_pkg.g_results_table(r).key8

Line 948: ||'*'||ak_query_pkg.g_results_table(r).key5

944: ||'*'||ak_query_pkg.g_results_table(r).key1
945: ||'*'||ak_query_pkg.g_results_table(r).key2
946: ||'*'||ak_query_pkg.g_results_table(r).key3
947: ||'*'||ak_query_pkg.g_results_table(r).key4
948: ||'*'||ak_query_pkg.g_results_table(r).key5
949: ||'*'||ak_query_pkg.g_results_table(r).key6
950: ||'*'||ak_query_pkg.g_results_table(r).key7
951: ||'*'||ak_query_pkg.g_results_table(r).key8
952: ||'*'||ak_query_pkg.g_results_table(r).key9

Line 949: ||'*'||ak_query_pkg.g_results_table(r).key6

945: ||'*'||ak_query_pkg.g_results_table(r).key2
946: ||'*'||ak_query_pkg.g_results_table(r).key3
947: ||'*'||ak_query_pkg.g_results_table(r).key4
948: ||'*'||ak_query_pkg.g_results_table(r).key5
949: ||'*'||ak_query_pkg.g_results_table(r).key6
950: ||'*'||ak_query_pkg.g_results_table(r).key7
951: ||'*'||ak_query_pkg.g_results_table(r).key8
952: ||'*'||ak_query_pkg.g_results_table(r).key9
953: ||'*'||ak_query_pkg.g_results_table(r).key10||'**]';

Line 950: ||'*'||ak_query_pkg.g_results_table(r).key7

946: ||'*'||ak_query_pkg.g_results_table(r).key3
947: ||'*'||ak_query_pkg.g_results_table(r).key4
948: ||'*'||ak_query_pkg.g_results_table(r).key5
949: ||'*'||ak_query_pkg.g_results_table(r).key6
950: ||'*'||ak_query_pkg.g_results_table(r).key7
951: ||'*'||ak_query_pkg.g_results_table(r).key8
952: ||'*'||ak_query_pkg.g_results_table(r).key9
953: ||'*'||ak_query_pkg.g_results_table(r).key10||'**]';
954:

Line 951: ||'*'||ak_query_pkg.g_results_table(r).key8

947: ||'*'||ak_query_pkg.g_results_table(r).key4
948: ||'*'||ak_query_pkg.g_results_table(r).key5
949: ||'*'||ak_query_pkg.g_results_table(r).key6
950: ||'*'||ak_query_pkg.g_results_table(r).key7
951: ||'*'||ak_query_pkg.g_results_table(r).key8
952: ||'*'||ak_query_pkg.g_results_table(r).key9
953: ||'*'||ak_query_pkg.g_results_table(r).key10||'**]';
954:
955: htp.p('');

Line 952: ||'*'||ak_query_pkg.g_results_table(r).key9

948: ||'*'||ak_query_pkg.g_results_table(r).key5
949: ||'*'||ak_query_pkg.g_results_table(r).key6
950: ||'*'||ak_query_pkg.g_results_table(r).key7
951: ||'*'||ak_query_pkg.g_results_table(r).key8
952: ||'*'||ak_query_pkg.g_results_table(r).key9
953: ||'*'||ak_query_pkg.g_results_table(r).key10||'**]';
954:
955: htp.p('');
956:

Line 953: ||'*'||ak_query_pkg.g_results_table(r).key10||'**]';

949: ||'*'||ak_query_pkg.g_results_table(r).key6
950: ||'*'||ak_query_pkg.g_results_table(r).key7
951: ||'*'||ak_query_pkg.g_results_table(r).key8
952: ||'*'||ak_query_pkg.g_results_table(r).key9
953: ||'*'||ak_query_pkg.g_results_table(r).key10||'**]';
954:
955: htp.p('');
956:
957: for i in l_region_items_start..l_region_items_end loop

Line 959: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

955: htp.p('');
956:
957: for i in l_region_items_start..l_region_items_end loop
958:
959: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
960: and ak_query_pkg.g_items_table(i).secured_column = 'F'
961: then
962: -- htp.p('DEBUG '||i||' '||l_value_id(i)||' '||l_secured_column(i)||' '||l_node_display_flag(i)||' '||ak_query_pkg.g_items_table(i).attribute_label_long||' '||l_item_styles(i)||' '||l_url_display_sequence(i));htp.nl;
963:

Line 960: and ak_query_pkg.g_items_table(i).secured_column = 'F'

956:
957: for i in l_region_items_start..l_region_items_end loop
958:
959: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
960: and ak_query_pkg.g_items_table(i).secured_column = 'F'
961: then
962: -- htp.p('DEBUG '||i||' '||l_value_id(i)||' '||l_secured_column(i)||' '||l_node_display_flag(i)||' '||ak_query_pkg.g_items_table(i).attribute_label_long||' '||l_item_styles(i)||' '||l_url_display_sequence(i));htp.nl;
963:
964: if ak_query_pkg.g_items_table(i).value_id is null

Line 962: -- htp.p('DEBUG '||i||' '||l_value_id(i)||' '||l_secured_column(i)||' '||l_node_display_flag(i)||' '||ak_query_pkg.g_items_table(i).attribute_label_long||' '||l_item_styles(i)||' '||l_url_display_sequence(i));htp.nl;

958:
959: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
960: and ak_query_pkg.g_items_table(i).secured_column = 'F'
961: then
962: -- htp.p('DEBUG '||i||' '||l_value_id(i)||' '||l_secured_column(i)||' '||l_node_display_flag(i)||' '||ak_query_pkg.g_items_table(i).attribute_label_long||' '||l_item_styles(i)||' '||l_url_display_sequence(i));htp.nl;
963:
964: if ak_query_pkg.g_items_table(i).value_id is null
965: then
966: l_value := ak_query_pkg.g_items_table(i).attribute_label_long;

Line 964: if ak_query_pkg.g_items_table(i).value_id is null

960: and ak_query_pkg.g_items_table(i).secured_column = 'F'
961: then
962: -- htp.p('DEBUG '||i||' '||l_value_id(i)||' '||l_secured_column(i)||' '||l_node_display_flag(i)||' '||ak_query_pkg.g_items_table(i).attribute_label_long||' '||l_item_styles(i)||' '||l_url_display_sequence(i));htp.nl;
963:
964: if ak_query_pkg.g_items_table(i).value_id is null
965: then
966: l_value := ak_query_pkg.g_items_table(i).attribute_label_long;
967: else
968: l_value := l_values(ak_query_pkg.g_items_table(i).value_id);

Line 966: l_value := ak_query_pkg.g_items_table(i).attribute_label_long;

962: -- htp.p('DEBUG '||i||' '||l_value_id(i)||' '||l_secured_column(i)||' '||l_node_display_flag(i)||' '||ak_query_pkg.g_items_table(i).attribute_label_long||' '||l_item_styles(i)||' '||l_url_display_sequence(i));htp.nl;
963:
964: if ak_query_pkg.g_items_table(i).value_id is null
965: then
966: l_value := ak_query_pkg.g_items_table(i).attribute_label_long;
967: else
968: l_value := l_values(ak_query_pkg.g_items_table(i).value_id);
969: end if;
970:

Line 968: l_value := l_values(ak_query_pkg.g_items_table(i).value_id);

964: if ak_query_pkg.g_items_table(i).value_id is null
965: then
966: l_value := ak_query_pkg.g_items_table(i).attribute_label_long;
967: else
968: l_value := l_values(ak_query_pkg.g_items_table(i).value_id);
969: end if;
970:
971: if l_item_styles(i) = 'TEXT'
972: then

Line 974: printText( ak_query_pkg.g_items_table(i),

970:
971: if l_item_styles(i) = 'TEXT'
972: then
973:
974: printText( ak_query_pkg.g_items_table(i),
975: l_data_types(i),
976: l_value,
977: l_rowids(i),
978: l_goto,

Line 987: printSpinboxup( ak_query_pkg.g_items_table(i).update_flag,

983:
984: elsif l_item_styles(i) = 'SPINBOX'
985: then
986:
987: printSpinboxup( ak_query_pkg.g_items_table(i).update_flag,
988: ak_query_pkg.g_items_table(i).required_flag,
989: ak_query_pkg.g_items_table(i).attribute_label_long,
990: l_data_types(i),
991: l_value,

Line 988: ak_query_pkg.g_items_table(i).required_flag,

984: elsif l_item_styles(i) = 'SPINBOX'
985: then
986:
987: printSpinboxup( ak_query_pkg.g_items_table(i).update_flag,
988: ak_query_pkg.g_items_table(i).required_flag,
989: ak_query_pkg.g_items_table(i).attribute_label_long,
990: l_data_types(i),
991: l_value,
992: ak_query_pkg.g_items_table(i).display_value_length,

Line 989: ak_query_pkg.g_items_table(i).attribute_label_long,

985: then
986:
987: printSpinboxup( ak_query_pkg.g_items_table(i).update_flag,
988: ak_query_pkg.g_items_table(i).required_flag,
989: ak_query_pkg.g_items_table(i).attribute_label_long,
990: l_data_types(i),
991: l_value,
992: ak_query_pkg.g_items_table(i).display_value_length,
993: ak_query_pkg.g_items_table(i).bold,

Line 992: ak_query_pkg.g_items_table(i).display_value_length,

988: ak_query_pkg.g_items_table(i).required_flag,
989: ak_query_pkg.g_items_table(i).attribute_label_long,
990: l_data_types(i),
991: l_value,
992: ak_query_pkg.g_items_table(i).display_value_length,
993: ak_query_pkg.g_items_table(i).bold,
994: ak_query_pkg.g_items_table(i).italic,
995: ak_query_pkg.g_items_table(i).horizontal_alignment,
996: ak_query_pkg.g_items_table(i).vertical_alignment,

Line 993: ak_query_pkg.g_items_table(i).bold,

989: ak_query_pkg.g_items_table(i).attribute_label_long,
990: l_data_types(i),
991: l_value,
992: ak_query_pkg.g_items_table(i).display_value_length,
993: ak_query_pkg.g_items_table(i).bold,
994: ak_query_pkg.g_items_table(i).italic,
995: ak_query_pkg.g_items_table(i).horizontal_alignment,
996: ak_query_pkg.g_items_table(i).vertical_alignment,
997: to_char((l_row_count-1)*l_update_total+l_update_counts(i)-1),

Line 994: ak_query_pkg.g_items_table(i).italic,

990: l_data_types(i),
991: l_value,
992: ak_query_pkg.g_items_table(i).display_value_length,
993: ak_query_pkg.g_items_table(i).bold,
994: ak_query_pkg.g_items_table(i).italic,
995: ak_query_pkg.g_items_table(i).horizontal_alignment,
996: ak_query_pkg.g_items_table(i).vertical_alignment,
997: to_char((l_row_count-1)*l_update_total+l_update_counts(i)-1),
998: l_language_code,

Line 995: ak_query_pkg.g_items_table(i).horizontal_alignment,

991: l_value,
992: ak_query_pkg.g_items_table(i).display_value_length,
993: ak_query_pkg.g_items_table(i).bold,
994: ak_query_pkg.g_items_table(i).italic,
995: ak_query_pkg.g_items_table(i).horizontal_alignment,
996: ak_query_pkg.g_items_table(i).vertical_alignment,
997: to_char((l_row_count-1)*l_update_total+l_update_counts(i)-1),
998: l_language_code,
999: l_rowspan);

Line 996: ak_query_pkg.g_items_table(i).vertical_alignment,

992: ak_query_pkg.g_items_table(i).display_value_length,
993: ak_query_pkg.g_items_table(i).bold,
994: ak_query_pkg.g_items_table(i).italic,
995: ak_query_pkg.g_items_table(i).horizontal_alignment,
996: ak_query_pkg.g_items_table(i).vertical_alignment,
997: to_char((l_row_count-1)*l_update_total+l_update_counts(i)-1),
998: l_language_code,
999: l_rowspan);
1000:

Line 1003: printButton( ak_query_pkg.g_items_table(i),

999: l_rowspan);
1000:
1001: elsif l_item_styles(i) = 'BUTTON'
1002: then
1003: printButton( ak_query_pkg.g_items_table(i),
1004: l_rowids(i),
1005: l_goto,
1006: l_session_id,
1007: l_rowspan,

Line 1016: printCheckbox( ak_query_pkg.g_items_table(i).update_flag,

1012: htp.formHidden('h',l_value);
1013: elsif l_item_styles(i) = 'CHECKBOX'
1014: then
1015:
1016: printCheckbox( ak_query_pkg.g_items_table(i).update_flag,
1017: ak_query_pkg.g_items_table(i).value_id,
1018: l_value,
1019: ak_query_pkg.g_items_table(i).horizontal_alignment,
1020: ak_query_pkg.g_items_table(i).vertical_alignment,

Line 1017: ak_query_pkg.g_items_table(i).value_id,

1013: elsif l_item_styles(i) = 'CHECKBOX'
1014: then
1015:
1016: printCheckbox( ak_query_pkg.g_items_table(i).update_flag,
1017: ak_query_pkg.g_items_table(i).value_id,
1018: l_value,
1019: ak_query_pkg.g_items_table(i).horizontal_alignment,
1020: ak_query_pkg.g_items_table(i).vertical_alignment,
1021: l_language_code,

Line 1019: ak_query_pkg.g_items_table(i).horizontal_alignment,

1015:
1016: printCheckbox( ak_query_pkg.g_items_table(i).update_flag,
1017: ak_query_pkg.g_items_table(i).value_id,
1018: l_value,
1019: ak_query_pkg.g_items_table(i).horizontal_alignment,
1020: ak_query_pkg.g_items_table(i).vertical_alignment,
1021: l_language_code,
1022: l_rowspan,
1023: '');

Line 1020: ak_query_pkg.g_items_table(i).vertical_alignment,

1016: printCheckbox( ak_query_pkg.g_items_table(i).update_flag,
1017: ak_query_pkg.g_items_table(i).value_id,
1018: l_value,
1019: ak_query_pkg.g_items_table(i).horizontal_alignment,
1020: ak_query_pkg.g_items_table(i).vertical_alignment,
1021: l_language_code,
1022: l_rowspan,
1023: '');
1024:

Line 1028: printImage( ak_query_pkg.g_items_table(i),

1024:
1025: elsif l_item_styles(i) = 'IMAGE'
1026: then
1027:
1028: printImage( ak_query_pkg.g_items_table(i),
1029: l_value,
1030: l_rowids(i),
1031: l_goto,
1032: l_session_id,

Line 1039: printPoplist( ak_query_pkg.g_items_table(i).lov_region_application_id,

1035:
1036: elsif l_item_styles(i) = 'POPLIST'
1037: then
1038:
1039: printPoplist( ak_query_pkg.g_items_table(i).lov_region_application_id,
1040: ak_query_pkg.g_items_table(i).lov_region_code,
1041: ak_query_pkg.g_items_table(i).update_flag,
1042: ak_query_pkg.g_items_table(i).value_id,
1043: l_value,

Line 1040: ak_query_pkg.g_items_table(i).lov_region_code,

1036: elsif l_item_styles(i) = 'POPLIST'
1037: then
1038:
1039: printPoplist( ak_query_pkg.g_items_table(i).lov_region_application_id,
1040: ak_query_pkg.g_items_table(i).lov_region_code,
1041: ak_query_pkg.g_items_table(i).update_flag,
1042: ak_query_pkg.g_items_table(i).value_id,
1043: l_value,
1044: ak_query_pkg.g_items_table(i).bold,

Line 1041: ak_query_pkg.g_items_table(i).update_flag,

1037: then
1038:
1039: printPoplist( ak_query_pkg.g_items_table(i).lov_region_application_id,
1040: ak_query_pkg.g_items_table(i).lov_region_code,
1041: ak_query_pkg.g_items_table(i).update_flag,
1042: ak_query_pkg.g_items_table(i).value_id,
1043: l_value,
1044: ak_query_pkg.g_items_table(i).bold,
1045: ak_query_pkg.g_items_table(i).italic,

Line 1042: ak_query_pkg.g_items_table(i).value_id,

1038:
1039: printPoplist( ak_query_pkg.g_items_table(i).lov_region_application_id,
1040: ak_query_pkg.g_items_table(i).lov_region_code,
1041: ak_query_pkg.g_items_table(i).update_flag,
1042: ak_query_pkg.g_items_table(i).value_id,
1043: l_value,
1044: ak_query_pkg.g_items_table(i).bold,
1045: ak_query_pkg.g_items_table(i).italic,
1046: ak_query_pkg.g_items_table(i).horizontal_alignment,

Line 1044: ak_query_pkg.g_items_table(i).bold,

1040: ak_query_pkg.g_items_table(i).lov_region_code,
1041: ak_query_pkg.g_items_table(i).update_flag,
1042: ak_query_pkg.g_items_table(i).value_id,
1043: l_value,
1044: ak_query_pkg.g_items_table(i).bold,
1045: ak_query_pkg.g_items_table(i).italic,
1046: ak_query_pkg.g_items_table(i).horizontal_alignment,
1047: ak_query_pkg.g_items_table(i).vertical_alignment,
1048: l_rowspan);

Line 1045: ak_query_pkg.g_items_table(i).italic,

1041: ak_query_pkg.g_items_table(i).update_flag,
1042: ak_query_pkg.g_items_table(i).value_id,
1043: l_value,
1044: ak_query_pkg.g_items_table(i).bold,
1045: ak_query_pkg.g_items_table(i).italic,
1046: ak_query_pkg.g_items_table(i).horizontal_alignment,
1047: ak_query_pkg.g_items_table(i).vertical_alignment,
1048: l_rowspan);
1049:

Line 1046: ak_query_pkg.g_items_table(i).horizontal_alignment,

1042: ak_query_pkg.g_items_table(i).value_id,
1043: l_value,
1044: ak_query_pkg.g_items_table(i).bold,
1045: ak_query_pkg.g_items_table(i).italic,
1046: ak_query_pkg.g_items_table(i).horizontal_alignment,
1047: ak_query_pkg.g_items_table(i).vertical_alignment,
1048: l_rowspan);
1049:
1050: elsif l_item_styles(i) = 'DEFAULT_PKG'

Line 1047: ak_query_pkg.g_items_table(i).vertical_alignment,

1043: l_value,
1044: ak_query_pkg.g_items_table(i).bold,
1045: ak_query_pkg.g_items_table(i).italic,
1046: ak_query_pkg.g_items_table(i).horizontal_alignment,
1047: ak_query_pkg.g_items_table(i).vertical_alignment,
1048: l_rowspan);
1049:
1050: elsif l_item_styles(i) = 'DEFAULT_PKG'
1051: then

Line 1052: htp.p('');

1048: l_rowspan);
1049:
1050: elsif l_item_styles(i) = 'DEFAULT_PKG'
1051: then
1052: htp.p('');
1053: l_procedure_call := ak_query_pkg.g_items_table(i).region_defaulting_api_pkg||'.'||ak_query_pkg.g_items_table(i).region_defaulting_api_proc||'(:l_attribute_codes,:p_result_values)';
1054: p_result_values := '';
1055:
1056: for i in l_region_items_start..l_region_items_end loop

Line 1053: l_procedure_call := ak_query_pkg.g_items_table(i).region_defaulting_api_pkg||'.'||ak_query_pkg.g_items_table(i).region_defaulting_api_proc||'(:l_attribute_codes,:p_result_values)';

1049:
1050: elsif l_item_styles(i) = 'DEFAULT_PKG'
1051: then
1052: htp.p('');
1053: l_procedure_call := ak_query_pkg.g_items_table(i).region_defaulting_api_pkg||'.'||ak_query_pkg.g_items_table(i).region_defaulting_api_proc||'(:l_attribute_codes,:p_result_values)';
1054: p_result_values := '';
1055:
1056: for i in l_region_items_start..l_region_items_end loop
1057: if ak_query_pkg.g_items_table(i).value_id is null

Line 1057: if ak_query_pkg.g_items_table(i).value_id is null

1053: l_procedure_call := ak_query_pkg.g_items_table(i).region_defaulting_api_pkg||'.'||ak_query_pkg.g_items_table(i).region_defaulting_api_proc||'(:l_attribute_codes,:p_result_values)';
1054: p_result_values := '';
1055:
1056: for i in l_region_items_start..l_region_items_end loop
1057: if ak_query_pkg.g_items_table(i).value_id is null
1058: then
1059: p_result_values := p_result_values||'*';
1060: else
1061: l_value := replace(l_values(l_value_id(i)),'*','~at~');

Line 1078: printText( ak_query_pkg.g_items_table(i),

1074: elsif l_item_styles(i) = 'URL'
1075: then
1076: if l_values(l_value_id(l_url_display_sequence(i))) is null
1077: then
1078: printText( ak_query_pkg.g_items_table(i),
1079: l_data_types(i),
1080: l_value,
1081: l_rowids(i),
1082: l_goto,

Line 1089: ||icx_on_utilities.formatText(l_values(l_value_id(i)),ak_query_pkg.g_items_table(i).bold,ak_query_pkg.g_items_table(i).italic)

1085: '',
1086: l_rowspan);
1087: else
1088: htp.tableData(cvalue => ''
1089: ||icx_on_utilities.formatText(l_values(l_value_id(i)),ak_query_pkg.g_items_table(i).bold,ak_query_pkg.g_items_table(i).italic)
1090: ||'', calign => ak_query_pkg.g_items_table(i).horizontal_alignment, cattributes => 'VALIGN="'||ak_query_pkg.g_items_table(i).vertical_alignment||'"', crowspan => l_rowspan);
1091: end if;
1092: else
1093: printText( ak_query_pkg.g_items_table(i),

Line 1090: ||'', calign => ak_query_pkg.g_items_table(i).horizontal_alignment, cattributes => 'VALIGN="'||ak_query_pkg.g_items_table(i).vertical_alignment||'"', crowspan => l_rowspan);

1086: l_rowspan);
1087: else
1088: htp.tableData(cvalue => ''
1089: ||icx_on_utilities.formatText(l_values(l_value_id(i)),ak_query_pkg.g_items_table(i).bold,ak_query_pkg.g_items_table(i).italic)
1090: ||'', calign => ak_query_pkg.g_items_table(i).horizontal_alignment, cattributes => 'VALIGN="'||ak_query_pkg.g_items_table(i).vertical_alignment||'"', crowspan => l_rowspan);
1091: end if;
1092: else
1093: printText( ak_query_pkg.g_items_table(i),
1094: l_data_types(i),

Line 1093: printText( ak_query_pkg.g_items_table(i),

1089: ||icx_on_utilities.formatText(l_values(l_value_id(i)),ak_query_pkg.g_items_table(i).bold,ak_query_pkg.g_items_table(i).italic)
1090: ||'', calign => ak_query_pkg.g_items_table(i).horizontal_alignment, cattributes => 'VALIGN="'||ak_query_pkg.g_items_table(i).vertical_alignment||'"', crowspan => l_rowspan);
1091: end if;
1092: else
1093: printText( ak_query_pkg.g_items_table(i),
1094: l_data_types(i),
1095: l_value,
1096: l_rowids(i),
1097: l_goto,

Line 1111: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

1107: if l_rowspan = 2
1108: then
1109: htp.p('');
1110: for i in l_region_items_start..l_region_items_end loop
1111: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
1112: and ak_query_pkg.g_items_table(i).secured_column = 'F'
1113: then
1114: if l_item_styles(i) = 'SPINBOX'
1115: then

Line 1112: and ak_query_pkg.g_items_table(i).secured_column = 'F'

1108: then
1109: htp.p('');
1110: for i in l_region_items_start..l_region_items_end loop
1111: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
1112: and ak_query_pkg.g_items_table(i).secured_column = 'F'
1113: then
1114: if l_item_styles(i) = 'SPINBOX'
1115: then
1116: printSpinboxdown( ak_query_pkg.g_items_table(i).update_flag,

Line 1116: printSpinboxdown( ak_query_pkg.g_items_table(i).update_flag,

1112: and ak_query_pkg.g_items_table(i).secured_column = 'F'
1113: then
1114: if l_item_styles(i) = 'SPINBOX'
1115: then
1116: printSpinboxdown( ak_query_pkg.g_items_table(i).update_flag,
1117: l_data_types(i),
1118: to_char((l_row_count-1)*l_update_total+l_update_counts(i)-1),
1119: l_language_code);
1120: end if;

Line 1126: end loop; -- ak_query_pkg.g_results_table

1122: end loop; -- region_items
1123: htp.tableRowClose;
1124: end if; -- l_rowspan = 2
1125:
1126: end loop; -- ak_query_pkg.g_results_table
1127:
1128: if l_total_result_count > 5 and l_query_set2 > 5 then
1129: htp.tableRowOpen;
1130: htp.tableRowClose;

Line 1135: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

1131: htp.tableRowOpen;
1132: htp.tableRowClose;
1133: htp.p('');
1134: for i in l_region_items_start..l_region_items_end loop
1135: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
1136: and ak_query_pkg.g_items_table(i).secured_column = 'F'
1137: then
1138: if l_item_styles(i) = 'BUTTON'
1139: then

Line 1136: and ak_query_pkg.g_items_table(i).secured_column = 'F'

1132: htp.tableRowClose;
1133: htp.p('');
1134: for i in l_region_items_start..l_region_items_end loop
1135: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
1136: and ak_query_pkg.g_items_table(i).secured_column = 'F'
1137: then
1138: if l_item_styles(i) = 'BUTTON'
1139: then
1140: htp.tableData(cvalue => '
');

Line 1146: htp.tableData(cvalue => ''||ak_query_pkg.g_items_table(i).attribute_label_long||'', calign => 'CENTER', ccolspan => 2);

1142: then
1143: l_title := '';
1144: elsif l_item_styles(i) = 'SPINBOX' and l_data_types(i) = 'NUMBER'
1145: then
1146: htp.tableData(cvalue => ''||ak_query_pkg.g_items_table(i).attribute_label_long||'', calign => 'CENTER', ccolspan => 2);
1147: else
1148: htp.tableData(''||ak_query_pkg.g_items_table(i).attribute_label_long||'', calign => 'CENTER');
1149: end if;
1150: end if;

Line 1148: htp.tableData(''||ak_query_pkg.g_items_table(i).attribute_label_long||'', calign => 'CENTER');

1144: elsif l_item_styles(i) = 'SPINBOX' and l_data_types(i) = 'NUMBER'
1145: then
1146: htp.tableData(cvalue => ''||ak_query_pkg.g_items_table(i).attribute_label_long||'', calign => 'CENTER', ccolspan => 2);
1147: else
1148: htp.tableData(''||ak_query_pkg.g_items_table(i).attribute_label_long||'', calign => 'CENTER');
1149: end if;
1150: end if;
1151: end loop; -- region_items
1152: htp.tableRowClose;

Line 1184: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),l_values);

1180:
1181: if l_start_row <= l_row_count and l_row_count <= l_stop_row
1182: then
1183:
1184: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),l_values);
1185:
1186: l_goto := ak_query_pkg.g_regions_table(p_region_rec_id).primary_key_name
1187: ||'*'||ak_query_pkg.g_results_table(r).key1||'*'||ak_query_pkg.g_results_table(r).key2||'*'||ak_query_pkg.g_results_table(r).key3||'*'||ak_query_pkg.g_results_table(r).key4||'*'||ak_query_pkg.g_results_table(r).key5
1188: ||'*'||ak_query_pkg.g_results_table(r).key6||'*'||ak_query_pkg.g_results_table(r).key7||'*'||ak_query_pkg.g_results_table(r).key8||'*'||ak_query_pkg.g_results_table(r).key9||'*'||ak_query_pkg.g_results_table(r).key10||'**]';

Line 1186: l_goto := ak_query_pkg.g_regions_table(p_region_rec_id).primary_key_name

1182: then
1183:
1184: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),l_values);
1185:
1186: l_goto := ak_query_pkg.g_regions_table(p_region_rec_id).primary_key_name
1187: ||'*'||ak_query_pkg.g_results_table(r).key1||'*'||ak_query_pkg.g_results_table(r).key2||'*'||ak_query_pkg.g_results_table(r).key3||'*'||ak_query_pkg.g_results_table(r).key4||'*'||ak_query_pkg.g_results_table(r).key5
1188: ||'*'||ak_query_pkg.g_results_table(r).key6||'*'||ak_query_pkg.g_results_table(r).key7||'*'||ak_query_pkg.g_results_table(r).key8||'*'||ak_query_pkg.g_results_table(r).key9||'*'||ak_query_pkg.g_results_table(r).key10||'**]';
1189:
1190: for i in l_region_items_start..l_region_items_end loop

Line 1187: ||''||ak_query_pkg.g_results_table(r).key1||''||ak_query_pkg.g_results_table(r).key2||''||ak_query_pkg.g_results_table(r).key3||''||ak_query_pkg.g_results_table(r).key4||'*'||ak_query_pkg.g_results_table(r).key5

1183:
1184: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),l_values);
1185:
1186: l_goto := ak_query_pkg.g_regions_table(p_region_rec_id).primary_key_name
1187: ||'*'||ak_query_pkg.g_results_table(r).key1||'*'||ak_query_pkg.g_results_table(r).key2||'*'||ak_query_pkg.g_results_table(r).key3||'*'||ak_query_pkg.g_results_table(r).key4||'*'||ak_query_pkg.g_results_table(r).key5
1188: ||'*'||ak_query_pkg.g_results_table(r).key6||'*'||ak_query_pkg.g_results_table(r).key7||'*'||ak_query_pkg.g_results_table(r).key8||'*'||ak_query_pkg.g_results_table(r).key9||'*'||ak_query_pkg.g_results_table(r).key10||'**]';
1189:
1190: for i in l_region_items_start..l_region_items_end loop
1191:

Line 1188: ||''||ak_query_pkg.g_results_table(r).key6||''||ak_query_pkg.g_results_table(r).key7||''||ak_query_pkg.g_results_table(r).key8||''||ak_query_pkg.g_results_table(r).key9||'*'||ak_query_pkg.g_results_table(r).key10||'**]';

1184: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),l_values);
1185:
1186: l_goto := ak_query_pkg.g_regions_table(p_region_rec_id).primary_key_name
1187: ||'*'||ak_query_pkg.g_results_table(r).key1||'*'||ak_query_pkg.g_results_table(r).key2||'*'||ak_query_pkg.g_results_table(r).key3||'*'||ak_query_pkg.g_results_table(r).key4||'*'||ak_query_pkg.g_results_table(r).key5
1188: ||'*'||ak_query_pkg.g_results_table(r).key6||'*'||ak_query_pkg.g_results_table(r).key7||'*'||ak_query_pkg.g_results_table(r).key8||'*'||ak_query_pkg.g_results_table(r).key9||'*'||ak_query_pkg.g_results_table(r).key10||'**]';
1189:
1190: for i in l_region_items_start..l_region_items_end loop
1191:
1192: if l_counter = 1

Line 1193: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

1189:
1190: for i in l_region_items_start..l_region_items_end loop
1191:
1192: if l_counter = 1
1193: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
1194: and ak_query_pkg.g_items_table(i).secured_column = 'F'
1195: then
1196: htp.tableRowOpen;
1197: end if;

Line 1194: and ak_query_pkg.g_items_table(i).secured_column = 'F'

1190: for i in l_region_items_start..l_region_items_end loop
1191:
1192: if l_counter = 1
1193: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
1194: and ak_query_pkg.g_items_table(i).secured_column = 'F'
1195: then
1196: htp.tableRowOpen;
1197: end if;
1198:

Line 1201: l_value := ak_query_pkg.g_items_table(i).attribute_label_long;

1197: end if;
1198:
1199: if l_value_id(i) is null
1200: then
1201: l_value := ak_query_pkg.g_items_table(i).attribute_label_long;
1202: else
1203: l_value := l_values(l_value_id(i));
1204: end if;
1205:

Line 1206: if ak_query_pkg.g_items_table(i).node_display_flag = 'N'

1202: else
1203: l_value := l_values(l_value_id(i));
1204: end if;
1205:
1206: if ak_query_pkg.g_items_table(i).node_display_flag = 'N'
1207: or ak_query_pkg.g_items_table(i).secured_column = 'T'
1208: or (ak_query_pkg.g_items_table(i).attribute_label_long is null and l_value is null)
1209: then
1210: l_counter := l_counter;

Line 1207: or ak_query_pkg.g_items_table(i).secured_column = 'T'

1203: l_value := l_values(l_value_id(i));
1204: end if;
1205:
1206: if ak_query_pkg.g_items_table(i).node_display_flag = 'N'
1207: or ak_query_pkg.g_items_table(i).secured_column = 'T'
1208: or (ak_query_pkg.g_items_table(i).attribute_label_long is null and l_value is null)
1209: then
1210: l_counter := l_counter;
1211: else

Line 1208: or (ak_query_pkg.g_items_table(i).attribute_label_long is null and l_value is null)

1204: end if;
1205:
1206: if ak_query_pkg.g_items_table(i).node_display_flag = 'N'
1207: or ak_query_pkg.g_items_table(i).secured_column = 'T'
1208: or (ak_query_pkg.g_items_table(i).attribute_label_long is null and l_value is null)
1209: then
1210: l_counter := l_counter;
1211: else
1212: if l_item_styles(i) = 'TEXT'

Line 1215: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN='||ak_query_pkg.g_items_table(i).vertical_alignment);

1211: else
1212: if l_item_styles(i) = 'TEXT'
1213: then
1214:
1215: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN='||ak_query_pkg.g_items_table(i).vertical_alignment);
1216: htp.tableData(' ');
1217:
1218: printText( ak_query_pkg.g_items_table(i),
1219: l_data_types(i),

Line 1218: printText( ak_query_pkg.g_items_table(i),

1214:
1215: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN='||ak_query_pkg.g_items_table(i).vertical_alignment);
1216: htp.tableData(' ');
1217:
1218: printText( ak_query_pkg.g_items_table(i),
1219: l_data_types(i),
1220: l_value,
1221: l_rowids(i),
1222: l_goto,

Line 1231: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');

1227:
1228: elsif l_item_styles(i) = 'SPINBOX'
1229: then
1230:
1231: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');
1232: htp.tableData(' ');
1233:
1234: printSpinboxup( ak_query_pkg.g_items_table(i).update_flag,
1235: ak_query_pkg.g_items_table(i).required_flag,

Line 1234: printSpinboxup( ak_query_pkg.g_items_table(i).update_flag,

1230:
1231: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');
1232: htp.tableData(' ');
1233:
1234: printSpinboxup( ak_query_pkg.g_items_table(i).update_flag,
1235: ak_query_pkg.g_items_table(i).required_flag,
1236: ak_query_pkg.g_items_table(i).attribute_label_long,
1237: l_data_types(i),
1238: l_value,

Line 1235: ak_query_pkg.g_items_table(i).required_flag,

1231: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');
1232: htp.tableData(' ');
1233:
1234: printSpinboxup( ak_query_pkg.g_items_table(i).update_flag,
1235: ak_query_pkg.g_items_table(i).required_flag,
1236: ak_query_pkg.g_items_table(i).attribute_label_long,
1237: l_data_types(i),
1238: l_value,
1239: ak_query_pkg.g_items_table(i).display_value_length,

Line 1236: ak_query_pkg.g_items_table(i).attribute_label_long,

1232: htp.tableData(' ');
1233:
1234: printSpinboxup( ak_query_pkg.g_items_table(i).update_flag,
1235: ak_query_pkg.g_items_table(i).required_flag,
1236: ak_query_pkg.g_items_table(i).attribute_label_long,
1237: l_data_types(i),
1238: l_value,
1239: ak_query_pkg.g_items_table(i).display_value_length,
1240: 'Y',

Line 1239: ak_query_pkg.g_items_table(i).display_value_length,

1235: ak_query_pkg.g_items_table(i).required_flag,
1236: ak_query_pkg.g_items_table(i).attribute_label_long,
1237: l_data_types(i),
1238: l_value,
1239: ak_query_pkg.g_items_table(i).display_value_length,
1240: 'Y',
1241: ak_query_pkg.g_items_table(i).italic,
1242: ak_query_pkg.g_items_table(i).horizontal_alignment,
1243: ak_query_pkg.g_items_table(i).vertical_alignment,

Line 1241: ak_query_pkg.g_items_table(i).italic,

1237: l_data_types(i),
1238: l_value,
1239: ak_query_pkg.g_items_table(i).display_value_length,
1240: 'Y',
1241: ak_query_pkg.g_items_table(i).italic,
1242: ak_query_pkg.g_items_table(i).horizontal_alignment,
1243: ak_query_pkg.g_items_table(i).vertical_alignment,
1244: to_char((l_row_count-1)*l_update_total+l_update_counts(i)-1),
1245: l_language_code,

Line 1242: ak_query_pkg.g_items_table(i).horizontal_alignment,

1238: l_value,
1239: ak_query_pkg.g_items_table(i).display_value_length,
1240: 'Y',
1241: ak_query_pkg.g_items_table(i).italic,
1242: ak_query_pkg.g_items_table(i).horizontal_alignment,
1243: ak_query_pkg.g_items_table(i).vertical_alignment,
1244: to_char((l_row_count-1)*l_update_total+l_update_counts(i)-1),
1245: l_language_code,
1246: l_rowspan);

Line 1243: ak_query_pkg.g_items_table(i).vertical_alignment,

1239: ak_query_pkg.g_items_table(i).display_value_length,
1240: 'Y',
1241: ak_query_pkg.g_items_table(i).italic,
1242: ak_query_pkg.g_items_table(i).horizontal_alignment,
1243: ak_query_pkg.g_items_table(i).vertical_alignment,
1244: to_char((l_row_count-1)*l_update_total+l_update_counts(i)-1),
1245: l_language_code,
1246: l_rowspan);
1247:

Line 1251: printButton( ak_query_pkg.g_items_table(i),

1247:
1248: elsif l_item_styles(i) = 'BUTTON'
1249: then
1250:
1251: printButton( ak_query_pkg.g_items_table(i),
1252: l_rowids(i),
1253: l_goto,
1254: l_session_id,
1255: l_rowspan,

Line 1268: printCheckbox( ak_query_pkg.g_items_table(i).update_flag,

1264:
1265: htp.tableData(' ');
1266: htp.tableData(' ');
1267:
1268: printCheckbox( ak_query_pkg.g_items_table(i).update_flag,
1269: ak_query_pkg.g_items_table(i).value_id,
1270: l_value,
1271: ak_query_pkg.g_items_table(i).horizontal_alignment,
1272: ak_query_pkg.g_items_table(i).vertical_alignment,

Line 1269: ak_query_pkg.g_items_table(i).value_id,

1265: htp.tableData(' ');
1266: htp.tableData(' ');
1267:
1268: printCheckbox( ak_query_pkg.g_items_table(i).update_flag,
1269: ak_query_pkg.g_items_table(i).value_id,
1270: l_value,
1271: ak_query_pkg.g_items_table(i).horizontal_alignment,
1272: ak_query_pkg.g_items_table(i).vertical_alignment,
1273: l_language_code,

Line 1271: ak_query_pkg.g_items_table(i).horizontal_alignment,

1267:
1268: printCheckbox( ak_query_pkg.g_items_table(i).update_flag,
1269: ak_query_pkg.g_items_table(i).value_id,
1270: l_value,
1271: ak_query_pkg.g_items_table(i).horizontal_alignment,
1272: ak_query_pkg.g_items_table(i).vertical_alignment,
1273: l_language_code,
1274: l_rowspan,
1275: ak_query_pkg.g_items_table(i).attribute_label_long);

Line 1272: ak_query_pkg.g_items_table(i).vertical_alignment,

1268: printCheckbox( ak_query_pkg.g_items_table(i).update_flag,
1269: ak_query_pkg.g_items_table(i).value_id,
1270: l_value,
1271: ak_query_pkg.g_items_table(i).horizontal_alignment,
1272: ak_query_pkg.g_items_table(i).vertical_alignment,
1273: l_language_code,
1274: l_rowspan,
1275: ak_query_pkg.g_items_table(i).attribute_label_long);
1276:

Line 1275: ak_query_pkg.g_items_table(i).attribute_label_long);

1271: ak_query_pkg.g_items_table(i).horizontal_alignment,
1272: ak_query_pkg.g_items_table(i).vertical_alignment,
1273: l_language_code,
1274: l_rowspan,
1275: ak_query_pkg.g_items_table(i).attribute_label_long);
1276:
1277: elsif l_item_styles(i) = 'POPLIST'
1278: then
1279:

Line 1280: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');

1276:
1277: elsif l_item_styles(i) = 'POPLIST'
1278: then
1279:
1280: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');
1281: htp.tableData(' ');
1282:
1283: printPoplist( ak_query_pkg.g_items_table(i).lov_region_application_id,
1284: ak_query_pkg.g_items_table(i).lov_region_code,

Line 1283: printPoplist( ak_query_pkg.g_items_table(i).lov_region_application_id,

1279:
1280: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');
1281: htp.tableData(' ');
1282:
1283: printPoplist( ak_query_pkg.g_items_table(i).lov_region_application_id,
1284: ak_query_pkg.g_items_table(i).lov_region_code,
1285: ak_query_pkg.g_items_table(i).update_flag,
1286: ak_query_pkg.g_items_table(i).value_id,
1287: l_value,

Line 1284: ak_query_pkg.g_items_table(i).lov_region_code,

1280: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');
1281: htp.tableData(' ');
1282:
1283: printPoplist( ak_query_pkg.g_items_table(i).lov_region_application_id,
1284: ak_query_pkg.g_items_table(i).lov_region_code,
1285: ak_query_pkg.g_items_table(i).update_flag,
1286: ak_query_pkg.g_items_table(i).value_id,
1287: l_value,
1288: ak_query_pkg.g_items_table(i).bold,

Line 1285: ak_query_pkg.g_items_table(i).update_flag,

1281: htp.tableData(' ');
1282:
1283: printPoplist( ak_query_pkg.g_items_table(i).lov_region_application_id,
1284: ak_query_pkg.g_items_table(i).lov_region_code,
1285: ak_query_pkg.g_items_table(i).update_flag,
1286: ak_query_pkg.g_items_table(i).value_id,
1287: l_value,
1288: ak_query_pkg.g_items_table(i).bold,
1289: ak_query_pkg.g_items_table(i).italic,

Line 1286: ak_query_pkg.g_items_table(i).value_id,

1282:
1283: printPoplist( ak_query_pkg.g_items_table(i).lov_region_application_id,
1284: ak_query_pkg.g_items_table(i).lov_region_code,
1285: ak_query_pkg.g_items_table(i).update_flag,
1286: ak_query_pkg.g_items_table(i).value_id,
1287: l_value,
1288: ak_query_pkg.g_items_table(i).bold,
1289: ak_query_pkg.g_items_table(i).italic,
1290: ak_query_pkg.g_items_table(i).horizontal_alignment,

Line 1288: ak_query_pkg.g_items_table(i).bold,

1284: ak_query_pkg.g_items_table(i).lov_region_code,
1285: ak_query_pkg.g_items_table(i).update_flag,
1286: ak_query_pkg.g_items_table(i).value_id,
1287: l_value,
1288: ak_query_pkg.g_items_table(i).bold,
1289: ak_query_pkg.g_items_table(i).italic,
1290: ak_query_pkg.g_items_table(i).horizontal_alignment,
1291: ak_query_pkg.g_items_table(i).vertical_alignment,
1292: l_rowspan);

Line 1289: ak_query_pkg.g_items_table(i).italic,

1285: ak_query_pkg.g_items_table(i).update_flag,
1286: ak_query_pkg.g_items_table(i).value_id,
1287: l_value,
1288: ak_query_pkg.g_items_table(i).bold,
1289: ak_query_pkg.g_items_table(i).italic,
1290: ak_query_pkg.g_items_table(i).horizontal_alignment,
1291: ak_query_pkg.g_items_table(i).vertical_alignment,
1292: l_rowspan);
1293: elsif l_item_styles(i) = 'DEFAULT_PKG'

Line 1290: ak_query_pkg.g_items_table(i).horizontal_alignment,

1286: ak_query_pkg.g_items_table(i).value_id,
1287: l_value,
1288: ak_query_pkg.g_items_table(i).bold,
1289: ak_query_pkg.g_items_table(i).italic,
1290: ak_query_pkg.g_items_table(i).horizontal_alignment,
1291: ak_query_pkg.g_items_table(i).vertical_alignment,
1292: l_rowspan);
1293: elsif l_item_styles(i) = 'DEFAULT_PKG'
1294: then

Line 1291: ak_query_pkg.g_items_table(i).vertical_alignment,

1287: l_value,
1288: ak_query_pkg.g_items_table(i).bold,
1289: ak_query_pkg.g_items_table(i).italic,
1290: ak_query_pkg.g_items_table(i).horizontal_alignment,
1291: ak_query_pkg.g_items_table(i).vertical_alignment,
1292: l_rowspan);
1293: elsif l_item_styles(i) = 'DEFAULT_PKG'
1294: then
1295: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');

Line 1295: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');

1291: ak_query_pkg.g_items_table(i).vertical_alignment,
1292: l_rowspan);
1293: elsif l_item_styles(i) = 'DEFAULT_PKG'
1294: then
1295: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');
1296: htp.tableData(' ');
1297: htp.p('');
1298: l_procedure_call := ak_query_pkg.g_items_table(i).region_defaulting_api_pkg||'.'||ak_query_pkg.g_items_table(i).region_defaulting_api_proc||'(:l_attribute_codes,:p_result_values)';
1299: p_result_values := '';

Line 1297: htp.p('');

1293: elsif l_item_styles(i) = 'DEFAULT_PKG'
1294: then
1295: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');
1296: htp.tableData(' ');
1297: htp.p('');
1298: l_procedure_call := ak_query_pkg.g_items_table(i).region_defaulting_api_pkg||'.'||ak_query_pkg.g_items_table(i).region_defaulting_api_proc||'(:l_attribute_codes,:p_result_values)';
1299: p_result_values := '';
1300:
1301: for i in l_region_items_start..l_region_items_end loop

Line 1298: l_procedure_call := ak_query_pkg.g_items_table(i).region_defaulting_api_pkg||'.'||ak_query_pkg.g_items_table(i).region_defaulting_api_proc||'(:l_attribute_codes,:p_result_values)';

1294: then
1295: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');
1296: htp.tableData(' ');
1297: htp.p('');
1298: l_procedure_call := ak_query_pkg.g_items_table(i).region_defaulting_api_pkg||'.'||ak_query_pkg.g_items_table(i).region_defaulting_api_proc||'(:l_attribute_codes,:p_result_values)';
1299: p_result_values := '';
1300:
1301: for i in l_region_items_start..l_region_items_end loop
1302: if ak_query_pkg.g_items_table(i).value_id is null

Line 1302: if ak_query_pkg.g_items_table(i).value_id is null

1298: l_procedure_call := ak_query_pkg.g_items_table(i).region_defaulting_api_pkg||'.'||ak_query_pkg.g_items_table(i).region_defaulting_api_proc||'(:l_attribute_codes,:p_result_values)';
1299: p_result_values := '';
1300:
1301: for i in l_region_items_start..l_region_items_end loop
1302: if ak_query_pkg.g_items_table(i).value_id is null
1303: then
1304: p_result_values := p_result_values||'*';
1305: else
1306: l_value := replace(l_values(l_value_id(i)),'*','~at~');

Line 1323: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');

1319: elsif l_item_styles(i) = 'URL'
1320: then
1321: if l_values(l_value_id(l_url_display_sequence(i))) is null
1322: then
1323: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');
1324: htp.tableData(' ');
1325: printText( ak_query_pkg.g_items_table(i),
1326: l_data_types(i),
1327: l_value,

Line 1325: printText( ak_query_pkg.g_items_table(i),

1321: if l_values(l_value_id(l_url_display_sequence(i))) is null
1322: then
1323: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');
1324: htp.tableData(' ');
1325: printText( ak_query_pkg.g_items_table(i),
1326: l_data_types(i),
1327: l_value,
1328: l_rowids(i),
1329: l_goto,

Line 1335: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');

1331: l_region_style,
1332: l_data_singlerow_color,
1333: l_rowspan);
1334: else
1335: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');
1336: htp.tableData(' ');
1337: htp.tableData(cvalue => ''
1338: ||icx_on_utilities.formatText(l_values(l_value_id(i)),'Y',ak_query_pkg.g_items_table(i).italic)
1339: ||'', calign => ak_query_pkg.g_items_table(i).horizontal_alignment, cattributes => 'VALIGN="'||ak_query_pkg.g_items_table(i).vertical_alignment||'"', crowspan => l_rowspan);

Line 1338: ||icx_on_utilities.formatText(l_values(l_value_id(i)),'Y',ak_query_pkg.g_items_table(i).italic)

1334: else
1335: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');
1336: htp.tableData(' ');
1337: htp.tableData(cvalue => ''
1338: ||icx_on_utilities.formatText(l_values(l_value_id(i)),'Y',ak_query_pkg.g_items_table(i).italic)
1339: ||'', calign => ak_query_pkg.g_items_table(i).horizontal_alignment, cattributes => 'VALIGN="'||ak_query_pkg.g_items_table(i).vertical_alignment||'"', crowspan => l_rowspan);
1340: end if;
1341: else
1342: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');

Line 1339: ||'', calign => ak_query_pkg.g_items_table(i).horizontal_alignment, cattributes => 'VALIGN="'||ak_query_pkg.g_items_table(i).vertical_alignment||'"', crowspan => l_rowspan);

1335: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');
1336: htp.tableData(' ');
1337: htp.tableData(cvalue => ''
1338: ||icx_on_utilities.formatText(l_values(l_value_id(i)),'Y',ak_query_pkg.g_items_table(i).italic)
1339: ||'', calign => ak_query_pkg.g_items_table(i).horizontal_alignment, cattributes => 'VALIGN="'||ak_query_pkg.g_items_table(i).vertical_alignment||'"', crowspan => l_rowspan);
1340: end if;
1341: else
1342: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');
1343: htp.tableData(' ');

Line 1342: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');

1338: ||icx_on_utilities.formatText(l_values(l_value_id(i)),'Y',ak_query_pkg.g_items_table(i).italic)
1339: ||'', calign => ak_query_pkg.g_items_table(i).horizontal_alignment, cattributes => 'VALIGN="'||ak_query_pkg.g_items_table(i).vertical_alignment||'"', crowspan => l_rowspan);
1340: end if;
1341: else
1342: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');
1343: htp.tableData(' ');
1344: printText( ak_query_pkg.g_items_table(i),
1345: l_data_types(i),
1346: l_value,

Line 1344: printText( ak_query_pkg.g_items_table(i),

1340: end if;
1341: else
1342: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');
1343: htp.tableData(' ');
1344: printText( ak_query_pkg.g_items_table(i),
1345: l_data_types(i),
1346: l_value,
1347: l_rowids(i),
1348: l_goto,

Line 1357: if ak_query_pkg.g_items_table(i).node_display_flag = 'N'

1353:
1354: end if; -- item_styles
1355: end if; -- node_display_flag
1356:
1357: if ak_query_pkg.g_items_table(i).node_display_flag = 'N'
1358: or ak_query_pkg.g_items_table(i).secured_column = 'T'
1359: then
1360: l_counter := l_counter;
1361: elsif l_counter = l_num_columns

Line 1358: or ak_query_pkg.g_items_table(i).secured_column = 'T'

1354: end if; -- item_styles
1355: end if; -- node_display_flag
1356:
1357: if ak_query_pkg.g_items_table(i).node_display_flag = 'N'
1358: or ak_query_pkg.g_items_table(i).secured_column = 'T'
1359: then
1360: l_counter := l_counter;
1361: elsif l_counter = l_num_columns
1362: then

Line 1368: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

1364: if l_rowspan = 2
1365: then
1366: htp.tableRowOpen;
1367: for i in l_region_items_start..l_region_items_end loop
1368: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
1369: and ak_query_pkg.g_items_table(i).secured_column = 'F'
1370: then
1371: if l_item_styles(i) = 'SPINBOX'
1372: then

Line 1369: and ak_query_pkg.g_items_table(i).secured_column = 'F'

1365: then
1366: htp.tableRowOpen;
1367: for i in l_region_items_start..l_region_items_end loop
1368: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
1369: and ak_query_pkg.g_items_table(i).secured_column = 'F'
1370: then
1371: if l_item_styles(i) = 'SPINBOX'
1372: then
1373: printSpinboxdown( ak_query_pkg.g_items_table(i).update_flag,

Line 1373: printSpinboxdown( ak_query_pkg.g_items_table(i).update_flag,

1369: and ak_query_pkg.g_items_table(i).secured_column = 'F'
1370: then
1371: if l_item_styles(i) = 'SPINBOX'
1372: then
1373: printSpinboxdown( ak_query_pkg.g_items_table(i).update_flag,
1374: l_data_types(i),
1375: to_char((l_row_count-1)*l_update_total+l_update_counts(i)-1),
1376: l_language_code);
1377: end if;

Line 1443: htp.p('Total Regions = '||to_char(ak_query_pkg.g_regions_table.COUNT));htp.nl;

1439:
1440: htp.p('===============================================================');htp.nl;
1441: htp.p('REGIONS');htp.nl;
1442: htp.p('===============================================================');htp.nl;
1443: htp.p('Total Regions = '||to_char(ak_query_pkg.g_regions_table.COUNT));htp.nl;
1444: FOR i IN ak_query_pkg.g_regions_table.FIRST..ak_query_pkg.g_regions_table.LAST LOOP
1445: htp.p('Regions Table Row ='||to_char(i));htp.nl;
1446: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_regions_table(i).region_rec_id));htp.nl;
1447: htp.p('- parent_region_rec_id = '||to_char(ak_query_pkg.g_regions_table(i).parent_region_rec_id));htp.nl;

Line 1444: FOR i IN ak_query_pkg.g_regions_table.FIRST..ak_query_pkg.g_regions_table.LAST LOOP

1440: htp.p('===============================================================');htp.nl;
1441: htp.p('REGIONS');htp.nl;
1442: htp.p('===============================================================');htp.nl;
1443: htp.p('Total Regions = '||to_char(ak_query_pkg.g_regions_table.COUNT));htp.nl;
1444: FOR i IN ak_query_pkg.g_regions_table.FIRST..ak_query_pkg.g_regions_table.LAST LOOP
1445: htp.p('Regions Table Row ='||to_char(i));htp.nl;
1446: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_regions_table(i).region_rec_id));htp.nl;
1447: htp.p('- parent_region_rec_id = '||to_char(ak_query_pkg.g_regions_table(i).parent_region_rec_id));htp.nl;
1448: htp.p('- total_result_count = '||to_char(ak_query_pkg.g_regions_table(i).total_result_count));htp.nl;

Line 1446: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_regions_table(i).region_rec_id));htp.nl;

1442: htp.p('===============================================================');htp.nl;
1443: htp.p('Total Regions = '||to_char(ak_query_pkg.g_regions_table.COUNT));htp.nl;
1444: FOR i IN ak_query_pkg.g_regions_table.FIRST..ak_query_pkg.g_regions_table.LAST LOOP
1445: htp.p('Regions Table Row ='||to_char(i));htp.nl;
1446: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_regions_table(i).region_rec_id));htp.nl;
1447: htp.p('- parent_region_rec_id = '||to_char(ak_query_pkg.g_regions_table(i).parent_region_rec_id));htp.nl;
1448: htp.p('- total_result_count = '||to_char(ak_query_pkg.g_regions_table(i).total_result_count));htp.nl;
1449: htp.p('- flow_application_id = '||to_char(ak_query_pkg.g_regions_table(i).flow_application_id));htp.nl;
1450: htp.p('- flow_code = '||ak_query_pkg.g_regions_table(i).flow_code);htp.nl;

Line 1447: htp.p('- parent_region_rec_id = '||to_char(ak_query_pkg.g_regions_table(i).parent_region_rec_id));htp.nl;

1443: htp.p('Total Regions = '||to_char(ak_query_pkg.g_regions_table.COUNT));htp.nl;
1444: FOR i IN ak_query_pkg.g_regions_table.FIRST..ak_query_pkg.g_regions_table.LAST LOOP
1445: htp.p('Regions Table Row ='||to_char(i));htp.nl;
1446: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_regions_table(i).region_rec_id));htp.nl;
1447: htp.p('- parent_region_rec_id = '||to_char(ak_query_pkg.g_regions_table(i).parent_region_rec_id));htp.nl;
1448: htp.p('- total_result_count = '||to_char(ak_query_pkg.g_regions_table(i).total_result_count));htp.nl;
1449: htp.p('- flow_application_id = '||to_char(ak_query_pkg.g_regions_table(i).flow_application_id));htp.nl;
1450: htp.p('- flow_code = '||ak_query_pkg.g_regions_table(i).flow_code);htp.nl;
1451: htp.p('- page_application_id = '||to_char(ak_query_pkg.g_regions_table(i).page_application_id));htp.nl;

Line 1448: htp.p('- total_result_count = '||to_char(ak_query_pkg.g_regions_table(i).total_result_count));htp.nl;

1444: FOR i IN ak_query_pkg.g_regions_table.FIRST..ak_query_pkg.g_regions_table.LAST LOOP
1445: htp.p('Regions Table Row ='||to_char(i));htp.nl;
1446: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_regions_table(i).region_rec_id));htp.nl;
1447: htp.p('- parent_region_rec_id = '||to_char(ak_query_pkg.g_regions_table(i).parent_region_rec_id));htp.nl;
1448: htp.p('- total_result_count = '||to_char(ak_query_pkg.g_regions_table(i).total_result_count));htp.nl;
1449: htp.p('- flow_application_id = '||to_char(ak_query_pkg.g_regions_table(i).flow_application_id));htp.nl;
1450: htp.p('- flow_code = '||ak_query_pkg.g_regions_table(i).flow_code);htp.nl;
1451: htp.p('- page_application_id = '||to_char(ak_query_pkg.g_regions_table(i).page_application_id));htp.nl;
1452: htp.p('- page_code = '||ak_query_pkg.g_regions_table(i).page_code);htp.nl;

Line 1449: htp.p('- flow_application_id = '||to_char(ak_query_pkg.g_regions_table(i).flow_application_id));htp.nl;

1445: htp.p('Regions Table Row ='||to_char(i));htp.nl;
1446: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_regions_table(i).region_rec_id));htp.nl;
1447: htp.p('- parent_region_rec_id = '||to_char(ak_query_pkg.g_regions_table(i).parent_region_rec_id));htp.nl;
1448: htp.p('- total_result_count = '||to_char(ak_query_pkg.g_regions_table(i).total_result_count));htp.nl;
1449: htp.p('- flow_application_id = '||to_char(ak_query_pkg.g_regions_table(i).flow_application_id));htp.nl;
1450: htp.p('- flow_code = '||ak_query_pkg.g_regions_table(i).flow_code);htp.nl;
1451: htp.p('- page_application_id = '||to_char(ak_query_pkg.g_regions_table(i).page_application_id));htp.nl;
1452: htp.p('- page_code = '||ak_query_pkg.g_regions_table(i).page_code);htp.nl;
1453: htp.p('- region_application_id = '||to_char(ak_query_pkg.g_regions_table(i).region_application_id));htp.nl;

Line 1450: htp.p('- flow_code = '||ak_query_pkg.g_regions_table(i).flow_code);htp.nl;

1446: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_regions_table(i).region_rec_id));htp.nl;
1447: htp.p('- parent_region_rec_id = '||to_char(ak_query_pkg.g_regions_table(i).parent_region_rec_id));htp.nl;
1448: htp.p('- total_result_count = '||to_char(ak_query_pkg.g_regions_table(i).total_result_count));htp.nl;
1449: htp.p('- flow_application_id = '||to_char(ak_query_pkg.g_regions_table(i).flow_application_id));htp.nl;
1450: htp.p('- flow_code = '||ak_query_pkg.g_regions_table(i).flow_code);htp.nl;
1451: htp.p('- page_application_id = '||to_char(ak_query_pkg.g_regions_table(i).page_application_id));htp.nl;
1452: htp.p('- page_code = '||ak_query_pkg.g_regions_table(i).page_code);htp.nl;
1453: htp.p('- region_application_id = '||to_char(ak_query_pkg.g_regions_table(i).region_application_id));htp.nl;
1454: htp.p('- region_code = '||ak_query_pkg.g_regions_table(i).region_code);htp.nl;

Line 1451: htp.p('- page_application_id = '||to_char(ak_query_pkg.g_regions_table(i).page_application_id));htp.nl;

1447: htp.p('- parent_region_rec_id = '||to_char(ak_query_pkg.g_regions_table(i).parent_region_rec_id));htp.nl;
1448: htp.p('- total_result_count = '||to_char(ak_query_pkg.g_regions_table(i).total_result_count));htp.nl;
1449: htp.p('- flow_application_id = '||to_char(ak_query_pkg.g_regions_table(i).flow_application_id));htp.nl;
1450: htp.p('- flow_code = '||ak_query_pkg.g_regions_table(i).flow_code);htp.nl;
1451: htp.p('- page_application_id = '||to_char(ak_query_pkg.g_regions_table(i).page_application_id));htp.nl;
1452: htp.p('- page_code = '||ak_query_pkg.g_regions_table(i).page_code);htp.nl;
1453: htp.p('- region_application_id = '||to_char(ak_query_pkg.g_regions_table(i).region_application_id));htp.nl;
1454: htp.p('- region_code = '||ak_query_pkg.g_regions_table(i).region_code);htp.nl;
1455: htp.p('- primary_key_name = '||ak_query_pkg.g_regions_table(i).primary_key_name);htp.nl;

Line 1452: htp.p('- page_code = '||ak_query_pkg.g_regions_table(i).page_code);htp.nl;

1448: htp.p('- total_result_count = '||to_char(ak_query_pkg.g_regions_table(i).total_result_count));htp.nl;
1449: htp.p('- flow_application_id = '||to_char(ak_query_pkg.g_regions_table(i).flow_application_id));htp.nl;
1450: htp.p('- flow_code = '||ak_query_pkg.g_regions_table(i).flow_code);htp.nl;
1451: htp.p('- page_application_id = '||to_char(ak_query_pkg.g_regions_table(i).page_application_id));htp.nl;
1452: htp.p('- page_code = '||ak_query_pkg.g_regions_table(i).page_code);htp.nl;
1453: htp.p('- region_application_id = '||to_char(ak_query_pkg.g_regions_table(i).region_application_id));htp.nl;
1454: htp.p('- region_code = '||ak_query_pkg.g_regions_table(i).region_code);htp.nl;
1455: htp.p('- primary_key_name = '||ak_query_pkg.g_regions_table(i).primary_key_name);htp.nl;
1456: htp.p('- name = '||ak_query_pkg.g_regions_table(i).name);htp.nl;

Line 1453: htp.p('- region_application_id = '||to_char(ak_query_pkg.g_regions_table(i).region_application_id));htp.nl;

1449: htp.p('- flow_application_id = '||to_char(ak_query_pkg.g_regions_table(i).flow_application_id));htp.nl;
1450: htp.p('- flow_code = '||ak_query_pkg.g_regions_table(i).flow_code);htp.nl;
1451: htp.p('- page_application_id = '||to_char(ak_query_pkg.g_regions_table(i).page_application_id));htp.nl;
1452: htp.p('- page_code = '||ak_query_pkg.g_regions_table(i).page_code);htp.nl;
1453: htp.p('- region_application_id = '||to_char(ak_query_pkg.g_regions_table(i).region_application_id));htp.nl;
1454: htp.p('- region_code = '||ak_query_pkg.g_regions_table(i).region_code);htp.nl;
1455: htp.p('- primary_key_name = '||ak_query_pkg.g_regions_table(i).primary_key_name);htp.nl;
1456: htp.p('- name = '||ak_query_pkg.g_regions_table(i).name);htp.nl;
1457: htp.p('- region_style = '||ak_query_pkg.g_regions_table(i).region_style);htp.nl;

Line 1454: htp.p('- region_code = '||ak_query_pkg.g_regions_table(i).region_code);htp.nl;

1450: htp.p('- flow_code = '||ak_query_pkg.g_regions_table(i).flow_code);htp.nl;
1451: htp.p('- page_application_id = '||to_char(ak_query_pkg.g_regions_table(i).page_application_id));htp.nl;
1452: htp.p('- page_code = '||ak_query_pkg.g_regions_table(i).page_code);htp.nl;
1453: htp.p('- region_application_id = '||to_char(ak_query_pkg.g_regions_table(i).region_application_id));htp.nl;
1454: htp.p('- region_code = '||ak_query_pkg.g_regions_table(i).region_code);htp.nl;
1455: htp.p('- primary_key_name = '||ak_query_pkg.g_regions_table(i).primary_key_name);htp.nl;
1456: htp.p('- name = '||ak_query_pkg.g_regions_table(i).name);htp.nl;
1457: htp.p('- region_style = '||ak_query_pkg.g_regions_table(i).region_style);htp.nl;
1458: htp.p('- number_of_format_columns = '||to_char(ak_query_pkg.g_regions_table(i).number_of_format_columns));htp.nl;

Line 1455: htp.p('- primary_key_name = '||ak_query_pkg.g_regions_table(i).primary_key_name);htp.nl;

1451: htp.p('- page_application_id = '||to_char(ak_query_pkg.g_regions_table(i).page_application_id));htp.nl;
1452: htp.p('- page_code = '||ak_query_pkg.g_regions_table(i).page_code);htp.nl;
1453: htp.p('- region_application_id = '||to_char(ak_query_pkg.g_regions_table(i).region_application_id));htp.nl;
1454: htp.p('- region_code = '||ak_query_pkg.g_regions_table(i).region_code);htp.nl;
1455: htp.p('- primary_key_name = '||ak_query_pkg.g_regions_table(i).primary_key_name);htp.nl;
1456: htp.p('- name = '||ak_query_pkg.g_regions_table(i).name);htp.nl;
1457: htp.p('- region_style = '||ak_query_pkg.g_regions_table(i).region_style);htp.nl;
1458: htp.p('- number_of_format_columns = '||to_char(ak_query_pkg.g_regions_table(i).number_of_format_columns));htp.nl;
1459: htp.p('- region_defaulting_api_pkg = '||ak_query_pkg.g_regions_table(i).region_defaulting_api_pkg);htp.nl;

Line 1456: htp.p('- name = '||ak_query_pkg.g_regions_table(i).name);htp.nl;

1452: htp.p('- page_code = '||ak_query_pkg.g_regions_table(i).page_code);htp.nl;
1453: htp.p('- region_application_id = '||to_char(ak_query_pkg.g_regions_table(i).region_application_id));htp.nl;
1454: htp.p('- region_code = '||ak_query_pkg.g_regions_table(i).region_code);htp.nl;
1455: htp.p('- primary_key_name = '||ak_query_pkg.g_regions_table(i).primary_key_name);htp.nl;
1456: htp.p('- name = '||ak_query_pkg.g_regions_table(i).name);htp.nl;
1457: htp.p('- region_style = '||ak_query_pkg.g_regions_table(i).region_style);htp.nl;
1458: htp.p('- number_of_format_columns = '||to_char(ak_query_pkg.g_regions_table(i).number_of_format_columns));htp.nl;
1459: htp.p('- region_defaulting_api_pkg = '||ak_query_pkg.g_regions_table(i).region_defaulting_api_pkg);htp.nl;
1460: htp.p('- region_defaulting_api_proc= '||ak_query_pkg.g_regions_table(i).region_defaulting_api_proc);htp.nl;

Line 1457: htp.p('- region_style = '||ak_query_pkg.g_regions_table(i).region_style);htp.nl;

1453: htp.p('- region_application_id = '||to_char(ak_query_pkg.g_regions_table(i).region_application_id));htp.nl;
1454: htp.p('- region_code = '||ak_query_pkg.g_regions_table(i).region_code);htp.nl;
1455: htp.p('- primary_key_name = '||ak_query_pkg.g_regions_table(i).primary_key_name);htp.nl;
1456: htp.p('- name = '||ak_query_pkg.g_regions_table(i).name);htp.nl;
1457: htp.p('- region_style = '||ak_query_pkg.g_regions_table(i).region_style);htp.nl;
1458: htp.p('- number_of_format_columns = '||to_char(ak_query_pkg.g_regions_table(i).number_of_format_columns));htp.nl;
1459: htp.p('- region_defaulting_api_pkg = '||ak_query_pkg.g_regions_table(i).region_defaulting_api_pkg);htp.nl;
1460: htp.p('- region_defaulting_api_proc= '||ak_query_pkg.g_regions_table(i).region_defaulting_api_proc);htp.nl;
1461: htp.p('- region_validation_api_pkg = '||ak_query_pkg.g_regions_table(i).region_validation_api_pkg);htp.nl;

Line 1458: htp.p('- number_of_format_columns = '||to_char(ak_query_pkg.g_regions_table(i).number_of_format_columns));htp.nl;

1454: htp.p('- region_code = '||ak_query_pkg.g_regions_table(i).region_code);htp.nl;
1455: htp.p('- primary_key_name = '||ak_query_pkg.g_regions_table(i).primary_key_name);htp.nl;
1456: htp.p('- name = '||ak_query_pkg.g_regions_table(i).name);htp.nl;
1457: htp.p('- region_style = '||ak_query_pkg.g_regions_table(i).region_style);htp.nl;
1458: htp.p('- number_of_format_columns = '||to_char(ak_query_pkg.g_regions_table(i).number_of_format_columns));htp.nl;
1459: htp.p('- region_defaulting_api_pkg = '||ak_query_pkg.g_regions_table(i).region_defaulting_api_pkg);htp.nl;
1460: htp.p('- region_defaulting_api_proc= '||ak_query_pkg.g_regions_table(i).region_defaulting_api_proc);htp.nl;
1461: htp.p('- region_validation_api_pkg = '||ak_query_pkg.g_regions_table(i).region_validation_api_pkg);htp.nl;
1462: htp.p('- region_validation_api_proc= '||ak_query_pkg.g_regions_table(i).region_validation_api_proc);htp.nl;

Line 1459: htp.p('- region_defaulting_api_pkg = '||ak_query_pkg.g_regions_table(i).region_defaulting_api_pkg);htp.nl;

1455: htp.p('- primary_key_name = '||ak_query_pkg.g_regions_table(i).primary_key_name);htp.nl;
1456: htp.p('- name = '||ak_query_pkg.g_regions_table(i).name);htp.nl;
1457: htp.p('- region_style = '||ak_query_pkg.g_regions_table(i).region_style);htp.nl;
1458: htp.p('- number_of_format_columns = '||to_char(ak_query_pkg.g_regions_table(i).number_of_format_columns));htp.nl;
1459: htp.p('- region_defaulting_api_pkg = '||ak_query_pkg.g_regions_table(i).region_defaulting_api_pkg);htp.nl;
1460: htp.p('- region_defaulting_api_proc= '||ak_query_pkg.g_regions_table(i).region_defaulting_api_proc);htp.nl;
1461: htp.p('- region_validation_api_pkg = '||ak_query_pkg.g_regions_table(i).region_validation_api_pkg);htp.nl;
1462: htp.p('- region_validation_api_proc= '||ak_query_pkg.g_regions_table(i).region_validation_api_proc);htp.nl;
1463: htp.p('- object_defaulting_api_pkg = '||ak_query_pkg.g_regions_table(i).object_defaulting_api_pkg);htp.nl;

Line 1460: htp.p('- region_defaulting_api_proc= '||ak_query_pkg.g_regions_table(i).region_defaulting_api_proc);htp.nl;

1456: htp.p('- name = '||ak_query_pkg.g_regions_table(i).name);htp.nl;
1457: htp.p('- region_style = '||ak_query_pkg.g_regions_table(i).region_style);htp.nl;
1458: htp.p('- number_of_format_columns = '||to_char(ak_query_pkg.g_regions_table(i).number_of_format_columns));htp.nl;
1459: htp.p('- region_defaulting_api_pkg = '||ak_query_pkg.g_regions_table(i).region_defaulting_api_pkg);htp.nl;
1460: htp.p('- region_defaulting_api_proc= '||ak_query_pkg.g_regions_table(i).region_defaulting_api_proc);htp.nl;
1461: htp.p('- region_validation_api_pkg = '||ak_query_pkg.g_regions_table(i).region_validation_api_pkg);htp.nl;
1462: htp.p('- region_validation_api_proc= '||ak_query_pkg.g_regions_table(i).region_validation_api_proc);htp.nl;
1463: htp.p('- object_defaulting_api_pkg = '||ak_query_pkg.g_regions_table(i).object_defaulting_api_pkg);htp.nl;
1464: htp.p('- object_defaulting_api_proc= '||ak_query_pkg.g_regions_table(i).object_defaulting_api_proc);htp.nl;

Line 1461: htp.p('- region_validation_api_pkg = '||ak_query_pkg.g_regions_table(i).region_validation_api_pkg);htp.nl;

1457: htp.p('- region_style = '||ak_query_pkg.g_regions_table(i).region_style);htp.nl;
1458: htp.p('- number_of_format_columns = '||to_char(ak_query_pkg.g_regions_table(i).number_of_format_columns));htp.nl;
1459: htp.p('- region_defaulting_api_pkg = '||ak_query_pkg.g_regions_table(i).region_defaulting_api_pkg);htp.nl;
1460: htp.p('- region_defaulting_api_proc= '||ak_query_pkg.g_regions_table(i).region_defaulting_api_proc);htp.nl;
1461: htp.p('- region_validation_api_pkg = '||ak_query_pkg.g_regions_table(i).region_validation_api_pkg);htp.nl;
1462: htp.p('- region_validation_api_proc= '||ak_query_pkg.g_regions_table(i).region_validation_api_proc);htp.nl;
1463: htp.p('- object_defaulting_api_pkg = '||ak_query_pkg.g_regions_table(i).object_defaulting_api_pkg);htp.nl;
1464: htp.p('- object_defaulting_api_proc= '||ak_query_pkg.g_regions_table(i).object_defaulting_api_proc);htp.nl;
1465: htp.p('- object_validation_api_pkg = '||ak_query_pkg.g_regions_table(i).object_validation_api_pkg);htp.nl;

Line 1462: htp.p('- region_validation_api_proc= '||ak_query_pkg.g_regions_table(i).region_validation_api_proc);htp.nl;

1458: htp.p('- number_of_format_columns = '||to_char(ak_query_pkg.g_regions_table(i).number_of_format_columns));htp.nl;
1459: htp.p('- region_defaulting_api_pkg = '||ak_query_pkg.g_regions_table(i).region_defaulting_api_pkg);htp.nl;
1460: htp.p('- region_defaulting_api_proc= '||ak_query_pkg.g_regions_table(i).region_defaulting_api_proc);htp.nl;
1461: htp.p('- region_validation_api_pkg = '||ak_query_pkg.g_regions_table(i).region_validation_api_pkg);htp.nl;
1462: htp.p('- region_validation_api_proc= '||ak_query_pkg.g_regions_table(i).region_validation_api_proc);htp.nl;
1463: htp.p('- object_defaulting_api_pkg = '||ak_query_pkg.g_regions_table(i).object_defaulting_api_pkg);htp.nl;
1464: htp.p('- object_defaulting_api_proc= '||ak_query_pkg.g_regions_table(i).object_defaulting_api_proc);htp.nl;
1465: htp.p('- object_validation_api_pkg = '||ak_query_pkg.g_regions_table(i).object_validation_api_pkg);htp.nl;
1466: htp.p('- object_validation_api_proc= '||ak_query_pkg.g_regions_table(i).object_validation_api_proc);htp.nl;

Line 1463: htp.p('- object_defaulting_api_pkg = '||ak_query_pkg.g_regions_table(i).object_defaulting_api_pkg);htp.nl;

1459: htp.p('- region_defaulting_api_pkg = '||ak_query_pkg.g_regions_table(i).region_defaulting_api_pkg);htp.nl;
1460: htp.p('- region_defaulting_api_proc= '||ak_query_pkg.g_regions_table(i).region_defaulting_api_proc);htp.nl;
1461: htp.p('- region_validation_api_pkg = '||ak_query_pkg.g_regions_table(i).region_validation_api_pkg);htp.nl;
1462: htp.p('- region_validation_api_proc= '||ak_query_pkg.g_regions_table(i).region_validation_api_proc);htp.nl;
1463: htp.p('- object_defaulting_api_pkg = '||ak_query_pkg.g_regions_table(i).object_defaulting_api_pkg);htp.nl;
1464: htp.p('- object_defaulting_api_proc= '||ak_query_pkg.g_regions_table(i).object_defaulting_api_proc);htp.nl;
1465: htp.p('- object_validation_api_pkg = '||ak_query_pkg.g_regions_table(i).object_validation_api_pkg);htp.nl;
1466: htp.p('- object_validation_api_proc= '||ak_query_pkg.g_regions_table(i).object_validation_api_proc);htp.nl;
1467: END LOOP;

Line 1464: htp.p('- object_defaulting_api_proc= '||ak_query_pkg.g_regions_table(i).object_defaulting_api_proc);htp.nl;

1460: htp.p('- region_defaulting_api_proc= '||ak_query_pkg.g_regions_table(i).region_defaulting_api_proc);htp.nl;
1461: htp.p('- region_validation_api_pkg = '||ak_query_pkg.g_regions_table(i).region_validation_api_pkg);htp.nl;
1462: htp.p('- region_validation_api_proc= '||ak_query_pkg.g_regions_table(i).region_validation_api_proc);htp.nl;
1463: htp.p('- object_defaulting_api_pkg = '||ak_query_pkg.g_regions_table(i).object_defaulting_api_pkg);htp.nl;
1464: htp.p('- object_defaulting_api_proc= '||ak_query_pkg.g_regions_table(i).object_defaulting_api_proc);htp.nl;
1465: htp.p('- object_validation_api_pkg = '||ak_query_pkg.g_regions_table(i).object_validation_api_pkg);htp.nl;
1466: htp.p('- object_validation_api_proc= '||ak_query_pkg.g_regions_table(i).object_validation_api_proc);htp.nl;
1467: END LOOP;
1468:

Line 1465: htp.p('- object_validation_api_pkg = '||ak_query_pkg.g_regions_table(i).object_validation_api_pkg);htp.nl;

1461: htp.p('- region_validation_api_pkg = '||ak_query_pkg.g_regions_table(i).region_validation_api_pkg);htp.nl;
1462: htp.p('- region_validation_api_proc= '||ak_query_pkg.g_regions_table(i).region_validation_api_proc);htp.nl;
1463: htp.p('- object_defaulting_api_pkg = '||ak_query_pkg.g_regions_table(i).object_defaulting_api_pkg);htp.nl;
1464: htp.p('- object_defaulting_api_proc= '||ak_query_pkg.g_regions_table(i).object_defaulting_api_proc);htp.nl;
1465: htp.p('- object_validation_api_pkg = '||ak_query_pkg.g_regions_table(i).object_validation_api_pkg);htp.nl;
1466: htp.p('- object_validation_api_proc= '||ak_query_pkg.g_regions_table(i).object_validation_api_proc);htp.nl;
1467: END LOOP;
1468:
1469: htp.p('===============================================================');htp.nl;

Line 1466: htp.p('- object_validation_api_proc= '||ak_query_pkg.g_regions_table(i).object_validation_api_proc);htp.nl;

1462: htp.p('- region_validation_api_proc= '||ak_query_pkg.g_regions_table(i).region_validation_api_proc);htp.nl;
1463: htp.p('- object_defaulting_api_pkg = '||ak_query_pkg.g_regions_table(i).object_defaulting_api_pkg);htp.nl;
1464: htp.p('- object_defaulting_api_proc= '||ak_query_pkg.g_regions_table(i).object_defaulting_api_proc);htp.nl;
1465: htp.p('- object_validation_api_pkg = '||ak_query_pkg.g_regions_table(i).object_validation_api_pkg);htp.nl;
1466: htp.p('- object_validation_api_proc= '||ak_query_pkg.g_regions_table(i).object_validation_api_proc);htp.nl;
1467: END LOOP;
1468:
1469: htp.p('===============================================================');htp.nl;
1470: htp.p('ITEMS');htp.nl;

Line 1472: htp.p('Total Items = '||to_char(ak_query_pkg.g_items_table.COUNT));htp.nl;

1468:
1469: htp.p('===============================================================');htp.nl;
1470: htp.p('ITEMS');htp.nl;
1471: htp.p('===============================================================');htp.nl;
1472: htp.p('Total Items = '||to_char(ak_query_pkg.g_items_table.COUNT));htp.nl;
1473: FOR i IN 0..(ak_query_pkg.g_items_table.COUNT - 1) LOOP
1474: htp.p('Item Table Row ='||to_char(i));htp.nl;
1475: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_items_table(i).region_rec_id));htp.nl;
1476: htp.p('- value_id = '||to_char(ak_query_pkg.g_items_table(i).value_id));htp.nl;

Line 1473: FOR i IN 0..(ak_query_pkg.g_items_table.COUNT - 1) LOOP

1469: htp.p('===============================================================');htp.nl;
1470: htp.p('ITEMS');htp.nl;
1471: htp.p('===============================================================');htp.nl;
1472: htp.p('Total Items = '||to_char(ak_query_pkg.g_items_table.COUNT));htp.nl;
1473: FOR i IN 0..(ak_query_pkg.g_items_table.COUNT - 1) LOOP
1474: htp.p('Item Table Row ='||to_char(i));htp.nl;
1475: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_items_table(i).region_rec_id));htp.nl;
1476: htp.p('- value_id = '||to_char(ak_query_pkg.g_items_table(i).value_id));htp.nl;
1477: htp.p('- attribute_application_id = '||to_char(ak_query_pkg.g_items_table(i).attribute_application_id));htp.nl;

Line 1475: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_items_table(i).region_rec_id));htp.nl;

1471: htp.p('===============================================================');htp.nl;
1472: htp.p('Total Items = '||to_char(ak_query_pkg.g_items_table.COUNT));htp.nl;
1473: FOR i IN 0..(ak_query_pkg.g_items_table.COUNT - 1) LOOP
1474: htp.p('Item Table Row ='||to_char(i));htp.nl;
1475: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_items_table(i).region_rec_id));htp.nl;
1476: htp.p('- value_id = '||to_char(ak_query_pkg.g_items_table(i).value_id));htp.nl;
1477: htp.p('- attribute_application_id = '||to_char(ak_query_pkg.g_items_table(i).attribute_application_id));htp.nl;
1478: htp.p('- attribute_code = '||ak_query_pkg.g_items_table(i).attribute_code);htp.nl;
1479: htp.p('- attribute_label_long = '||ak_query_pkg.g_items_table(i).attribute_label_long);htp.nl;

Line 1476: htp.p('- value_id = '||to_char(ak_query_pkg.g_items_table(i).value_id));htp.nl;

1472: htp.p('Total Items = '||to_char(ak_query_pkg.g_items_table.COUNT));htp.nl;
1473: FOR i IN 0..(ak_query_pkg.g_items_table.COUNT - 1) LOOP
1474: htp.p('Item Table Row ='||to_char(i));htp.nl;
1475: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_items_table(i).region_rec_id));htp.nl;
1476: htp.p('- value_id = '||to_char(ak_query_pkg.g_items_table(i).value_id));htp.nl;
1477: htp.p('- attribute_application_id = '||to_char(ak_query_pkg.g_items_table(i).attribute_application_id));htp.nl;
1478: htp.p('- attribute_code = '||ak_query_pkg.g_items_table(i).attribute_code);htp.nl;
1479: htp.p('- attribute_label_long = '||ak_query_pkg.g_items_table(i).attribute_label_long);htp.nl;
1480: htp.p('- attribute_label_length = '||to_char(ak_query_pkg.g_items_table(i).attribute_label_length));htp.nl;

Line 1477: htp.p('- attribute_application_id = '||to_char(ak_query_pkg.g_items_table(i).attribute_application_id));htp.nl;

1473: FOR i IN 0..(ak_query_pkg.g_items_table.COUNT - 1) LOOP
1474: htp.p('Item Table Row ='||to_char(i));htp.nl;
1475: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_items_table(i).region_rec_id));htp.nl;
1476: htp.p('- value_id = '||to_char(ak_query_pkg.g_items_table(i).value_id));htp.nl;
1477: htp.p('- attribute_application_id = '||to_char(ak_query_pkg.g_items_table(i).attribute_application_id));htp.nl;
1478: htp.p('- attribute_code = '||ak_query_pkg.g_items_table(i).attribute_code);htp.nl;
1479: htp.p('- attribute_label_long = '||ak_query_pkg.g_items_table(i).attribute_label_long);htp.nl;
1480: htp.p('- attribute_label_length = '||to_char(ak_query_pkg.g_items_table(i).attribute_label_length));htp.nl;
1481: htp.p('- display_value_length = '||to_char(ak_query_pkg.g_items_table(i).display_value_length));htp.nl;

Line 1478: htp.p('- attribute_code = '||ak_query_pkg.g_items_table(i).attribute_code);htp.nl;

1474: htp.p('Item Table Row ='||to_char(i));htp.nl;
1475: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_items_table(i).region_rec_id));htp.nl;
1476: htp.p('- value_id = '||to_char(ak_query_pkg.g_items_table(i).value_id));htp.nl;
1477: htp.p('- attribute_application_id = '||to_char(ak_query_pkg.g_items_table(i).attribute_application_id));htp.nl;
1478: htp.p('- attribute_code = '||ak_query_pkg.g_items_table(i).attribute_code);htp.nl;
1479: htp.p('- attribute_label_long = '||ak_query_pkg.g_items_table(i).attribute_label_long);htp.nl;
1480: htp.p('- attribute_label_length = '||to_char(ak_query_pkg.g_items_table(i).attribute_label_length));htp.nl;
1481: htp.p('- display_value_length = '||to_char(ak_query_pkg.g_items_table(i).display_value_length));htp.nl;
1482: htp.p('- display_sequence = '||to_char(ak_query_pkg.g_items_table(i).display_sequence));htp.nl;

Line 1479: htp.p('- attribute_label_long = '||ak_query_pkg.g_items_table(i).attribute_label_long);htp.nl;

1475: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_items_table(i).region_rec_id));htp.nl;
1476: htp.p('- value_id = '||to_char(ak_query_pkg.g_items_table(i).value_id));htp.nl;
1477: htp.p('- attribute_application_id = '||to_char(ak_query_pkg.g_items_table(i).attribute_application_id));htp.nl;
1478: htp.p('- attribute_code = '||ak_query_pkg.g_items_table(i).attribute_code);htp.nl;
1479: htp.p('- attribute_label_long = '||ak_query_pkg.g_items_table(i).attribute_label_long);htp.nl;
1480: htp.p('- attribute_label_length = '||to_char(ak_query_pkg.g_items_table(i).attribute_label_length));htp.nl;
1481: htp.p('- display_value_length = '||to_char(ak_query_pkg.g_items_table(i).display_value_length));htp.nl;
1482: htp.p('- display_sequence = '||to_char(ak_query_pkg.g_items_table(i).display_sequence));htp.nl;
1483: htp.p('- item_style = '||ak_query_pkg.g_items_table(i).item_style);htp.nl;

Line 1480: htp.p('- attribute_label_length = '||to_char(ak_query_pkg.g_items_table(i).attribute_label_length));htp.nl;

1476: htp.p('- value_id = '||to_char(ak_query_pkg.g_items_table(i).value_id));htp.nl;
1477: htp.p('- attribute_application_id = '||to_char(ak_query_pkg.g_items_table(i).attribute_application_id));htp.nl;
1478: htp.p('- attribute_code = '||ak_query_pkg.g_items_table(i).attribute_code);htp.nl;
1479: htp.p('- attribute_label_long = '||ak_query_pkg.g_items_table(i).attribute_label_long);htp.nl;
1480: htp.p('- attribute_label_length = '||to_char(ak_query_pkg.g_items_table(i).attribute_label_length));htp.nl;
1481: htp.p('- display_value_length = '||to_char(ak_query_pkg.g_items_table(i).display_value_length));htp.nl;
1482: htp.p('- display_sequence = '||to_char(ak_query_pkg.g_items_table(i).display_sequence));htp.nl;
1483: htp.p('- item_style = '||ak_query_pkg.g_items_table(i).item_style);htp.nl;
1484: htp.p('- bold = '||ak_query_pkg.g_items_table(i).bold);htp.nl;

Line 1481: htp.p('- display_value_length = '||to_char(ak_query_pkg.g_items_table(i).display_value_length));htp.nl;

1477: htp.p('- attribute_application_id = '||to_char(ak_query_pkg.g_items_table(i).attribute_application_id));htp.nl;
1478: htp.p('- attribute_code = '||ak_query_pkg.g_items_table(i).attribute_code);htp.nl;
1479: htp.p('- attribute_label_long = '||ak_query_pkg.g_items_table(i).attribute_label_long);htp.nl;
1480: htp.p('- attribute_label_length = '||to_char(ak_query_pkg.g_items_table(i).attribute_label_length));htp.nl;
1481: htp.p('- display_value_length = '||to_char(ak_query_pkg.g_items_table(i).display_value_length));htp.nl;
1482: htp.p('- display_sequence = '||to_char(ak_query_pkg.g_items_table(i).display_sequence));htp.nl;
1483: htp.p('- item_style = '||ak_query_pkg.g_items_table(i).item_style);htp.nl;
1484: htp.p('- bold = '||ak_query_pkg.g_items_table(i).bold);htp.nl;
1485: htp.p('- italic = '||ak_query_pkg.g_items_table(i).italic);htp.nl;

Line 1482: htp.p('- display_sequence = '||to_char(ak_query_pkg.g_items_table(i).display_sequence));htp.nl;

1478: htp.p('- attribute_code = '||ak_query_pkg.g_items_table(i).attribute_code);htp.nl;
1479: htp.p('- attribute_label_long = '||ak_query_pkg.g_items_table(i).attribute_label_long);htp.nl;
1480: htp.p('- attribute_label_length = '||to_char(ak_query_pkg.g_items_table(i).attribute_label_length));htp.nl;
1481: htp.p('- display_value_length = '||to_char(ak_query_pkg.g_items_table(i).display_value_length));htp.nl;
1482: htp.p('- display_sequence = '||to_char(ak_query_pkg.g_items_table(i).display_sequence));htp.nl;
1483: htp.p('- item_style = '||ak_query_pkg.g_items_table(i).item_style);htp.nl;
1484: htp.p('- bold = '||ak_query_pkg.g_items_table(i).bold);htp.nl;
1485: htp.p('- italic = '||ak_query_pkg.g_items_table(i).italic);htp.nl;
1486: htp.p('- vertical_alignment = '||ak_query_pkg.g_items_table(i).vertical_alignment);htp.nl;

Line 1483: htp.p('- item_style = '||ak_query_pkg.g_items_table(i).item_style);htp.nl;

1479: htp.p('- attribute_label_long = '||ak_query_pkg.g_items_table(i).attribute_label_long);htp.nl;
1480: htp.p('- attribute_label_length = '||to_char(ak_query_pkg.g_items_table(i).attribute_label_length));htp.nl;
1481: htp.p('- display_value_length = '||to_char(ak_query_pkg.g_items_table(i).display_value_length));htp.nl;
1482: htp.p('- display_sequence = '||to_char(ak_query_pkg.g_items_table(i).display_sequence));htp.nl;
1483: htp.p('- item_style = '||ak_query_pkg.g_items_table(i).item_style);htp.nl;
1484: htp.p('- bold = '||ak_query_pkg.g_items_table(i).bold);htp.nl;
1485: htp.p('- italic = '||ak_query_pkg.g_items_table(i).italic);htp.nl;
1486: htp.p('- vertical_alignment = '||ak_query_pkg.g_items_table(i).vertical_alignment);htp.nl;
1487: htp.p('- horizontal_alignment = '||ak_query_pkg.g_items_table(i).horizontal_alignment);htp.nl;

Line 1484: htp.p('- bold = '||ak_query_pkg.g_items_table(i).bold);htp.nl;

1480: htp.p('- attribute_label_length = '||to_char(ak_query_pkg.g_items_table(i).attribute_label_length));htp.nl;
1481: htp.p('- display_value_length = '||to_char(ak_query_pkg.g_items_table(i).display_value_length));htp.nl;
1482: htp.p('- display_sequence = '||to_char(ak_query_pkg.g_items_table(i).display_sequence));htp.nl;
1483: htp.p('- item_style = '||ak_query_pkg.g_items_table(i).item_style);htp.nl;
1484: htp.p('- bold = '||ak_query_pkg.g_items_table(i).bold);htp.nl;
1485: htp.p('- italic = '||ak_query_pkg.g_items_table(i).italic);htp.nl;
1486: htp.p('- vertical_alignment = '||ak_query_pkg.g_items_table(i).vertical_alignment);htp.nl;
1487: htp.p('- horizontal_alignment = '||ak_query_pkg.g_items_table(i).horizontal_alignment);htp.nl;
1488: htp.p('- object_attribute_flag = '||ak_query_pkg.g_items_table(i).object_attribute_flag);htp.nl;

Line 1485: htp.p('- italic = '||ak_query_pkg.g_items_table(i).italic);htp.nl;

1481: htp.p('- display_value_length = '||to_char(ak_query_pkg.g_items_table(i).display_value_length));htp.nl;
1482: htp.p('- display_sequence = '||to_char(ak_query_pkg.g_items_table(i).display_sequence));htp.nl;
1483: htp.p('- item_style = '||ak_query_pkg.g_items_table(i).item_style);htp.nl;
1484: htp.p('- bold = '||ak_query_pkg.g_items_table(i).bold);htp.nl;
1485: htp.p('- italic = '||ak_query_pkg.g_items_table(i).italic);htp.nl;
1486: htp.p('- vertical_alignment = '||ak_query_pkg.g_items_table(i).vertical_alignment);htp.nl;
1487: htp.p('- horizontal_alignment = '||ak_query_pkg.g_items_table(i).horizontal_alignment);htp.nl;
1488: htp.p('- object_attribute_flag = '||ak_query_pkg.g_items_table(i).object_attribute_flag);htp.nl;
1489: htp.p('- secured_column = '||ak_query_pkg.g_items_table(i).secured_column);htp.nl;

Line 1486: htp.p('- vertical_alignment = '||ak_query_pkg.g_items_table(i).vertical_alignment);htp.nl;

1482: htp.p('- display_sequence = '||to_char(ak_query_pkg.g_items_table(i).display_sequence));htp.nl;
1483: htp.p('- item_style = '||ak_query_pkg.g_items_table(i).item_style);htp.nl;
1484: htp.p('- bold = '||ak_query_pkg.g_items_table(i).bold);htp.nl;
1485: htp.p('- italic = '||ak_query_pkg.g_items_table(i).italic);htp.nl;
1486: htp.p('- vertical_alignment = '||ak_query_pkg.g_items_table(i).vertical_alignment);htp.nl;
1487: htp.p('- horizontal_alignment = '||ak_query_pkg.g_items_table(i).horizontal_alignment);htp.nl;
1488: htp.p('- object_attribute_flag = '||ak_query_pkg.g_items_table(i).object_attribute_flag);htp.nl;
1489: htp.p('- secured_column = '||ak_query_pkg.g_items_table(i).secured_column);htp.nl;
1490: htp.p('- node_query_flag = '||ak_query_pkg.g_items_table(i).node_query_flag);htp.nl;

Line 1487: htp.p('- horizontal_alignment = '||ak_query_pkg.g_items_table(i).horizontal_alignment);htp.nl;

1483: htp.p('- item_style = '||ak_query_pkg.g_items_table(i).item_style);htp.nl;
1484: htp.p('- bold = '||ak_query_pkg.g_items_table(i).bold);htp.nl;
1485: htp.p('- italic = '||ak_query_pkg.g_items_table(i).italic);htp.nl;
1486: htp.p('- vertical_alignment = '||ak_query_pkg.g_items_table(i).vertical_alignment);htp.nl;
1487: htp.p('- horizontal_alignment = '||ak_query_pkg.g_items_table(i).horizontal_alignment);htp.nl;
1488: htp.p('- object_attribute_flag = '||ak_query_pkg.g_items_table(i).object_attribute_flag);htp.nl;
1489: htp.p('- secured_column = '||ak_query_pkg.g_items_table(i).secured_column);htp.nl;
1490: htp.p('- node_query_flag = '||ak_query_pkg.g_items_table(i).node_query_flag);htp.nl;
1491: htp.p('- node_display_flag = '||ak_query_pkg.g_items_table(i).node_display_flag);htp.nl;

Line 1488: htp.p('- object_attribute_flag = '||ak_query_pkg.g_items_table(i).object_attribute_flag);htp.nl;

1484: htp.p('- bold = '||ak_query_pkg.g_items_table(i).bold);htp.nl;
1485: htp.p('- italic = '||ak_query_pkg.g_items_table(i).italic);htp.nl;
1486: htp.p('- vertical_alignment = '||ak_query_pkg.g_items_table(i).vertical_alignment);htp.nl;
1487: htp.p('- horizontal_alignment = '||ak_query_pkg.g_items_table(i).horizontal_alignment);htp.nl;
1488: htp.p('- object_attribute_flag = '||ak_query_pkg.g_items_table(i).object_attribute_flag);htp.nl;
1489: htp.p('- secured_column = '||ak_query_pkg.g_items_table(i).secured_column);htp.nl;
1490: htp.p('- node_query_flag = '||ak_query_pkg.g_items_table(i).node_query_flag);htp.nl;
1491: htp.p('- node_display_flag = '||ak_query_pkg.g_items_table(i).node_display_flag);htp.nl;
1492: htp.p('- update_flag = '||ak_query_pkg.g_items_table(i).update_flag);htp.nl;

Line 1489: htp.p('- secured_column = '||ak_query_pkg.g_items_table(i).secured_column);htp.nl;

1485: htp.p('- italic = '||ak_query_pkg.g_items_table(i).italic);htp.nl;
1486: htp.p('- vertical_alignment = '||ak_query_pkg.g_items_table(i).vertical_alignment);htp.nl;
1487: htp.p('- horizontal_alignment = '||ak_query_pkg.g_items_table(i).horizontal_alignment);htp.nl;
1488: htp.p('- object_attribute_flag = '||ak_query_pkg.g_items_table(i).object_attribute_flag);htp.nl;
1489: htp.p('- secured_column = '||ak_query_pkg.g_items_table(i).secured_column);htp.nl;
1490: htp.p('- node_query_flag = '||ak_query_pkg.g_items_table(i).node_query_flag);htp.nl;
1491: htp.p('- node_display_flag = '||ak_query_pkg.g_items_table(i).node_display_flag);htp.nl;
1492: htp.p('- update_flag = '||ak_query_pkg.g_items_table(i).update_flag);htp.nl;
1493: htp.p('- required_flag = '||ak_query_pkg.g_items_table(i).required_flag);htp.nl;

Line 1490: htp.p('- node_query_flag = '||ak_query_pkg.g_items_table(i).node_query_flag);htp.nl;

1486: htp.p('- vertical_alignment = '||ak_query_pkg.g_items_table(i).vertical_alignment);htp.nl;
1487: htp.p('- horizontal_alignment = '||ak_query_pkg.g_items_table(i).horizontal_alignment);htp.nl;
1488: htp.p('- object_attribute_flag = '||ak_query_pkg.g_items_table(i).object_attribute_flag);htp.nl;
1489: htp.p('- secured_column = '||ak_query_pkg.g_items_table(i).secured_column);htp.nl;
1490: htp.p('- node_query_flag = '||ak_query_pkg.g_items_table(i).node_query_flag);htp.nl;
1491: htp.p('- node_display_flag = '||ak_query_pkg.g_items_table(i).node_display_flag);htp.nl;
1492: htp.p('- update_flag = '||ak_query_pkg.g_items_table(i).update_flag);htp.nl;
1493: htp.p('- required_flag = '||ak_query_pkg.g_items_table(i).required_flag);htp.nl;
1494: htp.p('- icx_custom_call = '||ak_query_pkg.g_items_table(i).icx_custom_call);htp.nl;

Line 1491: htp.p('- node_display_flag = '||ak_query_pkg.g_items_table(i).node_display_flag);htp.nl;

1487: htp.p('- horizontal_alignment = '||ak_query_pkg.g_items_table(i).horizontal_alignment);htp.nl;
1488: htp.p('- object_attribute_flag = '||ak_query_pkg.g_items_table(i).object_attribute_flag);htp.nl;
1489: htp.p('- secured_column = '||ak_query_pkg.g_items_table(i).secured_column);htp.nl;
1490: htp.p('- node_query_flag = '||ak_query_pkg.g_items_table(i).node_query_flag);htp.nl;
1491: htp.p('- node_display_flag = '||ak_query_pkg.g_items_table(i).node_display_flag);htp.nl;
1492: htp.p('- update_flag = '||ak_query_pkg.g_items_table(i).update_flag);htp.nl;
1493: htp.p('- required_flag = '||ak_query_pkg.g_items_table(i).required_flag);htp.nl;
1494: htp.p('- icx_custom_call = '||ak_query_pkg.g_items_table(i).icx_custom_call);htp.nl;
1495: htp.p('- region_defaulting_api_pkg = '||ak_query_pkg.g_items_table(i).region_defaulting_api_pkg);htp.nl;

Line 1492: htp.p('- update_flag = '||ak_query_pkg.g_items_table(i).update_flag);htp.nl;

1488: htp.p('- object_attribute_flag = '||ak_query_pkg.g_items_table(i).object_attribute_flag);htp.nl;
1489: htp.p('- secured_column = '||ak_query_pkg.g_items_table(i).secured_column);htp.nl;
1490: htp.p('- node_query_flag = '||ak_query_pkg.g_items_table(i).node_query_flag);htp.nl;
1491: htp.p('- node_display_flag = '||ak_query_pkg.g_items_table(i).node_display_flag);htp.nl;
1492: htp.p('- update_flag = '||ak_query_pkg.g_items_table(i).update_flag);htp.nl;
1493: htp.p('- required_flag = '||ak_query_pkg.g_items_table(i).required_flag);htp.nl;
1494: htp.p('- icx_custom_call = '||ak_query_pkg.g_items_table(i).icx_custom_call);htp.nl;
1495: htp.p('- region_defaulting_api_pkg = '||ak_query_pkg.g_items_table(i).region_defaulting_api_pkg);htp.nl;
1496: htp.p('- region_defaulting_api_proc = '||ak_query_pkg.g_items_table(i).region_defaulting_api_proc);htp.nl;

Line 1493: htp.p('- required_flag = '||ak_query_pkg.g_items_table(i).required_flag);htp.nl;

1489: htp.p('- secured_column = '||ak_query_pkg.g_items_table(i).secured_column);htp.nl;
1490: htp.p('- node_query_flag = '||ak_query_pkg.g_items_table(i).node_query_flag);htp.nl;
1491: htp.p('- node_display_flag = '||ak_query_pkg.g_items_table(i).node_display_flag);htp.nl;
1492: htp.p('- update_flag = '||ak_query_pkg.g_items_table(i).update_flag);htp.nl;
1493: htp.p('- required_flag = '||ak_query_pkg.g_items_table(i).required_flag);htp.nl;
1494: htp.p('- icx_custom_call = '||ak_query_pkg.g_items_table(i).icx_custom_call);htp.nl;
1495: htp.p('- region_defaulting_api_pkg = '||ak_query_pkg.g_items_table(i).region_defaulting_api_pkg);htp.nl;
1496: htp.p('- region_defaulting_api_proc = '||ak_query_pkg.g_items_table(i).region_defaulting_api_proc);htp.nl;
1497: htp.p('- region_validation_api_pkg = '||ak_query_pkg.g_items_table(i).region_validation_api_pkg);htp.nl;

Line 1494: htp.p('- icx_custom_call = '||ak_query_pkg.g_items_table(i).icx_custom_call);htp.nl;

1490: htp.p('- node_query_flag = '||ak_query_pkg.g_items_table(i).node_query_flag);htp.nl;
1491: htp.p('- node_display_flag = '||ak_query_pkg.g_items_table(i).node_display_flag);htp.nl;
1492: htp.p('- update_flag = '||ak_query_pkg.g_items_table(i).update_flag);htp.nl;
1493: htp.p('- required_flag = '||ak_query_pkg.g_items_table(i).required_flag);htp.nl;
1494: htp.p('- icx_custom_call = '||ak_query_pkg.g_items_table(i).icx_custom_call);htp.nl;
1495: htp.p('- region_defaulting_api_pkg = '||ak_query_pkg.g_items_table(i).region_defaulting_api_pkg);htp.nl;
1496: htp.p('- region_defaulting_api_proc = '||ak_query_pkg.g_items_table(i).region_defaulting_api_proc);htp.nl;
1497: htp.p('- region_validation_api_pkg = '||ak_query_pkg.g_items_table(i).region_validation_api_pkg);htp.nl;
1498: htp.p('- region_validation_api_proc = '||ak_query_pkg.g_items_table(i).region_validation_api_proc);htp.nl;

Line 1495: htp.p('- region_defaulting_api_pkg = '||ak_query_pkg.g_items_table(i).region_defaulting_api_pkg);htp.nl;

1491: htp.p('- node_display_flag = '||ak_query_pkg.g_items_table(i).node_display_flag);htp.nl;
1492: htp.p('- update_flag = '||ak_query_pkg.g_items_table(i).update_flag);htp.nl;
1493: htp.p('- required_flag = '||ak_query_pkg.g_items_table(i).required_flag);htp.nl;
1494: htp.p('- icx_custom_call = '||ak_query_pkg.g_items_table(i).icx_custom_call);htp.nl;
1495: htp.p('- region_defaulting_api_pkg = '||ak_query_pkg.g_items_table(i).region_defaulting_api_pkg);htp.nl;
1496: htp.p('- region_defaulting_api_proc = '||ak_query_pkg.g_items_table(i).region_defaulting_api_proc);htp.nl;
1497: htp.p('- region_validation_api_pkg = '||ak_query_pkg.g_items_table(i).region_validation_api_pkg);htp.nl;
1498: htp.p('- region_validation_api_proc = '||ak_query_pkg.g_items_table(i).region_validation_api_proc);htp.nl;
1499: htp.p('- object_defaulting_api_pkg = '||ak_query_pkg.g_items_table(i).object_defaulting_api_pkg);htp.nl;

Line 1496: htp.p('- region_defaulting_api_proc = '||ak_query_pkg.g_items_table(i).region_defaulting_api_proc);htp.nl;

1492: htp.p('- update_flag = '||ak_query_pkg.g_items_table(i).update_flag);htp.nl;
1493: htp.p('- required_flag = '||ak_query_pkg.g_items_table(i).required_flag);htp.nl;
1494: htp.p('- icx_custom_call = '||ak_query_pkg.g_items_table(i).icx_custom_call);htp.nl;
1495: htp.p('- region_defaulting_api_pkg = '||ak_query_pkg.g_items_table(i).region_defaulting_api_pkg);htp.nl;
1496: htp.p('- region_defaulting_api_proc = '||ak_query_pkg.g_items_table(i).region_defaulting_api_proc);htp.nl;
1497: htp.p('- region_validation_api_pkg = '||ak_query_pkg.g_items_table(i).region_validation_api_pkg);htp.nl;
1498: htp.p('- region_validation_api_proc = '||ak_query_pkg.g_items_table(i).region_validation_api_proc);htp.nl;
1499: htp.p('- object_defaulting_api_pkg = '||ak_query_pkg.g_items_table(i).object_defaulting_api_pkg);htp.nl;
1500: htp.p('- object_defaulting_api_proc = '||ak_query_pkg.g_items_table(i).object_defaulting_api_proc);htp.nl;

Line 1497: htp.p('- region_validation_api_pkg = '||ak_query_pkg.g_items_table(i).region_validation_api_pkg);htp.nl;

1493: htp.p('- required_flag = '||ak_query_pkg.g_items_table(i).required_flag);htp.nl;
1494: htp.p('- icx_custom_call = '||ak_query_pkg.g_items_table(i).icx_custom_call);htp.nl;
1495: htp.p('- region_defaulting_api_pkg = '||ak_query_pkg.g_items_table(i).region_defaulting_api_pkg);htp.nl;
1496: htp.p('- region_defaulting_api_proc = '||ak_query_pkg.g_items_table(i).region_defaulting_api_proc);htp.nl;
1497: htp.p('- region_validation_api_pkg = '||ak_query_pkg.g_items_table(i).region_validation_api_pkg);htp.nl;
1498: htp.p('- region_validation_api_proc = '||ak_query_pkg.g_items_table(i).region_validation_api_proc);htp.nl;
1499: htp.p('- object_defaulting_api_pkg = '||ak_query_pkg.g_items_table(i).object_defaulting_api_pkg);htp.nl;
1500: htp.p('- object_defaulting_api_proc = '||ak_query_pkg.g_items_table(i).object_defaulting_api_proc);htp.nl;
1501: htp.p('- object_validation_api_pkg = '||ak_query_pkg.g_items_table(i).object_validation_api_pkg);htp.nl;

Line 1498: htp.p('- region_validation_api_proc = '||ak_query_pkg.g_items_table(i).region_validation_api_proc);htp.nl;

1494: htp.p('- icx_custom_call = '||ak_query_pkg.g_items_table(i).icx_custom_call);htp.nl;
1495: htp.p('- region_defaulting_api_pkg = '||ak_query_pkg.g_items_table(i).region_defaulting_api_pkg);htp.nl;
1496: htp.p('- region_defaulting_api_proc = '||ak_query_pkg.g_items_table(i).region_defaulting_api_proc);htp.nl;
1497: htp.p('- region_validation_api_pkg = '||ak_query_pkg.g_items_table(i).region_validation_api_pkg);htp.nl;
1498: htp.p('- region_validation_api_proc = '||ak_query_pkg.g_items_table(i).region_validation_api_proc);htp.nl;
1499: htp.p('- object_defaulting_api_pkg = '||ak_query_pkg.g_items_table(i).object_defaulting_api_pkg);htp.nl;
1500: htp.p('- object_defaulting_api_proc = '||ak_query_pkg.g_items_table(i).object_defaulting_api_proc);htp.nl;
1501: htp.p('- object_validation_api_pkg = '||ak_query_pkg.g_items_table(i).object_validation_api_pkg);htp.nl;
1502: htp.p('- object_validation_api_proc = '||ak_query_pkg.g_items_table(i).object_validation_api_proc);htp.nl;

Line 1499: htp.p('- object_defaulting_api_pkg = '||ak_query_pkg.g_items_table(i).object_defaulting_api_pkg);htp.nl;

1495: htp.p('- region_defaulting_api_pkg = '||ak_query_pkg.g_items_table(i).region_defaulting_api_pkg);htp.nl;
1496: htp.p('- region_defaulting_api_proc = '||ak_query_pkg.g_items_table(i).region_defaulting_api_proc);htp.nl;
1497: htp.p('- region_validation_api_pkg = '||ak_query_pkg.g_items_table(i).region_validation_api_pkg);htp.nl;
1498: htp.p('- region_validation_api_proc = '||ak_query_pkg.g_items_table(i).region_validation_api_proc);htp.nl;
1499: htp.p('- object_defaulting_api_pkg = '||ak_query_pkg.g_items_table(i).object_defaulting_api_pkg);htp.nl;
1500: htp.p('- object_defaulting_api_proc = '||ak_query_pkg.g_items_table(i).object_defaulting_api_proc);htp.nl;
1501: htp.p('- object_validation_api_pkg = '||ak_query_pkg.g_items_table(i).object_validation_api_pkg);htp.nl;
1502: htp.p('- object_validation_api_proc = '||ak_query_pkg.g_items_table(i).object_validation_api_proc);htp.nl;
1503: END LOOP;

Line 1500: htp.p('- object_defaulting_api_proc = '||ak_query_pkg.g_items_table(i).object_defaulting_api_proc);htp.nl;

1496: htp.p('- region_defaulting_api_proc = '||ak_query_pkg.g_items_table(i).region_defaulting_api_proc);htp.nl;
1497: htp.p('- region_validation_api_pkg = '||ak_query_pkg.g_items_table(i).region_validation_api_pkg);htp.nl;
1498: htp.p('- region_validation_api_proc = '||ak_query_pkg.g_items_table(i).region_validation_api_proc);htp.nl;
1499: htp.p('- object_defaulting_api_pkg = '||ak_query_pkg.g_items_table(i).object_defaulting_api_pkg);htp.nl;
1500: htp.p('- object_defaulting_api_proc = '||ak_query_pkg.g_items_table(i).object_defaulting_api_proc);htp.nl;
1501: htp.p('- object_validation_api_pkg = '||ak_query_pkg.g_items_table(i).object_validation_api_pkg);htp.nl;
1502: htp.p('- object_validation_api_proc = '||ak_query_pkg.g_items_table(i).object_validation_api_proc);htp.nl;
1503: END LOOP;
1504:

Line 1501: htp.p('- object_validation_api_pkg = '||ak_query_pkg.g_items_table(i).object_validation_api_pkg);htp.nl;

1497: htp.p('- region_validation_api_pkg = '||ak_query_pkg.g_items_table(i).region_validation_api_pkg);htp.nl;
1498: htp.p('- region_validation_api_proc = '||ak_query_pkg.g_items_table(i).region_validation_api_proc);htp.nl;
1499: htp.p('- object_defaulting_api_pkg = '||ak_query_pkg.g_items_table(i).object_defaulting_api_pkg);htp.nl;
1500: htp.p('- object_defaulting_api_proc = '||ak_query_pkg.g_items_table(i).object_defaulting_api_proc);htp.nl;
1501: htp.p('- object_validation_api_pkg = '||ak_query_pkg.g_items_table(i).object_validation_api_pkg);htp.nl;
1502: htp.p('- object_validation_api_proc = '||ak_query_pkg.g_items_table(i).object_validation_api_proc);htp.nl;
1503: END LOOP;
1504:
1505: htp.p('===============================================================');htp.nl;

Line 1502: htp.p('- object_validation_api_proc = '||ak_query_pkg.g_items_table(i).object_validation_api_proc);htp.nl;

1498: htp.p('- region_validation_api_proc = '||ak_query_pkg.g_items_table(i).region_validation_api_proc);htp.nl;
1499: htp.p('- object_defaulting_api_pkg = '||ak_query_pkg.g_items_table(i).object_defaulting_api_pkg);htp.nl;
1500: htp.p('- object_defaulting_api_proc = '||ak_query_pkg.g_items_table(i).object_defaulting_api_proc);htp.nl;
1501: htp.p('- object_validation_api_pkg = '||ak_query_pkg.g_items_table(i).object_validation_api_pkg);htp.nl;
1502: htp.p('- object_validation_api_proc = '||ak_query_pkg.g_items_table(i).object_validation_api_proc);htp.nl;
1503: END LOOP;
1504:
1505: htp.p('===============================================================');htp.nl;
1506: htp.p('RESULTS');htp.nl;

Line 1508: htp.p('Total Results = '||to_char(ak_query_pkg.g_results_table.COUNT));htp.nl;

1504:
1505: htp.p('===============================================================');htp.nl;
1506: htp.p('RESULTS');htp.nl;
1507: htp.p('===============================================================');htp.nl;
1508: htp.p('Total Results = '||to_char(ak_query_pkg.g_results_table.COUNT));htp.nl;
1509:
1510: if ak_query_pkg.g_results_table.COUNT <> 0
1511: then
1512:

Line 1510: if ak_query_pkg.g_results_table.COUNT <> 0

1506: htp.p('RESULTS');htp.nl;
1507: htp.p('===============================================================');htp.nl;
1508: htp.p('Total Results = '||to_char(ak_query_pkg.g_results_table.COUNT));htp.nl;
1509:
1510: if ak_query_pkg.g_results_table.COUNT <> 0
1511: then
1512:
1513: FOR i IN ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST LOOP
1514: htp.p('Results Table Row ='||to_char(i));htp.nl;

Line 1513: FOR i IN ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST LOOP

1509:
1510: if ak_query_pkg.g_results_table.COUNT <> 0
1511: then
1512:
1513: FOR i IN ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST LOOP
1514: htp.p('Results Table Row ='||to_char(i));htp.nl;
1515: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_results_table(i).region_rec_id));htp.nl;
1516: htp.p('- key1 = '||ak_query_pkg.g_results_table(i).key1);htp.nl;
1517: htp.p('- key2 = '||ak_query_pkg.g_results_table(i).key2);htp.nl;

Line 1515: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_results_table(i).region_rec_id));htp.nl;

1511: then
1512:
1513: FOR i IN ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST LOOP
1514: htp.p('Results Table Row ='||to_char(i));htp.nl;
1515: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_results_table(i).region_rec_id));htp.nl;
1516: htp.p('- key1 = '||ak_query_pkg.g_results_table(i).key1);htp.nl;
1517: htp.p('- key2 = '||ak_query_pkg.g_results_table(i).key2);htp.nl;
1518: htp.p('- key3 = '||ak_query_pkg.g_results_table(i).key3);htp.nl;
1519: htp.p('- key4 = '||ak_query_pkg.g_results_table(i).key4);htp.nl;

Line 1516: htp.p('- key1 = '||ak_query_pkg.g_results_table(i).key1);htp.nl;

1512:
1513: FOR i IN ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST LOOP
1514: htp.p('Results Table Row ='||to_char(i));htp.nl;
1515: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_results_table(i).region_rec_id));htp.nl;
1516: htp.p('- key1 = '||ak_query_pkg.g_results_table(i).key1);htp.nl;
1517: htp.p('- key2 = '||ak_query_pkg.g_results_table(i).key2);htp.nl;
1518: htp.p('- key3 = '||ak_query_pkg.g_results_table(i).key3);htp.nl;
1519: htp.p('- key4 = '||ak_query_pkg.g_results_table(i).key4);htp.nl;
1520: htp.p('- key5 = '||ak_query_pkg.g_results_table(i).key5);htp.nl;

Line 1517: htp.p('- key2 = '||ak_query_pkg.g_results_table(i).key2);htp.nl;

1513: FOR i IN ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST LOOP
1514: htp.p('Results Table Row ='||to_char(i));htp.nl;
1515: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_results_table(i).region_rec_id));htp.nl;
1516: htp.p('- key1 = '||ak_query_pkg.g_results_table(i).key1);htp.nl;
1517: htp.p('- key2 = '||ak_query_pkg.g_results_table(i).key2);htp.nl;
1518: htp.p('- key3 = '||ak_query_pkg.g_results_table(i).key3);htp.nl;
1519: htp.p('- key4 = '||ak_query_pkg.g_results_table(i).key4);htp.nl;
1520: htp.p('- key5 = '||ak_query_pkg.g_results_table(i).key5);htp.nl;
1521: htp.p('- value1 = '||ak_query_pkg.g_results_table(i).value1);htp.nl;

Line 1518: htp.p('- key3 = '||ak_query_pkg.g_results_table(i).key3);htp.nl;

1514: htp.p('Results Table Row ='||to_char(i));htp.nl;
1515: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_results_table(i).region_rec_id));htp.nl;
1516: htp.p('- key1 = '||ak_query_pkg.g_results_table(i).key1);htp.nl;
1517: htp.p('- key2 = '||ak_query_pkg.g_results_table(i).key2);htp.nl;
1518: htp.p('- key3 = '||ak_query_pkg.g_results_table(i).key3);htp.nl;
1519: htp.p('- key4 = '||ak_query_pkg.g_results_table(i).key4);htp.nl;
1520: htp.p('- key5 = '||ak_query_pkg.g_results_table(i).key5);htp.nl;
1521: htp.p('- value1 = '||ak_query_pkg.g_results_table(i).value1);htp.nl;
1522: htp.p('- value2 = '||ak_query_pkg.g_results_table(i).value2);htp.nl;

Line 1519: htp.p('- key4 = '||ak_query_pkg.g_results_table(i).key4);htp.nl;

1515: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_results_table(i).region_rec_id));htp.nl;
1516: htp.p('- key1 = '||ak_query_pkg.g_results_table(i).key1);htp.nl;
1517: htp.p('- key2 = '||ak_query_pkg.g_results_table(i).key2);htp.nl;
1518: htp.p('- key3 = '||ak_query_pkg.g_results_table(i).key3);htp.nl;
1519: htp.p('- key4 = '||ak_query_pkg.g_results_table(i).key4);htp.nl;
1520: htp.p('- key5 = '||ak_query_pkg.g_results_table(i).key5);htp.nl;
1521: htp.p('- value1 = '||ak_query_pkg.g_results_table(i).value1);htp.nl;
1522: htp.p('- value2 = '||ak_query_pkg.g_results_table(i).value2);htp.nl;
1523: htp.p('- value3 = '||ak_query_pkg.g_results_table(i).value3);htp.nl;

Line 1520: htp.p('- key5 = '||ak_query_pkg.g_results_table(i).key5);htp.nl;

1516: htp.p('- key1 = '||ak_query_pkg.g_results_table(i).key1);htp.nl;
1517: htp.p('- key2 = '||ak_query_pkg.g_results_table(i).key2);htp.nl;
1518: htp.p('- key3 = '||ak_query_pkg.g_results_table(i).key3);htp.nl;
1519: htp.p('- key4 = '||ak_query_pkg.g_results_table(i).key4);htp.nl;
1520: htp.p('- key5 = '||ak_query_pkg.g_results_table(i).key5);htp.nl;
1521: htp.p('- value1 = '||ak_query_pkg.g_results_table(i).value1);htp.nl;
1522: htp.p('- value2 = '||ak_query_pkg.g_results_table(i).value2);htp.nl;
1523: htp.p('- value3 = '||ak_query_pkg.g_results_table(i).value3);htp.nl;
1524: htp.p('- value4 = '||ak_query_pkg.g_results_table(i).value4);htp.nl;

Line 1521: htp.p('- value1 = '||ak_query_pkg.g_results_table(i).value1);htp.nl;

1517: htp.p('- key2 = '||ak_query_pkg.g_results_table(i).key2);htp.nl;
1518: htp.p('- key3 = '||ak_query_pkg.g_results_table(i).key3);htp.nl;
1519: htp.p('- key4 = '||ak_query_pkg.g_results_table(i).key4);htp.nl;
1520: htp.p('- key5 = '||ak_query_pkg.g_results_table(i).key5);htp.nl;
1521: htp.p('- value1 = '||ak_query_pkg.g_results_table(i).value1);htp.nl;
1522: htp.p('- value2 = '||ak_query_pkg.g_results_table(i).value2);htp.nl;
1523: htp.p('- value3 = '||ak_query_pkg.g_results_table(i).value3);htp.nl;
1524: htp.p('- value4 = '||ak_query_pkg.g_results_table(i).value4);htp.nl;
1525: htp.p('- value5 = '||ak_query_pkg.g_results_table(i).value5);htp.nl;

Line 1522: htp.p('- value2 = '||ak_query_pkg.g_results_table(i).value2);htp.nl;

1518: htp.p('- key3 = '||ak_query_pkg.g_results_table(i).key3);htp.nl;
1519: htp.p('- key4 = '||ak_query_pkg.g_results_table(i).key4);htp.nl;
1520: htp.p('- key5 = '||ak_query_pkg.g_results_table(i).key5);htp.nl;
1521: htp.p('- value1 = '||ak_query_pkg.g_results_table(i).value1);htp.nl;
1522: htp.p('- value2 = '||ak_query_pkg.g_results_table(i).value2);htp.nl;
1523: htp.p('- value3 = '||ak_query_pkg.g_results_table(i).value3);htp.nl;
1524: htp.p('- value4 = '||ak_query_pkg.g_results_table(i).value4);htp.nl;
1525: htp.p('- value5 = '||ak_query_pkg.g_results_table(i).value5);htp.nl;
1526: htp.p('- value6 = '||ak_query_pkg.g_results_table(i).value6);htp.nl;

Line 1523: htp.p('- value3 = '||ak_query_pkg.g_results_table(i).value3);htp.nl;

1519: htp.p('- key4 = '||ak_query_pkg.g_results_table(i).key4);htp.nl;
1520: htp.p('- key5 = '||ak_query_pkg.g_results_table(i).key5);htp.nl;
1521: htp.p('- value1 = '||ak_query_pkg.g_results_table(i).value1);htp.nl;
1522: htp.p('- value2 = '||ak_query_pkg.g_results_table(i).value2);htp.nl;
1523: htp.p('- value3 = '||ak_query_pkg.g_results_table(i).value3);htp.nl;
1524: htp.p('- value4 = '||ak_query_pkg.g_results_table(i).value4);htp.nl;
1525: htp.p('- value5 = '||ak_query_pkg.g_results_table(i).value5);htp.nl;
1526: htp.p('- value6 = '||ak_query_pkg.g_results_table(i).value6);htp.nl;
1527: htp.p('- value7 = '||ak_query_pkg.g_results_table(i).value7);htp.nl;

Line 1524: htp.p('- value4 = '||ak_query_pkg.g_results_table(i).value4);htp.nl;

1520: htp.p('- key5 = '||ak_query_pkg.g_results_table(i).key5);htp.nl;
1521: htp.p('- value1 = '||ak_query_pkg.g_results_table(i).value1);htp.nl;
1522: htp.p('- value2 = '||ak_query_pkg.g_results_table(i).value2);htp.nl;
1523: htp.p('- value3 = '||ak_query_pkg.g_results_table(i).value3);htp.nl;
1524: htp.p('- value4 = '||ak_query_pkg.g_results_table(i).value4);htp.nl;
1525: htp.p('- value5 = '||ak_query_pkg.g_results_table(i).value5);htp.nl;
1526: htp.p('- value6 = '||ak_query_pkg.g_results_table(i).value6);htp.nl;
1527: htp.p('- value7 = '||ak_query_pkg.g_results_table(i).value7);htp.nl;
1528: htp.p('- value8 = '||ak_query_pkg.g_results_table(i).value8);htp.nl;

Line 1525: htp.p('- value5 = '||ak_query_pkg.g_results_table(i).value5);htp.nl;

1521: htp.p('- value1 = '||ak_query_pkg.g_results_table(i).value1);htp.nl;
1522: htp.p('- value2 = '||ak_query_pkg.g_results_table(i).value2);htp.nl;
1523: htp.p('- value3 = '||ak_query_pkg.g_results_table(i).value3);htp.nl;
1524: htp.p('- value4 = '||ak_query_pkg.g_results_table(i).value4);htp.nl;
1525: htp.p('- value5 = '||ak_query_pkg.g_results_table(i).value5);htp.nl;
1526: htp.p('- value6 = '||ak_query_pkg.g_results_table(i).value6);htp.nl;
1527: htp.p('- value7 = '||ak_query_pkg.g_results_table(i).value7);htp.nl;
1528: htp.p('- value8 = '||ak_query_pkg.g_results_table(i).value8);htp.nl;
1529: htp.p('- value9 = '||ak_query_pkg.g_results_table(i).value9);htp.nl;

Line 1526: htp.p('- value6 = '||ak_query_pkg.g_results_table(i).value6);htp.nl;

1522: htp.p('- value2 = '||ak_query_pkg.g_results_table(i).value2);htp.nl;
1523: htp.p('- value3 = '||ak_query_pkg.g_results_table(i).value3);htp.nl;
1524: htp.p('- value4 = '||ak_query_pkg.g_results_table(i).value4);htp.nl;
1525: htp.p('- value5 = '||ak_query_pkg.g_results_table(i).value5);htp.nl;
1526: htp.p('- value6 = '||ak_query_pkg.g_results_table(i).value6);htp.nl;
1527: htp.p('- value7 = '||ak_query_pkg.g_results_table(i).value7);htp.nl;
1528: htp.p('- value8 = '||ak_query_pkg.g_results_table(i).value8);htp.nl;
1529: htp.p('- value9 = '||ak_query_pkg.g_results_table(i).value9);htp.nl;
1530: htp.p('- value10 = '||ak_query_pkg.g_results_table(i).value10);htp.nl;

Line 1527: htp.p('- value7 = '||ak_query_pkg.g_results_table(i).value7);htp.nl;

1523: htp.p('- value3 = '||ak_query_pkg.g_results_table(i).value3);htp.nl;
1524: htp.p('- value4 = '||ak_query_pkg.g_results_table(i).value4);htp.nl;
1525: htp.p('- value5 = '||ak_query_pkg.g_results_table(i).value5);htp.nl;
1526: htp.p('- value6 = '||ak_query_pkg.g_results_table(i).value6);htp.nl;
1527: htp.p('- value7 = '||ak_query_pkg.g_results_table(i).value7);htp.nl;
1528: htp.p('- value8 = '||ak_query_pkg.g_results_table(i).value8);htp.nl;
1529: htp.p('- value9 = '||ak_query_pkg.g_results_table(i).value9);htp.nl;
1530: htp.p('- value10 = '||ak_query_pkg.g_results_table(i).value10);htp.nl;
1531: END LOOP;

Line 1528: htp.p('- value8 = '||ak_query_pkg.g_results_table(i).value8);htp.nl;

1524: htp.p('- value4 = '||ak_query_pkg.g_results_table(i).value4);htp.nl;
1525: htp.p('- value5 = '||ak_query_pkg.g_results_table(i).value5);htp.nl;
1526: htp.p('- value6 = '||ak_query_pkg.g_results_table(i).value6);htp.nl;
1527: htp.p('- value7 = '||ak_query_pkg.g_results_table(i).value7);htp.nl;
1528: htp.p('- value8 = '||ak_query_pkg.g_results_table(i).value8);htp.nl;
1529: htp.p('- value9 = '||ak_query_pkg.g_results_table(i).value9);htp.nl;
1530: htp.p('- value10 = '||ak_query_pkg.g_results_table(i).value10);htp.nl;
1531: END LOOP;
1532:

Line 1529: htp.p('- value9 = '||ak_query_pkg.g_results_table(i).value9);htp.nl;

1525: htp.p('- value5 = '||ak_query_pkg.g_results_table(i).value5);htp.nl;
1526: htp.p('- value6 = '||ak_query_pkg.g_results_table(i).value6);htp.nl;
1527: htp.p('- value7 = '||ak_query_pkg.g_results_table(i).value7);htp.nl;
1528: htp.p('- value8 = '||ak_query_pkg.g_results_table(i).value8);htp.nl;
1529: htp.p('- value9 = '||ak_query_pkg.g_results_table(i).value9);htp.nl;
1530: htp.p('- value10 = '||ak_query_pkg.g_results_table(i).value10);htp.nl;
1531: END LOOP;
1532:
1533: end if;

Line 1530: htp.p('- value10 = '||ak_query_pkg.g_results_table(i).value10);htp.nl;

1526: htp.p('- value6 = '||ak_query_pkg.g_results_table(i).value6);htp.nl;
1527: htp.p('- value7 = '||ak_query_pkg.g_results_table(i).value7);htp.nl;
1528: htp.p('- value8 = '||ak_query_pkg.g_results_table(i).value8);htp.nl;
1529: htp.p('- value9 = '||ak_query_pkg.g_results_table(i).value9);htp.nl;
1530: htp.p('- value10 = '||ak_query_pkg.g_results_table(i).value10);htp.nl;
1531: END LOOP;
1532:
1533: end if;
1534: