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.

[Home] [Help]

APPS.ZX_TAX_CONTENT_UPLOAD dependencies on DBMS_UTILITY

Line 623: l_start := DBMS_UTILITY.GET_TIME;

619: FETCH C_CNTRY_ID
620: INTO l_cntry_geography_id;
621: CLOSE C_CNTRY_ID;
622:
623: l_start := DBMS_UTILITY.GET_TIME;
624:
625: -- Find the state geography id using abbreviation code. Note that since we
626: -- are using code, even the name change records will get the geography_id.
627: update ZX_DATA_UPLOAD_INTERFACE x

Line 640: l_end := DBMS_UTILITY.GET_TIME;

636: x.status = 'NOCHANGE'
637: where x.record_type = 1;
638:
639: l_rows_processed := SQL%ROWCOUNT;
640: l_end := DBMS_UTILITY.GET_TIME;
641: l_log := 'After State Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
642: FND_FILE.PUT_LINE
643: (
644: FND_FILE.LOG,

Line 648: l_start := DBMS_UTILITY.GET_TIME;

644: FND_FILE.LOG,
645: l_log
646: );
647:
648: l_start := DBMS_UTILITY.GET_TIME;
649:
650: -- Now update the status of the name change record.
651: update ZX_DATA_UPLOAD_INTERFACE x
652: set x.status = 'UPDATE'

Line 663: l_end := DBMS_UTILITY.GET_TIME;

659: and y.country_state_abbreviation = x.country_state_abbreviation
660: and y.effective_to IS NOT NULL);
661:
662: l_rows_processed := SQL%ROWCOUNT;
663: l_end := DBMS_UTILITY.GET_TIME;
664: l_log := 'After State Name Change Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
665: FND_FILE.PUT_LINE
666: (
667: FND_FILE.LOG,

Line 671: l_start := DBMS_UTILITY.GET_TIME;

667: FND_FILE.LOG,
668: l_log
669: );
670:
671: l_start := DBMS_UTILITY.GET_TIME;
672:
673: -- Geography Id's for County for pre-existing geographies
674: -- The state record could have been ended or it could have been sent twice
675: -- with name change, so rownum clause is used.

Line 692: l_end := DBMS_UTILITY.GET_TIME;

688: x.status = 'NOCHANGE'
689: where x.record_type = 3;
690:
691: l_rows_processed := SQL%ROWCOUNT;
692: l_end := DBMS_UTILITY.GET_TIME;
693: l_log := 'After County Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
694: FND_FILE.PUT_LINE
695: (
696: FND_FILE.LOG,

Line 700: l_start := DBMS_UTILITY.GET_TIME;

696: FND_FILE.LOG,
697: l_log
698: );
699:
700: l_start := DBMS_UTILITY.GET_TIME;
701:
702: -- Geography Id's for County for pre-existing geographies, which had name
703: -- change. Use existing record with old name to find the id.
704: update ZX_DATA_UPLOAD_INTERFACE x

Line 717: l_end := DBMS_UTILITY.GET_TIME;

713: and x.geography_id is null
714: and x.effective_to is null;
715:
716: l_rows_processed := SQL%ROWCOUNT;
717: l_end := DBMS_UTILITY.GET_TIME;
718: l_log := 'After County Name Change Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
719: FND_FILE.PUT_LINE
720: (
721: FND_FILE.LOG,

Line 725: l_start := DBMS_UTILITY.GET_TIME;

721: FND_FILE.LOG,
722: l_log
723: );
724:
725: l_start := DBMS_UTILITY.GET_TIME;
726:
727: -- Geography Id's for City for pre-existing geographies.
728: -- This is for the case where a city is in a single county
729: -- or city with multiple counties has been created as multiple geographies.

Line 766: l_end := DBMS_UTILITY.GET_TIME;

762: update zx_data_upload_interface
763: set geography_id = l_geography_ids(i),
764: status = 'NOCHANGE'
765: where rowid = l_rowids(i);
766: l_end := DBMS_UTILITY.GET_TIME;
767: l_log := 'After City Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
768: FND_FILE.PUT_LINE
769: (
770: FND_FILE.LOG,

Line 774: l_start := DBMS_UTILITY.GET_TIME;

770: FND_FILE.LOG,
771: l_log
772: );
773:
774: l_start := DBMS_UTILITY.GET_TIME;
775:
776: -- Geography Id's for City for pre-existing geographies, which had name
777: -- change. Use existing record with old name to find the id.
778: update ZX_DATA_UPLOAD_INTERFACE x

Line 793: l_end := DBMS_UTILITY.GET_TIME;

789: and x.geography_id is null
790: and x.effective_to is null;
791:
792: l_rows_processed := SQL%ROWCOUNT;
793: l_end := DBMS_UTILITY.GET_TIME;
794: l_log := 'After City Name Change Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
795: FND_FILE.PUT_LINE
796: (
797: FND_FILE.LOG,

Line 801: l_start := DBMS_UTILITY.GET_TIME;

797: FND_FILE.LOG,
798: l_log
799: );
800:
801: l_start := DBMS_UTILITY.GET_TIME;
802:
803: -- Get new id for new state and county
804: update ZX_DATA_UPLOAD_INTERFACE
805: set geography_id = hz_geographies_s.nextval,

Line 812: l_end := DBMS_UTILITY.GET_TIME;

808: and geography_id is null
809: and effective_to is null;
810:
811: l_rows_processed := SQL%ROWCOUNT;
812: l_end := DBMS_UTILITY.GET_TIME;
813: l_log := 'After new State and County 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: -- Get new id for new city. In the case of city divided in two or more
823: -- jurisdictions, get new id only for the first one
824: update ZX_DATA_UPLOAD_INTERFACE

Line 851: l_end := DBMS_UTILITY.GET_TIME;

847: WHERE CITY_ROW_NUMBER = 1
848: AND GEOGRAPHY_ID IS NULL);
849:
850: l_rows_processed := SQL%ROWCOUNT;
851: l_end := DBMS_UTILITY.GET_TIME;
852: l_log := 'After new City Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
853: FND_FILE.PUT_LINE
854: (
855: FND_FILE.LOG,

Line 859: l_start := DBMS_UTILITY.GET_TIME;

855: FND_FILE.LOG,
856: l_log
857: );
858:
859: l_start := DBMS_UTILITY.GET_TIME;
860:
861: -- Use the id from previous step for multi jurisdiction cities
862: update ZX_DATA_UPLOAD_INTERFACE a
863: set geography_id = (select b.geography_id

Line 877: l_end := DBMS_UTILITY.GET_TIME;

873: and geography_id is null
874: and effective_to is null;
875:
876: l_rows_processed := SQL%ROWCOUNT;
877: l_end := DBMS_UTILITY.GET_TIME;
878: l_log := 'After new City 2nd Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
879: FND_FILE.PUT_LINE
880: (
881: FND_FILE.LOG,

Line 885: l_start := DBMS_UTILITY.GET_TIME;

881: FND_FILE.LOG,
882: l_log
883: );
884:
885: l_start := DBMS_UTILITY.GET_TIME;
886:
887: -- Update the zip range and alternate city rows with their corresponding city rows
888: update ZX_DATA_UPLOAD_INTERFACE a
889: set (geography_id,status) = (select b.geography_id,b.status

Line 899: l_end := DBMS_UTILITY.GET_TIME;

895: and rownum = 1)
896: where record_type IN (7,8);
897:
898: l_rows_processed := SQL%ROWCOUNT;
899: l_end := DBMS_UTILITY.GET_TIME;
900: l_log := 'After Zip and Alternate City Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
901: FND_FILE.PUT_LINE
902: (
903: FND_FILE.LOG,

Line 913: l_start := DBMS_UTILITY.GET_TIME;

909:
910: IF (p_migrated_tax_regime_flag = 'Y')
911: THEN
912:
913: l_start := DBMS_UTILITY.GET_TIME;
914:
915: -- First update the zone_geography_id for pre-existing states,
916: -- but do this only if a rate exists
917: update ZX_DATA_UPLOAD_INTERFACE x

Line 933: l_end := DBMS_UTILITY.GET_TIME;

929: and y.CITY_JURISDICTION_CODE = x.CITY_JURISDICTION_CODE
930: and y.record_type in (9,10,11,12));*/
931:
932: l_rows_processed := SQL%ROWCOUNT;
933: l_end := DBMS_UTILITY.GET_TIME;
934: l_log := 'After State Zone Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
935: FND_FILE.PUT_LINE
936: (
937: FND_FILE.LOG,

Line 941: l_start := DBMS_UTILITY.GET_TIME;

937: FND_FILE.LOG,
938: l_log
939: );
940:
941: l_start := DBMS_UTILITY.GET_TIME;
942:
943: -- First update the zone_geography_id for pre-existing counties,
944: -- but do this only if a rate exists
945: update ZX_DATA_UPLOAD_INTERFACE x

Line 961: l_end := DBMS_UTILITY.GET_TIME;

957: and y.CITY_JURISDICTION_CODE = x.CITY_JURISDICTION_CODE
958: and y.record_type in (9,10,11,12)); */
959:
960: l_rows_processed := SQL%ROWCOUNT;
961: l_end := DBMS_UTILITY.GET_TIME;
962: l_log := 'After County Zone Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
963: FND_FILE.PUT_LINE
964: (
965: FND_FILE.LOG,

Line 969: l_start := DBMS_UTILITY.GET_TIME;

965: FND_FILE.LOG,
966: l_log
967: );
968:
969: l_start := DBMS_UTILITY.GET_TIME;
970:
971: -- First update the zone_geography_id for pre-existing cities,
972: -- but do this only if a rate exists
973: update ZX_DATA_UPLOAD_INTERFACE x

Line 989: l_end := DBMS_UTILITY.GET_TIME;

985: and y.CITY_JURISDICTION_CODE = x.CITY_JURISDICTION_CODE
986: and y.record_type in (9,10,11,12));*/
987:
988: l_rows_processed := SQL%ROWCOUNT;
989: l_end := DBMS_UTILITY.GET_TIME;
990: l_log := 'After City Zone Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
991: FND_FILE.PUT_LINE
992: (
993: FND_FILE.LOG,

Line 997: l_start := DBMS_UTILITY.GET_TIME;

993: FND_FILE.LOG,
994: l_log
995: );
996:
997: l_start := DBMS_UTILITY.GET_TIME;
998:
999: -- Now, update the zone_geography_id for new records,
1000: -- but do this only if a rate exists
1001: update ZX_DATA_UPLOAD_INTERFACE x

Line 1014: l_end := DBMS_UTILITY.GET_TIME;

1010: and nvl(y.CITY_JURISDICTION_CODE,'-1') = nvl(x.CITY_JURISDICTION_CODE,'-1')
1011: and y.record_type in (9,10,11,12));*/
1012:
1013: l_rows_processed := SQL%ROWCOUNT;
1014: l_end := DBMS_UTILITY.GET_TIME;
1015: l_log := 'After new State/County/City Zone Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1016: FND_FILE.PUT_LINE
1017: (
1018: FND_FILE.LOG,

Line 1022: l_start := DBMS_UTILITY.GET_TIME;

1018: FND_FILE.LOG,
1019: l_log
1020: );
1021:
1022: l_start := DBMS_UTILITY.GET_TIME;
1023:
1024: -- Now, update the zone_geography_id for override rates
1025: -- Update only the first row as there could be multiple rates for one
1026: -- overriding jurisdiction. First case is for city overriding state/county

Line 1067: l_end := DBMS_UTILITY.GET_TIME;

1063: where row_number = 1
1064: );
1065:
1066: l_rows_processed := SQL%ROWCOUNT;
1067: l_end := DBMS_UTILITY.GET_TIME;
1068: l_log := 'After City Override Zone Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1069: FND_FILE.PUT_LINE
1070: (
1071: FND_FILE.LOG,

Line 1075: l_start := DBMS_UTILITY.GET_TIME;

1071: FND_FILE.LOG,
1072: l_log
1073: );
1074:
1075: l_start := DBMS_UTILITY.GET_TIME;
1076:
1077: -- Now, update the zone_geography_id for override rates
1078: -- Update only the first row as there could be multiple rates for one
1079: -- overriding jurisdiction

Line 1116: l_end := DBMS_UTILITY.GET_TIME;

1112: where row_number = 1
1113: );
1114:
1115: l_rows_processed := SQL%ROWCOUNT;
1116: l_end := DBMS_UTILITY.GET_TIME;
1117: l_log := 'After new City Override Zone Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1118: FND_FILE.PUT_LINE
1119: (
1120: FND_FILE.LOG,

Line 1124: l_start := DBMS_UTILITY.GET_TIME;

1120: FND_FILE.LOG,
1121: l_log
1122: );
1123:
1124: l_start := DBMS_UTILITY.GET_TIME;
1125:
1126: -- Now, update the zone_geography_id for override rates
1127: -- Update only the first row as there could be multiple rates for one
1128: -- overriding jurisdiction. First case is for county overriding state

Line 1164: l_end := DBMS_UTILITY.GET_TIME;

1160: where row_number = 1
1161: );
1162:
1163: l_rows_processed := SQL%ROWCOUNT;
1164: l_end := DBMS_UTILITY.GET_TIME;
1165: l_log := 'After County Override Zone Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1166: FND_FILE.PUT_LINE
1167: (
1168: FND_FILE.LOG,

Line 1172: l_start := DBMS_UTILITY.GET_TIME;

1168: FND_FILE.LOG,
1169: l_log
1170: );
1171:
1172: l_start := DBMS_UTILITY.GET_TIME;
1173:
1174: -- Now, update the zone_geography_id for override rates
1175: -- Update only the first row as there could be multiple rates for one
1176: -- overriding jurisdiction

Line 1208: l_end := DBMS_UTILITY.GET_TIME;

1204: where row_number = 1
1205: );
1206:
1207: l_rows_processed := SQL%ROWCOUNT;
1208: l_end := DBMS_UTILITY.GET_TIME;
1209: l_log := 'After new County Override Zone Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1210: FND_FILE.PUT_LINE
1211: (
1212: FND_FILE.LOG,

Line 1218: l_start := DBMS_UTILITY.GET_TIME;

1214: );
1215:
1216: ELSE
1217:
1218: l_start := DBMS_UTILITY.GET_TIME;
1219:
1220: -- First update the zone_geography_id for pre-existing cities,
1221: -- but do this only if a rate exists
1222: update ZX_DATA_UPLOAD_INTERFACE x

Line 1239: l_end := DBMS_UTILITY.GET_TIME;

1235: and y.CITY_JURISDICTION_CODE = x.CITY_JURISDICTION_CODE
1236: and y.record_type in (9,10,11,12));*/
1237:
1238: l_rows_processed := SQL%ROWCOUNT;
1239: l_end := DBMS_UTILITY.GET_TIME;
1240: l_log := 'After City Zone Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1241: FND_FILE.PUT_LINE
1242: (
1243: FND_FILE.LOG,

Line 1247: l_start := DBMS_UTILITY.GET_TIME;

1243: FND_FILE.LOG,
1244: l_log
1245: );
1246:
1247: l_start := DBMS_UTILITY.GET_TIME;
1248:
1249: -- Now, update the zone_geography_id for new records,
1250: -- but do this only if a rate exists
1251: update ZX_DATA_UPLOAD_INTERFACE x

Line 1264: l_end := DBMS_UTILITY.GET_TIME;

1260: and y.CITY_JURISDICTION_CODE = x.CITY_JURISDICTION_CODE
1261: and y.record_type in (9,10,11,12));*/
1262:
1263: l_rows_processed := SQL%ROWCOUNT;
1264: l_end := DBMS_UTILITY.GET_TIME;
1265: l_log := 'After new City Zone Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1266: FND_FILE.PUT_LINE
1267: (
1268: FND_FILE.LOG,