DBA Data[Home] [Help]

APPS.IBY_HZ_UNIFICATION_PKG dependencies on IBY_DOCS_PAYABLE_ALL

Line 790: UPDATE iby_docs_payable_all

786: END IF;
787:
788: IF (p_parent_entity_name = 'HZ_PARTIES') THEN
789:
790: UPDATE iby_docs_payable_all
791: SET payee_party_id = p_to_fk_id,
792: last_update_date = hz_utility_pub.last_update_date,
793: last_updated_by = hz_utility_pub.user_id,
794: last_update_login = hz_utility_pub.last_update_login

Line 798: UPDATE iby_docs_payable_all

794: last_update_login = hz_utility_pub.last_update_login
795: WHERE (document_payable_id = p_from_id)
796: AND (payee_party_id = p_from_fk_id);
797:
798: UPDATE iby_docs_payable_all
799: SET beneficiary_party = p_to_fk_id,
800: last_update_date = hz_utility_pub.last_update_date,
801: last_updated_by = hz_utility_pub.user_id,
802: last_update_login = hz_utility_pub.last_update_login

Line 808: UPDATE iby_docs_payable_all

804: AND (beneficiary_party = p_from_fk_id);
805:
806: ELSIF (p_parent_entity_name = 'IBY_EXTERNAL_PAYERS_ALL') THEN
807:
808: UPDATE iby_docs_payable_all
809: SET ext_payee_id = p_to_fk_id,
810: last_update_date = hz_utility_pub.last_update_date,
811: last_updated_by = hz_utility_pub.user_id,
812: last_update_login = hz_utility_pub.last_update_login

Line 817: UPDATE iby_docs_payable_all

813: WHERE (document_payable_id = p_from_id);
814:
815: ELSIF (p_parent_entity_name = 'HZ_PARTY_SITES') THEN
816:
817: UPDATE iby_docs_payable_all
818: SET party_site_id = p_to_fk_id,
819: -- party site may be transferred to a new party
820: payee_party_id =
821: DECODE(payee_party_id, NULL,payee_party_id,