APPS.IBY_MERGE dependencies on IBY_EXT_PARTY_PMT_MTHDS

Line 512: | Account merge procedure for the table, IBY_EXT_PARTY_PMT_MTHDS

508: |
509: | PROCEDURE
510: | PAYMENT_METHODS_MERGE
511: | DESCRIPTION :
512: | Account merge procedure for the table, IBY_EXT_PARTY_PMT_MTHDS
513: |--------------------------------------------------------------*/
514: PROCEDURE PAYMENT_METHODS_MERGE
515: (
516: ext_payer_from_list ext_payer_id_list_type,

Line 528: UPDATE iby_ext_party_pmt_mthds dup

524: for the target account, else transfer the same
525: */
526: iby_debug_pub.Add('Merging the Payment Methods');
527: FORALL i in 1..ext_payer_from_list.COUNT
528: UPDATE iby_ext_party_pmt_mthds dup
529: SET ext_pmt_party_id = ext_payer_to_list(i),
530: last_update_date = SYSDATE,
531: last_updated_by = arp_standard.profile.user_id,
532: last_update_login = arp_standard.profile.last_update_login

Line 539: FROM iby_ext_party_pmt_mthds mto

535: AND ext_payer_to_list(i) IS NOT NULL
536: AND NOT EXISTS
537: (
538: SELECT ext_party_pmt_mthd_id
539: FROM iby_ext_party_pmt_mthds mto
540: WHERE mto.ext_pmt_party_id = ext_payer_to_list(i)
541: AND mto.payment_method_code = dup.payment_method_code
542: AND mto.payment_flow = dup.payment_flow
543: AND mto.payment_function = dup.payment_function

Line 547: UPDATE iby_ext_party_pmt_mthds dup

543: AND mto.payment_function = dup.payment_function
544: );
545: iby_debug_pub.Add('Transferring the Payment Methods');
546: FORALL i in 1..ext_payer_from_list.COUNT
547: UPDATE iby_ext_party_pmt_mthds dup
548: SET inactive_date = SYSDATE,
549: last_update_date = SYSDATE,
550: last_updated_by = arp_standard.profile.user_id,
551: last_update_login = arp_standard.profile.last_update_login

Line 558: FROM iby_ext_party_pmt_mthds mto

554: AND ext_payer_to_list(i) IS NOT NULL
555: AND EXISTS
556: (
557: SELECT ext_party_pmt_mthd_id
558: FROM iby_ext_party_pmt_mthds mto
559: WHERE mto.ext_pmt_party_id = ext_payer_to_list(i)
560: AND mto.payment_method_code = dup.payment_method_code
561: AND mto.payment_flow = dup.payment_flow
562: AND mto.payment_function = dup.payment_function