1717: --
1718:
1719: IF l_tax_prof_name = 'SHIP_TO_PARTY_TAX_PROF_ID' THEN
1720: l_tax_prof_id :=
1721: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ship_to_party_tax_prof_id(p_trx_line_index);
1722: l_parent_ptp_id := l_tax_prof_id;
1723: l_site_ptp_id := NULL;
1724: ELSIF l_tax_prof_name = 'SHIP_FROM_PARTY_TAX_PROF_ID' THEN
1725: l_tax_prof_id :=
1722: l_parent_ptp_id := l_tax_prof_id;
1723: l_site_ptp_id := NULL;
1724: ELSIF l_tax_prof_name = 'SHIP_FROM_PARTY_TAX_PROF_ID' THEN
1725: l_tax_prof_id :=
1726: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ship_from_party_tax_prof_id(p_trx_line_index);
1727: l_parent_ptp_id := l_tax_prof_id;
1728: l_site_ptp_id := NULL;
1729: ELSIF l_tax_prof_name = 'BILL_TO_PARTY_TAX_PROF_ID' THEN
1730: l_tax_prof_id :=
1727: l_parent_ptp_id := l_tax_prof_id;
1728: l_site_ptp_id := NULL;
1729: ELSIF l_tax_prof_name = 'BILL_TO_PARTY_TAX_PROF_ID' THEN
1730: l_tax_prof_id :=
1731: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.bill_to_party_tax_prof_id(p_trx_line_index);
1732: l_parent_ptp_id := l_tax_prof_id;
1733: l_site_ptp_id := NULL;
1734: ELSIF l_tax_prof_name = 'BILL_FROM_PARTY_TAX_PROF_ID' THEN
1735: l_tax_prof_id :=
1732: l_parent_ptp_id := l_tax_prof_id;
1733: l_site_ptp_id := NULL;
1734: ELSIF l_tax_prof_name = 'BILL_FROM_PARTY_TAX_PROF_ID' THEN
1735: l_tax_prof_id :=
1736: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.bill_from_party_tax_prof_id(p_trx_line_index);
1737: l_parent_ptp_id := l_tax_prof_id;
1738: l_site_ptp_id := NULL;
1739: ELSIF l_tax_prof_name = 'SHIP_TO_SITE_TAX_PROF_ID' THEN
1740: l_tax_prof_id :=
1737: l_parent_ptp_id := l_tax_prof_id;
1738: l_site_ptp_id := NULL;
1739: ELSIF l_tax_prof_name = 'SHIP_TO_SITE_TAX_PROF_ID' THEN
1740: l_tax_prof_id :=
1741: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ship_to_site_tax_prof_id(p_trx_line_index);
1742: l_parent_ptp_id :=
1743: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ship_to_party_tax_prof_id(p_trx_line_index);
1744: l_site_ptp_id := l_tax_prof_id;
1745: ELSIF l_tax_prof_name = 'SHIP_FROM_SITE_TAX_PROF_ID' THEN
1739: ELSIF l_tax_prof_name = 'SHIP_TO_SITE_TAX_PROF_ID' THEN
1740: l_tax_prof_id :=
1741: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ship_to_site_tax_prof_id(p_trx_line_index);
1742: l_parent_ptp_id :=
1743: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ship_to_party_tax_prof_id(p_trx_line_index);
1744: l_site_ptp_id := l_tax_prof_id;
1745: ELSIF l_tax_prof_name = 'SHIP_FROM_SITE_TAX_PROF_ID' THEN
1746: l_tax_prof_id :=
1747: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ship_from_site_tax_prof_id(p_trx_line_index);
1743: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ship_to_party_tax_prof_id(p_trx_line_index);
1744: l_site_ptp_id := l_tax_prof_id;
1745: ELSIF l_tax_prof_name = 'SHIP_FROM_SITE_TAX_PROF_ID' THEN
1746: l_tax_prof_id :=
1747: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ship_from_site_tax_prof_id(p_trx_line_index);
1748: l_parent_ptp_id :=
1749: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ship_from_party_tax_prof_id(p_trx_line_index);
1750: l_site_ptp_id := l_tax_prof_id;
1751: ELSIF l_tax_prof_name = 'BILL_TO_SITE_TAX_PROF_ID' THEN
1745: ELSIF l_tax_prof_name = 'SHIP_FROM_SITE_TAX_PROF_ID' THEN
1746: l_tax_prof_id :=
1747: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ship_from_site_tax_prof_id(p_trx_line_index);
1748: l_parent_ptp_id :=
1749: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ship_from_party_tax_prof_id(p_trx_line_index);
1750: l_site_ptp_id := l_tax_prof_id;
1751: ELSIF l_tax_prof_name = 'BILL_TO_SITE_TAX_PROF_ID' THEN
1752: l_tax_prof_id :=
1753: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.bill_to_site_tax_prof_id(p_trx_line_index);
1749: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ship_from_party_tax_prof_id(p_trx_line_index);
1750: l_site_ptp_id := l_tax_prof_id;
1751: ELSIF l_tax_prof_name = 'BILL_TO_SITE_TAX_PROF_ID' THEN
1752: l_tax_prof_id :=
1753: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.bill_to_site_tax_prof_id(p_trx_line_index);
1754: l_parent_ptp_id :=
1755: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.bill_to_party_tax_prof_id(p_trx_line_index);
1756: l_site_ptp_id := l_tax_prof_id;
1757: ELSIF l_tax_prof_name = 'BILL_FROM_SITE_TAX_PROF_ID' THEN
1751: ELSIF l_tax_prof_name = 'BILL_TO_SITE_TAX_PROF_ID' THEN
1752: l_tax_prof_id :=
1753: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.bill_to_site_tax_prof_id(p_trx_line_index);
1754: l_parent_ptp_id :=
1755: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.bill_to_party_tax_prof_id(p_trx_line_index);
1756: l_site_ptp_id := l_tax_prof_id;
1757: ELSIF l_tax_prof_name = 'BILL_FROM_SITE_TAX_PROF_ID' THEN
1758: l_tax_prof_id :=
1759: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.bill_from_site_tax_prof_id(p_trx_line_index);
1755: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.bill_to_party_tax_prof_id(p_trx_line_index);
1756: l_site_ptp_id := l_tax_prof_id;
1757: ELSIF l_tax_prof_name = 'BILL_FROM_SITE_TAX_PROF_ID' THEN
1758: l_tax_prof_id :=
1759: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.bill_from_site_tax_prof_id(p_trx_line_index);
1760: l_parent_ptp_id :=
1761: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.bill_from_party_tax_prof_id(p_trx_line_index);
1762: l_site_ptp_id := l_tax_prof_id;
1763: END IF;
1757: ELSIF l_tax_prof_name = 'BILL_FROM_SITE_TAX_PROF_ID' THEN
1758: l_tax_prof_id :=
1759: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.bill_from_site_tax_prof_id(p_trx_line_index);
1760: l_parent_ptp_id :=
1761: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.bill_from_party_tax_prof_id(p_trx_line_index);
1762: l_site_ptp_id := l_tax_prof_id;
1763: END IF;
1764:
1765: IF (g_level_statement >= g_current_runtime_level ) THEN
1776: --
1777: IF SUBSTR(p_Party_Type_Code, 1, 4) = 'SHIP' THEN
1778:
1779: l_account_id :=
1780: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ship_third_pty_acct_id(p_trx_line_index);
1781: l_account_site_id :=
1782: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ship_third_pty_acct_site_id(p_trx_line_index);
1783: l_site_use_id :=
1784: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ship_to_cust_acct_site_use_id(p_trx_line_index);
1778:
1779: l_account_id :=
1780: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ship_third_pty_acct_id(p_trx_line_index);
1781: l_account_site_id :=
1782: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ship_third_pty_acct_site_id(p_trx_line_index);
1783: l_site_use_id :=
1784: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ship_to_cust_acct_site_use_id(p_trx_line_index);
1785:
1786: ELSIF SUBSTR(p_Party_Type_Code, 1, 4) = 'BILL' THEN
1780: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ship_third_pty_acct_id(p_trx_line_index);
1781: l_account_site_id :=
1782: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ship_third_pty_acct_site_id(p_trx_line_index);
1783: l_site_use_id :=
1784: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ship_to_cust_acct_site_use_id(p_trx_line_index);
1785:
1786: ELSIF SUBSTR(p_Party_Type_Code, 1, 4) = 'BILL' THEN
1787:
1788: l_account_id :=
1785:
1786: ELSIF SUBSTR(p_Party_Type_Code, 1, 4) = 'BILL' THEN
1787:
1788: l_account_id :=
1789: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.bill_third_pty_acct_id(p_trx_line_index);
1790: l_account_site_id :=
1791: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.bill_third_pty_acct_site_id(p_trx_line_index);
1792: l_site_use_id :=
1793: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.bill_to_cust_acct_site_use_id(p_trx_line_index);
1787:
1788: l_account_id :=
1789: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.bill_third_pty_acct_id(p_trx_line_index);
1790: l_account_site_id :=
1791: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.bill_third_pty_acct_site_id(p_trx_line_index);
1792: l_site_use_id :=
1793: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.bill_to_cust_acct_site_use_id(p_trx_line_index);
1794:
1795: ELSE
1789: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.bill_third_pty_acct_id(p_trx_line_index);
1790: l_account_site_id :=
1791: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.bill_third_pty_acct_site_id(p_trx_line_index);
1792: l_site_use_id :=
1793: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.bill_to_cust_acct_site_use_id(p_trx_line_index);
1794:
1795: ELSE
1796: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1797: p_error_buffer := 'Invalid Rounding Level Hierarchy';
2373: CLOSE get_lines_det_factors ;
2374:
2375: ELSE --PLS --Bug 5103375
2376:
2377: FOR i IN ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id.FIRST ..
2378: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id.LAST
2379: LOOP
2380:
2381: IF p_event_class_rec.application_id =
2374:
2375: ELSE --PLS --Bug 5103375
2376:
2377: FOR i IN ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id.FIRST ..
2378: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id.LAST
2379: LOOP
2380:
2381: IF p_event_class_rec.application_id =
2382: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(i) AND
2378: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id.LAST
2379: LOOP
2380:
2381: IF p_event_class_rec.application_id =
2382: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(i) AND
2383: p_event_class_rec.entity_code =
2384: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(i) AND
2385: p_event_class_rec.event_class_code =
2386: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(i) AND
2380:
2381: IF p_event_class_rec.application_id =
2382: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(i) AND
2383: p_event_class_rec.entity_code =
2384: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(i) AND
2385: p_event_class_rec.event_class_code =
2386: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(i) AND
2387: p_event_class_rec.trx_id =
2388: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id(i)
2382: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(i) AND
2383: p_event_class_rec.entity_code =
2384: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(i) AND
2385: p_event_class_rec.event_class_code =
2386: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(i) AND
2387: p_event_class_rec.trx_id =
2388: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id(i)
2389: THEN
2390:
2384: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(i) AND
2385: p_event_class_rec.event_class_code =
2386: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(i) AND
2387: p_event_class_rec.trx_id =
2388: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id(i)
2389: THEN
2390:
2391: l_ship_third_pty_acct_id :=
2392: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ship_third_pty_acct_id(i);
2388: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id(i)
2389: THEN
2390:
2391: l_ship_third_pty_acct_id :=
2392: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ship_third_pty_acct_id(i);
2393: l_bill_third_pty_acct_id :=
2394: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.bill_third_pty_acct_id(i);
2395: l_ship_third_pty_acct_site_id :=
2396: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ship_third_pty_acct_site_id(i);
2390:
2391: l_ship_third_pty_acct_id :=
2392: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ship_third_pty_acct_id(i);
2393: l_bill_third_pty_acct_id :=
2394: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.bill_third_pty_acct_id(i);
2395: l_ship_third_pty_acct_site_id :=
2396: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ship_third_pty_acct_site_id(i);
2397: l_bill_third_pty_acct_site_id :=
2398: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.bill_third_pty_acct_site_id(i);
2392: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ship_third_pty_acct_id(i);
2393: l_bill_third_pty_acct_id :=
2394: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.bill_third_pty_acct_id(i);
2395: l_ship_third_pty_acct_site_id :=
2396: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ship_third_pty_acct_site_id(i);
2397: l_bill_third_pty_acct_site_id :=
2398: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.bill_third_pty_acct_site_id(i);
2399: l_ship_to_cust_acct_st_use_id :=
2400: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ship_to_cust_acct_site_use_id(i);
2394: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.bill_third_pty_acct_id(i);
2395: l_ship_third_pty_acct_site_id :=
2396: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ship_third_pty_acct_site_id(i);
2397: l_bill_third_pty_acct_site_id :=
2398: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.bill_third_pty_acct_site_id(i);
2399: l_ship_to_cust_acct_st_use_id :=
2400: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ship_to_cust_acct_site_use_id(i);
2401: l_bill_to_cust_acct_st_use_id :=
2402: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.bill_to_cust_acct_site_use_id(i);
2396: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ship_third_pty_acct_site_id(i);
2397: l_bill_third_pty_acct_site_id :=
2398: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.bill_third_pty_acct_site_id(i);
2399: l_ship_to_cust_acct_st_use_id :=
2400: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ship_to_cust_acct_site_use_id(i);
2401: l_bill_to_cust_acct_st_use_id :=
2402: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.bill_to_cust_acct_site_use_id(i);
2403:
2404: ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_date(
2398: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.bill_third_pty_acct_site_id(i);
2399: l_ship_to_cust_acct_st_use_id :=
2400: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ship_to_cust_acct_site_use_id(i);
2401: l_bill_to_cust_acct_st_use_id :=
2402: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.bill_to_cust_acct_site_use_id(i);
2403:
2404: ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_date(
2405: i,
2406: l_tax_date,
7786: p_rounding_level_code := NULL;
7787: p_rounding_rule_code := NULL;
7788:
7789:
7790: IF ZX_GLOBAL_STRUCTURES_PKG.g_supp_site_info_tbl.exists(p_account_site_id) THEN
7791:
7792: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7793: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX_TDS_TAX_ROUNDING_PKG.Get_Supplier_Site',
7794: 'Vendor site record found in cache for vendor site id:'||to_char(p_account_site_id));
7793: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX_TDS_TAX_ROUNDING_PKG.Get_Supplier_Site',
7794: 'Vendor site record found in cache for vendor site id:'||to_char(p_account_site_id));
7795: END IF;
7796:
7797: p_rounding_rule_code := ZX_GLOBAL_STRUCTURES_PKG.g_supp_site_info_tbl(p_account_site_id).TAX_ROUNDING_RULE;
7798: P_rounding_level_code := ZX_GLOBAL_STRUCTURES_PKG.g_supp_site_info_tbl(p_account_site_id).TAX_ROUNDING_LEVEL;
7799: ZX_TDS_CALC_SERVICES_PUB_PKG.g_process_for_appl_flg := ZX_GLOBAL_STRUCTURES_PKG.g_supp_site_info_tbl(p_account_site_id).Auto_Tax_Calc_Flag;
7800:
7801: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7794: 'Vendor site record found in cache for vendor site id:'||to_char(p_account_site_id));
7795: END IF;
7796:
7797: p_rounding_rule_code := ZX_GLOBAL_STRUCTURES_PKG.g_supp_site_info_tbl(p_account_site_id).TAX_ROUNDING_RULE;
7798: P_rounding_level_code := ZX_GLOBAL_STRUCTURES_PKG.g_supp_site_info_tbl(p_account_site_id).TAX_ROUNDING_LEVEL;
7799: ZX_TDS_CALC_SERVICES_PUB_PKG.g_process_for_appl_flg := ZX_GLOBAL_STRUCTURES_PKG.g_supp_site_info_tbl(p_account_site_id).Auto_Tax_Calc_Flag;
7800:
7801: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7802: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX_TDS_TAX_ROUNDING_PKG.Get_Supplier_Site',
7795: END IF;
7796:
7797: p_rounding_rule_code := ZX_GLOBAL_STRUCTURES_PKG.g_supp_site_info_tbl(p_account_site_id).TAX_ROUNDING_RULE;
7798: P_rounding_level_code := ZX_GLOBAL_STRUCTURES_PKG.g_supp_site_info_tbl(p_account_site_id).TAX_ROUNDING_LEVEL;
7799: ZX_TDS_CALC_SERVICES_PUB_PKG.g_process_for_appl_flg := ZX_GLOBAL_STRUCTURES_PKG.g_supp_site_info_tbl(p_account_site_id).Auto_Tax_Calc_Flag;
7800:
7801: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7802: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX_TDS_TAX_ROUNDING_PKG.Get_Supplier_Site',
7803: 'ZX_TDS_CALC_SERVICES_PUB_PKG.g_process_for_appl_flg '|| ZX_TDS_CALC_SERVICES_PUB_PKG.g_process_for_appl_flg );
7822: 'Auto tax calc flag '|| l_auto_tax_calc_flag);
7823: END IF;
7824:
7825:
7826: ZX_GLOBAL_STRUCTURES_PKG.g_supp_site_info_tbl(p_account_site_id).TAX_ROUNDING_RULE :=
7827: l_ap_tax_rounding_rule;
7828: ZX_GLOBAL_STRUCTURES_PKG.g_supp_site_info_tbl(p_account_site_id).Auto_Tax_Calc_Flag :=
7829: l_auto_tax_calc_flag;
7830: ZX_GLOBAL_STRUCTURES_PKG.g_supp_site_info_tbl(p_account_site_id).VAT_CODE := l_vat_code;
7824:
7825:
7826: ZX_GLOBAL_STRUCTURES_PKG.g_supp_site_info_tbl(p_account_site_id).TAX_ROUNDING_RULE :=
7827: l_ap_tax_rounding_rule;
7828: ZX_GLOBAL_STRUCTURES_PKG.g_supp_site_info_tbl(p_account_site_id).Auto_Tax_Calc_Flag :=
7829: l_auto_tax_calc_flag;
7830: ZX_GLOBAL_STRUCTURES_PKG.g_supp_site_info_tbl(p_account_site_id).VAT_CODE := l_vat_code;
7831: ZX_GLOBAL_STRUCTURES_PKG.g_supp_site_info_tbl(p_account_site_id).TAX_ROUNDING_LEVEL :=
7832: l_tax_rounding_level;
7826: ZX_GLOBAL_STRUCTURES_PKG.g_supp_site_info_tbl(p_account_site_id).TAX_ROUNDING_RULE :=
7827: l_ap_tax_rounding_rule;
7828: ZX_GLOBAL_STRUCTURES_PKG.g_supp_site_info_tbl(p_account_site_id).Auto_Tax_Calc_Flag :=
7829: l_auto_tax_calc_flag;
7830: ZX_GLOBAL_STRUCTURES_PKG.g_supp_site_info_tbl(p_account_site_id).VAT_CODE := l_vat_code;
7831: ZX_GLOBAL_STRUCTURES_PKG.g_supp_site_info_tbl(p_account_site_id).TAX_ROUNDING_LEVEL :=
7832: l_tax_rounding_level;
7833: ZX_GLOBAL_STRUCTURES_PKG.g_supp_site_info_tbl(p_account_site_id).VAT_REGISTRATION_NUM :=
7834: l_vat_registration_num;
7827: l_ap_tax_rounding_rule;
7828: ZX_GLOBAL_STRUCTURES_PKG.g_supp_site_info_tbl(p_account_site_id).Auto_Tax_Calc_Flag :=
7829: l_auto_tax_calc_flag;
7830: ZX_GLOBAL_STRUCTURES_PKG.g_supp_site_info_tbl(p_account_site_id).VAT_CODE := l_vat_code;
7831: ZX_GLOBAL_STRUCTURES_PKG.g_supp_site_info_tbl(p_account_site_id).TAX_ROUNDING_LEVEL :=
7832: l_tax_rounding_level;
7833: ZX_GLOBAL_STRUCTURES_PKG.g_supp_site_info_tbl(p_account_site_id).VAT_REGISTRATION_NUM :=
7834: l_vat_registration_num;
7835: ZX_TDS_CALC_SERVICES_PUB_PKG.g_process_for_appl_flg := l_auto_tax_calc_flag;
7829: l_auto_tax_calc_flag;
7830: ZX_GLOBAL_STRUCTURES_PKG.g_supp_site_info_tbl(p_account_site_id).VAT_CODE := l_vat_code;
7831: ZX_GLOBAL_STRUCTURES_PKG.g_supp_site_info_tbl(p_account_site_id).TAX_ROUNDING_LEVEL :=
7832: l_tax_rounding_level;
7833: ZX_GLOBAL_STRUCTURES_PKG.g_supp_site_info_tbl(p_account_site_id).VAT_REGISTRATION_NUM :=
7834: l_vat_registration_num;
7835: ZX_TDS_CALC_SERVICES_PUB_PKG.g_process_for_appl_flg := l_auto_tax_calc_flag;
7836:
7837: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7925: p_return_status := FND_API.G_RET_STS_SUCCESS;
7926: p_rounding_level_code := NULL;
7927: p_rounding_rule_code := NULL;
7928:
7929: IF ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl.exists(p_site_use_id) then
7930: p_Rounding_Rule_Code:=
7931: ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).tax_rounding_rule;
7932:
7933: IF ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).tax_header_level_flag = 'Y' THEN
7927: p_rounding_rule_code := NULL;
7928:
7929: IF ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl.exists(p_site_use_id) then
7930: p_Rounding_Rule_Code:=
7931: ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).tax_rounding_rule;
7932:
7933: IF ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).tax_header_level_flag = 'Y' THEN
7934: p_rounding_level_code := 'HEADER';
7935: ELSIF ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).tax_header_level_flag = 'N' THEN
7929: IF ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl.exists(p_site_use_id) then
7930: p_Rounding_Rule_Code:=
7931: ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).tax_rounding_rule;
7932:
7933: IF ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).tax_header_level_flag = 'Y' THEN
7934: p_rounding_level_code := 'HEADER';
7935: ELSIF ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).tax_header_level_flag = 'N' THEN
7936: p_rounding_level_code := 'LINE';
7937: END IF;
7931: ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).tax_rounding_rule;
7932:
7933: IF ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).tax_header_level_flag = 'Y' THEN
7934: p_rounding_level_code := 'HEADER';
7935: ELSIF ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).tax_header_level_flag = 'N' THEN
7936: p_rounding_level_code := 'LINE';
7937: END IF;
7938:
7939: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7955:
7956: CLOSE c_site_uses;
7957:
7958: -- Populate the cache
7959: ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).site_use_id := p_site_use_id;
7960: ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).tax_rounding_rule:= l_tax_rounding_rule;
7961: ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).tax_header_level_flag := l_tax_header_level_flag;
7962: ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).tax_code := l_tax_code;
7963: ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).Tax_Classification:= l_Tax_Classification;
7956: CLOSE c_site_uses;
7957:
7958: -- Populate the cache
7959: ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).site_use_id := p_site_use_id;
7960: ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).tax_rounding_rule:= l_tax_rounding_rule;
7961: ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).tax_header_level_flag := l_tax_header_level_flag;
7962: ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).tax_code := l_tax_code;
7963: ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).Tax_Classification:= l_Tax_Classification;
7964: ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).tax_reference := l_tax_reference;
7957:
7958: -- Populate the cache
7959: ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).site_use_id := p_site_use_id;
7960: ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).tax_rounding_rule:= l_tax_rounding_rule;
7961: ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).tax_header_level_flag := l_tax_header_level_flag;
7962: ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).tax_code := l_tax_code;
7963: ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).Tax_Classification:= l_Tax_Classification;
7964: ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).tax_reference := l_tax_reference;
7965:
7958: -- Populate the cache
7959: ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).site_use_id := p_site_use_id;
7960: ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).tax_rounding_rule:= l_tax_rounding_rule;
7961: ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).tax_header_level_flag := l_tax_header_level_flag;
7962: ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).tax_code := l_tax_code;
7963: ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).Tax_Classification:= l_Tax_Classification;
7964: ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).tax_reference := l_tax_reference;
7965:
7966: p_Rounding_Rule_Code:= l_tax_rounding_rule;
7959: ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).site_use_id := p_site_use_id;
7960: ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).tax_rounding_rule:= l_tax_rounding_rule;
7961: ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).tax_header_level_flag := l_tax_header_level_flag;
7962: ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).tax_code := l_tax_code;
7963: ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).Tax_Classification:= l_Tax_Classification;
7964: ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).tax_reference := l_tax_reference;
7965:
7966: p_Rounding_Rule_Code:= l_tax_rounding_rule;
7967:
7960: ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).tax_rounding_rule:= l_tax_rounding_rule;
7961: ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).tax_header_level_flag := l_tax_header_level_flag;
7962: ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).tax_code := l_tax_code;
7963: ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).Tax_Classification:= l_Tax_Classification;
7964: ZX_GLOBAL_STRUCTURES_PKG.g_cust_site_use_info_tbl(p_site_use_id).tax_reference := l_tax_reference;
7965:
7966: p_Rounding_Rule_Code:= l_tax_rounding_rule;
7967:
7968: IF l_tax_header_level_flag = 'Y' THEN
8037: p_return_status := FND_API.G_RET_STS_SUCCESS;
8038: p_rounding_level_code := NULL;
8039: p_rounding_rule_code := NULL;
8040:
8041: IF ZX_GLOBAL_STRUCTURES_PKG.g_cust_acct_info_tbl.exists(p_account_id) THEN
8042: p_Rounding_Rule_Code:=
8043: ZX_GLOBAL_STRUCTURES_PKG.g_cust_acct_info_tbl(p_account_id).tax_rounding_rule;
8044:
8045: IF ZX_GLOBAL_STRUCTURES_PKG.g_cust_acct_info_tbl(p_account_id).tax_header_level_flag = 'Y' THEN
8039: p_rounding_rule_code := NULL;
8040:
8041: IF ZX_GLOBAL_STRUCTURES_PKG.g_cust_acct_info_tbl.exists(p_account_id) THEN
8042: p_Rounding_Rule_Code:=
8043: ZX_GLOBAL_STRUCTURES_PKG.g_cust_acct_info_tbl(p_account_id).tax_rounding_rule;
8044:
8045: IF ZX_GLOBAL_STRUCTURES_PKG.g_cust_acct_info_tbl(p_account_id).tax_header_level_flag = 'Y' THEN
8046: p_rounding_level_code := 'HEADER';
8047: ELSIF ZX_GLOBAL_STRUCTURES_PKG.g_cust_acct_info_tbl(p_account_id).tax_header_level_flag = 'N' THEN
8041: IF ZX_GLOBAL_STRUCTURES_PKG.g_cust_acct_info_tbl.exists(p_account_id) THEN
8042: p_Rounding_Rule_Code:=
8043: ZX_GLOBAL_STRUCTURES_PKG.g_cust_acct_info_tbl(p_account_id).tax_rounding_rule;
8044:
8045: IF ZX_GLOBAL_STRUCTURES_PKG.g_cust_acct_info_tbl(p_account_id).tax_header_level_flag = 'Y' THEN
8046: p_rounding_level_code := 'HEADER';
8047: ELSIF ZX_GLOBAL_STRUCTURES_PKG.g_cust_acct_info_tbl(p_account_id).tax_header_level_flag = 'N' THEN
8048: p_rounding_level_code := 'LINE';
8049: END IF;
8043: ZX_GLOBAL_STRUCTURES_PKG.g_cust_acct_info_tbl(p_account_id).tax_rounding_rule;
8044:
8045: IF ZX_GLOBAL_STRUCTURES_PKG.g_cust_acct_info_tbl(p_account_id).tax_header_level_flag = 'Y' THEN
8046: p_rounding_level_code := 'HEADER';
8047: ELSIF ZX_GLOBAL_STRUCTURES_PKG.g_cust_acct_info_tbl(p_account_id).tax_header_level_flag = 'N' THEN
8048: p_rounding_level_code := 'LINE';
8049: END IF;
8050:
8051: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
8070: p_rounding_level_code := 'LINE';
8071: END IF;
8072:
8073:
8074: ZX_GLOBAL_STRUCTURES_PKG.g_cust_acct_info_tbl(p_account_id).CUST_ACCOUNT_ID := p_account_id;
8075: ZX_GLOBAL_STRUCTURES_PKG.g_cust_acct_info_tbl(p_account_id).TAX_CODE := l_tax_code;
8076: ZX_GLOBAL_STRUCTURES_PKG.g_cust_acct_info_tbl(p_account_id).TAX_ROUNDING_RULE := l_tax_rounding_rule;
8077: ZX_GLOBAL_STRUCTURES_PKG.g_cust_acct_info_tbl(p_account_id).TAX_HEADER_LEVEL_FLAG := l_tax_header_level_flag;
8078:
8071: END IF;
8072:
8073:
8074: ZX_GLOBAL_STRUCTURES_PKG.g_cust_acct_info_tbl(p_account_id).CUST_ACCOUNT_ID := p_account_id;
8075: ZX_GLOBAL_STRUCTURES_PKG.g_cust_acct_info_tbl(p_account_id).TAX_CODE := l_tax_code;
8076: ZX_GLOBAL_STRUCTURES_PKG.g_cust_acct_info_tbl(p_account_id).TAX_ROUNDING_RULE := l_tax_rounding_rule;
8077: ZX_GLOBAL_STRUCTURES_PKG.g_cust_acct_info_tbl(p_account_id).TAX_HEADER_LEVEL_FLAG := l_tax_header_level_flag;
8078:
8079: END IF;
8072:
8073:
8074: ZX_GLOBAL_STRUCTURES_PKG.g_cust_acct_info_tbl(p_account_id).CUST_ACCOUNT_ID := p_account_id;
8075: ZX_GLOBAL_STRUCTURES_PKG.g_cust_acct_info_tbl(p_account_id).TAX_CODE := l_tax_code;
8076: ZX_GLOBAL_STRUCTURES_PKG.g_cust_acct_info_tbl(p_account_id).TAX_ROUNDING_RULE := l_tax_rounding_rule;
8077: ZX_GLOBAL_STRUCTURES_PKG.g_cust_acct_info_tbl(p_account_id).TAX_HEADER_LEVEL_FLAG := l_tax_header_level_flag;
8078:
8079: END IF;
8080:
8073:
8074: ZX_GLOBAL_STRUCTURES_PKG.g_cust_acct_info_tbl(p_account_id).CUST_ACCOUNT_ID := p_account_id;
8075: ZX_GLOBAL_STRUCTURES_PKG.g_cust_acct_info_tbl(p_account_id).TAX_CODE := l_tax_code;
8076: ZX_GLOBAL_STRUCTURES_PKG.g_cust_acct_info_tbl(p_account_id).TAX_ROUNDING_RULE := l_tax_rounding_rule;
8077: ZX_GLOBAL_STRUCTURES_PKG.g_cust_acct_info_tbl(p_account_id).TAX_HEADER_LEVEL_FLAG := l_tax_header_level_flag;
8078:
8079: END IF;
8080:
8081:
8137: X_RETURN_STATUS => p_return_status);
8138:
8139: IF L_TBL_INDEX is not null then
8140: p_rounding_level_code :=
8141: ZX_GLOBAL_STRUCTURES_PKG.G_PARTY_TAX_PROF_INFO_TBL(p_party_tax_profile_id).rounding_level_code;
8142: p_rounding_rule_code :=
8143: ZX_GLOBAL_STRUCTURES_PKG.G_PARTY_TAX_PROF_INFO_TBL(p_party_tax_profile_id).rounding_rule_code;
8144: ELSE
8145:
8139: IF L_TBL_INDEX is not null then
8140: p_rounding_level_code :=
8141: ZX_GLOBAL_STRUCTURES_PKG.G_PARTY_TAX_PROF_INFO_TBL(p_party_tax_profile_id).rounding_level_code;
8142: p_rounding_rule_code :=
8143: ZX_GLOBAL_STRUCTURES_PKG.G_PARTY_TAX_PROF_INFO_TBL(p_party_tax_profile_id).rounding_rule_code;
8144: ELSE
8145:
8146: IF (g_level_procedure >= g_current_runtime_level ) THEN
8147: FND_LOG.STRING(g_level_procedure,