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_TAXES_PKG dependencies on ZX_TAXES_B

Line 304: cursor C is select ROWID from ZX_TAXES_B

300: X_LIVE_FOR_APPLICABILITY_FLAG in VARCHAR2,
301: X_APPLICABLE_BY_DEFAULT_FLAG in VARCHAR2,
302: X_LEGAL_REPORTING_STATUS_DEF_V in VARCHAR2
303: ) is
304: cursor C is select ROWID from ZX_TAXES_B
305: where TAX_ID = X_TAX_ID
306: ;
307: begin
308: insert into ZX_TAXES_B (

Line 308: insert into ZX_TAXES_B (

304: cursor C is select ROWID from ZX_TAXES_B
305: where TAX_ID = X_TAX_ID
306: ;
307: begin
308: insert into ZX_TAXES_B (
309: ATTRIBUTE13,
310: ATTRIBUTE14,
311: ATTRIBUTE15,
312: ATTRIBUTE_CATEGORY,

Line 807: from ZX_TAXES_B

803: OBJECT_VERSION_NUMBER,
804: LIVE_FOR_APPLICABILITY_FLAG,
805: APPLICABLE_BY_DEFAULT_FLAG,
806: LEGAL_REPORTING_STATUS_DEF_VAL
807: from ZX_TAXES_B
808: where TAX_ID = X_TAX_ID
809: for update of TAX_ID nowait;
810: recinfo c%rowtype;
811: cursor c1 is select

Line 1181: FROM ZX_TAXES_B

1177: SELECT REP_TAX_AUTHORITY_ID,
1178: COLL_TAX_AUTHORITY_ID,
1179: PRIMARY_RECOVERY_TYPE_CODE,
1180: SECONDARY_RECOVERY_TYPE_CODE
1181: FROM ZX_TAXES_B
1182: WHERE TAX_ID = X_TAX_ID;
1183: l_old_references c_old_ref_values%ROWTYPE;
1184: l_old_zone_geo_type ZX_TAXES_B.ZONE_GEOGRAPHY_TYPE%TYPE;
1185: l_old_parent_geo_type ZX_TAXES_B.PARENT_GEOGRAPHY_TYPE%TYPE;

Line 1184: l_old_zone_geo_type ZX_TAXES_B.ZONE_GEOGRAPHY_TYPE%TYPE;

1180: SECONDARY_RECOVERY_TYPE_CODE
1181: FROM ZX_TAXES_B
1182: WHERE TAX_ID = X_TAX_ID;
1183: l_old_references c_old_ref_values%ROWTYPE;
1184: l_old_zone_geo_type ZX_TAXES_B.ZONE_GEOGRAPHY_TYPE%TYPE;
1185: l_old_parent_geo_type ZX_TAXES_B.PARENT_GEOGRAPHY_TYPE%TYPE;
1186: l_old_parent_geo_id ZX_TAXES_B.PARENT_GEOGRAPHY_ID%TYPE;
1187: begin
1188: /*Logic to update ZX_JURISDICTIONS/ZX_REGISTRATIONS table if the Reporting and/or Collecting Tax Authorities have bee

Line 1185: l_old_parent_geo_type ZX_TAXES_B.PARENT_GEOGRAPHY_TYPE%TYPE;

1181: FROM ZX_TAXES_B
1182: WHERE TAX_ID = X_TAX_ID;
1183: l_old_references c_old_ref_values%ROWTYPE;
1184: l_old_zone_geo_type ZX_TAXES_B.ZONE_GEOGRAPHY_TYPE%TYPE;
1185: l_old_parent_geo_type ZX_TAXES_B.PARENT_GEOGRAPHY_TYPE%TYPE;
1186: l_old_parent_geo_id ZX_TAXES_B.PARENT_GEOGRAPHY_ID%TYPE;
1187: begin
1188: /*Logic to update ZX_JURISDICTIONS/ZX_REGISTRATIONS table if the Reporting and/or Collecting Tax Authorities have bee
1189: n changed*/

Line 1186: l_old_parent_geo_id ZX_TAXES_B.PARENT_GEOGRAPHY_ID%TYPE;

1182: WHERE TAX_ID = X_TAX_ID;
1183: l_old_references c_old_ref_values%ROWTYPE;
1184: l_old_zone_geo_type ZX_TAXES_B.ZONE_GEOGRAPHY_TYPE%TYPE;
1185: l_old_parent_geo_type ZX_TAXES_B.PARENT_GEOGRAPHY_TYPE%TYPE;
1186: l_old_parent_geo_id ZX_TAXES_B.PARENT_GEOGRAPHY_ID%TYPE;
1187: begin
1188: /*Logic to update ZX_JURISDICTIONS/ZX_REGISTRATIONS table if the Reporting and/or Collecting Tax Authorities have bee
1189: n changed*/
1190: open c_old_ref_values;

Line 1268: FROM ZX_TAXES_B WHERE TAX_ID = X_TAX_ID;

1264: if(X_RECORD_TYPE_CODE = 'MIGRATED' AND X_SOURCE_TAX_FLAG = 'Y') then
1265: begin
1266: SELECT ZONE_GEOGRAPHY_TYPE, PARENT_GEOGRAPHY_TYPE, PARENT_GEOGRAPHY_ID INTO
1267: l_old_zone_geo_type, l_old_parent_geo_type, l_old_parent_geo_id
1268: FROM ZX_TAXES_B WHERE TAX_ID = X_TAX_ID;
1269: if(nvl(l_old_zone_geo_type, '-1') <> nvl(X_ZONE_GEOGRAPHY_TYPE, '-1') OR
1270: nvl(l_old_parent_geo_type, '-1') <> nvl(X_PARENT_GEOGRAPHY_TYPE, '-1') OR
1271: nvl(l_old_parent_geo_id, -1) <> nvl(X_PARENT_GEOGRAPHY_ID, -1)) then
1272: UPDATE ZX_TAXES_B SET ZONE_GEOGRAPHY_TYPE = X_ZONE_GEOGRAPHY_TYPE,

Line 1272: UPDATE ZX_TAXES_B SET ZONE_GEOGRAPHY_TYPE = X_ZONE_GEOGRAPHY_TYPE,

1268: FROM ZX_TAXES_B WHERE TAX_ID = X_TAX_ID;
1269: if(nvl(l_old_zone_geo_type, '-1') <> nvl(X_ZONE_GEOGRAPHY_TYPE, '-1') OR
1270: nvl(l_old_parent_geo_type, '-1') <> nvl(X_PARENT_GEOGRAPHY_TYPE, '-1') OR
1271: nvl(l_old_parent_geo_id, -1) <> nvl(X_PARENT_GEOGRAPHY_ID, -1)) then
1272: UPDATE ZX_TAXES_B SET ZONE_GEOGRAPHY_TYPE = X_ZONE_GEOGRAPHY_TYPE,
1273: PARENT_GEOGRAPHY_TYPE = X_PARENT_GEOGRAPHY_TYPE,
1274: PARENT_GEOGRAPHY_ID = X_PARENT_GEOGRAPHY_ID
1275: WHERE TAX = X_TAX AND
1276: TAX_REGIME_CODE = X_TAX_REGIME_CODE AND

Line 1284: update ZX_TAXES_B set

1280: raise no_data_found;
1281: end;
1282: end if;
1283: /*Insert/Update of ZX_RECOVERY_TYPES_VL ends here*/
1284: update ZX_TAXES_B set
1285: ATTRIBUTE13 = X_ATTRIBUTE13,
1286: ATTRIBUTE14 = X_ATTRIBUTE14,
1287: ATTRIBUTE15 = X_ATTRIBUTE15,
1288: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,

Line 1420: delete from ZX_TAXES_B

1416: where TAX_ID = X_TAX_ID;
1417: if (sql%notfound) then
1418: raise no_data_found;
1419: end if;
1420: delete from ZX_TAXES_B
1421: where TAX_ID = X_TAX_ID;
1422: if (sql%notfound) then
1423: raise no_data_found;
1424: end if;

Line 1432: from ZX_TAXES_B B

1428: begin
1429: delete from ZX_TAXES_TL T
1430: where not exists
1431: (select NULL
1432: from ZX_TAXES_B B
1433: where B.TAX_ID = T.TAX_ID
1434: );
1435: update ZX_TAXES_TL T set (
1436: TAX_FULL_NAME