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.JA_CN_CFS_REPORT_PKG dependencies on DUAL

Line 768: FROM DUAL;

764: --for start period
765: SELECT XMLELEMENT("P_START_PERIOD",
766: P_GL_PERIOD_FROM)
767: INTO L_XML_ITEM
768: FROM DUAL;
769: L_XML_PARAMETER := L_XML_ITEM;
770: --for end period
771: SELECT XMLELEMENT("P_END_PERIOD",
772: P_GL_PERIOD_TO)

Line 774: FROM DUAL;

770: --for end period
771: SELECT XMLELEMENT("P_END_PERIOD",
772: P_GL_PERIOD_TO)
773: INTO L_XML_ITEM
774: FROM DUAL;
775: SELECT XMLCONCAT(L_XML_PARAMETER,
776: L_XML_ITEM)
777: INTO L_XML_PARAMETER
778: FROM DUAL;

Line 778: FROM DUAL;

774: FROM DUAL;
775: SELECT XMLCONCAT(L_XML_PARAMETER,
776: L_XML_ITEM)
777: INTO L_XML_PARAMETER
778: FROM DUAL;
779: --for report name
780: SELECT XMLELEMENT("P_REPORT_NAME",
781: L_REPORT_NAME)
782: INTO L_XML_ITEM

Line 783: FROM DUAL;

779: --for report name
780: SELECT XMLELEMENT("P_REPORT_NAME",
781: L_REPORT_NAME)
782: INTO L_XML_ITEM
783: FROM DUAL;
784: SELECT XMLCONCAT(L_XML_PARAMETER,
785: L_XML_ITEM)
786: INTO L_XML_PARAMETER
787: FROM DUAL;

Line 787: FROM DUAL;

783: FROM DUAL;
784: SELECT XMLCONCAT(L_XML_PARAMETER,
785: L_XML_ITEM)
786: INTO L_XML_PARAMETER
787: FROM DUAL;
788: --for source
789: SELECT XMLELEMENT("P_SOURCE",
790: P_SOURCE)
791: INTO L_XML_ITEM

Line 792: FROM DUAL;

788: --for source
789: SELECT XMLELEMENT("P_SOURCE",
790: P_SOURCE)
791: INTO L_XML_ITEM
792: FROM DUAL;
793: SELECT XMLCONCAT(L_XML_PARAMETER,
794: L_XML_ITEM)
795: INTO L_XML_PARAMETER
796: FROM DUAL;

Line 796: FROM DUAL;

792: FROM DUAL;
793: SELECT XMLCONCAT(L_XML_PARAMETER,
794: L_XML_ITEM)
795: INTO L_XML_PARAMETER
796: FROM DUAL;
797: --for ledger name
798: SELECT XMLELEMENT("P_LEDGER_NAME",
799: L_LEDGER_NAME)
800: INTO L_XML_ITEM

Line 801: FROM DUAL;

797: --for ledger name
798: SELECT XMLELEMENT("P_LEDGER_NAME",
799: L_LEDGER_NAME)
800: INTO L_XML_ITEM
801: FROM DUAL;
802: SELECT XMLCONCAT(L_XML_PARAMETER,
803: L_XML_ITEM)
804: INTO L_XML_PARAMETER
805: FROM DUAL;

Line 805: FROM DUAL;

801: FROM DUAL;
802: SELECT XMLCONCAT(L_XML_PARAMETER,
803: L_XML_ITEM)
804: INTO L_XML_PARAMETER
805: FROM DUAL;
806: --for legal entity
807: SELECT XMLELEMENT("P_LEGAL_ENTITY",
808: L_LE_NAME)
809: INTO L_XML_ITEM

Line 810: FROM DUAL;

806: --for legal entity
807: SELECT XMLELEMENT("P_LEGAL_ENTITY",
808: L_LE_NAME)
809: INTO L_XML_ITEM
810: FROM DUAL;
811: SELECT XMLCONCAT(L_XML_PARAMETER,
812: L_XML_ITEM)
813: INTO L_XML_PARAMETER
814: FROM DUAL;

Line 814: FROM DUAL;

810: FROM DUAL;
811: SELECT XMLCONCAT(L_XML_PARAMETER,
812: L_XML_ITEM)
813: INTO L_XML_PARAMETER
814: FROM DUAL;
815:
816: --for row name
817: SELECT XMLELEMENT("P_ROW_NAME",
818: P_ROW_NAME)

Line 820: FROM DUAL;

816: --for row name
817: SELECT XMLELEMENT("P_ROW_NAME",
818: P_ROW_NAME)
819: INTO L_XML_ITEM
820: FROM DUAL;
821: SELECT XMLCONCAT(L_XML_PARAMETER,
822: L_XML_ITEM)
823: INTO L_XML_PARAMETER
824: FROM DUAL;

Line 824: FROM DUAL;

820: FROM DUAL;
821: SELECT XMLCONCAT(L_XML_PARAMETER,
822: L_XML_ITEM)
823: INTO L_XML_PARAMETER
824: FROM DUAL;
825:
826: --for bsv
827: SELECT XMLELEMENT("P_BSV",--enhancment add
828: P_BSV)

Line 830: FROM DUAL;

826: --for bsv
827: SELECT XMLELEMENT("P_BSV",--enhancment add
828: P_BSV)
829: INTO L_XML_ITEM
830: FROM DUAL;
831: SELECT XMLCONCAT(L_XML_PARAMETER,
832: L_XML_ITEM)
833: INTO L_XML_PARAMETER
834: FROM DUAL;

Line 834: FROM DUAL;

830: FROM DUAL;
831: SELECT XMLCONCAT(L_XML_PARAMETER,
832: L_XML_ITEM)
833: INTO L_XML_PARAMETER
834: FROM DUAL;
835:
836:
837: SELECT XMLCONCAT(L_XML_PARAMETER,
838: L_XML_REPORT)

Line 840: FROM DUAL;

836:
837: SELECT XMLCONCAT(L_XML_PARAMETER,
838: L_XML_REPORT)
839: INTO L_XML_REPORT
840: FROM DUAL;
841:
842:
843: --Get Period set name, Year_From and Year_To
844: SELECT LED.PERIOD_SET_NAME

Line 1029: FROM DUAL;

1025: -- Fix bug#6697073 end ----------------------------------------------
1026: SELECT XMLELEMENT("PERIOD_NAME",
1027: L_PERIOD_NAME)
1028: INTO L_XML_ITEM
1029: FROM DUAL;
1030: L_XML_ROW_ITEMS := L_XML_ITEM;
1031:
1032: SELECT XMLELEMENT("DETAILED_CFS_ITEM",
1033: L_DETAILED_CFS_ITEM)

Line 1035: FROM DUAL;

1031:
1032: SELECT XMLELEMENT("DETAILED_CFS_ITEM",
1033: L_DETAILED_CFS_ITEM)
1034: INTO L_XML_ITEM
1035: FROM DUAL;
1036: SELECT XMLCONCAT(L_XML_ROW_ITEMS,
1037: L_XML_ITEM)
1038: INTO L_XML_ROW_ITEMS
1039: FROM DUAL;

Line 1039: FROM DUAL;

1035: FROM DUAL;
1036: SELECT XMLCONCAT(L_XML_ROW_ITEMS,
1037: L_XML_ITEM)
1038: INTO L_XML_ROW_ITEMS
1039: FROM DUAL;
1040: SELECT XMLELEMENT("ROW_NAME",
1041: L_ROW_DESCRIPTION)
1042: INTO L_XML_ITEM
1043: FROM DUAL;

Line 1043: FROM DUAL;

1039: FROM DUAL;
1040: SELECT XMLELEMENT("ROW_NAME",
1041: L_ROW_DESCRIPTION)
1042: INTO L_XML_ITEM
1043: FROM DUAL;
1044: SELECT XMLCONCAT(L_XML_ROW_ITEMS,
1045: L_XML_ITEM)
1046: INTO L_XML_ROW_ITEMS
1047: FROM DUAL;

Line 1047: FROM DUAL;

1043: FROM DUAL;
1044: SELECT XMLCONCAT(L_XML_ROW_ITEMS,
1045: L_XML_ITEM)
1046: INTO L_XML_ROW_ITEMS
1047: FROM DUAL;
1048: SELECT XMLELEMENT("SOURCE",
1049: L_SOURCE)
1050: INTO L_XML_ITEM
1051: FROM DUAL;

Line 1051: FROM DUAL;

1047: FROM DUAL;
1048: SELECT XMLELEMENT("SOURCE",
1049: L_SOURCE)
1050: INTO L_XML_ITEM
1051: FROM DUAL;
1052: SELECT XMLCONCAT(L_XML_ROW_ITEMS,
1053: L_XML_ITEM)
1054: INTO L_XML_ROW_ITEMS
1055: FROM DUAL;

Line 1055: FROM DUAL;

1051: FROM DUAL;
1052: SELECT XMLCONCAT(L_XML_ROW_ITEMS,
1053: L_XML_ITEM)
1054: INTO L_XML_ROW_ITEMS
1055: FROM DUAL;
1056:
1057: SELECT XMLELEMENT("BSV",--Fix bug#7334017 add
1058: L_BSV)
1059: INTO L_XML_ITEM

Line 1060: FROM DUAL;

1056:
1057: SELECT XMLELEMENT("BSV",--Fix bug#7334017 add
1058: L_BSV)
1059: INTO L_XML_ITEM
1060: FROM DUAL;
1061: SELECT XMLCONCAT(L_XML_ROW_ITEMS,
1062: L_XML_ITEM)
1063: INTO L_XML_ROW_ITEMS
1064: FROM DUAL;

Line 1064: FROM DUAL;

1060: FROM DUAL;
1061: SELECT XMLCONCAT(L_XML_ROW_ITEMS,
1062: L_XML_ITEM)
1063: INTO L_XML_ROW_ITEMS
1064: FROM DUAL;
1065:
1066:
1067: SELECT XMLELEMENT("THIRD_PARTY_NAME",
1068: L_THIRD_PARTY_NAME)

Line 1070: FROM DUAL;

1066:
1067: SELECT XMLELEMENT("THIRD_PARTY_NAME",
1068: L_THIRD_PARTY_NAME)
1069: INTO L_XML_ITEM
1070: FROM DUAL;
1071: SELECT XMLCONCAT(L_XML_ROW_ITEMS,
1072: L_XML_ITEM)
1073: INTO L_XML_ROW_ITEMS
1074: FROM DUAL;

Line 1074: FROM DUAL;

1070: FROM DUAL;
1071: SELECT XMLCONCAT(L_XML_ROW_ITEMS,
1072: L_XML_ITEM)
1073: INTO L_XML_ROW_ITEMS
1074: FROM DUAL;
1075: SELECT XMLELEMENT("RECEIPT_PAYMENT_NUMBER",
1076: L_TRX_NUMBER)
1077: INTO L_XML_ITEM
1078: FROM DUAL;

Line 1078: FROM DUAL;

1074: FROM DUAL;
1075: SELECT XMLELEMENT("RECEIPT_PAYMENT_NUMBER",
1076: L_TRX_NUMBER)
1077: INTO L_XML_ITEM
1078: FROM DUAL;
1079: SELECT XMLCONCAT(L_XML_ROW_ITEMS,
1080: L_XML_ITEM)
1081: INTO L_XML_ROW_ITEMS
1082: FROM DUAL;

Line 1082: FROM DUAL;

1078: FROM DUAL;
1079: SELECT XMLCONCAT(L_XML_ROW_ITEMS,
1080: L_XML_ITEM)
1081: INTO L_XML_ROW_ITEMS
1082: FROM DUAL;
1083:
1084: -- Fix bug#6697073 begin ----------------------------
1085: SELECT XMLELEMENT("TRANSACTION_NUMBER",
1086: L_INVOICE_NUM1(l_count))--L_INVOICE_NUM

Line 1088: FROM DUAL;

1084: -- Fix bug#6697073 begin ----------------------------
1085: SELECT XMLELEMENT("TRANSACTION_NUMBER",
1086: L_INVOICE_NUM1(l_count))--L_INVOICE_NUM
1087: INTO L_XML_ITEM
1088: FROM DUAL;
1089: -- Fix bug#6697073 end ------------------------------
1090:
1091: SELECT XMLCONCAT(L_XML_ROW_ITEMS,
1092: L_XML_ITEM)

Line 1094: FROM DUAL;

1090:
1091: SELECT XMLCONCAT(L_XML_ROW_ITEMS,
1092: L_XML_ITEM)
1093: INTO L_XML_ROW_ITEMS
1094: FROM DUAL;
1095:
1096: -- Fix bug#6697073 begin ----------------------------
1097: SELECT XMLELEMENT("TRANSACTION_AMOUNT",
1098: L_FUNC_AMOUNT_TEMP(l_count))--L_FUNC_AMOUNT

Line 1100: FROM DUAL;

1096: -- Fix bug#6697073 begin ----------------------------
1097: SELECT XMLELEMENT("TRANSACTION_AMOUNT",
1098: L_FUNC_AMOUNT_TEMP(l_count))--L_FUNC_AMOUNT
1099: INTO L_XML_ITEM
1100: FROM DUAL;
1101:
1102: SELECT XMLCONCAT(L_XML_ROW_ITEMS,
1103: L_XML_ITEM)
1104: INTO L_XML_ROW_ITEMS

Line 1105: FROM DUAL;

1101:
1102: SELECT XMLCONCAT(L_XML_ROW_ITEMS,
1103: L_XML_ITEM)
1104: INTO L_XML_ROW_ITEMS
1105: FROM DUAL;
1106:
1107: SELECT XMLELEMENT("ROW_DETAIL",
1108: L_XML_ROW_ITEMS)
1109: INTO L_XML_ITEM

Line 1110: FROM DUAL;

1106:
1107: SELECT XMLELEMENT("ROW_DETAIL",
1108: L_XML_ROW_ITEMS)
1109: INTO L_XML_ITEM
1110: FROM DUAL;
1111: SELECT XMLCONCAT(L_XML_ROW,
1112: L_XML_ITEM)
1113: INTO L_XML_ROW
1114: FROM DUAL;

Line 1114: FROM DUAL;

1110: FROM DUAL;
1111: SELECT XMLCONCAT(L_XML_ROW,
1112: L_XML_ITEM)
1113: INTO L_XML_ROW
1114: FROM DUAL;
1115:
1116: --count row amount
1117: l_row_amount:=l_row_amount+nvl(L_FUNC_AMOUNT_TEMP(l_count),0);
1118: end loop;

Line 1131: FROM DUAL;

1127: if L_DIS_FLAG<>0 then--fix bug 7487395 add
1128: SELECT XMLELEMENT("ROW_AMOUNT",
1129: L_ROW_AMOUNT)
1130: INTO L_XML_ITEM
1131: FROM DUAL;
1132: SELECT XMLCONCAT(L_XML_ROW,
1133: L_XML_ITEM)
1134: INTO L_XML_ROW
1135: FROM DUAL;

Line 1135: FROM DUAL;

1131: FROM DUAL;
1132: SELECT XMLCONCAT(L_XML_ROW,
1133: L_XML_ITEM)
1134: INTO L_XML_ROW
1135: FROM DUAL;
1136:
1137: SELECT XMLELEMENT("ROW",
1138: L_XML_ROW)
1139: INTO L_XML_ITEM

Line 1140: FROM DUAL;

1136:
1137: SELECT XMLELEMENT("ROW",
1138: L_XML_ROW)
1139: INTO L_XML_ITEM
1140: FROM DUAL;
1141: end if; --fix bug 7487395 add
1142: -- Fix bug #6854438: record all the rows info by L_XML_ROWS_ALL begin
1143: IF L_XML_ROWS_ALL IS NULL
1144: THEN

Line 1150: FROM DUAL;

1146: ELSE
1147: SELECT XMLCONCAT(L_XML_ROWS_ALL,
1148: L_XML_ITEM)
1149: INTO L_XML_ROWS_ALL
1150: FROM DUAL;
1151: END IF;
1152: -- Fix bug #6854438: record all the rows info by L_XML_ROWS_ALL end
1153:
1154: END LOOP; --cursor c_rows

Line 1160: FROM DUAL;

1156:
1157: SELECT XMLCONCAT(L_XML_PERIOD,
1158: L_XML_ROWS_ALL)
1159: INTO L_XML_PERIOD
1160: FROM DUAL;
1161:
1162: SELECT XMLELEMENT("PERIOD",
1163: L_XML_PERIOD)
1164: INTO L_XML_ITEM

Line 1165: FROM DUAL;

1161:
1162: SELECT XMLELEMENT("PERIOD",
1163: L_XML_PERIOD)
1164: INTO L_XML_ITEM
1165: FROM DUAL;
1166: SELECT XMLCONCAT(L_XML_REPORT,
1167: L_XML_ITEM)
1168: INTO L_XML_REPORT
1169: FROM DUAL;

Line 1169: FROM DUAL;

1165: FROM DUAL;
1166: SELECT XMLCONCAT(L_XML_REPORT,
1167: L_XML_ITEM)
1168: INTO L_XML_REPORT
1169: FROM DUAL;
1170:
1171: -- END LOOP; --cursor c_rows
1172:
1173: END LOOP; --cursor c_reports

Line 1180: FROM DUAL;

1176:
1177: SELECT XMLELEMENT("REPORT",
1178: L_XML_REPORT)
1179: INTO L_XML_ROOT
1180: FROM DUAL;
1181: JA_CN_UTILITY.OUTPUT_CONC(L_XML_ROOT.GETCLOBVAL());
1182:
1183: --log for debug
1184: IF (L_PROC_LEVEL >= L_DBG_LEVEL)

Line 1207: FROM DUAL;

1203:
1204: SELECT XMLELEMENT("EXCEPTION",
1205: L_MSG_INVALID_GLPERIOD)
1206: INTO L_XML_ITEM
1207: FROM DUAL;
1208: SELECT XMLCONCAT(L_XML_PARAMETER,
1209: L_XML_ITEM)
1210: INTO L_XML_ALL
1211: FROM DUAL;

Line 1211: FROM DUAL;

1207: FROM DUAL;
1208: SELECT XMLCONCAT(L_XML_PARAMETER,
1209: L_XML_ITEM)
1210: INTO L_XML_ALL
1211: FROM DUAL;
1212: --To add root node for the xml output and then output it
1213: SELECT XMLELEMENT("REPORT",
1214: L_XML_ALL)
1215: INTO L_XML_ROOT

Line 1216: FROM DUAL;

1212: --To add root node for the xml output and then output it
1213: SELECT XMLELEMENT("REPORT",
1214: L_XML_ALL)
1215: INTO L_XML_ROOT
1216: FROM DUAL;
1217: JA_CN_UTILITY.OUTPUT_CONC(L_XML_ROOT.GETCLOBVAL());
1218:
1219: RETCODE := 1;
1220: ERRBUF := L_MSG_INVALID_GLPERIOD;

Line 1233: FROM DUAL;

1229:
1230: SELECT XMLELEMENT("EXCEPTION",
1231: 'Other_Exception')
1232: INTO L_XML_ITEM
1233: FROM DUAL;
1234: SELECT XMLCONCAT(L_XML_PARAMETER,
1235: L_XML_ITEM)
1236: INTO L_XML_ALL
1237: FROM DUAL;

Line 1237: FROM DUAL;

1233: FROM DUAL;
1234: SELECT XMLCONCAT(L_XML_PARAMETER,
1235: L_XML_ITEM)
1236: INTO L_XML_ALL
1237: FROM DUAL;
1238: --To add root node for the xml output and then output it
1239: SELECT XMLELEMENT("REPORT",
1240: L_XML_ALL)
1241: INTO L_XML_ROOT

Line 1242: FROM DUAL;

1238: --To add root node for the xml output and then output it
1239: SELECT XMLELEMENT("REPORT",
1240: L_XML_ALL)
1241: INTO L_XML_ROOT
1242: FROM DUAL;
1243:
1244: JA_CN_UTILITY.OUTPUT_CONC(L_XML_ROOT.GETCLOBVAL());
1245: IF c_periods%ISOPEN THEN
1246: CLOSE c_periods;