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 XMLTYPE

Line 652: SELECT count(*) l_count, XMLType.getClobVal(XMLAgg(XMLElement("ID",Relationship_id)))

648:
649: IF(p_relationship.active='Y') THEN
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

Line 686: SELECT count(*) l_count, XMLType.getClobVal(XMLAgg(XMLElement("ID",Relationship_id)))

682: print_debuginfo('Conflicting Primary Relationship IDs: '||l_error_id);
683: END IF;
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