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 721: l_table_owner := 'ZX_PARTY_TAX_PROFILE';

717: end if;
718:
719: -- 4: Supplier or Supplier Site
720: if l_Party_Type_Code <> 'FIRST_PARTY' THEN -- for third party or site
721: l_table_owner := 'ZX_PARTY_TAX_PROFILE';
722: l_table_id:= p_fsc_rec.classified_entity_id;
723:
724: if p_fsc_rec.condition_value is not null THEN -- bugfix for handling NULL/ NOT NULL OPERATOR where condition value is null
725: Open c_party_category;

Line 827: FROM zx_party_tax_profile

823: /*
824: --5373773
825: BEGIN
826: SELECT party_tax_profile_id INTO l_ptp_id
827: FROM zx_party_tax_profile
828: where party_id = l_party_id
829: and party_type_code ='FIRST_PARTY';
830: EXCEPTION WHEN OTHERS THEN
831: l_ptp_id := null;

Line 886: l_table_owner := 'ZX_PARTY_TAX_PROFILE';

882: l_log_msg);
883: END IF;
884:
885: if l_le_status = 'NOT_FOUND' then
886: l_table_owner := 'ZX_PARTY_TAX_PROFILE';
887: l_table_id := l_ptp_id;
888:
889: if p_fsc_rec.condition_value is not null then
890: Open c_party_category;

Line 973: l_table_owner := 'ZX_PARTY_TAX_PROFILE';

969: END IF;
970:
971: elsif l_le_other_fc_status = 'NOT_FOUND' then
972:
973: l_table_owner := 'ZX_PARTY_TAX_PROFILE';
974: l_table_id := l_ptp_id;
975: Open c_pty_fc_assgn_exists;
976: fetch c_pty_fc_assgn_exists into l_allocated_flag;
977: IF c_pty_fc_assgn_exists%NOTFOUND THEN

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

1541: * level. *
1542: * *
1543: ********************************************************************************/
1544: PROCEDURE Do_Get_Registration_Tax
1545: (p_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,
1546: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1547: p_tax IN ZX_TAXES_B.TAX%TYPE,
1548: p_jurisdiction_code IN ZX_JURISDICTIONS_B.TAX_JURISDICTION_CODE%TYPE,
1549: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,

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

1626: * level. *
1627: * *
1628: ********************************************************************************/
1629: PROCEDURE Do_Get_Registration_Tax
1630: (p_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,
1631: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1632: p_tax IN ZX_TAXES_B.TAX%TYPE,
1633: p_jurisdiction_code IN ZX_JURISDICTIONS_B.TAX_JURISDICTION_CODE%TYPE,
1634: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,

Line 1644: l_ptp_type_code zx_party_tax_profile.party_type_code%type;

1640:
1641: -----------------------------
1642: -- Local variables definition
1643: -----------------------------
1644: l_ptp_type_code zx_party_tax_profile.party_type_code%type;
1645:
1646: -- Logging Infra
1647: l_procedure_name CONSTANT VARCHAR2(30) := 'Do_Get_Registration_Tax';
1648: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

Line 1736: zx_party_tax_profile ptp

1732: ptp.effective_from_use_le,
1733: ptp.party_id,
1734: ptp.rep_registration_number
1735: FROM zx_registrations reg,
1736: zx_party_tax_profile ptp
1737: WHERE reg.party_tax_profile_id = c_party_tax_profile_id
1738: AND reg.party_tax_profile_id = ptp.party_tax_profile_id
1739: AND nvl(reg.tax_regime_code,1) = nvl(c_tax_regime_code,1)
1740: AND nvl(reg.tax,nvl(c_tax,1)) = nvl(c_tax,1)

Line 1748: FROM zx_party_tax_profile

1744:
1745: -- dario1
1746: CURSOR c_ptp_type (c_ptp_id number) IS
1747: SELECT party_type_code
1748: FROM zx_party_tax_profile
1749: WHERE party_tax_profile_id = c_ptp_id;
1750:
1751: -- variables for caching
1752: L_TAX_REGIME_CODE ZX_REGIMES_B.TAX_REGIME_CODE%TYPE;

Line 2509: p_parent_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,

2505: * tax registration information *
2506: ********************************************************************************/
2507:
2508: Procedure Get_Tax_Registration(
2509: p_parent_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,
2510: p_site_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,
2511: p_account_Type_Code IN zx_registrations.account_type_code%TYPE,
2512: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
2513: p_tax IN ZX_TAXES_B.TAX%TYPE,

Line 2510: p_site_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,

2506: ********************************************************************************/
2507:
2508: Procedure Get_Tax_Registration(
2509: p_parent_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,
2510: p_site_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,
2511: p_account_Type_Code IN zx_registrations.account_type_code%TYPE,
2512: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
2513: p_tax IN ZX_TAXES_B.TAX%TYPE,
2514: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,