DBA Data[Home] [Help]

APPS.IBY_HZ_UNIFICATION_PKG dependencies on IBY_PAYMENTS_ALL

Line 870: UPDATE iby_payments_all

866: END IF;
867:
868: IF (p_parent_entity_name = 'HZ_PARTIES') THEN
869:
870: UPDATE iby_payments_all
871: SET payee_party_id = p_to_fk_id,
872: last_update_date = hz_utility_pub.last_update_date,
873: last_updated_by = hz_utility_pub.user_id,
874: last_update_login = hz_utility_pub.last_update_login

Line 878: UPDATE iby_payments_all

874: last_update_login = hz_utility_pub.last_update_login
875: WHERE (payment_id = p_from_id)
876: AND (payee_party_id = p_from_fk_id);
877:
878: UPDATE iby_payments_all
879: SET beneficiary_party = p_to_fk_id,
880: last_update_date = hz_utility_pub.last_update_date,
881: last_updated_by = hz_utility_pub.user_id,
882: last_update_login = hz_utility_pub.last_update_login

Line 886: UPDATE iby_payments_all

882: last_update_login = hz_utility_pub.last_update_login
883: WHERE (payment_id = p_from_id)
884: AND (beneficiary_party = p_from_fk_id);
885:
886: UPDATE iby_payments_all
887: SET payer_party_id = p_to_fk_id,
888: last_update_date = hz_utility_pub.last_update_date,
889: last_updated_by = hz_utility_pub.user_id,
890: last_update_login = hz_utility_pub.last_update_login

Line 896: UPDATE iby_payments_all

892: AND (payer_party_id = p_from_fk_id);
893:
894: ELSIF (p_parent_entity_name = 'IBY_EXTERNAL_PAYERS_ALL') THEN
895:
896: UPDATE iby_payments_all
897: SET ext_payee_id = p_to_fk_id,
898: last_update_date = hz_utility_pub.last_update_date,
899: last_updated_by = hz_utility_pub.user_id,
900: last_update_login = hz_utility_pub.last_update_login

Line 905: UPDATE iby_payments_all

901: WHERE (payment_id = p_from_id);
902:
903: ELSIF (p_parent_entity_name = 'HZ_PARTY_SITES') THEN
904:
905: UPDATE iby_payments_all
906: SET party_site_id = p_to_fk_id,
907: -- party site may be transferred to a new party
908: payee_party_id =
909: DECODE(payee_party_id, NULL,payee_party_id,