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 HZ_MERGE_PARTIES

Line 28: p_from_fk_id in hz_merge_parties.from_party_id%type,

24: PROCEDURE ZX_CUST_REG_MERGE (
25: p_entity_name in hz_merge_dictionary.entity_name%type,
26: p_from_id in oks_billing_profiles_b.id%type,
27: x_to_id in out nocopy oks_billing_profiles_b.id%type,
28: p_from_fk_id in hz_merge_parties.from_party_id%type,
29: p_to_fk_id in hz_merge_parties.to_party_id%type,
30: p_parent_entity_name in hz_merge_dictionary.parent_entity_name%type,
31: p_batch_id in hz_merge_batch.batch_id%type,
32: p_batch_party_id in hz_merge_party_details.batch_party_id%type,

Line 29: p_to_fk_id in hz_merge_parties.to_party_id%type,

25: p_entity_name in hz_merge_dictionary.entity_name%type,
26: p_from_id in oks_billing_profiles_b.id%type,
27: x_to_id in out nocopy oks_billing_profiles_b.id%type,
28: p_from_fk_id in hz_merge_parties.from_party_id%type,
29: p_to_fk_id in hz_merge_parties.to_party_id%type,
30: p_parent_entity_name in hz_merge_dictionary.parent_entity_name%type,
31: p_batch_id in hz_merge_batch.batch_id%type,
32: p_batch_party_id in hz_merge_party_details.batch_party_id%type,
33: x_return_status out nocopy varchar2)

Line 60: cursor registration_number(p_fk_id hz_merge_parties.from_party_id%type) IS

56: l_coll_tax_auth_id_from NUMBER;
57: l_coll_tax_auth_id_to NUMBER;
58:
59:
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

Line 220: p_from_fk_id in hz_merge_parties.from_party_id%type,

216: PROCEDURE ZX_PTP_MERGE (
217: p_entity_name in hz_merge_dictionary.entity_name%type,
218: p_from_id in oks_billing_profiles_b.id%type,
219: x_to_id in out nocopy oks_billing_profiles_b.id%type,
220: p_from_fk_id in hz_merge_parties.from_party_id%type,
221: p_to_fk_id in hz_merge_parties.to_party_id%type,
222: p_parent_entity_name in hz_merge_dictionary.parent_entity_name%type,
223: p_batch_id in hz_merge_batch.batch_id%type,
224: p_batch_party_id in hz_merge_party_details.batch_party_id%type,

Line 221: p_to_fk_id in hz_merge_parties.to_party_id%type,

217: p_entity_name in hz_merge_dictionary.entity_name%type,
218: p_from_id in oks_billing_profiles_b.id%type,
219: x_to_id in out nocopy oks_billing_profiles_b.id%type,
220: p_from_fk_id in hz_merge_parties.from_party_id%type,
221: p_to_fk_id in hz_merge_parties.to_party_id%type,
222: p_parent_entity_name in hz_merge_dictionary.parent_entity_name%type,
223: p_batch_id in hz_merge_batch.batch_id%type,
224: p_batch_party_id in hz_merge_party_details.batch_party_id%type,
225: x_return_status out nocopy varchar2)

Line 234: cursor Party_Tax_Profile(p_fk_id hz_merge_parties.from_party_id%type) IS

230: l_ptp_id_from NUMBER;
231: l_ptp_id_to NUMBER;
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';

Line 367: p_from_fk_id in hz_merge_parties.from_party_id%type,

363: p_entity_name in hz_merge_dictionary.entity_name%type,
364: p_ptp_id_from in NUMBER,
365: p_ptp_id_to in NUMBER,
366: x_to_id in out nocopy oks_billing_profiles_b.id%type,
367: p_from_fk_id in hz_merge_parties.from_party_id%type,
368: p_to_fk_id in hz_merge_parties.to_party_id%type,
369: x_return_status out nocopy varchar2)
370: IS
371: -- Enter the procedure variables here. As shown below

Line 368: p_to_fk_id in hz_merge_parties.to_party_id%type,

364: p_ptp_id_from in NUMBER,
365: p_ptp_id_to in NUMBER,
366: x_to_id in out nocopy oks_billing_profiles_b.id%type,
367: p_from_fk_id in hz_merge_parties.from_party_id%type,
368: p_to_fk_id in hz_merge_parties.to_party_id%type,
369: x_return_status out nocopy varchar2)
370: IS
371: -- Enter the procedure variables here. As shown below
372: l_proc_name varchar2(30) := 'ZX_TAX_AUTH_MERGE';

Line 523: p_from_fk_id in hz_merge_parties.from_party_id%type,

519: PROCEDURE ZX_EXEMPTIONS_P (
520: p_entity_name in hz_merge_dictionary.entity_name%type,
521: p_from_id in oks_billing_profiles_b.id%type,
522: x_to_id in out nocopy oks_billing_profiles_b.id%type,
523: p_from_fk_id in hz_merge_parties.from_party_id%type,
524: p_to_fk_id in hz_merge_parties.to_party_id%type,
525: p_parent_entity_name in hz_merge_dictionary.parent_entity_name%type,
526: p_batch_id in hz_merge_batch.batch_id%type,
527: p_batch_party_id in hz_merge_party_details.batch_party_id%type,

Line 524: p_to_fk_id in hz_merge_parties.to_party_id%type,

520: p_entity_name in hz_merge_dictionary.entity_name%type,
521: p_from_id in oks_billing_profiles_b.id%type,
522: x_to_id in out nocopy oks_billing_profiles_b.id%type,
523: p_from_fk_id in hz_merge_parties.from_party_id%type,
524: p_to_fk_id in hz_merge_parties.to_party_id%type,
525: p_parent_entity_name in hz_merge_dictionary.parent_entity_name%type,
526: p_batch_id in hz_merge_batch.batch_id%type,
527: p_batch_party_id in hz_merge_party_details.batch_party_id%type,
528: x_return_status out nocopy varchar2)

Line 532: cursor exe_number(p_fk_id hz_merge_parties.from_party_id%type) IS

528: x_return_status out nocopy varchar2)
529:
530: IS
531:
532: cursor exe_number(p_fk_id hz_merge_parties.from_party_id%type) IS
533: select TAX_EXEMPTION_ID
534: , EXEMPT_CERTIFICATE_NUMBER
535: , effective_from
536: , effective_to

Line 642: p_from_fk_id in hz_merge_parties.from_party_id%type,

638: PROCEDURE ZX_CUSTOMER_VETO (
639: p_ptp_id_from in number,
640: p_ptp_id_to in number,
641: x_merge_yn out nocopy VARCHAR2,
642: p_from_fk_id in hz_merge_parties.from_party_id%type,
643: p_to_fk_id in hz_merge_parties.to_party_id%type,
644: x_return_status out nocopy varchar2)
645: IS
646: -- Enter the procedure variables here. As shown below

Line 643: p_to_fk_id in hz_merge_parties.to_party_id%type,

639: p_ptp_id_from in number,
640: p_ptp_id_to in number,
641: x_merge_yn out nocopy VARCHAR2,
642: p_from_fk_id in hz_merge_parties.from_party_id%type,
643: p_to_fk_id in hz_merge_parties.to_party_id%type,
644: x_return_status out nocopy varchar2)
645: IS
646: -- Enter the procedure variables here. As shown below
647: l_proc_name varchar2(30) := 'ZX_CUSTOMER_VETO';

Line 770: p_from_fk_id in hz_merge_parties.from_party_id%type,

766: PROCEDURE ZX_MERGE (
767: p_entity_name in hz_merge_dictionary.entity_name%type,
768: p_from_id in oks_billing_profiles_b.id%type,
769: x_to_id in out nocopy oks_billing_profiles_b.id%type,
770: p_from_fk_id in hz_merge_parties.from_party_id%type,
771: p_to_fk_id in hz_merge_parties.to_party_id%type,
772: p_parent_entity_name in hz_merge_dictionary.parent_entity_name%type,
773: p_batch_id in hz_merge_batch.batch_id%type,
774: p_batch_party_id in hz_merge_party_details.batch_party_id%type,

Line 771: p_to_fk_id in hz_merge_parties.to_party_id%type,

767: p_entity_name in hz_merge_dictionary.entity_name%type,
768: p_from_id in oks_billing_profiles_b.id%type,
769: x_to_id in out nocopy oks_billing_profiles_b.id%type,
770: p_from_fk_id in hz_merge_parties.from_party_id%type,
771: p_to_fk_id in hz_merge_parties.to_party_id%type,
772: p_parent_entity_name in hz_merge_dictionary.parent_entity_name%type,
773: p_batch_id in hz_merge_batch.batch_id%type,
774: p_batch_party_id in hz_merge_party_details.batch_party_id%type,
775: x_return_status out nocopy varchar2)

Line 788: cursor Party_Tax_Profile(p_fk_id hz_merge_parties.from_party_id%type) IS

784: l_party_type_to VARCHAR2(30);
785: l_merge_yn VARCHAR2(1);
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';