APPS.IBY_FNDCPT_SETUP_PUB dependencies on IBY_EXT_PARTY_PMT_MTHDS

Line 703: (ci_payer_id IN iby_ext_party_pmt_mthds.ext_pmt_party_id%TYPE)

699: l_result IBY_FNDCPT_COMMON_PUB.Result_rec_type;
700: l_prev_msg_count NUMBER;
701:
702: CURSOR c_chnnl_assign
703: (ci_payer_id IN iby_ext_party_pmt_mthds.ext_pmt_party_id%TYPE)
704: IS
705: SELECT ext_party_pmt_mthd_id
706: FROM iby_ext_party_pmt_mthds
707: WHERE (ext_pmt_party_id = ci_payer_id)

Line 706: FROM iby_ext_party_pmt_mthds

702: CURSOR c_chnnl_assign
703: (ci_payer_id IN iby_ext_party_pmt_mthds.ext_pmt_party_id%TYPE)
704: IS
705: SELECT ext_party_pmt_mthd_id
706: FROM iby_ext_party_pmt_mthds
707: WHERE (ext_pmt_party_id = ci_payer_id)
708: AND (payment_flow = G_PMT_FLOW_FNDCPT)
709: AND (primary_flag = 'Y')
710: AND (NVL(inactive_date,SYSDATE-10)

Line 772: SELECT iby_ext_party_pmt_mthds_s.NEXTVAL

768: FETCH c_chnnl_assign INTO x_assignment_id;
769: CLOSE c_chnnl_assign;
770: IF (x_assignment_id IS NULL) THEN
771:
772: SELECT iby_ext_party_pmt_mthds_s.NEXTVAL
773: INTO x_assignment_id
774: FROM DUAL;
775:
776: INSERT INTO iby_ext_party_pmt_mthds

Line 776: INSERT INTO iby_ext_party_pmt_mthds

772: SELECT iby_ext_party_pmt_mthds_s.NEXTVAL
773: INTO x_assignment_id
774: FROM DUAL;
775:
776: INSERT INTO iby_ext_party_pmt_mthds
777: (ext_party_pmt_mthd_id, payment_method_code, payment_flow,
778: ext_pmt_party_id, payment_function, primary_flag, inactive_date,
779: created_by, creation_date, last_updated_by, last_update_date,
780: last_update_login, object_version_number)

Line 789: UPDATE iby_ext_party_pmt_mthds

785: fnd_global.user_id, SYSDATE, fnd_global.login_id, 1);
786:
787: ELSE
788:
789: UPDATE iby_ext_party_pmt_mthds
790: SET inactive_date = p_channel_assignment.Inactive_Date,
791: payment_method_code =
792: NVL(p_channel_assignment.Pmt_Channel_code,payment_method_code),
793: last_updated_by = fnd_global.user_id,

Line 871: (ci_payer_id IN iby_ext_party_pmt_mthds.ext_pmt_party_id%TYPE)

867: l_payer_attribs PayerAttributes_rec_type;
868: l_prev_msg_count NUMBER;
869:
870: CURSOR c_chnnl_assign
871: (ci_payer_id IN iby_ext_party_pmt_mthds.ext_pmt_party_id%TYPE)
872: IS
873: SELECT payment_method_code, primary_flag, inactive_date
874: FROM iby_ext_party_pmt_mthds
875: WHERE (ext_pmt_party_id = ci_payer_id)

Line 874: FROM iby_ext_party_pmt_mthds

870: CURSOR c_chnnl_assign
871: (ci_payer_id IN iby_ext_party_pmt_mthds.ext_pmt_party_id%TYPE)
872: IS
873: SELECT payment_method_code, primary_flag, inactive_date
874: FROM iby_ext_party_pmt_mthds
875: WHERE (ext_pmt_party_id = ci_payer_id)
876: AND (payment_flow = G_PMT_FLOW_FNDCPT)
877: AND (primary_flag = 'Y')
878: AND (NVL(inactive_date,SYSDATE-10)

Line 997: FROM iby_ext_party_pmt_mthds pm, iby_fndcpt_pmt_chnnls_b c

993: ci_payer_level IN VARCHAR2,
994: ci_payer_equiv IN VARCHAR2)
995: IS
996: SELECT c.payment_channel_code, c.instrument_type
997: FROM iby_ext_party_pmt_mthds pm, iby_fndcpt_pmt_chnnls_b c
998: WHERE (pm.payment_method_code = c.payment_channel_code)
999: AND (NVL(pm.inactive_date,SYSDATE-10) 1000: AND (NVL(c.inactive_date,SYSDATE-10) 1001: AND (pm.payment_flow = G_PMT_FLOW_FNDCPT)