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.IBY_HZ_UNIFICATION_PKG dependencies on IBY_EXTERNAL_PAYEES_ALL

Line 98: l_dup_id iby_external_payees_all.ext_payee_id%TYPE;

94: p_batch_party_id IN NUMBER,
95: x_return_status IN OUT NOCOPY VARCHAR2
96: )
97: IS
98: l_dup_id iby_external_payees_all.ext_payee_id%TYPE;
99: l_new_party_id iby_external_payees_all.payee_party_id%TYPE;
100:
101: CURSOR c_dupeparty
102: (ci_payee_id IN iby_external_payees_all.ext_payee_id%TYPE,

Line 99: l_new_party_id iby_external_payees_all.payee_party_id%TYPE;

95: x_return_status IN OUT NOCOPY VARCHAR2
96: )
97: IS
98: l_dup_id iby_external_payees_all.ext_payee_id%TYPE;
99: l_new_party_id iby_external_payees_all.payee_party_id%TYPE;
100:
101: CURSOR c_dupeparty
102: (ci_payee_id IN iby_external_payees_all.ext_payee_id%TYPE,
103: ci_party_id IN iby_external_payees_all.payee_party_id%TYPE)

Line 102: (ci_payee_id IN iby_external_payees_all.ext_payee_id%TYPE,

98: l_dup_id iby_external_payees_all.ext_payee_id%TYPE;
99: l_new_party_id iby_external_payees_all.payee_party_id%TYPE;
100:
101: CURSOR c_dupeparty
102: (ci_payee_id IN iby_external_payees_all.ext_payee_id%TYPE,
103: ci_party_id IN iby_external_payees_all.payee_party_id%TYPE)
104: IS
105: SELECT ext_payee_id
106: FROM iby_external_payees_all mto,

Line 103: ci_party_id IN iby_external_payees_all.payee_party_id%TYPE)

99: l_new_party_id iby_external_payees_all.payee_party_id%TYPE;
100:
101: CURSOR c_dupeparty
102: (ci_payee_id IN iby_external_payees_all.ext_payee_id%TYPE,
103: ci_party_id IN iby_external_payees_all.payee_party_id%TYPE)
104: IS
105: SELECT ext_payee_id
106: FROM iby_external_payees_all mto,
107: (SELECT payment_function,payee_party_id,party_site_id,

Line 106: FROM iby_external_payees_all mto,

102: (ci_payee_id IN iby_external_payees_all.ext_payee_id%TYPE,
103: ci_party_id IN iby_external_payees_all.payee_party_id%TYPE)
104: IS
105: SELECT ext_payee_id
106: FROM iby_external_payees_all mto,
107: (SELECT payment_function,payee_party_id,party_site_id,
108: supplier_site_id,org_type,org_id
109: FROM iby_external_payees_all
110: WHERE (ext_payee_id = ci_payee_id)) mfrom

Line 109: FROM iby_external_payees_all

105: SELECT ext_payee_id
106: FROM iby_external_payees_all mto,
107: (SELECT payment_function,payee_party_id,party_site_id,
108: supplier_site_id,org_type,org_id
109: FROM iby_external_payees_all
110: WHERE (ext_payee_id = ci_payee_id)) mfrom
111: WHERE
112: mto.ext_payee_id <> ci_payee_id
113: AND mto.payment_function = mfrom.payment_function

Line 121: (ci_payee_id IN iby_external_payees_all.ext_payee_id%TYPE,

117: AND NVL(mto.org_type,'!') = NVL(mfrom.org_type,'!')
118: AND NVL(mto.org_id,-99) = NVL(mfrom.org_id,-99);
119:
120: CURSOR c_dupesite
121: (ci_payee_id IN iby_external_payees_all.ext_payee_id%TYPE,
122: ci_site_id IN iby_external_payees_all.party_site_id%TYPE)
123: IS
124: SELECT ext_payee_id, np.party_id
125: FROM iby_external_payees_all mto,

Line 122: ci_site_id IN iby_external_payees_all.party_site_id%TYPE)

118: AND NVL(mto.org_id,-99) = NVL(mfrom.org_id,-99);
119:
120: CURSOR c_dupesite
121: (ci_payee_id IN iby_external_payees_all.ext_payee_id%TYPE,
122: ci_site_id IN iby_external_payees_all.party_site_id%TYPE)
123: IS
124: SELECT ext_payee_id, np.party_id
125: FROM iby_external_payees_all mto,
126: (SELECT payment_function,payee_party_id,party_site_id,

Line 125: FROM iby_external_payees_all mto,

121: (ci_payee_id IN iby_external_payees_all.ext_payee_id%TYPE,
122: ci_site_id IN iby_external_payees_all.party_site_id%TYPE)
123: IS
124: SELECT ext_payee_id, np.party_id
125: FROM iby_external_payees_all mto,
126: (SELECT payment_function,payee_party_id,party_site_id,
127: supplier_site_id,org_type,org_id
128: FROM iby_external_payees_all
129: WHERE (ext_payee_id = ci_payee_id)) mfrom,

Line 128: FROM iby_external_payees_all

124: SELECT ext_payee_id, np.party_id
125: FROM iby_external_payees_all mto,
126: (SELECT payment_function,payee_party_id,party_site_id,
127: supplier_site_id,org_type,org_id
128: FROM iby_external_payees_all
129: WHERE (ext_payee_id = ci_payee_id)) mfrom,
130: (SELECT party_id FROM hz_party_sites WHERE party_site_id = ci_site_id) np
131: WHERE
132: mto.ext_payee_id <> ci_payee_id

Line 168: UPDATE iby_external_payees_all

164:
165: iby_debug_pub.add('duplicate payee:='|| l_dup_id,
166: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
167:
168: UPDATE iby_external_payees_all
169: SET payee_party_id = DECODE(l_dup_id, NULL,p_to_fk_id, payee_party_id),
170: inactive_date = DECODE(l_dup_id, NULL,inactive_date, SYSDATE),
171: last_update_date = hz_utility_pub.last_update_date,
172: last_updated_by = hz_utility_pub.user_id,

Line 190: UPDATE iby_external_payees_all

186:
187: iby_debug_pub.add('duplicate payee:='|| l_dup_id,
188: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
189:
190: UPDATE iby_external_payees_all
191: SET party_site_id = DECODE(l_dup_id, NULL,p_to_fk_id, party_site_id),
192: --
193: -- update the denormalized party id to the new party in the
194: -- case of either merge or transfer of the site

Line 422: ELSIF (p_parent_entity_name = 'IBY_EXTERNAL_PAYEES_ALL')

418: ELSE
419: p_to_id := l_dup_id;
420: END IF;
421:
422: ELSIF (p_parent_entity_name = 'IBY_EXTERNAL_PAYEES_ALL')
423: OR (p_parent_entity_name = 'IBY_EXTERNAL_PAYERS_ALL')
424: THEN
425:
426: IF (p_from_fk_id = p_to_fk_id) THEN