APPS.IBY_FNDCPT_SETUP_PUB dependencies on IBY_EXT_PARTY_PMT_MTHDS

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

609: l_result IBY_FNDCPT_COMMON_PUB.Result_rec_type;
610: l_prev_msg_count NUMBER;
611:
612: CURSOR c_chnnl_assign
613: (ci_payer_id IN iby_ext_party_pmt_mthds.ext_pmt_party_id%TYPE)
614: IS
615: SELECT ext_party_pmt_mthd_id
616: FROM iby_ext_party_pmt_mthds
617: WHERE (ext_pmt_party_id = ci_payer_id)

Line 616: FROM iby_ext_party_pmt_mthds

612: CURSOR c_chnnl_assign
613: (ci_payer_id IN iby_ext_party_pmt_mthds.ext_pmt_party_id%TYPE)
614: IS
615: SELECT ext_party_pmt_mthd_id
616: FROM iby_ext_party_pmt_mthds
617: WHERE (ext_pmt_party_id = ci_payer_id)
618: AND (payment_flow = G_PMT_FLOW_FNDCPT)
619: AND (primary_flag = 'Y')
620: AND (NVL(inactive_date,SYSDATE-10)

Line 682: SELECT iby_ext_party_pmt_mthds_s.NEXTVAL

678: FETCH c_chnnl_assign INTO x_assignment_id;
679: CLOSE c_chnnl_assign;
680: IF (x_assignment_id IS NULL) THEN
681:
682: SELECT iby_ext_party_pmt_mthds_s.NEXTVAL
683: INTO x_assignment_id
684: FROM DUAL;
685:
686: INSERT INTO iby_ext_party_pmt_mthds

Line 686: INSERT INTO iby_ext_party_pmt_mthds

682: SELECT iby_ext_party_pmt_mthds_s.NEXTVAL
683: INTO x_assignment_id
684: FROM DUAL;
685:
686: INSERT INTO iby_ext_party_pmt_mthds
687: (ext_party_pmt_mthd_id, payment_method_code, payment_flow,
688: ext_pmt_party_id, payment_function, primary_flag, inactive_date,
689: created_by, creation_date, last_updated_by, last_update_date,
690: last_update_login, object_version_number)

Line 699: UPDATE iby_ext_party_pmt_mthds

695: fnd_global.user_id, SYSDATE, fnd_global.login_id, 1);
696:
697: ELSE
698:
699: UPDATE iby_ext_party_pmt_mthds
700: SET inactive_date = p_channel_assignment.Inactive_Date,
701: payment_method_code =
702: NVL(p_channel_assignment.Pmt_Channel_code,payment_method_code),
703: last_updated_by = fnd_global.user_id,

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

777: l_payer_attribs PayerAttributes_rec_type;
778: l_prev_msg_count NUMBER;
779:
780: CURSOR c_chnnl_assign
781: (ci_payer_id IN iby_ext_party_pmt_mthds.ext_pmt_party_id%TYPE)
782: IS
783: SELECT payment_method_code, primary_flag, inactive_date
784: FROM iby_ext_party_pmt_mthds
785: WHERE (ext_pmt_party_id = ci_payer_id)

Line 784: FROM iby_ext_party_pmt_mthds

780: CURSOR c_chnnl_assign
781: (ci_payer_id IN iby_ext_party_pmt_mthds.ext_pmt_party_id%TYPE)
782: IS
783: SELECT payment_method_code, primary_flag, inactive_date
784: FROM iby_ext_party_pmt_mthds
785: WHERE (ext_pmt_party_id = ci_payer_id)
786: AND (payment_flow = G_PMT_FLOW_FNDCPT)
787: AND (primary_flag = 'Y')
788: AND (NVL(inactive_date,SYSDATE-10)

Line 907: FROM iby_ext_party_pmt_mthds pm, iby_fndcpt_pmt_chnnls_b c

903: ci_payer_level IN VARCHAR2,
904: ci_payer_equiv IN VARCHAR2)
905: IS
906: SELECT c.payment_channel_code, c.instrument_type
907: FROM iby_ext_party_pmt_mthds pm, iby_fndcpt_pmt_chnnls_b c
908: WHERE (pm.payment_method_code = c.payment_channel_code)
909: AND (NVL(pm.inactive_date,SYSDATE-10) 910: AND (NVL(c.inactive_date,SYSDATE-10) 911: AND (pm.payment_flow = G_PMT_FLOW_FNDCPT)