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 23: p_from_fk_id in hz_merge_parties.from_party_id%type,

19: PROCEDURE ZX_CUST_REG_MERGE_PVT (
20: p_entity_name in hz_merge_dictionary.entity_name%type,
21: p_from_id in oks_billing_profiles_b.id%type,
22: x_to_id in out nocopy oks_billing_profiles_b.id%type,
23: p_from_fk_id in hz_merge_parties.from_party_id%type,
24: p_to_fk_id in hz_merge_parties.to_party_id%type,
25: p_parent_entity_name in hz_merge_dictionary.parent_entity_name%type,
26: p_batch_id in hz_merge_batch.batch_id%type,
27: p_batch_party_id in hz_merge_party_details.batch_party_id%type,

Line 24: p_to_fk_id in hz_merge_parties.to_party_id%type,

20: p_entity_name in hz_merge_dictionary.entity_name%type,
21: p_from_id in oks_billing_profiles_b.id%type,
22: x_to_id in out nocopy oks_billing_profiles_b.id%type,
23: p_from_fk_id in hz_merge_parties.from_party_id%type,
24: p_to_fk_id in hz_merge_parties.to_party_id%type,
25: p_parent_entity_name in hz_merge_dictionary.parent_entity_name%type,
26: p_batch_id in hz_merge_batch.batch_id%type,
27: p_batch_party_id in hz_merge_party_details.batch_party_id%type,
28: x_return_status out nocopy varchar2)

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

50: --l_coll_tax_auth_id_from NUMBER;
51: --l_coll_tax_auth_id_to NUMBER;
52:
53:
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

Line 65: (p_from_party_id hz_merge_parties.from_party_id%type

61: --from_registration_rec registration_number%ROWTYPE;
62: --to_registration_rec registration_number%ROWTYPE;0
63:
64: CURSOR registration_number
65: (p_from_party_id hz_merge_parties.from_party_id%type
66: ,p_to_party_id hz_merge_parties.to_party_id%type)
67: IS
68: SELECT from_reg.registration_id registration_id_from,
69: to_reg.registration_id registration_id_to,

Line 66: ,p_to_party_id hz_merge_parties.to_party_id%type)

62: --to_registration_rec registration_number%ROWTYPE;0
63:
64: CURSOR registration_number
65: (p_from_party_id hz_merge_parties.from_party_id%type
66: ,p_to_party_id hz_merge_parties.to_party_id%type)
67: IS
68: SELECT from_reg.registration_id registration_id_from,
69: to_reg.registration_id registration_id_to,
70: CASE WHEN from_reg.effective_from > to_reg.effective_from

Line 198: p_from_fk_id in hz_merge_parties.from_party_id%type,

194: PROCEDURE ZX_PTP_MERGE_PVT (
195: p_entity_name in hz_merge_dictionary.entity_name%type,
196: p_from_id in oks_billing_profiles_b.id%type,
197: x_to_id in out nocopy oks_billing_profiles_b.id%type,
198: p_from_fk_id in hz_merge_parties.from_party_id%type,
199: p_to_fk_id in hz_merge_parties.to_party_id%type,
200: p_parent_entity_name in hz_merge_dictionary.parent_entity_name%type,
201: p_batch_id in hz_merge_batch.batch_id%type,
202: p_batch_party_id in hz_merge_party_details.batch_party_id%type,

Line 199: p_to_fk_id in hz_merge_parties.to_party_id%type,

195: p_entity_name in hz_merge_dictionary.entity_name%type,
196: p_from_id in oks_billing_profiles_b.id%type,
197: x_to_id in out nocopy oks_billing_profiles_b.id%type,
198: p_from_fk_id in hz_merge_parties.from_party_id%type,
199: p_to_fk_id in hz_merge_parties.to_party_id%type,
200: p_parent_entity_name in hz_merge_dictionary.parent_entity_name%type,
201: p_batch_id in hz_merge_batch.batch_id%type,
202: p_batch_party_id in hz_merge_party_details.batch_party_id%type,
203: x_return_status out nocopy varchar2)

Line 211: CURSOR Party_Tax_Profile(p_fk_id hz_merge_parties.from_party_id%type) IS

207: l_ptp_id_from NUMBER;
208: l_ptp_id_to NUMBER;
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';

Line 342: p_from_fk_id in hz_merge_parties.from_party_id%type,

338: p_entity_name in hz_merge_dictionary.entity_name%type,
339: p_ptp_id_from in NUMBER,
340: p_ptp_id_to in NUMBER,
341: x_to_id in out nocopy oks_billing_profiles_b.id%type,
342: p_from_fk_id in hz_merge_parties.from_party_id%type,
343: p_to_fk_id in hz_merge_parties.to_party_id%type,
344: x_return_status out nocopy varchar2)
345: IS
346: -- Enter the procedure variables here. As shown below

Line 343: p_to_fk_id in hz_merge_parties.to_party_id%type,

339: p_ptp_id_from in NUMBER,
340: p_ptp_id_to in NUMBER,
341: x_to_id in out nocopy oks_billing_profiles_b.id%type,
342: p_from_fk_id in hz_merge_parties.from_party_id%type,
343: p_to_fk_id in hz_merge_parties.to_party_id%type,
344: x_return_status out nocopy varchar2)
345: IS
346: -- Enter the procedure variables here. As shown below
347: l_count number(10) := 0;

Line 492: p_from_fk_id in hz_merge_parties.from_party_id%type,

488: PROCEDURE ZX_EXEMPTIONS_PVT (
489: p_entity_name in hz_merge_dictionary.entity_name%type,
490: p_from_id in oks_billing_profiles_b.id%type,
491: x_to_id in out nocopy oks_billing_profiles_b.id%type,
492: p_from_fk_id in hz_merge_parties.from_party_id%type,
493: p_to_fk_id in hz_merge_parties.to_party_id%type,
494: p_parent_entity_name in hz_merge_dictionary.parent_entity_name%type,
495: p_batch_id in hz_merge_batch.batch_id%type,
496: p_batch_party_id in hz_merge_party_details.batch_party_id%type,

Line 493: p_to_fk_id in hz_merge_parties.to_party_id%type,

489: p_entity_name in hz_merge_dictionary.entity_name%type,
490: p_from_id in oks_billing_profiles_b.id%type,
491: x_to_id in out nocopy oks_billing_profiles_b.id%type,
492: p_from_fk_id in hz_merge_parties.from_party_id%type,
493: p_to_fk_id in hz_merge_parties.to_party_id%type,
494: p_parent_entity_name in hz_merge_dictionary.parent_entity_name%type,
495: p_batch_id in hz_merge_batch.batch_id%type,
496: p_batch_party_id in hz_merge_party_details.batch_party_id%type,
497: x_return_status out nocopy varchar2)

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

497: x_return_status out nocopy varchar2)
498:
499: IS
500:
501: cursor exe_number(p_fk_id hz_merge_parties.from_party_id%type) IS
502: SELECT TAX_EXEMPTION_ID
503: , EXEMPT_CERTIFICATE_NUMBER
504: , effective_from
505: , effective_to

Line 649: p_from_fk_id in hz_merge_parties.from_party_id%type,

645: PROCEDURE ZX_CUSTOMER_VETO_PVT (
646: p_ptp_id_from in number,
647: p_ptp_id_to in number,
648: x_merge_yn out nocopy VARCHAR2,
649: p_from_fk_id in hz_merge_parties.from_party_id%type,
650: p_to_fk_id in hz_merge_parties.to_party_id%type,
651: x_return_status out nocopy varchar2)
652: IS
653: -- Enter the procedure variables here. As shown below

Line 650: p_to_fk_id in hz_merge_parties.to_party_id%type,

646: p_ptp_id_from in number,
647: p_ptp_id_to in number,
648: x_merge_yn out nocopy VARCHAR2,
649: p_from_fk_id in hz_merge_parties.from_party_id%type,
650: p_to_fk_id in hz_merge_parties.to_party_id%type,
651: x_return_status out nocopy varchar2)
652: IS
653: -- Enter the procedure variables here. As shown below
654: l_ptp_id_from NUMBER;

Line 856: p_from_fk_id in hz_merge_parties.from_party_id%type,

852: PROCEDURE ZX_MERGE (
853: p_entity_name in hz_merge_dictionary.entity_name%type,
854: p_from_id in oks_billing_profiles_b.id%type,
855: x_to_id in out nocopy oks_billing_profiles_b.id%type,
856: p_from_fk_id in hz_merge_parties.from_party_id%type,
857: p_to_fk_id in hz_merge_parties.to_party_id%type,
858: p_parent_entity_name in hz_merge_dictionary.parent_entity_name%type,
859: p_batch_id in hz_merge_batch.batch_id%type,
860: p_batch_party_id in hz_merge_party_details.batch_party_id%type,

Line 857: p_to_fk_id in hz_merge_parties.to_party_id%type,

853: p_entity_name in hz_merge_dictionary.entity_name%type,
854: p_from_id in oks_billing_profiles_b.id%type,
855: x_to_id in out nocopy oks_billing_profiles_b.id%type,
856: p_from_fk_id in hz_merge_parties.from_party_id%type,
857: p_to_fk_id in hz_merge_parties.to_party_id%type,
858: p_parent_entity_name in hz_merge_dictionary.parent_entity_name%type,
859: p_batch_id in hz_merge_batch.batch_id%type,
860: p_batch_party_id in hz_merge_party_details.batch_party_id%type,
861: x_return_status out nocopy varchar2)

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

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