APPS.ZX_PARTY_MERGE_PKG dependencies on ZX_PARTY_TAX_PROFILE

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 99: arp_message.set_line('Updating zx_party_tax_profile...');

95:
96: if p_from_fk_id <> p_to_fk_id then
97: BEGIN
98:
99: arp_message.set_line('Updating zx_party_tax_profile...');
100:
101: OPEN registration_number(p_from_fk_id);
102: FETCH registration_number INTO from_registration_rec;
103: IF registration_number%FOUND THEN

Line 228: l_proc_name varchar2(30) := 'ZX_PARTY_TAX_PROFILE';

224: p_batch_party_id in hz_merge_party_details.batch_party_id%type,
225: x_return_status out nocopy varchar2)
226: IS
227: -- Enter the procedure variables here. As shown below
228: l_proc_name varchar2(30) := 'ZX_PARTY_TAX_PROFILE';
229: l_count number(10) := 0;
230: l_ptp_id_from NUMBER;
231: l_ptp_id_to NUMBER;
232: l_code_assignment_id hz_code_assignments.owner_table_name%TYPE;

Line 236: from zx_party_tax_profile prof

232: l_code_assignment_id hz_code_assignments.owner_table_name%TYPE;
233:
234: cursor Party_Tax_Profile(p_fk_id hz_merge_parties.from_party_id%type) IS
235: select Party_Tax_Profile_id
236: from zx_party_tax_profile prof
237: where prof.party_id = p_fk_id
238: and prof.party_type_code = 'THIRD_PARTY';
239:
240: from_ptp_rec Party_Tax_Profile%ROWTYPE;

Line 246: where owner_table_name = 'ZX_PARTY_TAX_PROFILE'

242:
243: cursor Class_Categories_From(p_ptp_id number) IS
244: select code_assignment_id, class_category, class_code, END_DATE_ACTIVE
245: from hz_code_assignments
246: where owner_table_name = 'ZX_PARTY_TAX_PROFILE'
247: and owner_table_id = p_ptp_id
248: and NVL(END_DATE_ACTIVE,SYSDATE) >= sysdate;
249:
250: cursor Class_Codes_To(p_ptp_id number,

Line 256: where owner_table_name = 'ZX_PARTY_TAX_PROFILE'

252: p_end_date hz_code_assignments.end_date_active%type,
253: p_class_code hz_code_assignments.class_code%type) IS
254: select distinct class_category, class_code, END_DATE_ACTIVE
255: from hz_code_assignments
256: where owner_table_name = 'ZX_PARTY_TAX_PROFILE'
257: and owner_table_id = p_ptp_id
258: and NVL(END_DATE_ACTIVE,SYSDATE) >= NVL(p_end_date,SYSDATE)
259: and class_category = p_class_category
260: and class_code = p_class_code

Line 294: arp_message.set_line('Updating zx_party_tax_profile...');

290:
291: if p_from_fk_id <> p_to_fk_id then
292:
293: BEGIN
294: arp_message.set_line('Updating zx_party_tax_profile...');
295:
296: OPEN Party_Tax_Profile(p_from_fk_id);
297: FETCH Party_Tax_Profile INTO from_ptp_rec;
298: IF Party_Tax_Profile%FOUND THEN

Line 310: update zx_party_tax_profile

306: l_ptp_id_to := to_ptp_rec.Party_Tax_Profile_id;
307: END IF;
308: CLOSE Party_Tax_Profile;
309:
310: update zx_party_tax_profile
311: set merged_to_ptp_id = l_ptp_id_to,
312: MERGED_STATUS_CODE = 'MERGED',
313: last_update_date = sysdate,
314: last_updated_by = g_user_id,

Line 664: from zx_party_tax_profile ptp

660: -- class_category_tbl class_category_tbl_type;
661:
662: cursor Calculate_Tax_Flag(p_ptp_id NUMBER) IS
663: select PROCESS_FOR_APPLICABILITY_FLAG
664: from zx_party_tax_profile ptp
665: where ptp.party_tax_profile_id = p_ptp_id;
666:
667: from_calc_tax_rec Calculate_Tax_Flag%ROWTYPE;
668: to_calc_tax_rec Calculate_Tax_Flag%ROWTYPE;

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;

Line 790: from zx_party_tax_profile prof

786:
787:
788: cursor Party_Tax_Profile(p_fk_id hz_merge_parties.from_party_id%type) IS
789: select Party_Tax_Profile_id, party_type_code
790: from zx_party_tax_profile prof
791: where prof.party_id = p_fk_id
792: and prof.party_type_code = 'THIRD_PARTY';
793:
794: from_ptp_rec Party_Tax_Profile%ROWTYPE;