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_REGISTRATIONS

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 95: FROM zx_registrations from_reg,

91: END as rep_tax_auth_id_to,
92: CASE WHEN to_reg.COLL_TAX_AUTHORITY_ID IS NULL AND from_reg.COLL_TAX_AUTHORITY_ID IS NOT NULL
93: THEN from_reg.COLL_TAX_AUTHORITY_ID
94: END as coll_tax_auth_id_to
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

Line 96: zx_registrations to_reg

92: CASE WHEN to_reg.COLL_TAX_AUTHORITY_ID IS NULL AND from_reg.COLL_TAX_AUTHORITY_ID IS NOT NULL
93: THEN from_reg.COLL_TAX_AUTHORITY_ID
94: END as coll_tax_auth_id_to
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

Line 140: arp_message.set_line(G_MODULE_NAME||l_procedure_name||' Updating zx_registrations...');

136:
137: IF p_from_fk_id <> p_to_fk_id THEN
138: BEGIN
139:
140: arp_message.set_line(G_MODULE_NAME||l_procedure_name||' Updating zx_registrations...');
141:
142: FOR registration_rec IN registration_number(p_from_fk_id,p_to_fk_id)
143: LOOP
144: UPDATE zx_registrations

Line 144: UPDATE zx_registrations

140: arp_message.set_line(G_MODULE_NAME||l_procedure_name||' Updating zx_registrations...');
141:
142: FOR registration_rec IN registration_number(p_from_fk_id,p_to_fk_id)
143: LOOP
144: UPDATE zx_registrations
145: SET merged_to_registration_id = registration_rec.registration_id_to,
146: effective_to = SYSDATE,
147: last_update_date = SYSDATE,
148: last_updated_by = G_USER_ID,

Line 153: UPDATE zx_registrations

149: last_update_login = G_LOGIN_ID,
150: object_version_number = object_version_number+1
151: WHERE registration_id = registration_rec.registration_id_from;
152:
153: UPDATE zx_registrations
154: SET effective_from = registration_rec.update_reg_from_date,
155: effective_to = registration_rec.update_reg_to_date,
156: legal_location_id = registration_rec.location_id_to,
157: registration_source_code = registration_rec.reg_src_code_to,

Line 374: arp_message.set_line(G_MODULE_NAME||l_procedure_name||' Updating zx_registrations for tax Authorities...');

370:
371: if p_from_fk_id <> p_to_fk_id THEN
372: BEGIN
373:
374: arp_message.set_line(G_MODULE_NAME||l_procedure_name||' Updating zx_registrations for tax Authorities...');
375:
376: UPDATE zx_registrations
377: set TAX_AUTHORITY_ID = p_ptp_id_to,
378: last_update_date = SYSDATE,

Line 376: UPDATE zx_registrations

372: BEGIN
373:
374: arp_message.set_line(G_MODULE_NAME||l_procedure_name||' Updating zx_registrations for tax Authorities...');
375:
376: UPDATE zx_registrations
377: set TAX_AUTHORITY_ID = p_ptp_id_to,
378: last_update_date = SYSDATE,
379: last_updated_by = G_USER_ID,
380: last_update_login = G_LOGIN_ID,

Line 384: UPDATE zx_registrations

380: last_update_login = G_LOGIN_ID,
381: object_version_number = object_version_number+1
382: WHERE TAX_AUTHORITY_ID = p_ptp_id_from;
383:
384: UPDATE zx_registrations
385: set REP_TAX_AUTHORITY_ID = p_ptp_id_to,
386: last_update_date = SYSDATE,
387: last_updated_by = G_USER_ID,
388: last_update_login = G_LOGIN_ID,

Line 392: UPDATE zx_registrations

388: last_update_login = G_LOGIN_ID,
389: object_version_number = object_version_number+1
390: WHERE REP_TAX_AUTHORITY_ID = p_ptp_id_from;
391:
392: UPDATE zx_registrations
393: set COLL_TAX_AUTHORITY_ID = p_ptp_id_to,
394: last_update_date = SYSDATE,
395: last_updated_by = G_USER_ID,
396: last_update_login = G_LOGIN_ID,

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 1239: -- fix for bug 14477937 check to avoid if insertion is creating ZX_REGISTRATIONS_U2

1235: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name,
1236: 'Inserting registration records');
1237: END IF;
1238: arp_message.set_line(G_MODULE_NAME||l_procedure_name||'Inserting registration records');
1239: -- fix for bug 14477937 check to avoid if insertion is creating ZX_REGISTRATIONS_U2
1240: FORALL i in 1..l_tbl_from_ptp_id.count
1241: INSERT INTO ZX_REGISTRATIONS
1242: (registration_type_code
1243: ,registration_number

Line 1241: INSERT INTO ZX_REGISTRATIONS

1237: END IF;
1238: arp_message.set_line(G_MODULE_NAME||l_procedure_name||'Inserting registration records');
1239: -- fix for bug 14477937 check to avoid if insertion is creating ZX_REGISTRATIONS_U2
1240: FORALL i in 1..l_tbl_from_ptp_id.count
1241: INSERT INTO ZX_REGISTRATIONS
1242: (registration_type_code
1243: ,registration_number
1244: ,validation_rule
1245: ,rounding_rule_code

Line 1350: ,zx_registrations_s.nextval

1346: ,attribute15
1347: ,attribute_category
1348: ,tax_classification_code
1349: ,G_LOGIN_ID
1350: ,zx_registrations_s.nextval
1351: ,tax_authority_id
1352: ,rep_tax_authority_id
1353: ,coll_tax_authority_id
1354: ,l_tbl_to_ptp_id(i)

Line 1364: FROM zx_registrations main_tbl

1360: ,1
1361: ,rounding_level_code
1362: ,account_type_code
1363: ,merged_to_registration_id
1364: FROM zx_registrations main_tbl
1365: WHERE party_tax_profile_id = l_tbl_from_ptp_id(i)
1366: AND NOT EXISTS
1367: (SELECT 1
1368: FROM zx_registrations ref_data

Line 1368: FROM zx_registrations ref_data

1364: FROM zx_registrations main_tbl
1365: WHERE party_tax_profile_id = l_tbl_from_ptp_id(i)
1366: AND NOT EXISTS
1367: (SELECT 1
1368: FROM zx_registrations ref_data
1369: WHERE ref_data.party_tax_profile_id = l_tbl_from_ptp_id(i)
1370: AND NVL(ref_data.tax_regime_code,FND_API.G_MISS_CHAR) = NVL(main_tbl.tax_regime_code,FND_API.G_MISS_CHAR)
1371: AND NVL(ref_data.tax,FND_API.G_MISS_CHAR) = NVL(main_tbl.tax,FND_API.G_MISS_CHAR)
1372: AND NVL(ref_data.tax_jurisdiction_code,FND_API.G_MISS_CHAR) = NVL(main_tbl.tax_jurisdiction_code,FND_API.G_MISS_CHAR)

Line 1521: SELECT * FROM zx_registrations

1517: ,x_return_status OUT NOCOPY VARCHAR2
1518: ) IS
1519:
1520: CURSOR get_from_ptp_registrations IS
1521: SELECT * FROM zx_registrations
1522: WHERE party_tax_profile_id = p_from_ptp_id;
1523:
1524: l_registration_id NUMBER;
1525: l_reg_count NUMBER;

Line 1541: SELECT zx_registrations_s.nextval

1537: l_reg_count := 0;
1538:
1539: FOR rec IN get_from_ptp_registrations LOOP
1540:
1541: SELECT zx_registrations_s.nextval
1542: INTO l_registration_id
1543: FROM dual;
1544:
1545: -- fix for bug 14477937 check to avoid if insertion is creating ZX_REGISTRATIONS_U2

Line 1545: -- fix for bug 14477937 check to avoid if insertion is creating ZX_REGISTRATIONS_U2

1541: SELECT zx_registrations_s.nextval
1542: INTO l_registration_id
1543: FROM dual;
1544:
1545: -- fix for bug 14477937 check to avoid if insertion is creating ZX_REGISTRATIONS_U2
1546: INSERT INTO ZX_REGISTRATIONS
1547: (registration_type_code
1548: ,registration_number
1549: ,validation_rule

Line 1546: INSERT INTO ZX_REGISTRATIONS

1542: INTO l_registration_id
1543: FROM dual;
1544:
1545: -- fix for bug 14477937 check to avoid if insertion is creating ZX_REGISTRATIONS_U2
1546: INSERT INTO ZX_REGISTRATIONS
1547: (registration_type_code
1548: ,registration_number
1549: ,validation_rule
1550: ,rounding_rule_code

Line 1664: FROM zx_registrations ref_data

1660: ,TO_NUMBER(NULL)
1661: FROM DUAL
1662: WHERE NOT EXISTS
1663: (SELECT 1
1664: FROM zx_registrations ref_data
1665: WHERE ref_data.party_tax_profile_id = p_to_ptp_id
1666: AND NVL(ref_data.tax_regime_code,FND_API.G_MISS_CHAR) = NVL(rec.tax_regime_code,FND_API.G_MISS_CHAR)
1667: AND NVL(ref_data.tax,FND_API.G_MISS_CHAR) = NVL(rec.tax,FND_API.G_MISS_CHAR)
1668: AND NVL(ref_data.tax_jurisdiction_code,FND_API.G_MISS_CHAR) = NVL(rec.tax_jurisdiction_code,FND_API.G_MISS_CHAR)

Line 1674: UPDATE zx_registrations

1670: AND NVL(ref_data.account_site_id,FND_API.G_MISS_NUM) = NVL(rec.account_site_id,FND_API.G_MISS_NUM)
1671: AND ref_data.effective_from = rec.effective_from
1672: );
1673:
1674: UPDATE zx_registrations
1675: SET merged_to_registration_id = l_registration_id,
1676: effective_to = SYSDATE,
1677: last_update_date = SYSDATE,
1678: last_updated_by = G_USER_ID,

Line 1690: l_reg_count||' record(s) created in ZX_Registrations');

1686: END LOOP;
1687:
1688: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1689: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
1690: l_reg_count||' record(s) created in ZX_Registrations');
1691: END IF;
1692:
1693: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1694: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,