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_EXT_PAYEE_RELSHIPS_PKG dependencies on IBY_EXT_PAYEE_RELATIONSHIPS

Line 42: FROM iby_ext_payee_relationships irel

38: INTO
39: x_relationship_id,
40: x_remit_party_id,
41: x_remit_supplier_site_id
42: FROM iby_ext_payee_relationships irel
43: WHERE party_id = p_party_id
44: AND supplier_site_id = p_supplier_site_id
45: AND primary_flag = 'Y'
46: AND active = 'Y'

Line 108: FROM iby_ext_payee_relationships irel

104: INTO
105: x_relationship_id,
106: x_remit_party_id,
107: x_remit_supplier_site_id
108: FROM iby_ext_payee_relationships irel
109: WHERE party_id = p_party_id
110: AND supplier_site_id = p_supplier_site_id
111: AND active = 'Y'
112: AND primary_flag = 'Y'

Line 140: FROM iby_ext_payee_relationships irel

136: remit_party_id
137: INTO
138: x_relationship_id,
139: x_remit_party_id
140: FROM iby_ext_payee_relationships irel
141: WHERE party_id = p_party_id
142: AND supplier_site_id = p_supplier_site_id
143: AND remit_supplier_site_id = x_remit_supplier_site_id
144: AND active = 'Y'

Line 158: FROM iby_ext_payee_relationships irel

154:
155: print_debuginfo('2 Primary Relationship not found');
156: SELECT count(*)
157: INTO p_count
158: FROM iby_ext_payee_relationships irel
159: WHERE party_id = p_party_id
160: AND supplier_site_id = p_supplier_site_id
161: AND remit_supplier_site_id = x_remit_supplier_site_id
162: AND active = 'Y'

Line 178: FROM iby_ext_payee_relationships irel

174:
175: IF( p_count = 1) THEN
176: SELECT irel.relationship_id,irel.remit_party_id,irel.remit_supplier_site_id
177: INTO x_relationship_id, x_remit_party_id, x_remit_supplier_site_id
178: FROM iby_ext_payee_relationships irel
179: WHERE irel.party_id = p_party_id
180: AND irel.supplier_site_id = p_supplier_site_id
181: AND irel.remit_supplier_site_id = x_remit_supplier_site_id
182: AND active = 'Y'

Line 208: FROM iby_ext_payee_relationships irel

204: remit_supplier_site_id
205: INTO
206: x_relationship_id,
207: x_remit_supplier_site_id
208: FROM iby_ext_payee_relationships irel
209: WHERE party_id = p_party_id
210: AND supplier_site_id = p_supplier_site_id
211: AND remit_party_id = x_remit_party_id
212: AND active = 'Y'

Line 225: FROM iby_ext_payee_relationships irel

221: print_debuginfo('3 Primary Relationship not found');
222: IF ( x_remit_party_id <> p_party_id ) THEN
223: SELECT count(*)
224: INTO p_count
225: FROM iby_ext_payee_relationships irel
226: WHERE party_id = p_party_id
227: AND supplier_site_id = p_supplier_site_id
228: AND remit_party_id = x_remit_party_id
229: AND active = 'Y'

Line 245: FROM iby_ext_payee_relationships irel

241:
242: IF( p_count = 1) THEN
243: SELECT irel.relationship_id,irel.remit_party_id,irel.remit_supplier_site_id
244: INTO x_relationship_id, x_remit_party_id, x_remit_supplier_site_id
245: FROM iby_ext_payee_relationships irel
246: WHERE irel.party_id = p_party_id
247: AND irel.supplier_site_id = p_supplier_site_id
248: AND irel.remit_party_id = x_remit_party_id
249: AND active = 'Y'

Line 273: FROM iby_ext_payee_relationships irel

269: SELECT
270: relationship_id
271: INTO
272: x_relationship_id
273: FROM iby_ext_payee_relationships irel
274: WHERE party_id = p_party_id
275: AND supplier_site_id = p_supplier_site_id
276: AND remit_party_id = x_remit_party_id
277: AND remit_supplier_site_id = x_remit_supplier_site_id

Line 291: FROM iby_ext_payee_relationships irel

287: print_debuginfo('4 Primary Relationship not found');
288:
289: SELECT count(*)
290: INTO p_count
291: FROM iby_ext_payee_relationships irel
292: WHERE party_id = p_party_id
293: AND supplier_site_id = p_supplier_site_id
294: AND remit_party_id = x_remit_party_id
295: AND remit_supplier_site_id = x_remit_supplier_site_id

Line 311: FROM iby_ext_payee_relationships irel

307:
308: IF( p_count = 1) THEN
309: SELECT irel.relationship_id,irel.remit_party_id,irel.remit_supplier_site_id
310: INTO x_relationship_id, x_remit_party_id, x_remit_supplier_site_id
311: FROM iby_ext_payee_relationships irel
312: WHERE irel.party_id = p_party_id
313: AND irel.supplier_site_id = p_supplier_site_id
314: AND irel.remit_party_id = x_remit_party_id
315: AND irel.remit_supplier_site_id = x_remit_supplier_site_id

Line 344: FROM iby_ext_payee_relationships irel

340: remit_supplier_site_id
341: INTO
342: x_remit_party_id,
343: x_remit_supplier_site_id
344: FROM iby_ext_payee_relationships irel
345: WHERE party_id = p_party_id
346: AND supplier_site_id = p_supplier_site_id
347: AND active = 'Y'
348: AND relationship_id = x_relationship_id

Line 371: FROM iby_ext_payee_relationships irel

367: SELECT
368: remit_party_id
369: INTO
370: x_remit_party_id
371: FROM iby_ext_payee_relationships irel
372: WHERE party_id = p_party_id
373: AND supplier_site_id = p_supplier_site_id
374: AND remit_supplier_site_id = x_remit_supplier_site_id
375: AND active = 'Y'

Line 402: FROM iby_ext_payee_relationships irel

398: SELECT
399: remit_supplier_site_id
400: INTO
401: x_remit_supplier_site_id
402: FROM iby_ext_payee_relationships irel
403: WHERE party_id = p_party_id
404: AND supplier_site_id = p_supplier_site_id
405: AND remit_party_id = x_remit_party_id
406: AND active = 'Y'

Line 431: FROM iby_ext_payee_relationships irel

427: SELECT
428: relationship_id
429: INTO
430: x_relationship_id
431: FROM iby_ext_payee_relationships irel
432: WHERE party_id = p_party_id
433: AND supplier_site_id = p_supplier_site_id
434: AND remit_party_id = x_remit_party_id
435: AND remit_supplier_site_id = x_remit_supplier_site_id

Line 481: INTO IBY_EXT_PAYEE_RELATIONSHIPS

477:
478: x_relationship_id := IBY_EXT_PAYEE_RELSHIP_SEQ.nextval;
479:
480: INSERT
481: INTO IBY_EXT_PAYEE_RELATIONSHIPS
482: (
483: RELATIONSHIP_ID,
484: PARTY_ID,
485: SUPPLIER_SITE_ID,

Line 578: UPDATE IBY_EXT_PAYEE_RELATIONSHIPS

574: validate_Payee_Relationship(p_relationship,'UPDATE', x_return_status);
575: x_relationship_id := p_relationship.relationship_id;
576:
577: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
578: UPDATE IBY_EXT_PAYEE_RELATIONSHIPS
579: SET
580: party_id = p_relationship.party_id,
581: supplier_site_id = p_relationship.supplier_site_id,
582: remit_party_id = p_relationship.remit_party_id,

Line 654: FROM iby_ext_payee_relationships irel

650: --Finding other active primary relationships for the same date range
651: IF (p_relationship.primary_flag='Y') THEN
652: SELECT count(*) l_count, XMLType.getClobVal(XMLAgg(XMLElement("ID",Relationship_id)))
653: INTO l_error_count, l_error_id
654: FROM iby_ext_payee_relationships irel
655: WHERE party_id = p_relationship.party_id
656: AND supplier_site_id = p_relationship.supplier_site_id
657: AND active = 'Y'
658: AND primary_flag = 'Y'

Line 688: FROM iby_ext_payee_relationships irel

684:
685: --Finding other active relationships for same tranding-partner/remit-to-supplier in the same daterange.
686: SELECT count(*) l_count, XMLType.getClobVal(XMLAgg(XMLElement("ID",Relationship_id)))
687: INTO l_error_count, l_error_id
688: FROM iby_ext_payee_relationships irel
689: WHERE party_id = p_relationship.party_id
690: AND supplier_site_id = p_relationship.supplier_site_id
691: AND remit_party_id = p_relationship.remit_party_id
692: AND remit_supplier_site_id = p_relationship.remit_supplier_site_id