eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_TCM_CONTROL_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 40: l_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%type;

36: l_category_id mtl_categories_b.category_id%type;
37: l_structure_id mtl_category_sets_b.structure_id%type;
38: l_allocated_flag varchar2(15);
39: l_tca_class_category_code hz_class_categories.class_category%type;
40: l_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%type;
41: l_party_id zx_party_tax_profile.party_id%type;
42: l_table_owner zx_fc_types_b.Owner_Table_Code%type;
43: l_table_id zx_fc_types_b.owner_id_char%type;
44: l_class_code fnd_lookup_values.lookup_code%type;

Line 41: l_party_id zx_party_tax_profile.party_id%type;

37: l_structure_id mtl_category_sets_b.structure_id%type;
38: l_allocated_flag varchar2(15);
39: l_tca_class_category_code hz_class_categories.class_category%type;
40: l_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%type;
41: l_party_id zx_party_tax_profile.party_id%type;
42: l_table_owner zx_fc_types_b.Owner_Table_Code%type;
43: l_table_id zx_fc_types_b.owner_id_char%type;
44: l_class_code fnd_lookup_values.lookup_code%type;
45: l_classification_type_code zx_fc_types_b.classification_type_code%type;

Line 48: l_Party_Type_Code zx_party_tax_profile.Party_Type_Code%type;

44: l_class_code fnd_lookup_values.lookup_code%type;
45: l_classification_type_code zx_fc_types_b.classification_type_code%type;
46: l_effective_from date;
47: l_effective_to date;
48: l_Party_Type_Code zx_party_tax_profile.Party_Type_Code%type;
49: l_le_status varchar2(30);
50: l_le_other_fc_status varchar2(30);
51: l_xle_legal_entity xle_utilities_grp.Legal_Entity_Tbl_Type;
52: l_xle_establishment xle_utilities_grp.Establishment_Tbl_Type;

Line 148: from zx_party_tax_profile

144: where classification_type_code = p_fsc_rec.classification_type;
145:
146: cursor c_party_tax_profile_id is
147: Select party_id ,Party_Type_Code
148: from zx_party_tax_profile
149: where party_tax_profile_id = p_fsc_rec.classified_entity_id;
150:
151: cursor c_class_code is
152: select class_code

Line 710: l_table_owner := 'ZX_PARTY_TAX_PROFILE';

706: end if;
707:
708: -- 4: Supplier or Supplier Site
709: if l_Party_Type_Code ='THIRD_PARTY_SITE' OR l_Party_Type_Code = 'THIRD_PARTY' THEN
710: l_table_owner := 'ZX_PARTY_TAX_PROFILE';
711: l_table_id:= p_fsc_rec.classified_entity_id;
712:
713: Open c_party_category;
714: fetch c_party_category into l_allocated_flag,l_effective_from, l_effective_to;

Line 818: FROM zx_party_tax_profile

814: /*
815: --5373773
816: BEGIN
817: SELECT party_tax_profile_id INTO l_ptp_id
818: FROM zx_party_tax_profile
819: where party_id = l_party_id
820: and party_type_code ='FIRST_PARTY';
821: EXCEPTION WHEN OTHERS THEN
822: l_ptp_id := null;

Line 877: l_table_owner := 'ZX_PARTY_TAX_PROFILE';

873: l_log_msg);
874: END IF;
875:
876: if l_le_status = 'NOT_FOUND' then
877: l_table_owner := 'ZX_PARTY_TAX_PROFILE';
878: l_table_id := l_ptp_id;
879:
880: Open c_party_category;
881: fetch c_party_category into l_allocated_flag,l_effective_from, l_effective_to;

Line 952: l_table_owner := 'ZX_PARTY_TAX_PROFILE';

948: END IF;
949:
950: elsif l_le_other_fc_status = 'NOT_FOUND' then
951:
952: l_table_owner := 'ZX_PARTY_TAX_PROFILE';
953: l_table_id := l_ptp_id;
954: Open c_pty_fc_assgn_exists;
955: fetch c_pty_fc_assgn_exists into l_allocated_flag;
956: IF c_pty_fc_assgn_exists%NOTFOUND THEN

Line 1506: (p_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,

1502: * level. *
1503: * *
1504: ********************************************************************************/
1505: PROCEDURE Do_Get_Registration_Tax
1506: (p_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,
1507: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1508: p_tax IN ZX_TAXES_B.TAX%TYPE,
1509: p_jurisdiction_code IN ZX_JURISDICTIONS_B.TAX_JURISDICTION_CODE%TYPE,
1510: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,

Line 1591: (p_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,

1587: * level. *
1588: * *
1589: ********************************************************************************/
1590: PROCEDURE Do_Get_Registration_Tax
1591: (p_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,
1592: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1593: p_tax IN ZX_TAXES_B.TAX%TYPE,
1594: p_jurisdiction_code IN ZX_JURISDICTIONS_B.TAX_JURISDICTION_CODE%TYPE,
1595: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,

Line 1605: l_ptp_type_code zx_party_tax_profile.party_type_code%type;

1601:
1602: -----------------------------
1603: -- Local variables definition
1604: -----------------------------
1605: l_ptp_type_code zx_party_tax_profile.party_type_code%type;
1606:
1607: -- Logging Infra
1608: l_procedure_name CONSTANT VARCHAR2(30) := 'Do_Get_Registration_Tax';
1609: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

Line 1697: zx_party_tax_profile ptp

1693: ptp.effective_from_use_le,
1694: ptp.party_id,
1695: ptp.rep_registration_number
1696: FROM zx_registrations reg,
1697: zx_party_tax_profile ptp
1698: WHERE reg.party_tax_profile_id = c_party_tax_profile_id
1699: AND reg.party_tax_profile_id = ptp.party_tax_profile_id
1700: AND nvl(reg.tax_regime_code,1) = nvl(c_tax_regime_code,1)
1701: AND nvl(reg.tax,nvl(c_tax,1)) = nvl(c_tax,1)

Line 1709: FROM zx_party_tax_profile

1705:
1706: -- dario1
1707: CURSOR c_ptp_type (c_ptp_id number) IS
1708: SELECT party_type_code
1709: FROM zx_party_tax_profile
1710: WHERE party_tax_profile_id = c_ptp_id;
1711:
1712: -- variables for caching
1713: L_TAX_REGIME_CODE ZX_REGIMES_B.TAX_REGIME_CODE%TYPE;

Line 2442: p_parent_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,

2438: * tax registration information *
2439: ********************************************************************************/
2440:
2441: Procedure Get_Tax_Registration(
2442: p_parent_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,
2443: p_site_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,
2444: p_account_Type_Code IN zx_registrations.account_type_code%TYPE,
2445: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
2446: p_tax IN ZX_TAXES_B.TAX%TYPE,

Line 2443: p_site_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,

2439: ********************************************************************************/
2440:
2441: Procedure Get_Tax_Registration(
2442: p_parent_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,
2443: p_site_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,
2444: p_account_Type_Code IN zx_registrations.account_type_code%TYPE,
2445: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
2446: p_tax IN ZX_TAXES_B.TAX%TYPE,
2447: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,