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_PARTY_MERGE_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 58: --from zx_registrations reg, zx_party_tax_profile prof

54: --cursor registration_number(p_fk_id hz_merge_parties.from_party_id%type) IS
55: --select registration_id, registration_number, effective_from, effective_to,
56: --LEGAL_LOCATION_ID, REGISTRATION_SOURCE_CODE, REGISTRATION_REASON_CODE,
57: --REP_TAX_AUTHORITY_ID, COLL_TAX_AUTHORITY_ID
58: --from zx_registrations reg, zx_party_tax_profile prof
59: --where reg.PARTY_TAX_PROFILE_ID = prof.PARTY_TAX_PROFILE_ID
60: --and prof.party_id = p_fk_id;
61: --from_registration_rec registration_number%ROWTYPE;
62: --to_registration_rec registration_number%ROWTYPE;0

Line 99: FROM zx_party_tax_profile

95: FROM zx_registrations from_reg,
96: zx_registrations to_reg
97: WHERE from_reg.PARTY_TAX_PROFILE_ID IN
98: (SELECT party_tax_profile_id
99: FROM zx_party_tax_profile
100: WHERE party_id = p_from_party_id
101: AND party_type_code = 'THIRD_PARTY'
102: )
103: AND to_reg.PARTY_TAX_PROFILE_ID IN

Line 105: FROM zx_party_tax_profile

101: AND party_type_code = 'THIRD_PARTY'
102: )
103: AND to_reg.PARTY_TAX_PROFILE_ID IN
104: (SELECT party_tax_profile_id
105: FROM zx_party_tax_profile
106: WHERE party_id = p_to_party_id
107: AND party_type_code = 'THIRD_PARTY'
108: )
109: AND from_reg.registration_number = to_reg.registration_number

Line 213: FROM zx_party_tax_profile prof

209: l_code_assignment_id hz_code_assignments.owner_table_name%TYPE;
210:
211: CURSOR Party_Tax_Profile(p_fk_id hz_merge_parties.from_party_id%type) IS
212: SELECT Party_Tax_Profile_id
213: FROM zx_party_tax_profile prof
214: WHERE prof.party_id = p_fk_id
215: AND prof.party_type_code = 'THIRD_PARTY';
216:
217: from_ptp_rec Party_Tax_Profile%ROWTYPE;

Line 223: WHERE owner_table_name = 'ZX_PARTY_TAX_PROFILE'

219:
220: CURSOR Class_Categories_From(p_ptp_id number) IS
221: SELECT code_assignment_id, class_category, class_code, END_DATE_ACTIVE
222: FROM hz_code_assignments
223: WHERE owner_table_name = 'ZX_PARTY_TAX_PROFILE'
224: AND owner_table_id = p_ptp_id
225: AND NVL(END_DATE_ACTIVE,SYSDATE) >= SYSDATE;
226:
227: CURSOR Class_Codes_To (p_ptp_id number,

Line 233: WHERE owner_table_name = 'ZX_PARTY_TAX_PROFILE'

229: p_end_date hz_code_assignments.end_date_active%type,
230: p_class_code hz_code_assignments.class_code%type) IS
231: SELECT DISTINCT class_category, class_code, END_DATE_ACTIVE
232: FROM hz_code_assignments
233: WHERE owner_table_name = 'ZX_PARTY_TAX_PROFILE'
234: AND owner_table_id = p_ptp_id
235: AND NVL(END_DATE_ACTIVE,SYSDATE) >= NVL(p_end_date,SYSDATE)
236: AND class_category = p_class_category
237: AND class_code = p_class_code

Line 268: arp_message.set_line(G_MODULE_NAME||l_procedure_name||' Updating zx_party_tax_profile...');

264:
265: IF p_from_fk_id <> p_to_fk_id THEN
266:
267: BEGIN
268: arp_message.set_line(G_MODULE_NAME||l_procedure_name||' Updating zx_party_tax_profile...');
269:
270: OPEN Party_Tax_Profile(p_from_fk_id);
271: FETCH Party_Tax_Profile INTO from_ptp_rec;
272: IF Party_Tax_Profile%FOUND THEN

Line 284: UPDATE zx_party_tax_profile

280: l_ptp_id_to := to_ptp_rec.Party_Tax_Profile_id;
281: END IF;
282: CLOSE Party_Tax_Profile;
283:
284: UPDATE zx_party_tax_profile
285: set merged_to_ptp_id = l_ptp_id_to,
286: merged_status_code = 'MERGED',
287: last_update_date = SYSDATE,
288: last_updated_by = G_USER_ID,

Line 669: FROM zx_party_tax_profile ptp

665: -- class_category_tbl class_category_tbl_type;
666:
667: cursor Calculate_Tax_Flag(p_ptp_id NUMBER) IS
668: SELECT PROCESS_FOR_APPLICABILITY_FLAG
669: FROM zx_party_tax_profile ptp
670: WHERE ptp.party_tax_profile_id = p_ptp_id;
671:
672: from_calc_tax_rec Calculate_Tax_Flag%ROWTYPE;
673: to_calc_tax_rec Calculate_Tax_Flag%ROWTYPE;

Line 678: -- from zx_registrations a, zx_party_tax_profile b

674:
675: -- cursor Registration_Attributes(p_ptp_id number) IS
676: -- select a.REGISTRATION_TYPE_CODE, a.REGISTRATION_NUMBER, a.ROUNDING_RULE_CODE,
677: -- a.SELF_ASSESS_FLAG, a.INCLUSIVE_TAX_FLAG
678: -- from zx_registrations a, zx_party_tax_profile b
679: -- where b.party_tax_profile_id = p_ptp_id
680: -- and a.party_tax_profile_id = b.party_tax_profile_id;
681:
682: -- Reg_Attr_From_Rec Registration_Attributes%ROWTYPE;

Line 695: FROM zx_registrations a, zx_party_tax_profile b

691: NVL(a.INCLUSIVE_TAX_FLAG, 'N') INCLUSIVE_TAX_FLAG,
692: a.TAX_REGIME_CODE,
693: a.TAX,
694: b.REP_REGISTRATION_NUMBER
695: FROM zx_registrations a, zx_party_tax_profile b
696: WHERE b.party_tax_profile_id = p_ptp_id_1
697: AND a.party_tax_profile_id = b.party_tax_profile_id
698: AND SYSDATE BETWEEN a.effective_from AND NVL(a.effective_to, SYSDATE)
699: MINUS

Line 708: FROM zx_registrations a, zx_party_tax_profile b

704: NVL(a.INCLUSIVE_TAX_FLAG, 'N') INCLUSIVE_TAX_FLAG,
705: a.TAX_REGIME_CODE,
706: a.TAX,
707: b.REP_REGISTRATION_NUMBER
708: FROM zx_registrations a, zx_party_tax_profile b
709: WHERE b.party_tax_profile_id = p_ptp_id_2
710: AND a.party_tax_profile_id = b.party_tax_profile_id
711: AND SYSDATE BETWEEN a.effective_from AND NVL(a.effective_to, SYSDATE);
712:

Line 715: FROM zx_registrations a, zx_party_tax_profile b

711: AND SYSDATE BETWEEN a.effective_from AND NVL(a.effective_to, SYSDATE);
712:
713: cursor Registration_Attributes_Exist(p_ptp_id number) IS
714: SELECT 1
715: FROM zx_registrations a, zx_party_tax_profile b
716: WHERE b.party_tax_profile_id = p_ptp_id
717: AND a.party_tax_profile_id = b.party_tax_profile_id
718: AND SYSDATE BETWEEN a.effective_from AND NVL(a.effective_to, SYSDATE);
719:

Line 874: FROM zx_party_tax_profile prof

870:
871:
872: cursor Party_Tax_Profile(p_fk_id hz_merge_parties.from_party_id%type) IS
873: SELECT Party_Tax_Profile_id, party_type_code
874: FROM zx_party_tax_profile prof
875: WHERE prof.party_id = p_fk_id
876: AND prof.party_type_code = 'THIRD_PARTY';
877:
878: from_ptp_rec Party_Tax_Profile%ROWTYPE;

Line 1057: zx_party_tax_profile_s.nextval,

1053: --
1054: SELECT from_party_site_id,
1055: to_party_site_id,
1056: party_tax_profile_id,
1057: zx_party_tax_profile_s.nextval,
1058: cust_account_id,
1059: cust_acct_site_id
1060: BULK COLLECT INTO l_tbl_from_party_site_id,
1061: l_tbl_to_party_site_id,

Line 1080: ZX_PARTY_TAX_PROFILE ptp

1076: ) as party_site_num
1077: FROM RA_CUSTOMER_MERGES rm,
1078: HZ_CUST_ACCT_SITES_ALL cas,
1079: HZ_CUST_ACCT_SITES_ALL cas2,
1080: ZX_PARTY_TAX_PROFILE ptp
1081: WHERE rm.request_id = l_request_id
1082: AND rm.duplicate_address_id = cas.cust_acct_site_id
1083: AND rm.customer_address_id = cas2.cust_acct_site_id
1084: AND ptp.party_id = cas.party_site_id

Line 1112: INSERT INTO ZX_PARTY_TAX_PROFILE

1108: 'Inserting party tax profile records');
1109: END IF;
1110: arp_message.set_line(G_MODULE_NAME||l_procedure_name||'Inserting party tax profile records');
1111: FORALL i IN 1..l_tbl_to_ptp_id.count
1112: INSERT INTO ZX_PARTY_TAX_PROFILE
1113: (party_type_code
1114: ,supplier_flag
1115: ,customer_flag
1116: ,site_flag

Line 1227: FROM zx_party_tax_profile a

1223: ,a.registration_type_code
1224: ,a.country_code
1225: ,a.merged_to_ptp_id
1226: ,a.merged_status_code
1227: FROM zx_party_tax_profile a
1228: WHERE a.party_tax_profile_id = l_tbl_from_ptp_id(i);
1229: --
1230: -- Processing for PTP records end
1231: -----------------------------------------------------------------

Line 1515: (p_from_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE

1511: ---------------------------------
1512: -- Merge Party Site Registrations
1513: ---------------------------------
1514: PROCEDURE MERGE_SITE_REGISTRATIONS_PVT
1515: (p_from_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE
1516: ,p_to_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE
1517: ,x_return_status OUT NOCOPY VARCHAR2
1518: ) IS
1519:

Line 1516: ,p_to_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE

1512: -- Merge Party Site Registrations
1513: ---------------------------------
1514: PROCEDURE MERGE_SITE_REGISTRATIONS_PVT
1515: (p_from_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE
1516: ,p_to_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE
1517: ,x_return_status OUT NOCOPY VARCHAR2
1518: ) IS
1519:
1520: CURSOR get_from_ptp_registrations IS

Line 1714: (p_from_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE

1710: ------------------------------
1711: -- Merge Party Site Exemptions
1712: ------------------------------
1713: PROCEDURE MERGE_SITE_EXEMPTIONS_PVT
1714: (p_from_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE
1715: ,p_to_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE
1716: ,x_return_status OUT NOCOPY VARCHAR2
1717: ) IS
1718:

Line 1715: ,p_to_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE

1711: -- Merge Party Site Exemptions
1712: ------------------------------
1713: PROCEDURE MERGE_SITE_EXEMPTIONS_PVT
1714: (p_from_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE
1715: ,p_to_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE
1716: ,x_return_status OUT NOCOPY VARCHAR2
1717: ) IS
1718:
1719: l_procedure_name CONSTANT VARCHAR2(30) := '.MERGE_SITE_EXEMPTIONS_PVT';

Line 1854: (p_from_fk_id IN zx_party_tax_profile.party_id%TYPE

1850: ------------------------------
1851: -- Merge Party Sites PTP
1852: ------------------------------
1853: PROCEDURE MERGE_PARTY_SITES_PTP_PVT
1854: (p_from_fk_id IN zx_party_tax_profile.party_id%TYPE
1855: ,p_from_party_type IN zx_party_tax_profile.party_type_code%TYPE
1856: ,p_to_fk_id IN zx_party_tax_profile.party_id%TYPE
1857: ,p_to_party_type IN zx_party_tax_profile.party_type_code%TYPE
1858: ,x_return_status OUT NOCOPY VARCHAR2

Line 1855: ,p_from_party_type IN zx_party_tax_profile.party_type_code%TYPE

1851: -- Merge Party Sites PTP
1852: ------------------------------
1853: PROCEDURE MERGE_PARTY_SITES_PTP_PVT
1854: (p_from_fk_id IN zx_party_tax_profile.party_id%TYPE
1855: ,p_from_party_type IN zx_party_tax_profile.party_type_code%TYPE
1856: ,p_to_fk_id IN zx_party_tax_profile.party_id%TYPE
1857: ,p_to_party_type IN zx_party_tax_profile.party_type_code%TYPE
1858: ,x_return_status OUT NOCOPY VARCHAR2
1859: ) IS

Line 1856: ,p_to_fk_id IN zx_party_tax_profile.party_id%TYPE

1852: ------------------------------
1853: PROCEDURE MERGE_PARTY_SITES_PTP_PVT
1854: (p_from_fk_id IN zx_party_tax_profile.party_id%TYPE
1855: ,p_from_party_type IN zx_party_tax_profile.party_type_code%TYPE
1856: ,p_to_fk_id IN zx_party_tax_profile.party_id%TYPE
1857: ,p_to_party_type IN zx_party_tax_profile.party_type_code%TYPE
1858: ,x_return_status OUT NOCOPY VARCHAR2
1859: ) IS
1860:

Line 1857: ,p_to_party_type IN zx_party_tax_profile.party_type_code%TYPE

1853: PROCEDURE MERGE_PARTY_SITES_PTP_PVT
1854: (p_from_fk_id IN zx_party_tax_profile.party_id%TYPE
1855: ,p_from_party_type IN zx_party_tax_profile.party_type_code%TYPE
1856: ,p_to_fk_id IN zx_party_tax_profile.party_id%TYPE
1857: ,p_to_party_type IN zx_party_tax_profile.party_type_code%TYPE
1858: ,x_return_status OUT NOCOPY VARCHAR2
1859: ) IS
1860:
1861: CURSOR c_party_type (c_party_type zx_party_tax_profile.party_type_code%TYPE) IS

Line 1861: CURSOR c_party_type (c_party_type zx_party_tax_profile.party_type_code%TYPE) IS

1857: ,p_to_party_type IN zx_party_tax_profile.party_type_code%TYPE
1858: ,x_return_status OUT NOCOPY VARCHAR2
1859: ) IS
1860:
1861: CURSOR c_party_type (c_party_type zx_party_tax_profile.party_type_code%TYPE) IS
1862: SELECT lookup_code
1863: FROM fnd_lookups
1864: WHERE lookup_type = 'ZX_PTP_PARTY_TYPE'
1865: AND lookup_code = c_party_type

Line 1870: (c_party_id zx_party_tax_profile.party_id%TYPE,

1866: AND enabled_flag = 'Y'
1867: AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active,SYSDATE);
1868:
1869: CURSOR get_ptp_info
1870: (c_party_id zx_party_tax_profile.party_id%TYPE,
1871: c_party_type zx_party_tax_profile.party_type_code%TYPE) IS
1872: SELECT * FROM zx_party_tax_profile
1873: WHERE party_id = c_party_id
1874: AND party_type_code = c_party_type;

Line 1871: c_party_type zx_party_tax_profile.party_type_code%TYPE) IS

1867: AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active,SYSDATE);
1868:
1869: CURSOR get_ptp_info
1870: (c_party_id zx_party_tax_profile.party_id%TYPE,
1871: c_party_type zx_party_tax_profile.party_type_code%TYPE) IS
1872: SELECT * FROM zx_party_tax_profile
1873: WHERE party_id = c_party_id
1874: AND party_type_code = c_party_type;
1875:

Line 1872: SELECT * FROM zx_party_tax_profile

1868:
1869: CURSOR get_ptp_info
1870: (c_party_id zx_party_tax_profile.party_id%TYPE,
1871: c_party_type zx_party_tax_profile.party_type_code%TYPE) IS
1872: SELECT * FROM zx_party_tax_profile
1873: WHERE party_id = c_party_id
1874: AND party_type_code = c_party_type;
1875:
1876: CURSOR get_ptp_id

Line 1877: (c_party_id zx_party_tax_profile.party_id%TYPE,

1873: WHERE party_id = c_party_id
1874: AND party_type_code = c_party_type;
1875:
1876: CURSOR get_ptp_id
1877: (c_party_id zx_party_tax_profile.party_id%TYPE,
1878: c_party_type zx_party_tax_profile.party_type_code%TYPE) IS
1879: SELECT party_tax_profile_id
1880: FROM zx_party_tax_profile
1881: WHERE party_id = c_party_id

Line 1878: c_party_type zx_party_tax_profile.party_type_code%TYPE) IS

1874: AND party_type_code = c_party_type;
1875:
1876: CURSOR get_ptp_id
1877: (c_party_id zx_party_tax_profile.party_id%TYPE,
1878: c_party_type zx_party_tax_profile.party_type_code%TYPE) IS
1879: SELECT party_tax_profile_id
1880: FROM zx_party_tax_profile
1881: WHERE party_id = c_party_id
1882: AND party_type_code = c_party_type;

Line 1880: FROM zx_party_tax_profile

1876: CURSOR get_ptp_id
1877: (c_party_id zx_party_tax_profile.party_id%TYPE,
1878: c_party_type zx_party_tax_profile.party_type_code%TYPE) IS
1879: SELECT party_tax_profile_id
1880: FROM zx_party_tax_profile
1881: WHERE party_id = c_party_id
1882: AND party_type_code = c_party_type;
1883:
1884: l_party_type_code zx_party_tax_profile.party_type_code%TYPE;

Line 1884: l_party_type_code zx_party_tax_profile.party_type_code%TYPE;

1880: FROM zx_party_tax_profile
1881: WHERE party_id = c_party_id
1882: AND party_type_code = c_party_type;
1883:
1884: l_party_type_code zx_party_tax_profile.party_type_code%TYPE;
1885:
1886: l_from_ptp_rec zx_Party_Tax_Profile%ROWTYPE;
1887: l_to_ptp_rec zx_Party_Tax_Profile%ROWTYPE;
1888:

Line 1886: l_from_ptp_rec zx_Party_Tax_Profile%ROWTYPE;

1882: AND party_type_code = c_party_type;
1883:
1884: l_party_type_code zx_party_tax_profile.party_type_code%TYPE;
1885:
1886: l_from_ptp_rec zx_Party_Tax_Profile%ROWTYPE;
1887: l_to_ptp_rec zx_Party_Tax_Profile%ROWTYPE;
1888:
1889: l_insert_ptp BOOLEAN;
1890: l_procedure_name CONSTANT VARCHAR2(30) := '.MERGE_PARTY_SITES_PTP_PVT';

Line 1887: l_to_ptp_rec zx_Party_Tax_Profile%ROWTYPE;

1883:
1884: l_party_type_code zx_party_tax_profile.party_type_code%TYPE;
1885:
1886: l_from_ptp_rec zx_Party_Tax_Profile%ROWTYPE;
1887: l_to_ptp_rec zx_Party_Tax_Profile%ROWTYPE;
1888:
1889: l_insert_ptp BOOLEAN;
1890: l_procedure_name CONSTANT VARCHAR2(30) := '.MERGE_PARTY_SITES_PTP_PVT';
1891:

Line 1970: ZX_PARTY_TAX_PROFILE_PKG.INSERT_ROW

1966: IF l_insert_ptp THEN
1967: ---------------------------------------
1968: -- Create New PTP record for To Site --
1969: ---------------------------------------
1970: ZX_PARTY_TAX_PROFILE_PKG.INSERT_ROW
1971: (p_collecting_authority_flag => l_from_ptp_rec.collecting_authority_flag
1972: ,p_provider_type_code => l_from_ptp_rec.provider_type_code
1973: ,p_create_awt_dists_type_code => l_from_ptp_rec.create_awt_dists_type_code
1974: ,p_create_awt_invoices_type_cod => l_from_ptp_rec.create_awt_invoices_type_code

Line 2022: ZX_PARTY_TAX_PROFILE_PKG.UPDATE_ROW (

2018: ELSE
2019: ---------------------------------------
2020: -- Update Existing PTP record for To Site --
2021: ---------------------------------------
2022: ZX_PARTY_TAX_PROFILE_PKG.UPDATE_ROW (
2023: p_party_tax_profile_id => l_to_ptp_rec.party_tax_profile_id
2024: ,p_collecting_authority_flag => l_from_ptp_rec.collecting_authority_flag
2025: ,p_provider_type_code => l_from_ptp_rec.provider_type_code
2026: ,p_create_awt_dists_type_code => l_from_ptp_rec.create_awt_dists_type_code

Line 2076: 'Incorrect status retuned by ZX_Party_Tax_Profile_Pkg.Insert_Row()');

2072:
2073: IF NVL(x_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
2074: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2075: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2076: 'Incorrect status retuned by ZX_Party_Tax_Profile_Pkg.Insert_Row()');
2077: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2078: 'Return Status = '||x_return_status);
2079: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2080: 'Merge_Party_Sites_PTP_Pvt(-)');

Line 2103: UPDATE zx_party_tax_profile

2099: 'Party_Tax_Profile_Id of To-Site : '||l_to_ptp_rec.party_tax_profile_id);
2100: END IF;
2101: END IF;
2102:
2103: UPDATE zx_party_tax_profile
2104: SET merged_to_ptp_id = l_to_ptp_rec.party_tax_profile_id,
2105: merged_status_code = 'MERGED',
2106: last_update_date = SYSDATE,
2107: last_updated_by = G_USER_ID,