APPS.ZX_RATES_PKG dependencies on ZX_ID_TCC_MAPPING_ALL

Line 64: -- the correct tax_rate_code_id when updating ZX_ID_TCC_MAPPING_ALL

60: -- end bug#6992215
61:
62: -- bug 12392129 start
63: -- added the new procedure to take p_source_id as a parameter to check for
64: -- the correct tax_rate_code_id when updating ZX_ID_TCC_MAPPING_ALL
65: --
66: PROCEDURE POPULATE_ID_TCC_MAPPING_PVT (
67: p_tax_rate_id IN NUMBER,
68: p_source_id IN NUMBER,

Line 85: -- Insert into ZX_ID_TCC_MAPPING_ALL table when ever the new rate is being created;

81: l_effective_to DATE;
82:
83: BEGIN
84:
85: -- Insert into ZX_ID_TCC_MAPPING_ALL table when ever the new rate is being created;
86: -- And if the record is already present then it will update the existing record.
87: -- If content owner is OU, add a record in zx_id_tcc_mapping_all table for each new tax rate
88: -- code created (tax_class = NULL and source = NULL).
89: -- Also note that we can create records in this table from the Conditions

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

83: BEGIN
84:
85: -- Insert into ZX_ID_TCC_MAPPING_ALL table when ever the new rate is being created;
86: -- And if the record is already present then it will update the existing record.
87: -- If content owner is OU, add a record in zx_id_tcc_mapping_all table for each new tax rate
88: -- code created (tax_class = NULL and source = NULL).
89: -- Also note that we can create records in this table from the Conditions
90: -- flow too. In that case we stamp the TaxRateCodeId as the negative of
91: -- ConditionGroupId: Bug 5249603

Line 131: UPDATE ZX_ID_TCC_MAPPING_ALL

127: NULL;
128: END;
129: END IF; -- l_effective_from IS NULL
130:
131: UPDATE ZX_ID_TCC_MAPPING_ALL
132: SET effective_to = l_effective_to,
133: active_flag = p_active_flag,
134: last_updated_by = fnd_global.user_id,
135: last_update_date = SYSDATE,

Line 145: INSERT INTO ZX_ID_TCC_MAPPING_ALL

141: p_tax_rate_id < 0
142: );
143:
144: IF (SQL%NOTFOUND) THEN
145: INSERT INTO ZX_ID_TCC_MAPPING_ALL
146: (
147: tcc_mapping_id ,
148: org_id ,
149: tax_class ,

Line 169: zx_id_tcc_mapping_all_s.NEXTVAL , --tcc_mapping_id

165: ledger_id ,
166: active_flag
167: )
168: SELECT
169: zx_id_tcc_mapping_all_s.NEXTVAL , --tcc_mapping_id
170: p_org_id , --org_id
171: p_tax_class , --tax_class
172: p_tax_rate_id , --tax_rate_code_id
173: p_tax_rate_code , --tax_classification_code

Line 191: FROM zx_id_tcc_mapping_all

187: p_ledger_id , --ledger_id
188: p_active_flag --active_flag
189: FROM DUAL
190: WHERE NOT EXISTS (SELECT 1
191: FROM zx_id_tcc_mapping_all
192: WHERE tax_classification_code = p_tax_rate_code
193: AND org_id = p_org_id
194: AND tax_rate_code_id = p_tax_rate_id
195: );

Line 499: -- Calling procedure POPULATE_ID_TCC_MAPPING_ALL to populate the ZX_ID_TCC_MAPPING_ALL table.

495: AND A.TAX_REGIME_CODE = X_TAX_REGIME_CODE
496: AND A.CONTENT_OWNER_ID = -99;
497: END;
498:
499: -- Calling procedure POPULATE_ID_TCC_MAPPING_ALL to populate the ZX_ID_TCC_MAPPING_ALL table.
500:
501: POPULATE_ID_TCC_MAPPING_PVT (
502: p_tax_rate_id => x_tax_rate_id,
503: p_source_id => x_source_id,

Line 1000: -- Calling procedure POPULATE_ID_TCC_MAPPING_ALL to populate the ZX_ID_TCC_MAPPING_ALL table.

996: AND A.TAX_REGIME_CODE = X_TAX_REGIME_CODE
997: AND A.CONTENT_OWNER_ID = -99;
998: END;
999:
1000: -- Calling procedure POPULATE_ID_TCC_MAPPING_ALL to populate the ZX_ID_TCC_MAPPING_ALL table.
1001:
1002: POPULATE_ID_TCC_MAPPING_PVT (
1003: p_tax_rate_id => x_tax_rate_id,
1004: p_source_id => x_source_id,