APPS.ZX_PARTY_MERGE_PKG dependencies on ZX_REGISTRATIONS

Line 64: from zx_registrations reg, zx_party_tax_profile prof

60: cursor registration_number(p_fk_id hz_merge_parties.from_party_id%type) IS
61: select registration_id, registration_number, effective_from, effective_to,
62: LEGAL_LOCATION_ID, REGISTRATION_SOURCE_CODE, REGISTRATION_REASON_CODE,
63: REP_TAX_AUTHORITY_ID, COLL_TAX_AUTHORITY_ID
64: from zx_registrations reg, zx_party_tax_profile prof
65: where reg.PARTY_TAX_PROFILE_ID = prof.PARTY_TAX_PROFILE_ID
66: and prof.party_id = p_fk_id;
67: from_registration_rec registration_number%ROWTYPE;
68: to_registration_rec registration_number%ROWTYPE;

Line 168: update zx_registrations

164: if(l_coll_tax_auth_id_to is null and l_coll_tax_auth_id_from is not null) THEN
165: l_coll_tax_auth_id_to := l_coll_tax_auth_id_from;
166: end if;
167:
168: update zx_registrations
169: set merged_to_registration_id = l_registration_id_to,
170: effective_to = sysdate,
171: last_update_date = sysdate,
172: last_updated_by = g_user_id,

Line 177: update zx_registrations

173: last_update_login = g_login_id,
174: object_version_number = object_version_number+1
175: where registration_id = l_registration_id_from;
176:
177: update zx_registrations
178: set effective_from = l_update_reg_from_date,
179: effective_to = l_update_reg_to_date,
180: LEGAL_LOCATION_ID = l_location_id_to,
181: REGISTRATION_SOURCE_CODE = l_reg_src_code_to,

Line 404: arp_message.set_line('Updating zx_registrations for tax Authorities...');

400:
401: if p_from_fk_id <> p_to_fk_id then
402: BEGIN
403:
404: arp_message.set_line('Updating zx_registrations for tax Authorities...');
405:
406: update zx_registrations
407: set TAX_AUTHORITY_ID = p_ptp_id_to,
408: last_update_date = sysdate,

Line 406: update zx_registrations

402: BEGIN
403:
404: arp_message.set_line('Updating zx_registrations for tax Authorities...');
405:
406: update zx_registrations
407: set TAX_AUTHORITY_ID = p_ptp_id_to,
408: last_update_date = sysdate,
409: last_updated_by = g_user_id,
410: last_update_login = g_login_id,

Line 414: update zx_registrations

410: last_update_login = g_login_id,
411: object_version_number = object_version_number+1
412: where TAX_AUTHORITY_ID = p_ptp_id_from;
413:
414: update zx_registrations
415: set REP_TAX_AUTHORITY_ID = p_ptp_id_to,
416: last_update_date = sysdate,
417: last_updated_by = g_user_id,
418: last_update_login = g_login_id,

Line 422: update zx_registrations

418: last_update_login = g_login_id,
419: object_version_number = object_version_number+1
420: where REP_TAX_AUTHORITY_ID = p_ptp_id_from;
421:
422: update zx_registrations
423: set COLL_TAX_AUTHORITY_ID = p_ptp_id_to,
424: last_update_date = sysdate,
425: last_updated_by = g_user_id,
426: last_update_login = g_login_id,

Line 673: from zx_registrations a, zx_party_tax_profile b

669:
670: cursor Registration_Attributes(p_ptp_id number) IS
671: select a.REGISTRATION_TYPE_CODE, a.REGISTRATION_NUMBER, a.ROUNDING_RULE_CODE,
672: a.SELF_ASSESS_FLAG, a.INCLUSIVE_TAX_FLAG
673: from zx_registrations a, zx_party_tax_profile b
674: where b.party_tax_profile_id = p_ptp_id
675: and a.party_tax_profile_id = b.party_tax_profile_id;
676:
677: Reg_Attr_From_Rec Registration_Attributes%ROWTYPE;