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.ZX_TAX_CONTENT_UPLOAD dependencies on DBMS_UTILITY

Line 660: l_start := DBMS_UTILITY.GET_TIME;

656: FETCH C_CNTRY_ID
657: INTO l_cntry_geography_id;
658: CLOSE C_CNTRY_ID;
659:
660: l_start := DBMS_UTILITY.GET_TIME;
661:
662: -- Find the state geography id using abbreviation code. Note that since we
663: -- are using code, even the name change records will get the geography_id.
664: UPDATE ZX_DATA_UPLOAD_INTERFACE x

Line 679: l_end := DBMS_UTILITY.GET_TIME;

675: x.status = 'NOCHANGE'
676: WHERE x.record_type = 1;
677:
678: l_rows_processed := SQL%ROWCOUNT;
679: l_end := DBMS_UTILITY.GET_TIME;
680: l_log := 'After State Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
681: FND_FILE.PUT_LINE
682: (
683: FND_FILE.LOG,

Line 687: l_start := DBMS_UTILITY.GET_TIME;

683: FND_FILE.LOG,
684: l_log
685: );
686:
687: l_start := DBMS_UTILITY.GET_TIME;
688:
689: -- Now update the status of the name change record.
690: UPDATE ZX_DATA_UPLOAD_INTERFACE x
691: SET x.status = 'UPDATE'

Line 702: l_end := DBMS_UTILITY.GET_TIME;

698: AND y.country_state_abbreviation = x.country_state_abbreviation
699: AND y.effective_to IS NOT NULL);
700:
701: l_rows_processed := SQL%ROWCOUNT;
702: l_end := DBMS_UTILITY.GET_TIME;
703: l_log := 'After State Name Change Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
704: FND_FILE.PUT_LINE
705: (
706: FND_FILE.LOG,

Line 710: l_start := DBMS_UTILITY.GET_TIME;

706: FND_FILE.LOG,
707: l_log
708: );
709:
710: l_start := DBMS_UTILITY.GET_TIME;
711:
712: -- Geography Id's for County for pre-existing geographies
713: -- The state record could have been ended or it could have been sent twice
714: -- with name change, so rownum clause is used.

Line 733: l_end := DBMS_UTILITY.GET_TIME;

729: x.status = 'NOCHANGE'
730: WHERE x.record_type = 3;
731:
732: l_rows_processed := SQL%ROWCOUNT;
733: l_end := DBMS_UTILITY.GET_TIME;
734: l_log := 'After County Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
735: FND_FILE.PUT_LINE
736: (
737: FND_FILE.LOG,

Line 741: l_start := DBMS_UTILITY.GET_TIME;

737: FND_FILE.LOG,
738: l_log
739: );
740:
741: l_start := DBMS_UTILITY.GET_TIME;
742:
743: -- Geography Id's for County for pre-existing geographies, which had name
744: -- change. Use existing record with old name to find the id.
745: UPDATE ZX_DATA_UPLOAD_INTERFACE x

Line 758: l_end := DBMS_UTILITY.GET_TIME;

754: AND x.geography_id IS NULL
755: AND x.effective_to IS NULL;
756:
757: l_rows_processed := SQL%ROWCOUNT;
758: l_end := DBMS_UTILITY.GET_TIME;
759: l_log := 'After County Name Change Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
760: FND_FILE.PUT_LINE
761: (
762: FND_FILE.LOG,

Line 766: l_start := DBMS_UTILITY.GET_TIME;

762: FND_FILE.LOG,
763: l_log
764: );
765:
766: l_start := DBMS_UTILITY.GET_TIME;
767:
768: -- Geography Id's for City for pre-existing geographies.
769: -- This is for the case where a city is in a single county
770: -- or city with multiple counties has been created as multiple geographies.

Line 812: l_end := DBMS_UTILITY.GET_TIME;

808: SET geography_id = l_geography_ids(i),
809: status = 'NOCHANGE'
810: WHERE rowid = l_rowids(i);
811:
812: l_end := DBMS_UTILITY.GET_TIME;
813: l_log := 'After City Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
814: FND_FILE.PUT_LINE
815: (
816: FND_FILE.LOG,

Line 820: -- l_start := DBMS_UTILITY.GET_TIME;

816: FND_FILE.LOG,
817: l_log
818: );
819:
820: -- l_start := DBMS_UTILITY.GET_TIME;
821: --
822: -- Geography Id's for City for pre-existing geographies, which had name
823: -- change. Use existing record with old name to find the id.
824: --

Line 840: -- l_end := DBMS_UTILITY.GET_TIME;

836: -- AND x.geography_id IS NULL
837: -- AND x.effective_to IS NULL;
838: --
839: -- l_rows_processed := SQL%ROWCOUNT;
840: -- l_end := DBMS_UTILITY.GET_TIME;
841: -- l_log := 'After City Name Change Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
842: -- FND_FILE.PUT_LINE
843: -- (
844: -- FND_FILE.LOG,

Line 848: l_start := DBMS_UTILITY.GET_TIME;

844: -- FND_FILE.LOG,
845: -- l_log
846: -- );
847:
848: l_start := DBMS_UTILITY.GET_TIME;
849:
850: -- Get new id for new state and county
851: UPDATE ZX_DATA_UPLOAD_INTERFACE
852: SET geography_id = hz_geographies_s.nextval,

Line 859: l_end := DBMS_UTILITY.GET_TIME;

855: AND geography_id IS NULL
856: AND effective_to IS NULL;
857:
858: l_rows_processed := SQL%ROWCOUNT;
859: l_end := DBMS_UTILITY.GET_TIME;
860: l_log := 'After new State and County Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
861: FND_FILE.PUT_LINE
862: (
863: FND_FILE.LOG,

Line 867: l_start := DBMS_UTILITY.GET_TIME;

863: FND_FILE.LOG,
864: l_log
865: );
866:
867: l_start := DBMS_UTILITY.GET_TIME;
868:
869: -- Get new id for new city. In the case of city divided in two or more
870: -- jurisdictions, get new id only for the first one
871: UPDATE ZX_DATA_UPLOAD_INTERFACE

Line 903: l_end := DBMS_UTILITY.GET_TIME;

899: WHERE CITY_ROW_NUMBER = 1
900: AND GEOGRAPHY_ID IS NULL);
901:
902: l_rows_processed := SQL%ROWCOUNT;
903: l_end := DBMS_UTILITY.GET_TIME;
904: l_log := 'After new City Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
905: FND_FILE.PUT_LINE
906: (
907: FND_FILE.LOG,

Line 911: l_start := DBMS_UTILITY.GET_TIME;

907: FND_FILE.LOG,
908: l_log
909: );
910:
911: l_start := DBMS_UTILITY.GET_TIME;
912:
913: -- Use the id from previous step for multi jurisdiction cities
914: UPDATE ZX_DATA_UPLOAD_INTERFACE a
915: SET geography_id = (SELECT b.geography_id

Line 928: l_end := DBMS_UTILITY.GET_TIME;

924: AND geography_id IS NULL
925: AND effective_to IS NULL;
926:
927: l_rows_processed := SQL%ROWCOUNT;
928: l_end := DBMS_UTILITY.GET_TIME;
929: l_log := 'After new City 2nd Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
930: FND_FILE.PUT_LINE
931: (
932: FND_FILE.LOG,

Line 936: l_start := DBMS_UTILITY.GET_TIME;

932: FND_FILE.LOG,
933: l_log
934: );
935:
936: l_start := DBMS_UTILITY.GET_TIME;
937:
938: -- Update a new geography id for all remaining cities.
939: UPDATE ZX_DATA_UPLOAD_INTERFACE
940: SET geography_id = hz_geographies_s.nextval,

Line 947: l_end := DBMS_UTILITY.GET_TIME;

943: AND geography_id IS NULL
944: AND effective_to IS NULL;
945:
946: l_rows_processed := SQL%ROWCOUNT;
947: l_end := DBMS_UTILITY.GET_TIME;
948: l_log := 'After new City 3rd Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
949: FND_FILE.PUT_LINE
950: (
951: FND_FILE.LOG,

Line 955: l_start := DBMS_UTILITY.GET_TIME;

951: FND_FILE.LOG,
952: l_log
953: );
954:
955: l_start := DBMS_UTILITY.GET_TIME;
956:
957: -- Update the zip range with their corresponding city rows
958: UPDATE ZX_DATA_UPLOAD_INTERFACE a
959: SET (geography_id,status) = (SELECT b.geography_id, b.status

Line 973: l_end := DBMS_UTILITY.GET_TIME;

969: AND geography_id IS NULL
970: AND effective_to IS NULL;
971:
972: l_rows_processed := SQL%ROWCOUNT;
973: l_end := DBMS_UTILITY.GET_TIME;
974: l_log := 'After Zip Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
975: FND_FILE.PUT_LINE
976: (
977: FND_FILE.LOG,

Line 987: l_start := DBMS_UTILITY.GET_TIME;

983:
984: IF (p_migrated_tax_regime_flag = 'Y')
985: THEN
986:
987: l_start := DBMS_UTILITY.GET_TIME;
988:
989: -- First UPDATE the zone_geography_id for pre-existing states
990: UPDATE ZX_DATA_UPLOAD_INTERFACE x
991: SET x.zone_geography_id = (SELECT y.geography_id FROM hz_geographies y

Line 1010: l_end := DBMS_UTILITY.GET_TIME;

1006: -- AND y.CITY_JURISDICTION_CODE = x.CITY_JURISDICTION_CODE
1007: -- AND y.record_type in (9,10,11,12));
1008:
1009: l_rows_processed := SQL%ROWCOUNT;
1010: l_end := DBMS_UTILITY.GET_TIME;
1011: l_log := 'After State Zone Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1012: FND_FILE.PUT_LINE
1013: (
1014: FND_FILE.LOG,

Line 1018: l_start := DBMS_UTILITY.GET_TIME;

1014: FND_FILE.LOG,
1015: l_log
1016: );
1017:
1018: l_start := DBMS_UTILITY.GET_TIME;
1019:
1020: -- First UPDATE the zone_geography_id for pre-existing counties
1021: UPDATE ZX_DATA_UPLOAD_INTERFACE x
1022: SET x.zone_geography_id = (SELECT y.geography_id FROM hz_geographies y

Line 1042: l_end := DBMS_UTILITY.GET_TIME;

1038: -- AND y.CITY_JURISDICTION_CODE = x.CITY_JURISDICTION_CODE
1039: -- AND y.record_type in (9,10,11,12));
1040:
1041: l_rows_processed := SQL%ROWCOUNT;
1042: l_end := DBMS_UTILITY.GET_TIME;
1043: l_log := 'After County Zone UPDATE, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1044: FND_FILE.PUT_LINE
1045: (
1046: FND_FILE.LOG,

Line 1050: l_start := DBMS_UTILITY.GET_TIME;

1046: FND_FILE.LOG,
1047: l_log
1048: );
1049:
1050: l_start := DBMS_UTILITY.GET_TIME;
1051:
1052: -- First UPDATE the zone_geography_id for pre-existing cities
1053: UPDATE ZX_DATA_UPLOAD_INTERFACE x
1054: SET x.zone_geography_id = (SELECT y.geography_id FROM hz_geographies y

Line 1074: l_end := DBMS_UTILITY.GET_TIME;

1070: -- AND y.CITY_JURISDICTION_CODE = x.CITY_JURISDICTION_CODE
1071: -- AND y.record_type in (9,10,11,12));
1072:
1073: l_rows_processed := SQL%ROWCOUNT;
1074: l_end := DBMS_UTILITY.GET_TIME;
1075: l_log := 'After City Zone UPDATE, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1076: FND_FILE.PUT_LINE
1077: (
1078: FND_FILE.LOG,

Line 1082: l_start := DBMS_UTILITY.GET_TIME;

1078: FND_FILE.LOG,
1079: l_log
1080: );
1081:
1082: l_start := DBMS_UTILITY.GET_TIME;
1083:
1084: -- UPDATE the existing zone_geography_id for cities with same geocode
1085: UPDATE ZX_DATA_UPLOAD_INTERFACE x
1086: SET x.zone_geography_id = (SELECT y.zone_geography_id

Line 1101: l_end := DBMS_UTILITY.GET_TIME;

1097: AND x.zone_geography_id IS NULL
1098: AND x.geography_id IS NOT NULL;
1099:
1100: l_rows_processed := SQL%ROWCOUNT;
1101: l_end := DBMS_UTILITY.GET_TIME;
1102: l_log := 'After City Zone UPDATE 2, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1103: FND_FILE.PUT_LINE
1104: (
1105: FND_FILE.LOG,

Line 1109: l_start := DBMS_UTILITY.GET_TIME;

1105: FND_FILE.LOG,
1106: l_log
1107: );
1108:
1109: l_start := DBMS_UTILITY.GET_TIME;
1110:
1111: -- Now, UPDATE the zone_geography_id for new records for counties AND states
1112: UPDATE ZX_DATA_UPLOAD_INTERFACE x
1113: SET x.zone_geography_id = hz_geographies_s.nextval

Line 1125: l_end := DBMS_UTILITY.GET_TIME;

1121: -- AND NVL(y.CITY_JURISDICTION_CODE,'-1') = NVL(x.CITY_JURISDICTION_CODE,'-1')
1122: -- AND y.record_type in (9,10,11,12));
1123:
1124: l_rows_processed := SQL%ROWCOUNT;
1125: l_end := DBMS_UTILITY.GET_TIME;
1126: l_log := 'After new State/County Zone UPDATE, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1127: FND_FILE.PUT_LINE
1128: (
1129: FND_FILE.LOG,

Line 1133: l_start := DBMS_UTILITY.GET_TIME;

1129: FND_FILE.LOG,
1130: l_log
1131: );
1132:
1133: l_start := DBMS_UTILITY.GET_TIME;
1134:
1135: -- UPDATE the zone geography id for primary cities first.
1136: UPDATE ZX_DATA_UPLOAD_INTERFACE x
1137: SET x.zone_geography_id = hz_geographies_s.nextval

Line 1144: l_end := DBMS_UTILITY.GET_TIME;

1140: AND x.effective_to IS NULL
1141: AND x.primary_flag = 'Y';
1142:
1143: l_rows_processed := SQL%ROWCOUNT;
1144: l_end := DBMS_UTILITY.GET_TIME;
1145: l_log := 'After new Primary City Zone UPDATE, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1146: FND_FILE.PUT_LINE
1147: (
1148: FND_FILE.LOG,

Line 1152: l_start := DBMS_UTILITY.GET_TIME;

1148: FND_FILE.LOG,
1149: l_log
1150: );
1151:
1152: l_start := DBMS_UTILITY.GET_TIME;
1153:
1154: -- UPDATE the zone geography id for non primary cities.
1155: UPDATE ZX_DATA_UPLOAD_INTERFACE x
1156: SET x.zone_geography_id = (SELECT y.zone_geography_id

Line 1173: l_end := DBMS_UTILITY.GET_TIME;

1169: AND x.effective_to IS NULL
1170: AND x.primary_flag = 'N';
1171:
1172: l_rows_processed := SQL%ROWCOUNT;
1173: l_end := DBMS_UTILITY.GET_TIME;
1174: l_log := 'After new Non Primary City Zone UPDATE, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1175: FND_FILE.PUT_LINE
1176: (
1177: FND_FILE.LOG,

Line 1181: l_start := DBMS_UTILITY.GET_TIME;

1177: FND_FILE.LOG,
1178: l_log
1179: );
1180:
1181: l_start := DBMS_UTILITY.GET_TIME;
1182:
1183: -- Now, UPDATE the zone_geography_id for override rates
1184: -- UPDATE only the first row as there could be multiple rates for one
1185: -- overriding jurisdiction. First case is for city overriding state/county

Line 1233: l_end := DBMS_UTILITY.GET_TIME;

1229: WHERE row_number = 1
1230: );
1231:
1232: l_rows_processed := SQL%ROWCOUNT;
1233: l_end := DBMS_UTILITY.GET_TIME;
1234: l_log := 'After City Override Zone UPDATE, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1235: FND_FILE.PUT_LINE
1236: (
1237: FND_FILE.LOG,

Line 1241: l_start := DBMS_UTILITY.GET_TIME;

1237: FND_FILE.LOG,
1238: l_log
1239: );
1240:
1241: l_start := DBMS_UTILITY.GET_TIME;
1242:
1243: -- Now, UPDATE the zone_geography_id for override rates
1244: -- UPDATE only the first row as there could be multiple rates for one
1245: -- overriding jurisdiction

Line 1285: l_end := DBMS_UTILITY.GET_TIME;

1281: WHERE row_number = 1
1282: );
1283:
1284: l_rows_processed := SQL%ROWCOUNT;
1285: l_end := DBMS_UTILITY.GET_TIME;
1286: l_log := 'After new City Override Zone UPDATE, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1287: FND_FILE.PUT_LINE
1288: (
1289: FND_FILE.LOG,

Line 1293: l_start := DBMS_UTILITY.GET_TIME;

1289: FND_FILE.LOG,
1290: l_log
1291: );
1292:
1293: l_start := DBMS_UTILITY.GET_TIME;
1294:
1295: -- Now, UPDATE the zone_geography_id for override rates
1296: -- UPDATE only the first row as there could be multiple rates for one
1297: -- overriding jurisdiction. First case is for county overriding state

Line 1339: l_end := DBMS_UTILITY.GET_TIME;

1335: WHERE row_number = 1
1336: );
1337:
1338: l_rows_processed := SQL%ROWCOUNT;
1339: l_end := DBMS_UTILITY.GET_TIME;
1340: l_log := 'After County Override Zone UPDATE, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1341: FND_FILE.PUT_LINE
1342: (
1343: FND_FILE.LOG,

Line 1347: l_start := DBMS_UTILITY.GET_TIME;

1343: FND_FILE.LOG,
1344: l_log
1345: );
1346:
1347: l_start := DBMS_UTILITY.GET_TIME;
1348:
1349: -- Now, UPDATE the zone_geography_id for override rates
1350: -- UPDATE only the first row as there could be multiple rates for one
1351: -- overriding jurisdiction

Line 1385: l_end := DBMS_UTILITY.GET_TIME;

1381: WHERE row_number = 1
1382: );
1383:
1384: l_rows_processed := SQL%ROWCOUNT;
1385: l_end := DBMS_UTILITY.GET_TIME;
1386: l_log := 'After new County Override Zone UPDATE, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1387: FND_FILE.PUT_LINE
1388: (
1389: FND_FILE.LOG,

Line 1395: l_start := DBMS_UTILITY.GET_TIME;

1391: );
1392:
1393: ELSE
1394:
1395: l_start := DBMS_UTILITY.GET_TIME;
1396:
1397: -- First UPDATE the zone_geography_id for pre-existing cities,
1398: UPDATE ZX_DATA_UPLOAD_INTERFACE x
1399: SET x.zone_geography_id = (SELECT y.geography_id FROM hz_geographies y

Line 1419: l_end := DBMS_UTILITY.GET_TIME;

1415: -- AND y.CITY_JURISDICTION_CODE = x.CITY_JURISDICTION_CODE
1416: -- AND y.record_type in (9,10,11,12));
1417:
1418: l_rows_processed := SQL%ROWCOUNT;
1419: l_end := DBMS_UTILITY.GET_TIME;
1420: l_log := 'After City Zone UPDATE, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1421: FND_FILE.PUT_LINE
1422: (
1423: FND_FILE.LOG,

Line 1427: l_start := DBMS_UTILITY.GET_TIME;

1423: FND_FILE.LOG,
1424: l_log
1425: );
1426:
1427: l_start := DBMS_UTILITY.GET_TIME;
1428:
1429: -- UPDATE the zone_geography_id for cities
1430: UPDATE ZX_DATA_UPLOAD_INTERFACE x
1431: SET x.zone_geography_id = (SELECT y.zone_geography_id

Line 1444: l_end := DBMS_UTILITY.GET_TIME;

1440: WHERE x.record_type = 6
1441: AND x.zone_geography_id IS NULL;
1442:
1443: l_rows_processed := SQL%ROWCOUNT;
1444: l_end := DBMS_UTILITY.GET_TIME;
1445: l_log := 'After City Zone UPDATE 2, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1446: FND_FILE.PUT_LINE
1447: (
1448: FND_FILE.LOG,

Line 1452: l_start := DBMS_UTILITY.GET_TIME;

1448: FND_FILE.LOG,
1449: l_log
1450: );
1451:
1452: l_start := DBMS_UTILITY.GET_TIME;
1453:
1454: -- Now, UPDATE the zone_geography_id for new records,
1455: UPDATE ZX_DATA_UPLOAD_INTERFACE x
1456: SET x.zone_geography_id = hz_geographies_s.nextval

Line 1469: l_end := DBMS_UTILITY.GET_TIME;

1465: -- AND y.CITY_JURISDICTION_CODE = x.CITY_JURISDICTION_CODE
1466: -- AND y.record_type in (9,10,11,12));
1467:
1468: l_rows_processed := SQL%ROWCOUNT;
1469: l_end := DBMS_UTILITY.GET_TIME;
1470: l_log := 'After new Primary City Zone UPDATE, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1471: FND_FILE.PUT_LINE
1472: (
1473: FND_FILE.LOG,

Line 1494: l_end := DBMS_UTILITY.GET_TIME;

1490: AND x.effective_to IS NULL
1491: AND x.primary_flag = 'N';
1492:
1493: l_rows_processed := SQL%ROWCOUNT;
1494: l_end := DBMS_UTILITY.GET_TIME;
1495: l_log := 'After new City Zone Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1496: FND_FILE.PUT_LINE
1497: (
1498: FND_FILE.LOG,