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_RATES_PKG dependencies on ZX_ID_TCC_MAPPING_ALL

Line 358: /* Calling procedure POPULATE_ID_TCC_MAPPING_ALL to populate the ZX_ID_TCC_MAPPING_ALL table. */

354: AND A.CONTENT_OWNER_ID = -99;
355: END;
356:
357:
358: /* Calling procedure POPULATE_ID_TCC_MAPPING_ALL to populate the ZX_ID_TCC_MAPPING_ALL table. */
359:
360: POPULATE_ID_TCC_MAPPING_ALL (
361: X_TAX_RATE_ID,
362: X_TAX_RATE_CODE,

Line 852: /* Calling procedure POPULATE_ID_TCC_MAPPING_ALL to populate the ZX_ID_TCC_MAPPING_ALL table. */

848: AND A.TAX_REGIME_CODE = X_TAX_REGIME_CODE
849: AND A.CONTENT_OWNER_ID = -99;
850: END;
851:
852: /* Calling procedure POPULATE_ID_TCC_MAPPING_ALL to populate the ZX_ID_TCC_MAPPING_ALL table. */
853:
854: POPULATE_ID_TCC_MAPPING_ALL (
855: X_TAX_RATE_ID,
856: X_TAX_RATE_CODE,

Line 1048: /* Insert into ZX_ID_TCC_MAPPING_ALL table when ever the new rate is being created;

1044: L_EFFECTIVE_FROM DATE;
1045: L_EFFECTIVE_TO DATE;
1046:
1047: begin
1048: /* Insert into ZX_ID_TCC_MAPPING_ALL table when ever the new rate is being created;
1049: * And if the record is already present then it will update the existing record.
1050: * If content owner is OU, add a record in zx_id_tcc_mapping_all table for each new tax rate
1051: * code created (tax_class = NULL and source = NULL).
1052: * Also note that we can create records in this table from the Conditions

Line 1050: * If content owner is OU, add a record in zx_id_tcc_mapping_all table for each new tax rate

1046:
1047: begin
1048: /* Insert into ZX_ID_TCC_MAPPING_ALL table when ever the new rate is being created;
1049: * And if the record is already present then it will update the existing record.
1050: * If content owner is OU, add a record in zx_id_tcc_mapping_all table for each new tax rate
1051: * code created (tax_class = NULL and source = NULL).
1052: * Also note that we can create records in this table from the Conditions
1053: * flow too. In that case we stamp the TaxRateCodeId as the negative of
1054: * ConditionGroupId: Bug 5249603

Line 1101: UPDATE ZX_ID_TCC_MAPPING_ALL

1097: END;
1098:
1099: END IF;
1100:
1101: UPDATE ZX_ID_TCC_MAPPING_ALL
1102: SET
1103: EFFECTIVE_TO = L_EFFECTIVE_TO, --effective_to
1104: ACTIVE_FLAG = X_Active_Flag, -- Active_flag
1105: LAST_UPDATED_BY = fnd_global.user_id, --last_updated_by

Line 1116: INSERT INTO ZX_ID_TCC_MAPPING_ALL

1112:
1113:
1114: IF (SQL%NOTFOUND)
1115: then
1116: INSERT INTO ZX_ID_TCC_MAPPING_ALL
1117: (
1118: TCC_MAPPING_ID ,
1119: ORG_ID ,
1120: TAX_CLASS ,

Line 1140: ZX_ID_TCC_MAPPING_ALL_S.nextval , --tcc_mapping_id

1136: LEDGER_ID ,
1137: ACTIVE_FLAG
1138: )
1139: select
1140: ZX_ID_TCC_MAPPING_ALL_S.nextval , --tcc_mapping_id
1141: X_ORG_ID , --org_id
1142: X_TAX_CLASS , --tax_class
1143: X_TAX_RATE_ID , --tax_rate_code_id
1144: X_TAX_RATE_CODE , --tax_classification_code

Line 1164: (SELECT NULL FROM ZX_ID_TCC_MAPPING_ALL

1160: FROM
1161: dual
1162: WHERE
1163: NOT EXISTS
1164: (SELECT NULL FROM ZX_ID_TCC_MAPPING_ALL
1165: WHERE TAX_CLASSIFICATION_CODE = X_TAX_RATE_CODE
1166: AND ORG_ID = X_ORG_ID
1167: AND TAX_RATE_CODE_ID = X_TAX_RATE_ID
1168: );