APPS.ZX_TDS_APPLICABILITY_DETM_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 5743: l_reg_party_prof_id zx_party_tax_profile.party_tax_profile_id%TYPE;

5739: x_registration_rec OUT NOCOPY zx_tcm_control_pkg.zx_registration_info_rec,
5740: x_return_status OUT NOCOPY VARCHAR2
5741: ) IS
5742:
5743: l_reg_party_prof_id zx_party_tax_profile.party_tax_profile_id%TYPE;
5744:
5745: l_registration_rec zx_tcm_control_pkg.zx_registration_info_rec;
5746: l_ret_record_level VARCHAR2(30);
5747: l_error_buffer VARCHAR2(200);

Line 5752: l_parent_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;

5748:
5749: l_account_site_id hz_cust_acct_sites_all.cust_acct_site_id%TYPE;
5750: l_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
5751: l_account_id hz_cust_accounts.cust_account_id%TYPE;
5752: l_parent_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
5753: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
5754: l_account_type_code VARCHAR2(30);
5755: l_first_party_flag BOOLEAN;
5756: l_hq_estb_ptp_id zx_lines.hq_estb_party_tax_prof_id%TYPE;

Line 5753: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;

5749: l_account_site_id hz_cust_acct_sites_all.cust_acct_site_id%TYPE;
5750: l_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
5751: l_account_id hz_cust_accounts.cust_account_id%TYPE;
5752: l_parent_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
5753: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
5754: l_account_type_code VARCHAR2(30);
5755: l_first_party_flag BOOLEAN;
5756: l_hq_estb_ptp_id zx_lines.hq_estb_party_tax_prof_id%TYPE;
5757: l_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;

Line 6129: l_reg_party_prof_id zx_party_tax_profile.party_tax_profile_id%TYPE;

6125: x_registration_party_type OUT NOCOPY zx_taxes_b.def_registr_party_type_code%TYPE,
6126: x_return_status OUT NOCOPY VARCHAR2) IS
6127:
6128: l_reg_party_type zx_taxes_b.def_registr_party_type_code%TYPE;
6129: l_reg_party_prof_id zx_party_tax_profile.party_tax_profile_id%TYPE;
6130:
6131: l_registration_rec zx_tcm_control_pkg.zx_registration_info_rec;
6132: l_tax_service_type_code zx_rules_b.service_type_code%TYPE;
6133: l_error_buffer VARCHAR2(200);

Line 6140: l_parent_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;

6136:
6137: l_account_site_id hz_cust_acct_sites_all.cust_acct_site_id%TYPE;
6138: l_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
6139: l_account_id hz_cust_accounts.cust_account_id%TYPE;
6140: l_parent_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
6141: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
6142: l_account_type_code VARCHAR2(30);
6143:
6144: BEGIN

Line 6141: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;

6137: l_account_site_id hz_cust_acct_sites_all.cust_acct_site_id%TYPE;
6138: l_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
6139: l_account_id hz_cust_accounts.cust_account_id%TYPE;
6140: l_parent_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
6141: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
6142: l_account_type_code VARCHAR2(30);
6143:
6144: BEGIN
6145: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 6431: l_party_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;

6427: l_tax_id BINARY_INTEGER;
6428: l_registration_rec zx_tcm_control_pkg.zx_registration_info_rec;
6429: l_ret_record_level VARCHAR2(30);
6430: l_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;
6431: l_party_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
6432:
6433: BEGIN
6434: IF (g_level_statement >= g_current_runtime_level ) THEN
6435: FND_LOG.STRING(g_level_statement,