DBA Data[Home] [Help]

APPS.ZX_TDS_APPLICABILITY_DETM_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 5245: l_reg_party_prof_id zx_party_tax_profile.party_tax_profile_id%TYPE;

5241: x_registration_rec OUT NOCOPY zx_tcm_control_pkg.zx_registration_info_rec,
5242: x_return_status OUT NOCOPY VARCHAR2
5243: ) IS
5244:
5245: l_reg_party_prof_id zx_party_tax_profile.party_tax_profile_id%TYPE;
5246:
5247: l_registration_rec zx_tcm_control_pkg.zx_registration_info_rec;
5248: l_ret_record_level VARCHAR2(30);
5249: l_error_buffer VARCHAR2(200);

Line 5254: l_parent_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;

5250:
5251: l_account_site_id hz_cust_acct_sites_all.cust_acct_site_id%TYPE;
5252: l_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
5253: l_account_id hz_cust_accounts.cust_account_id%TYPE;
5254: l_parent_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
5255: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
5256: l_account_type_code VARCHAR2(30);
5257: l_first_party_flag BOOLEAN;
5258: l_hq_estb_ptp_id zx_lines.hq_estb_party_tax_prof_id%TYPE;

Line 5255: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;

5251: l_account_site_id hz_cust_acct_sites_all.cust_acct_site_id%TYPE;
5252: l_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
5253: l_account_id hz_cust_accounts.cust_account_id%TYPE;
5254: l_parent_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
5255: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
5256: l_account_type_code VARCHAR2(30);
5257: l_first_party_flag BOOLEAN;
5258: l_hq_estb_ptp_id zx_lines.hq_estb_party_tax_prof_id%TYPE;
5259: l_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;

Line 5631: l_reg_party_prof_id zx_party_tax_profile.party_tax_profile_id%TYPE;

5627: x_registration_party_type OUT NOCOPY zx_taxes_b.def_registr_party_type_code%TYPE,
5628: x_return_status OUT NOCOPY VARCHAR2) IS
5629:
5630: l_reg_party_type zx_taxes_b.def_registr_party_type_code%TYPE;
5631: l_reg_party_prof_id zx_party_tax_profile.party_tax_profile_id%TYPE;
5632:
5633: l_registration_rec zx_tcm_control_pkg.zx_registration_info_rec;
5634: l_tax_service_type_code zx_rules_b.service_type_code%TYPE;
5635: l_error_buffer VARCHAR2(200);

Line 5642: l_parent_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;

5638:
5639: l_account_site_id hz_cust_acct_sites_all.cust_acct_site_id%TYPE;
5640: l_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
5641: l_account_id hz_cust_accounts.cust_account_id%TYPE;
5642: l_parent_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
5643: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
5644: l_account_type_code VARCHAR2(30);
5645:
5646: BEGIN

Line 5643: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;

5639: l_account_site_id hz_cust_acct_sites_all.cust_acct_site_id%TYPE;
5640: l_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
5641: l_account_id hz_cust_accounts.cust_account_id%TYPE;
5642: l_parent_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
5643: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
5644: l_account_type_code VARCHAR2(30);
5645:
5646: BEGIN
5647: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 5933: l_party_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;

5929: l_tax_id BINARY_INTEGER;
5930: l_registration_rec zx_tcm_control_pkg.zx_registration_info_rec;
5931: l_ret_record_level VARCHAR2(30);
5932: l_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;
5933: l_party_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
5934:
5935: BEGIN
5936: IF (g_level_statement >= g_current_runtime_level ) THEN
5937: FND_LOG.STRING(g_level_statement,