DBA Data[Home] [Help]

APPS.ZX_TCM_CONTROL_PKG dependencies on AP_SUPPLIER_SITES_ALL

Line 1980: l_auto_tax_calc_flag ap_supplier_sites_all.auto_tax_calc_flag%TYPE;

1976: l_ptp_type_code VARCHAR2(30);
1977:
1978: l_ap_tax_rounding_rule VARCHAR2(10);
1979: l_tax_rounding_level VARCHAR2(10);
1980: l_auto_tax_calc_flag ap_supplier_sites_all.auto_tax_calc_flag%TYPE;
1981: l_vat_code ap_supplier_sites_all.vat_code%TYPE;
1982: l_vat_registration_num ap_supplier_sites_all.vat_registration_num%TYPE;
1983:
1984: -- Added for Bug#12980272

Line 1981: l_vat_code ap_supplier_sites_all.vat_code%TYPE;

1977:
1978: l_ap_tax_rounding_rule VARCHAR2(10);
1979: l_tax_rounding_level VARCHAR2(10);
1980: l_auto_tax_calc_flag ap_supplier_sites_all.auto_tax_calc_flag%TYPE;
1981: l_vat_code ap_supplier_sites_all.vat_code%TYPE;
1982: l_vat_registration_num ap_supplier_sites_all.vat_registration_num%TYPE;
1983:
1984: -- Added for Bug#12980272
1985: l_inclusive_tax_flag ap_supplier_sites_all.amount_includes_tax_flag%TYPE;

Line 1982: l_vat_registration_num ap_supplier_sites_all.vat_registration_num%TYPE;

1978: l_ap_tax_rounding_rule VARCHAR2(10);
1979: l_tax_rounding_level VARCHAR2(10);
1980: l_auto_tax_calc_flag ap_supplier_sites_all.auto_tax_calc_flag%TYPE;
1981: l_vat_code ap_supplier_sites_all.vat_code%TYPE;
1982: l_vat_registration_num ap_supplier_sites_all.vat_registration_num%TYPE;
1983:
1984: -- Added for Bug#12980272
1985: l_inclusive_tax_flag ap_supplier_sites_all.amount_includes_tax_flag%TYPE;
1986:

Line 1985: l_inclusive_tax_flag ap_supplier_sites_all.amount_includes_tax_flag%TYPE;

1981: l_vat_code ap_supplier_sites_all.vat_code%TYPE;
1982: l_vat_registration_num ap_supplier_sites_all.vat_registration_num%TYPE;
1983:
1984: -- Added for Bug#12980272
1985: l_inclusive_tax_flag ap_supplier_sites_all.amount_includes_tax_flag%TYPE;
1986:
1987: -- Logging Infra
1988: l_procedure_name CONSTANT VARCHAR2(30) := 'Do_Get_Sup_Site';
1989: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

Line 2008: FROM ap_supplier_sites_all povs

2004: 'H','HEADER',
2005: 'T','HEADER',
2006: NULL) tax_rounding_level
2007: ,povs.amount_includes_tax_flag -- Added for Bug#12980272
2008: FROM ap_supplier_sites_all povs
2009: WHERE povs.vendor_id = p_account_id
2010: AND povs.vendor_site_id = p_account_site_id;
2011:
2012: l_supp_site_info_rec ZX_GLOBAL_STRUCTURES_PKG.supp_site_info_rec_type;

Line 2620: -- Check if we can get the registration information from ap_supplier_sites_all

2616: return;
2617: END IF; -- if5
2618: END IF; -- if4
2619: END IF; -- if3 p_site_ptp_id id not null
2620: -- Check if we can get the registration information from ap_supplier_sites_all
2621: -- or hz_cust_accounts or hz_cust_site_uses
2622: --
2623: IF (p_account_id is not NULL) and (p_account_site_id IS NOT NULL) THEN -- if6
2624: -- Check party type code