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.BIS_PMV_PMF_PVT dependencies on AK_REGION_ITEMS

Line 447: FROM ak_region_items ak

443: ---jprabhud added Cursor, also added VIEWBY PARAMETER in where clause for enhancement#2184054
444:
445: CURSOR c_dimlvl(p_search_string IN VARCHAR2, p_view_by_level IN VARCHAR2 ) IS
446: select attribute2
447: FROM ak_region_items ak
448: where ak.region_code = p_region_code
449: AND ak.attribute1 in (G_DIMENSION_LEVEL, G_DIM_LEVEL_SINGLE_VALUE,G_VIEWBY_PARAMETER)
450: AND substr(ak.attribute2, instr(ak.attribute2, '+')+1)
451: = nvl(p_view_by_level, substr(ak.attribute2, instr(ak.attribute2, '+')+1))

Line 457: select nested_region_code from ak_region_items

453: like nvl(p_search_string, substr(ak.attribute2, 1,instr(ak.attribute2, '+')-1))
454: order by display_sequence;
455: --BugFix 3280466
456: CURSOR get_nested_region IS
457: select nested_region_code from ak_region_items
458: where region_code = p_region_code
459: and nested_region_code is not null;
460:
461:

Line 490: from ak_region_items_vl AK

486: begin
487: --BugFix 3280466 Changed all the sqls to also check from Nested Region
488: select DISTINCT nvl(attribute2,attribute_code)
489: into vParameter1
490: from ak_region_items_vl AK
491: where ak.region_code in ( p_region_code, l_nested_region_code)
492: AND nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm1Level_short_name
493: AND ak.node_query_flag = 'Y';
494: IF ( p_parm1Level_short_name ='AS_OF_DATE') THEN

Line 513: from ak_region_items_vl AK

509: begin
510:
511: select DISTINCT nvl(attribute2,attribute_code)
512: into vParameter2
513: from ak_region_items_vl AK
514: where ak.region_code in ( p_region_code, l_nested_region_code)
515: AND nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm2Level_short_name
516: AND ak.node_query_flag = 'Y';
517: IF ( p_parm2Level_short_name ='AS_OF_DATE') THEN

Line 536: from ak_region_items_vl AK

532: IF ( p_parm3Level_short_name IS NOT NULL) THEN
533: begin
534: select DISTINCT nvl(attribute2,attribute_code)
535: into vParameter3
536: from ak_region_items_vl AK
537: where ak.region_code in ( p_region_code, l_nested_region_code)
538: AND nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm3Level_short_name
539: AND ak.node_query_flag = 'Y';
540: IF ( p_parm3Level_short_name ='AS_OF_DATE') THEN

Line 560: from ak_region_items_vl AK

556: IF ( p_parm4Level_short_name IS NOT NULL) THEN
557: begin
558: select DISTINCT nvl(attribute2,attribute_code)
559: into vParameter4
560: from ak_region_items_vl AK
561: where ak.region_code in ( p_region_code, l_nested_region_code)
562: AND nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm4Level_short_name
563: AND ak.node_query_flag = 'Y';
564: IF ( p_parm4Level_short_name ='AS_OF_DATE') THEN

Line 583: from ak_region_items_vl AK

579: IF ( p_parm5Level_short_name IS NOT NULL) THEN
580: begin
581: select DISTINCT nvl(attribute2,attribute_code)
582: into vParameter5
583: from ak_region_items_vl AK
584: where ak.region_code in ( p_region_code, l_nested_region_code)
585: AND nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm5Level_short_name
586: AND ak.node_query_flag = 'Y';
587: IF ( p_parm5Level_short_name ='AS_OF_DATE') THEN

Line 606: from ak_region_items_vl AK

602: IF ( p_parm6Level_short_name IS NOT NULL) THEN
603: begin
604: select DISTINCT nvl(attribute2,attribute_code)
605: into vParameter6
606: from ak_region_items_vl AK
607: where ak.region_code in ( p_region_code, l_nested_region_code)
608: AND nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm6Level_short_name
609: AND ak.node_query_flag = 'Y';
610: IF ( p_parm6Level_short_name ='AS_OF_DATE') THEN

Line 629: from ak_region_items_vl AK

625: IF ( p_parm7Level_short_name IS NOT NULL) THEN
626: begin
627: select DISTINCT nvl(attribute2,attribute_code)
628: into vParameter7
629: from ak_region_items_vl AK
630: where ak.region_code = p_region_code
631: AND substr(ak.attribute2, instr(ak.attribute2, '+')+1) = p_parm7Level_short_name
632: AND ak.node_query_flag = 'Y';
633: exception

Line 649: from ak_region_items_vl AK

645: IF ( p_parm8Level_short_name IS NOT NULL) THEN
646: begin
647: select DISTINCT nvl(attribute2,attribute_code)
648: into vParameter8
649: from ak_region_items_vl AK
650: where ak.region_code in ( p_region_code, l_nested_region_code)
651: AND nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm8Level_short_name
652: AND ak.node_query_flag = 'Y';
653: IF ( p_parm8Level_short_name ='AS_OF_DATE') THEN

Line 672: from ak_region_items_vl AK

668: IF ( p_parm9Level_short_name IS NOT NULL) THEN
669: begin
670: select DISTINCT nvl(attribute2,attribute_code)
671: into vParameter9
672: from ak_region_items_vl AK
673: where ak.region_code in ( p_region_code, l_nested_region_code)
674: AND nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm9Level_short_name
675: AND ak.node_query_flag = 'Y';
676: IF ( p_parm9Level_short_name ='AS_OF_DATE') THEN

Line 695: from ak_region_items_vl AK

691: IF ( p_parm10Level_short_name IS NOT NULL) THEN
692: begin
693: select DISTINCT nvl(attribute2,attribute_code)
694: into vParameter10
695: from ak_region_items_vl AK
696: where ak.region_code in ( p_region_code, l_nested_region_code)
697: AND nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm10Level_short_name
698: AND ak.node_query_flag = 'Y';
699: IF ( p_parm10Level_short_name ='AS_OF_DATE') THEN

Line 718: from ak_region_items_vl AK

714: IF ( p_parm11Level_short_name IS NOT NULL) THEN
715: begin
716: select DISTINCT nvl(attribute2,attribute_code)
717: into vParameter11
718: from ak_region_items_vl AK
719: where ak.region_code in ( p_region_code, l_nested_region_code)
720: AND nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm11Level_short_name
721: AND ak.node_query_flag = 'Y';
722: IF ( p_parm11Level_short_name ='AS_OF_DATE') THEN

Line 741: from ak_region_items_vl AK

737: IF ( p_parm12Level_short_name IS NOT NULL) THEN
738: begin
739: select DISTINCT nvl(attribute2,attribute_code)
740: into vParameter12
741: from ak_region_items_vl AK
742: where ak.region_code in ( p_region_code, l_nested_region_code)
743: AND nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm12Level_short_name
744: AND ak.node_query_flag = 'Y';
745: IF ( p_parm12Level_short_name ='AS_OF_DATE') THEN

Line 764: from ak_region_items_vl AK

760: IF ( p_parm13Level_short_name IS NOT NULL) THEN
761: begin
762: select DISTINCT nvl(attribute2,attribute_code)
763: into vParameter13
764: from ak_region_items_vl AK
765: where ak.region_code in ( p_region_code, l_nested_region_code)
766: AND nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm13Level_short_name
767: AND ak.node_query_flag = 'Y';
768: IF ( p_parm13Level_short_name ='AS_OF_DATE') THEN

Line 794: from ak_region_items_vl AK

790: vParameter15 := 'VIEW_BY';
791: begin
792: Select attribute2
793: into vParm15Value_name
794: from ak_region_items_vl AK
795: where ak.region_code = p_region_code
796: AND substr(ak.attribute2, instr(ak.attribute2, '+')+1) = p_viewby_level_short_name
797: AND ak.attribute1 in ('DIMENSION LEVEL', 'DIM LEVEL SINGLE VALUE');
798: exception

Line 871: from ak_region_items_vl AK

867: IF (p_TimeFromparmValue_name IS NOT NULL) THEN
868: begin
869: Select nvl(attribute2,attribute_code)
870: into vTimeParameter
871: from ak_region_items_vl AK
872: where ak.region_code = p_region_code
873: AND substr(ak.attribute2, instr(ak.attribute2, '+')+1) = p_TimeparmLevel_short_name
874: AND ak.attribute1 in ('DIMENSION LEVEL', 'DIM LEVEL SINGLE VALUE', 'HIDE VIEW BY DIMENSION');
875: exception

Line 1117: FROM ak_region_items ak

1113: ---jprabhud added Cursor, also added VIEWBY PARAMETER in where clause for enhancement#2184054
1114:
1115: CURSOR c_dimlvl(p_search_string IN VARCHAR2, p_view_by_level IN VARCHAR2 ) IS
1116: select attribute2
1117: FROM ak_region_items ak
1118: where ak.region_code = p_region_code
1119: AND ak.attribute1 in (G_DIMENSION_LEVEL, G_DIM_LEVEL_SINGLE_VALUE,G_VIEWBY_PARAMETER)
1120: AND substr(ak.attribute2, instr(ak.attribute2, '+')+1)
1121: = nvl(p_view_by_level, substr(ak.attribute2, instr(ak.attribute2, '+')+1))

Line 1127: select nested_region_code from ak_region_items

1123: like nvl(p_search_string, substr(ak.attribute2, 1,instr(ak.attribute2, '+')-1))
1124: order by display_sequence;
1125: --BugFix 3280466
1126: CURSOR get_nested_region IS
1127: select nested_region_code from ak_region_items
1128: where region_code = p_region_code
1129: and nested_region_code is not null;
1130:
1131:

Line 1162: from ak_region_items_vl AK

1158: begin
1159: --BugFix 3280466 Changed all the sqls to also check from Nested Region
1160: select DISTINCT nvl(attribute2,attribute_code)
1161: into vParameter1
1162: from ak_region_items_vl AK
1163: where ak.region_code in ( p_region_code, l_nested_region_code)
1164: AND nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm1Level_short_name
1165: AND ak.node_query_flag = 'Y';
1166: IF ( p_parm1Level_short_name ='AS_OF_DATE') THEN

Line 1185: from ak_region_items_vl AK

1181: begin
1182:
1183: select DISTINCT nvl(attribute2,attribute_code)
1184: into vParameter2
1185: from ak_region_items_vl AK
1186: where ak.region_code in ( p_region_code, l_nested_region_code)
1187: AND nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm2Level_short_name
1188: AND ak.node_query_flag = 'Y';
1189: IF ( p_parm2Level_short_name ='AS_OF_DATE') THEN

Line 1208: from ak_region_items_vl AK

1204: IF ( p_parm3Level_short_name IS NOT NULL) THEN
1205: begin
1206: select DISTINCT nvl(attribute2,attribute_code)
1207: into vParameter3
1208: from ak_region_items_vl AK
1209: where ak.region_code in ( p_region_code, l_nested_region_code)
1210: AND nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm3Level_short_name
1211: AND ak.node_query_flag = 'Y';
1212: IF ( p_parm3Level_short_name ='AS_OF_DATE') THEN

Line 1232: from ak_region_items_vl AK

1228: IF ( p_parm4Level_short_name IS NOT NULL) THEN
1229: begin
1230: select DISTINCT nvl(attribute2,attribute_code)
1231: into vParameter4
1232: from ak_region_items_vl AK
1233: where ak.region_code in ( p_region_code, l_nested_region_code)
1234: AND nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm4Level_short_name
1235: AND ak.node_query_flag = 'Y';
1236: IF ( p_parm4Level_short_name ='AS_OF_DATE') THEN

Line 1255: from ak_region_items_vl AK

1251: IF ( p_parm5Level_short_name IS NOT NULL) THEN
1252: begin
1253: select DISTINCT nvl(attribute2,attribute_code)
1254: into vParameter5
1255: from ak_region_items_vl AK
1256: where ak.region_code in ( p_region_code, l_nested_region_code)
1257: AND nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm5Level_short_name
1258: AND ak.node_query_flag = 'Y';
1259: IF ( p_parm5Level_short_name ='AS_OF_DATE') THEN

Line 1278: from ak_region_items_vl AK

1274: IF ( p_parm6Level_short_name IS NOT NULL) THEN
1275: begin
1276: select DISTINCT nvl(attribute2,attribute_code)
1277: into vParameter6
1278: from ak_region_items_vl AK
1279: where ak.region_code in ( p_region_code, l_nested_region_code)
1280: AND nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm6Level_short_name
1281: AND ak.node_query_flag = 'Y';
1282: IF ( p_parm6Level_short_name ='AS_OF_DATE') THEN

Line 1301: from ak_region_items_vl AK

1297: IF ( p_parm7Level_short_name IS NOT NULL) THEN
1298: begin
1299: select DISTINCT nvl(attribute2,attribute_code)
1300: into vParameter7
1301: from ak_region_items_vl AK
1302: where ak.region_code = p_region_code
1303: AND substr(ak.attribute2, instr(ak.attribute2, '+')+1) = p_parm7Level_short_name
1304: AND ak.node_query_flag = 'Y';
1305: exception

Line 1321: from ak_region_items_vl AK

1317: IF ( p_parm8Level_short_name IS NOT NULL) THEN
1318: begin
1319: select DISTINCT nvl(attribute2,attribute_code)
1320: into vParameter8
1321: from ak_region_items_vl AK
1322: where ak.region_code in ( p_region_code, l_nested_region_code)
1323: AND nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm8Level_short_name
1324: AND ak.node_query_flag = 'Y';
1325: IF ( p_parm8Level_short_name ='AS_OF_DATE') THEN

Line 1344: from ak_region_items_vl AK

1340: IF ( p_parm9Level_short_name IS NOT NULL) THEN
1341: begin
1342: select DISTINCT nvl(attribute2,attribute_code)
1343: into vParameter9
1344: from ak_region_items_vl AK
1345: where ak.region_code in ( p_region_code, l_nested_region_code)
1346: AND nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm9Level_short_name
1347: AND ak.node_query_flag = 'Y';
1348: IF ( p_parm9Level_short_name ='AS_OF_DATE') THEN

Line 1367: from ak_region_items_vl AK

1363: IF ( p_parm10Level_short_name IS NOT NULL) THEN
1364: begin
1365: select DISTINCT nvl(attribute2,attribute_code)
1366: into vParameter10
1367: from ak_region_items_vl AK
1368: where ak.region_code in ( p_region_code, l_nested_region_code)
1369: AND nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm10Level_short_name
1370: AND ak.node_query_flag = 'Y';
1371: IF ( p_parm10Level_short_name ='AS_OF_DATE') THEN

Line 1390: from ak_region_items_vl AK

1386: IF ( p_parm11Level_short_name IS NOT NULL) THEN
1387: begin
1388: select DISTINCT nvl(attribute2,attribute_code)
1389: into vParameter11
1390: from ak_region_items_vl AK
1391: where ak.region_code in ( p_region_code, l_nested_region_code)
1392: AND nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm11Level_short_name
1393: AND ak.node_query_flag = 'Y';
1394: IF ( p_parm11Level_short_name ='AS_OF_DATE') THEN

Line 1413: from ak_region_items_vl AK

1409: IF ( p_parm12Level_short_name IS NOT NULL) THEN
1410: begin
1411: select DISTINCT nvl(attribute2,attribute_code)
1412: into vParameter12
1413: from ak_region_items_vl AK
1414: where ak.region_code in ( p_region_code, l_nested_region_code)
1415: AND nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm12Level_short_name
1416: AND ak.node_query_flag = 'Y';
1417: IF ( p_parm12Level_short_name ='AS_OF_DATE') THEN

Line 1436: from ak_region_items_vl AK

1432: IF ( p_parm13Level_short_name IS NOT NULL) THEN
1433: begin
1434: select DISTINCT nvl(attribute2,attribute_code)
1435: into vParameter13
1436: from ak_region_items_vl AK
1437: where ak.region_code in ( p_region_code, l_nested_region_code)
1438: AND nvl(substr(ak.attribute2, instr(ak.attribute2, '+')+1), attribute_code) = p_parm13Level_short_name
1439: AND ak.node_query_flag = 'Y';
1440: IF ( p_parm13Level_short_name ='AS_OF_DATE') THEN

Line 1466: from ak_region_items_vl AK

1462: vParameter15 := 'VIEW_BY';
1463: begin
1464: Select attribute2
1465: into vParm15Value_name
1466: from ak_region_items_vl AK
1467: where ak.region_code = p_region_code
1468: AND substr(ak.attribute2, instr(ak.attribute2, '+')+1) = p_viewby_level_short_name
1469: AND ak.attribute1 in ('DIMENSION LEVEL', 'DIM LEVEL SINGLE VALUE');
1470: exception

Line 1543: from ak_region_items_vl AK

1539: IF (p_TimeFromparmValue_name IS NOT NULL) THEN
1540: begin
1541: Select nvl(attribute2,attribute_code)
1542: into vTimeParameter
1543: from ak_region_items_vl AK
1544: where ak.region_code = p_region_code
1545: AND substr(ak.attribute2, instr(ak.attribute2, '+')+1) = p_TimeparmLevel_short_name
1546: AND ak.attribute1 in ('DIMENSION LEVEL', 'DIM LEVEL SINGLE VALUE', 'HIDE VIEW BY DIMENSION');
1547: exception