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

Line 847: l_query_binds ak_query_pkg.bind_tab;

843:
844: l_range_low number;
845: l_range_high number;
846: l_where_clause varchar2(2000);
847: l_query_binds ak_query_pkg.bind_tab;
848: l_max_rows number;
849: e_max_rows exception;
850: l_err_mesg varchar2(240);
851:

Line 1047: ak_query_pkg.g_regions_table(0).flow_application_id := -1;

1043: else
1044:
1045: c_type := 'Z';
1046: c_continue := FALSE;
1047: ak_query_pkg.g_regions_table(0).flow_application_id := -1;
1048:
1049: end if;
1050:
1051: -- ************* End Custom Call *************************

Line 1086: htp.p('DEBUG MESSAGE ak_query_pkg.exec_query('''||l_flow_appl_id||''','''||l_flow_code||''','''||c_to_page_appl_id||''','''||c_to_page_code||''','||c_to_region_appl_id||','''||c_to_region_code

1082: unpack_whereSegment(p_where,l_where_clause,l_query_binds);
1083:
1084: /* DEBUG TRACE
1085: htp.p('p_where = '||p_where);htp.nl;
1086: htp.p('DEBUG MESSAGE ak_query_pkg.exec_query('''||l_flow_appl_id||''','''||l_flow_code||''','''||c_to_page_appl_id||''','''||c_to_page_code||''','||c_to_region_appl_id||','''||c_to_region_code
1087: ||''','''||''','''||''','''||''','''||''','''||''','''||''','''||''','''||''','''||''','''||''','''||''','''||
1088: c_to_page_appl_id||''','''||c_to_page_code||''','''||l_where_clause||''','''||''','||l_responsibility_id||','||l_user_id||',T,'||l_return_children||',F,F,'||l_range_low||','||l_range_high||')');htp.nl;
1089: if l_query_binds.COUNT > 0 then
1090: for i in l_query_binds.FIRST..l_query_binds.LAST loop

Line 1096: ak_query_pkg.exec_query(

1092: end loop;
1093: end if;
1094: */
1095:
1096: ak_query_pkg.exec_query(
1097: P_FLOW_APPL_ID => l_flow_appl_id,
1098: P_FLOW_CODE => l_flow_code,
1099: P_PARENT_PAGE_APPL_ID => c_to_page_appl_id,
1100: P_PARENT_PAGE_CODE => c_to_page_code,

Line 1116: if ak_query_pkg.g_regions_table(0).total_result_count = l_max_rows

1112: P_RANGE_LOW => l_start,
1113: P_RANGE_HIGH => l_end,
1114: P_MAX_ROWS => l_max_rows);
1115:
1116: if ak_query_pkg.g_regions_table(0).total_result_count = l_max_rows
1117: then
1118: raise e_max_rows;
1119: end if;
1120:

Line 1147: htp.p('DEBUG MESSAGE ak_query_pkg.exec_query('||l_flow_appl_id||','''||l_flow_code||''','||c_from_page_appl_id||','''||c_from_page_code||''','||c_from_region_appl_id||','''||c_from_region_code

1143: /* DEBUG
1144: set serverout on size 200000;
1145: ALTER SESSION SET SQL_TRACE TRUE;
1146: execute
1147: htp.p('DEBUG MESSAGE ak_query_pkg.exec_query('||l_flow_appl_id||','''||l_flow_code||''','||c_from_page_appl_id||','''||c_from_page_code||''','||c_from_region_appl_id||','''||c_from_region_code
1148: ||''','''||c_unique_key_name||''','''||c_keys(1)||''','''||c_keys(2)||''','''||c_keys(3)||''','''||c_keys(4)||''','''||c_keys(5)||''','''||c_keys(6)||''','''||c_keys(7)||''','''||c_keys(8)||''','''||c_keys(9)||''','''||c_keys(10)
1149: ||''','''||c_to_page_appl_id||''','''||c_to_page_code||''','''||''','''||''','||l_responsibility_id||','||l_user_id||',F,T,F,F)');
1150: ALTER SESSION SET SQL_TRACE FALSE;
1151: */

Line 1157: ak_query_pkg.exec_query(

1153: -- select HSECS into l_timer from v$timer;htp.p('start exec_query PK @ '||l_timer);htp.nl;
1154:
1155: -- dbms_session.set_sql_trace(TRUE);
1156:
1157: ak_query_pkg.exec_query(
1158: P_FLOW_APPL_ID => l_flow_appl_id,
1159: P_FLOW_CODE => l_flow_code,
1160: P_PARENT_PAGE_APPL_ID => c_from_page_appl_id,
1161: P_PARENT_PAGE_CODE => c_from_page_code,

Line 1202: ak_query_pkg.g_regions_table(0).flow_application_id := -1;

1198: icx_util.add_error(l_err_mesg);
1199: icx_admin_sig.error_screen(l_err_mesg);
1200: c_type := 'Z';
1201: c_continue := FALSE;
1202: ak_query_pkg.g_regions_table(0).flow_application_id := -1;
1203: end;
1204:
1205: procedure displayPage is
1206:

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

1230: begin
1231:
1232: -- select HSECS into l_timer from v$timer;htp.p('begin displayPage @ '||l_timer);htp.nl;
1233:
1234: l_flow_appl_id := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).flow_application_id;
1235: l_flow_code := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).flow_code;
1236: l_page_appl_id := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).page_application_id;
1237: l_page_code := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).page_code;
1238:

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

1231:
1232: -- select HSECS into l_timer from v$timer;htp.p('begin displayPage @ '||l_timer);htp.nl;
1233:
1234: l_flow_appl_id := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).flow_application_id;
1235: l_flow_code := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).flow_code;
1236: l_page_appl_id := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).page_application_id;
1237: l_page_code := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).page_code;
1238:
1239: select NAME,DESCRIPTION

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

1232: -- select HSECS into l_timer from v$timer;htp.p('begin displayPage @ '||l_timer);htp.nl;
1233:
1234: l_flow_appl_id := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).flow_application_id;
1235: l_flow_code := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).flow_code;
1236: l_page_appl_id := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).page_application_id;
1237: l_page_code := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).page_code;
1238:
1239: select NAME,DESCRIPTION
1240: into l_page_title,l_page_description

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

1233:
1234: l_flow_appl_id := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).flow_application_id;
1235: l_flow_code := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).flow_code;
1236: l_page_appl_id := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).page_application_id;
1237: l_page_code := ak_query_pkg.g_regions_table(ak_query_pkg.g_regions_table.FIRST).page_code;
1238:
1239: select NAME,DESCRIPTION
1240: into l_page_title,l_page_description
1241: from AK_FLOW_PAGES_VL

Line 1294: if ak_query_pkg.g_results_table.COUNT = 0

1290:
1291: htp.p(''||l_page_title||' '||l_page_description);
1292: htp.nl;
1293:
1294: if ak_query_pkg.g_results_table.COUNT = 0
1295: then
1296: htp.p('');
1297: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
1298: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(0).name);

Line 1296: htp.p('');

1292: htp.nl;
1293:
1294: if ak_query_pkg.g_results_table.COUNT = 0
1295: then
1296: htp.p('');
1297: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
1298: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(0).name);
1299: l_message := fnd_message.get;
1300:

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

1294: if ak_query_pkg.g_results_table.COUNT = 0
1295: then
1296: htp.p('');
1297: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
1298: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(0).name);
1299: l_message := fnd_message.get;
1300:
1301: htp.strong(l_message);htp.nl;
1302:

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

1303: else
1304: l_continue := TRUE;
1305:
1306: -- bubble sort for bug 625660
1307: l_region_count := ak_query_pkg.g_regions_table.COUNT-1;
1308:
1309: if l_region_count > 0
1310: then
1311:

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

1310: then
1311:
1312: for x in 0..l_region_count loop
1313: l_region(x) := x;
1314: l_region_seq(x) := ak_query_pkg.g_regions_table(x).display_sequence;
1315: end loop;
1316:
1317: for x in 0..l_region_count-1 loop
1318: for y in 0..l_region_count-1-x loop

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

1328: end loop;
1329: end loop;
1330:
1331: for x in 0..l_region_count loop
1332: ak_query_pkg.g_regions_table(l_region(x)).display_sequence := x;
1333: end loop;
1334:
1335: else
1336: ak_query_pkg.g_regions_table(0).display_sequence := 0;

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

1332: ak_query_pkg.g_regions_table(l_region(x)).display_sequence := x;
1333: end loop;
1334:
1335: else
1336: ak_query_pkg.g_regions_table(0).display_sequence := 0;
1337: end if;
1338:
1339: -- second region loop added for bug 591931
1340: for c in 0..l_region_count loop

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

1339: -- second region loop added for bug 591931
1340: for c in 0..l_region_count loop
1341: for r in 0..l_region_count loop
1342:
1343: if r = ak_query_pkg.g_regions_table(c).display_sequence
1344: then
1345:
1346: if l_continue
1347: then

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

1348:
1349: select DESCRIPTION
1350: into l_region_description
1351: from AK_REGIONS_VL
1352: where REGION_APPLICATION_ID = ak_query_pkg.g_regions_table(r).region_application_id
1353: and REGION_CODE = ak_query_pkg.g_regions_table(r).region_code;
1354:
1355: if l_region_description is not null
1356: then

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

1349: select DESCRIPTION
1350: into l_region_description
1351: from AK_REGIONS_VL
1352: where REGION_APPLICATION_ID = ak_query_pkg.g_regions_table(r).region_application_id
1353: and REGION_CODE = ak_query_pkg.g_regions_table(r).region_code;
1354:
1355: if l_region_description is not null
1356: then
1357: htp.p(l_region_description);

Line 1360: htp.p('');

1356: then
1357: htp.p(l_region_description);
1358: end if;
1359:
1360: htp.p('');
1361:
1362: if ak_query_pkg.g_regions_table(r).total_result_count = 0
1363: then
1364: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');

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

1358: end if;
1359:
1360: htp.p('');
1361:
1362: if ak_query_pkg.g_regions_table(r).total_result_count = 0
1363: then
1364: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
1365: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(r).name);
1366: l_message := fnd_message.get;

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

1361:
1362: if ak_query_pkg.g_regions_table(r).total_result_count = 0
1363: then
1364: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
1365: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(r).name);
1366: l_message := fnd_message.get;
1367:
1368: htp.strong(l_message);htp.nl;
1369:

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

1366: l_message := fnd_message.get;
1367:
1368: htp.strong(l_message);htp.nl;
1369:
1370: elsif ak_query_pkg.g_regions_table(r).region_style = 'FORM'
1371: and ak_query_pkg.g_regions_table(r).total_result_count > 1
1372: then
1373: fnd_message.set_name('ICX','ICX_LIMIT_ROWS_ONE');
1374: l_message := fnd_message.get;

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

1367:
1368: htp.strong(l_message);htp.nl;
1369:
1370: elsif ak_query_pkg.g_regions_table(r).region_style = 'FORM'
1371: and ak_query_pkg.g_regions_table(r).total_result_count > 1
1372: then
1373: fnd_message.set_name('ICX','ICX_LIMIT_ROWS_ONE');
1374: l_message := fnd_message.get;
1375:

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

1375:
1376: htp.strong(l_message);
1377: l_continue := FALSE;
1378: else
1379: icx_on_utilities2.displayRegion(ak_query_pkg.g_regions_table(r).region_rec_id);
1380: end if; -- total_result_count = 0
1381: end if; -- l_continue
1382: end if; -- display_sequence
1383:

Line 1930: p_query_binds out NOCOPY ak_query_pkg.bind_tab) is

1926: end;
1927:
1928: procedure unpack_whereSegment(p_whereSegment in varchar2,
1929: p_where_clause out NOCOPY varchar2,
1930: p_query_binds out NOCOPY ak_query_pkg.bind_tab) is
1931: l_parameters v2000_table;
1932: l_index number;
1933: begin
1934:

Line 1954: p_query_binds IN out NOCOPY ak_query_pkg.bind_tab,

1950: end if;
1951: end;
1952:
1953: procedure unpack_whereSegment (p_whereSegment in varchar2,
1954: p_query_binds IN out NOCOPY ak_query_pkg.bind_tab,
1955: p_query_binds_index IN NUMBER) is
1956: -- This version of unpack_whereSegment is used with an additional bound where
1957: -- clause being passed to ICX from the product teams.
1958: l_parameters v2000_table;