APPS.IBY_HZ_UNIFICATION_PKG dependencies on IBY_EXT_PARTY_PMT_MTHDS

Line 571: l_dup_id iby_ext_party_pmt_mthds.ext_party_pmt_mthd_id%TYPE := NULL;

567: p_batch_party_id IN NUMBER,
568: x_return_status IN OUT NOCOPY VARCHAR2
569: )
570: IS
571: l_dup_id iby_ext_party_pmt_mthds.ext_party_pmt_mthd_id%TYPE := NULL;
572: l_flow_type iby_ext_party_pmt_mthds.payment_flow%TYPE;
573:
574: CURSOR c_dupemth
575: (ci_mth_id IN iby_ext_party_pmt_mthds.ext_party_pmt_mthd_id%TYPE,

Line 572: l_flow_type iby_ext_party_pmt_mthds.payment_flow%TYPE;

568: x_return_status IN OUT NOCOPY VARCHAR2
569: )
570: IS
571: l_dup_id iby_ext_party_pmt_mthds.ext_party_pmt_mthd_id%TYPE := NULL;
572: l_flow_type iby_ext_party_pmt_mthds.payment_flow%TYPE;
573:
574: CURSOR c_dupemth
575: (ci_mth_id IN iby_ext_party_pmt_mthds.ext_party_pmt_mthd_id%TYPE,
576: ci_party_id IN iby_ext_party_pmt_mthds.ext_pmt_party_id%TYPE,

Line 575: (ci_mth_id IN iby_ext_party_pmt_mthds.ext_party_pmt_mthd_id%TYPE,

571: l_dup_id iby_ext_party_pmt_mthds.ext_party_pmt_mthd_id%TYPE := NULL;
572: l_flow_type iby_ext_party_pmt_mthds.payment_flow%TYPE;
573:
574: CURSOR c_dupemth
575: (ci_mth_id IN iby_ext_party_pmt_mthds.ext_party_pmt_mthd_id%TYPE,
576: ci_party_id IN iby_ext_party_pmt_mthds.ext_pmt_party_id%TYPE,
577: ci_flow_type IN iby_ext_party_pmt_mthds.payment_flow%TYPE)
578: IS
579: SELECT ext_party_pmt_mthd_id

Line 576: ci_party_id IN iby_ext_party_pmt_mthds.ext_pmt_party_id%TYPE,

572: l_flow_type iby_ext_party_pmt_mthds.payment_flow%TYPE;
573:
574: CURSOR c_dupemth
575: (ci_mth_id IN iby_ext_party_pmt_mthds.ext_party_pmt_mthd_id%TYPE,
576: ci_party_id IN iby_ext_party_pmt_mthds.ext_pmt_party_id%TYPE,
577: ci_flow_type IN iby_ext_party_pmt_mthds.payment_flow%TYPE)
578: IS
579: SELECT ext_party_pmt_mthd_id
580: FROM iby_ext_party_pmt_mthds mto,

Line 577: ci_flow_type IN iby_ext_party_pmt_mthds.payment_flow%TYPE)

573:
574: CURSOR c_dupemth
575: (ci_mth_id IN iby_ext_party_pmt_mthds.ext_party_pmt_mthd_id%TYPE,
576: ci_party_id IN iby_ext_party_pmt_mthds.ext_pmt_party_id%TYPE,
577: ci_flow_type IN iby_ext_party_pmt_mthds.payment_flow%TYPE)
578: IS
579: SELECT ext_party_pmt_mthd_id
580: FROM iby_ext_party_pmt_mthds mto,
581: (SELECT payment_method_code

Line 580: FROM iby_ext_party_pmt_mthds mto,

576: ci_party_id IN iby_ext_party_pmt_mthds.ext_pmt_party_id%TYPE,
577: ci_flow_type IN iby_ext_party_pmt_mthds.payment_flow%TYPE)
578: IS
579: SELECT ext_party_pmt_mthd_id
580: FROM iby_ext_party_pmt_mthds mto,
581: (SELECT payment_method_code
582: FROM iby_ext_party_pmt_mthds
583: WHERE (ext_party_pmt_mthd_id = ci_mth_id)) mfrom
584: WHERE

Line 582: FROM iby_ext_party_pmt_mthds

578: IS
579: SELECT ext_party_pmt_mthd_id
580: FROM iby_ext_party_pmt_mthds mto,
581: (SELECT payment_method_code
582: FROM iby_ext_party_pmt_mthds
583: WHERE (ext_party_pmt_mthd_id = ci_mth_id)) mfrom
584: WHERE
585: mto.ext_pmt_party_id = ci_party_id
586: AND mto.payment_flow = ci_flow_type

Line 613: UPDATE iby_ext_party_pmt_mthds

609:
610: iby_debug_pub.add('duplicate pmt method:='|| l_dup_id,
611: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
612:
613: UPDATE iby_ext_party_pmt_mthds
614: SET ext_pmt_party_id = DECODE(l_dup_id, NULL,p_to_id, ext_pmt_party_id),
615: inactive_date = DECODE(l_dup_id, NULL,inactive_date, SYSDATE),
616: last_update_date = hz_utility_pub.last_update_date,
617: last_updated_by = hz_utility_pub.user_id,