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_CABO dependencies on AK_QUERY_PKG

Line 698: l_flow_appl_id := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).flow_application_id;

694: icx_cabo.g_plsql_agent := icx_cabo.plsqlagent;
695:
696: -- select HSECS into l_timer from v$timer;htp.p('begin displayPage @ '||l_timer);htp.nl;
697:
698: l_flow_appl_id := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).flow_application_id;
699: l_flow_code := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).flow_code;
700: l_page_appl_id := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).page_application_id;
701: l_page_code := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).page_code;
702:

Line 699: l_flow_code := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).flow_code;

695:
696: -- select HSECS into l_timer from v$timer;htp.p('begin displayPage @ '||l_timer);htp.nl;
697:
698: l_flow_appl_id := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).flow_application_id;
699: l_flow_code := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).flow_code;
700: l_page_appl_id := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).page_application_id;
701: l_page_code := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).page_code;
702:
703: select NAME,DESCRIPTION

Line 700: l_page_appl_id := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).page_application_id;

696: -- select HSECS into l_timer from v$timer;htp.p('begin displayPage @ '||l_timer);htp.nl;
697:
698: l_flow_appl_id := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).flow_application_id;
699: l_flow_code := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).flow_code;
700: l_page_appl_id := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).page_application_id;
701: l_page_code := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).page_code;
702:
703: select NAME,DESCRIPTION
704: into l_page_title,l_page_description

Line 701: l_page_code := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).page_code;

697:
698: l_flow_appl_id := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).flow_application_id;
699: l_flow_code := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).flow_code;
700: l_page_appl_id := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).page_application_id;
701: l_page_code := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).page_code;
702:
703: select NAME,DESCRIPTION
704: into l_page_title,l_page_description
705: from AK_FLOW_PAGES_VL

Line 747: if ak_query_pkg.g_results_table.COUNT = 0

743: htp.p('

');
746:
747: if ak_query_pkg.g_results_table.COUNT = 0
748: then
749: htp.p('');
750: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
751: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(0).name);

Line 749: htp.p('');

745: htp.p('');
746:
747: if ak_query_pkg.g_results_table.COUNT = 0
748: then
749: htp.p('');
750: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
751: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(0).name);
752: l_message := fnd_message.get;
753:

Line 751: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(0).name);

747: if ak_query_pkg.g_results_table.COUNT = 0
748: then
749: htp.p('');
750: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
751: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(0).name);
752: l_message := fnd_message.get;
753:
754: htp.strong(l_message);htp.nl;
755:

Line 760: l_region_count := ak_query_pkg.g_regions_table.COUNT-1;

756: else
757: l_continue := TRUE;
758:
759: -- bubble sort for bug 625660
760: l_region_count := ak_query_pkg.g_regions_table.COUNT-1;
761:
762: if l_region_count > 0
763: then
764:

Line 767: l_region_seq(x) := ak_query_pkg.g_regions_table(x).display_sequence;

763: then
764:
765: for x in 0..l_region_count loop
766: l_region(x) := x;
767: l_region_seq(x) := ak_query_pkg.g_regions_table(x).display_sequence;
768: end loop;
769:
770: for x in 0..l_region_count-1 loop
771: for y in 0..l_region_count-1-x loop

Line 785: ak_query_pkg.g_regions_table(l_region(x)).display_sequence := x;

781: end loop;
782: end loop;
783:
784: for x in 0..l_region_count loop
785: ak_query_pkg.g_regions_table(l_region(x)).display_sequence := x;
786: end loop;
787:
788: else
789: ak_query_pkg.g_regions_table(0).display_sequence := 0;

Line 789: ak_query_pkg.g_regions_table(0).display_sequence := 0;

785: ak_query_pkg.g_regions_table(l_region(x)).display_sequence := x;
786: end loop;
787:
788: else
789: ak_query_pkg.g_regions_table(0).display_sequence := 0;
790: end if;
791:
792: -- second region loop added for bug 591931
793: for c in 0..l_region_count loop

Line 796: if r = ak_query_pkg.g_regions_table(c).display_sequence

792: -- second region loop added for bug 591931
793: for c in 0..l_region_count loop
794: for r in 0..l_region_count loop
795:
796: if r = ak_query_pkg.g_regions_table(c).display_sequence
797: then
798:
799: if l_continue
800: then

Line 805: where REGION_APPLICATION_ID = ak_query_pkg.g_regions_table(r).region_application_id

801:
802: select DESCRIPTION
803: into l_region_description
804: from AK_REGIONS_VL
805: where REGION_APPLICATION_ID = ak_query_pkg.g_regions_table(r).region_application_id
806: and REGION_CODE = ak_query_pkg.g_regions_table(r).region_code;
807:
808: if l_region_description is not null
809: then

Line 806: and REGION_CODE = ak_query_pkg.g_regions_table(r).region_code;

802: select DESCRIPTION
803: into l_region_description
804: from AK_REGIONS_VL
805: where REGION_APPLICATION_ID = ak_query_pkg.g_regions_table(r).region_application_id
806: and REGION_CODE = ak_query_pkg.g_regions_table(r).region_code;
807:
808: if l_region_description is not null
809: then
810: htp.p(l_region_description);

Line 813: htp.p('');

809: then
810: htp.p(l_region_description);
811: end if;
812:
813: htp.p('');
814:
815: if ak_query_pkg.g_regions_table(r).total_result_count = 0
816: then
817: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');

Line 815: if ak_query_pkg.g_regions_table(r).total_result_count = 0

811: end if;
812:
813: htp.p('');
814:
815: if ak_query_pkg.g_regions_table(r).total_result_count = 0
816: then
817: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
818: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(r).name);
819: l_message := fnd_message.get;

Line 818: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(r).name);

814:
815: if ak_query_pkg.g_regions_table(r).total_result_count = 0
816: then
817: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
818: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(r).name);
819: l_message := fnd_message.get;
820:
821: htp.strong(l_message);htp.nl;
822:

Line 823: elsif ak_query_pkg.g_regions_table(r).region_style = 'FORM'

819: l_message := fnd_message.get;
820:
821: htp.strong(l_message);htp.nl;
822:
823: elsif ak_query_pkg.g_regions_table(r).region_style = 'FORM'
824: and ak_query_pkg.g_regions_table(r).total_result_count > 1
825: then
826: fnd_message.set_name('ICX','ICX_LIMIT_ROWS_ONE');
827: l_message := fnd_message.get;

Line 824: and ak_query_pkg.g_regions_table(r).total_result_count > 1

820:
821: htp.strong(l_message);htp.nl;
822:
823: elsif ak_query_pkg.g_regions_table(r).region_style = 'FORM'
824: and ak_query_pkg.g_regions_table(r).total_result_count > 1
825: then
826: fnd_message.set_name('ICX','ICX_LIMIT_ROWS_ONE');
827: l_message := fnd_message.get;
828:

Line 832: icx_on_utilities2.displayRegion(ak_query_pkg.g_regions_table(r).region_rec_id);

828:
829: htp.strong(l_message);
830: l_continue := FALSE;
831: else
832: icx_on_utilities2.displayRegion(ak_query_pkg.g_regions_table(r).region_rec_id);
833: end if; -- total_result_count = 0
834: end if; -- l_continue
835: end if; -- display_sequence
836:

Line 915: ak_query_pkg.g_regions_table(0).flow_application_id := 0;

911: p_helpmsg => l_page_description,
912: p_helptitle => '',
913: p_url => icx_cabo.g_base_href||icx_cabo.g_plsql_agent||'oracleON.DisplayWhere?X='||l_X);
914:
915: ak_query_pkg.g_regions_table(0).flow_application_id := 0;
916:
917: end;
918:
919: procedure WFPage is

Line 992: ak_query_pkg.g_regions_table(0).flow_application_id := 0;

988: p_helptitle => '',
989: p_url => icx_cabo.g_base_href||icx_cabo.g_plsql_agent||'ora
990: cleON.IC?Y='||l_X);
991:
992: ak_query_pkg.g_regions_table(0).flow_application_id := 0;
993:
994: end;
995:
996: end icx_on_cabo;