DBA Data[Home] [Help]

APPS.ZX_TDS_TAX_ROUNDING_PKG dependencies on ZX_LINES_DET_FACTORS

Line 185: p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID%TYPE,

181: p_trx_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
182: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
183: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
184: p_internal_organization_id IN ZX_LINES.INTERNAL_ORGANIZATION_ID%TYPE,
185: p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID%TYPE,
186: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
187: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
188: p_return_status OUT NOCOPY VARCHAR2,
189: p_error_buffer OUT NOCOPY VARCHAR2

Line 297: p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID%TYPE,

293: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
294: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
295: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
296: p_internal_organization_id IN ZX_LINES.INTERNAL_ORGANIZATION_ID%TYPE,
297: p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID%TYPE,
298: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
299: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
300: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT%TYPE,
301: p_prd_total_tax_amt_tax_curr OUT NOCOPY ZX_LINES.PRD_TOTAL_TAX_AMT_TAX_CURR%TYPE,

Line 2193: FROM ZX_LINES_DET_FACTORS

2189: provnl_tax_determination_date,
2190: adjusted_doc_date,
2191: trx_line_date,
2192: trx_date) tax_determine_date
2193: FROM ZX_LINES_DET_FACTORS
2194: WHERE application_id = p_event_class_rec.application_id
2195: AND entity_code = p_event_class_rec.entity_code
2196: AND event_class_code = p_event_class_rec.event_class_code
2197: AND trx_id = p_event_class_rec.trx_id

Line 3713: p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID%TYPE,

3709: p_trx_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
3710: p_trx_currency_code IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
3711: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
3712: p_internal_organization_id IN ZX_LINES.INTERNAL_ORGANIZATION_ID%TYPE,
3713: p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID%TYPE,
3714: p_unrounded_taxable_amt IN ZX_LINES.UNROUNDED_TAXABLE_AMT%TYPE,
3715: p_unrounded_tax_amt IN ZX_LINES.UNROUNDED_TAX_AMT%TYPE,
3716: p_return_status OUT NOCOPY VARCHAR2,
3717: p_error_buffer OUT NOCOPY VARCHAR2

Line 4776: p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID%TYPE,

4772: p_min_acct_unit IN OUT NOCOPY ZX_LINES.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
4773: p_precision IN OUT NOCOPY ZX_LINES.PRECISION%TYPE,
4774: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
4775: p_internal_organization_id IN ZX_LINES.INTERNAL_ORGANIZATION_ID%TYPE,
4776: p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.EVENT_CLASS_MAPPING_ID%TYPE,
4777: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
4778: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
4779: p_prd_total_tax_amt IN OUT NOCOPY ZX_LINES.prd_total_tax_amt%TYPE,
4780: p_prd_total_tax_amt_tax_curr OUT NOCOPY ZX_LINES.prd_total_tax_amt_tax_curr%TYPE,

Line 7767: l_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE;

7763: IS
7764:
7765: l_rounding_rule_code ZX_TAXES_B.ROUNDING_RULE_CODE%TYPE;
7766: l_tax_rounding_rule_code ZX_TAXES_B.ROUNDING_RULE_CODE%TYPE;
7767: l_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE;
7768: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
7769: l_trx_min_acct_unit ZX_LINES_DET_FACTORS.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
7770: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;
7771: l_trx_precision ZX_LINES_DET_FACTORS.PRECISION%TYPE;

Line 7769: l_trx_min_acct_unit ZX_LINES_DET_FACTORS.MINIMUM_ACCOUNTABLE_UNIT%TYPE;

7765: l_rounding_rule_code ZX_TAXES_B.ROUNDING_RULE_CODE%TYPE;
7766: l_tax_rounding_rule_code ZX_TAXES_B.ROUNDING_RULE_CODE%TYPE;
7767: l_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE;
7768: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
7769: l_trx_min_acct_unit ZX_LINES_DET_FACTORS.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
7770: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;
7771: l_trx_precision ZX_LINES_DET_FACTORS.PRECISION%TYPE;
7772: l_event_class_rec ZX_API_PUB.EVENT_CLASS_REC_TYPE;
7773: l_unrounded_tax_amt ZX_LINES.UNROUNDED_TAX_AMT%TYPE;

Line 7771: l_trx_precision ZX_LINES_DET_FACTORS.PRECISION%TYPE;

7767: l_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE;
7768: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
7769: l_trx_min_acct_unit ZX_LINES_DET_FACTORS.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
7770: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;
7771: l_trx_precision ZX_LINES_DET_FACTORS.PRECISION%TYPE;
7772: l_event_class_rec ZX_API_PUB.EVENT_CLASS_REC_TYPE;
7773: l_unrounded_tax_amt ZX_LINES.UNROUNDED_TAX_AMT%TYPE;
7774: l_rounding_level_code ZX_PARTY_TAX_PROFILE.Rounding_Level_Code%TYPE;
7775: l_rnd_lvl_party_tax_prof_id ZX_LINES.ROUNDING_LVL_PARTY_TAX_PROF_ID%TYPE;

Line 7797: -- to get trx currency info from zx_lines_det_factors

7793: EVENT_CLASS_CODE = c_event_class_code;
7794:
7795: -- bug#6798349
7796: -- add trx_currency_code, precision, minimum_accountable_unit
7797: -- to get trx currency info from zx_lines_det_factors
7798:
7799: CURSOR get_rnd_tx_prof_id_csr
7800: (c_application_id ZX_LINES.APPLICATION_ID%TYPE,
7801: c_entity_code ZX_LINES.ENTITY_CODE%TYPE,

Line 7816: FROM ZX_LINES_DET_FACTORS

7812: rdng_bill_from_pty_tx_p_st_id,
7813: trx_currency_code,
7814: precision,
7815: minimum_accountable_unit
7816: FROM ZX_LINES_DET_FACTORS
7817: WHERE APPLICATION_ID = c_application_id AND
7818: ENTITY_CODE = c_entity_code AND
7819: EVENT_CLASS_CODE = c_event_class_code AND
7820: TRX_ID = c_trx_id;

Line 7833: (c_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE)

7829: WHERE TAX_ID = c_tax_id;
7830:
7831: -- bug#6798349
7832: CURSOR get_precision_mau_csr
7833: (c_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE)
7834: IS
7835: SELECT minimum_accountable_unit,
7836: precision
7837: FROM FND_CURRENCIES