APPS.IBY_PARTY_MERGE dependencies on IBY_EXT_PARTY_PMT_MTHDS

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

532: x_return_status IN OUT NOCOPY VARCHAR2
533: )
534: IS
535: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.party_pmt_methods_merge';
536: l_dup_id iby_ext_party_pmt_mthds.ext_party_pmt_mthd_id%TYPE := NULL;
537: l_flow_type iby_ext_party_pmt_mthds.payment_flow%TYPE;
538: g_mesg VARCHAR2(1000) := '';
539:
540: CURSOR c_dupemth

Line 537: l_flow_type iby_ext_party_pmt_mthds.payment_flow%TYPE;

533: )
534: IS
535: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.party_pmt_methods_merge';
536: l_dup_id iby_ext_party_pmt_mthds.ext_party_pmt_mthd_id%TYPE := NULL;
537: l_flow_type iby_ext_party_pmt_mthds.payment_flow%TYPE;
538: g_mesg VARCHAR2(1000) := '';
539:
540: CURSOR c_dupemth
541: (ci_mth_id IN iby_ext_party_pmt_mthds.ext_party_pmt_mthd_id%TYPE,

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

537: l_flow_type iby_ext_party_pmt_mthds.payment_flow%TYPE;
538: g_mesg VARCHAR2(1000) := '';
539:
540: CURSOR c_dupemth
541: (ci_mth_id IN iby_ext_party_pmt_mthds.ext_party_pmt_mthd_id%TYPE,
542: ci_party_id IN iby_ext_party_pmt_mthds.ext_pmt_party_id%TYPE,
543: ci_flow_type IN iby_ext_party_pmt_mthds.payment_flow%TYPE)
544: IS
545: SELECT ext_party_pmt_mthd_id

Line 542: ci_party_id IN iby_ext_party_pmt_mthds.ext_pmt_party_id%TYPE,

538: g_mesg VARCHAR2(1000) := '';
539:
540: CURSOR c_dupemth
541: (ci_mth_id IN iby_ext_party_pmt_mthds.ext_party_pmt_mthd_id%TYPE,
542: ci_party_id IN iby_ext_party_pmt_mthds.ext_pmt_party_id%TYPE,
543: ci_flow_type IN iby_ext_party_pmt_mthds.payment_flow%TYPE)
544: IS
545: SELECT ext_party_pmt_mthd_id
546: FROM iby_ext_party_pmt_mthds mto,

Line 543: ci_flow_type IN iby_ext_party_pmt_mthds.payment_flow%TYPE)

539:
540: CURSOR c_dupemth
541: (ci_mth_id IN iby_ext_party_pmt_mthds.ext_party_pmt_mthd_id%TYPE,
542: ci_party_id IN iby_ext_party_pmt_mthds.ext_pmt_party_id%TYPE,
543: ci_flow_type IN iby_ext_party_pmt_mthds.payment_flow%TYPE)
544: IS
545: SELECT ext_party_pmt_mthd_id
546: FROM iby_ext_party_pmt_mthds mto,
547: (SELECT payment_method_code

Line 546: FROM iby_ext_party_pmt_mthds mto,

542: ci_party_id IN iby_ext_party_pmt_mthds.ext_pmt_party_id%TYPE,
543: ci_flow_type IN iby_ext_party_pmt_mthds.payment_flow%TYPE)
544: IS
545: SELECT ext_party_pmt_mthd_id
546: FROM iby_ext_party_pmt_mthds mto,
547: (SELECT payment_method_code
548: FROM iby_ext_party_pmt_mthds
549: WHERE (ext_party_pmt_mthd_id = ci_mth_id)) mfrom
550: WHERE

Line 548: FROM iby_ext_party_pmt_mthds

544: IS
545: SELECT ext_party_pmt_mthd_id
546: FROM iby_ext_party_pmt_mthds mto,
547: (SELECT payment_method_code
548: FROM iby_ext_party_pmt_mthds
549: WHERE (ext_party_pmt_mthd_id = ci_mth_id)) mfrom
550: WHERE
551: mto.ext_pmt_party_id = ci_party_id
552: AND mto.payment_flow = ci_flow_type

Line 593: UPDATE iby_ext_party_pmt_mthds

589:
590: g_mesg := 'duplicate pmt method:='|| l_dup_id;
591: fnd_file.put_line(fnd_file.log, g_mesg || l_dbg_mod );
592:
593: UPDATE iby_ext_party_pmt_mthds
594: SET ext_pmt_party_id = DECODE(l_dup_id, NULL,p_to_fk_id, ext_pmt_party_id),
595: inactive_date = DECODE(l_dup_id, NULL,inactive_date, SYSDATE),
596: last_update_date = hz_utility_pub.last_update_date,
597: last_updated_by = hz_utility_pub.user_id,