APPS.IBY_DISBURSEMENT_SETUP_PUB dependencies on IBY_PMT_INSTR_USES_ALL

Line 666: (ci_assign_id IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE,

662: l_ext_payee_rec External_Payee_Rec_Type;
663: l_payee_crt_status VARCHAR2(30);
664:
665: CURSOR c_instr_assignment
666: (ci_assign_id IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE,
667: ci_payee_id IN iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE,
668: ci_instr_type IN iby_pmt_instr_uses_all.instrument_type%TYPE,
669: ci_instr_id IN iby_pmt_instr_uses_all.instrument_id%TYPE
670: )

Line 667: ci_payee_id IN iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE,

663: l_payee_crt_status VARCHAR2(30);
664:
665: CURSOR c_instr_assignment
666: (ci_assign_id IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE,
667: ci_payee_id IN iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE,
668: ci_instr_type IN iby_pmt_instr_uses_all.instrument_type%TYPE,
669: ci_instr_id IN iby_pmt_instr_uses_all.instrument_id%TYPE
670: )
671: IS

Line 668: ci_instr_type IN iby_pmt_instr_uses_all.instrument_type%TYPE,

664:
665: CURSOR c_instr_assignment
666: (ci_assign_id IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE,
667: ci_payee_id IN iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE,
668: ci_instr_type IN iby_pmt_instr_uses_all.instrument_type%TYPE,
669: ci_instr_id IN iby_pmt_instr_uses_all.instrument_id%TYPE
670: )
671: IS
672: SELECT instrument_payment_use_id

Line 669: ci_instr_id IN iby_pmt_instr_uses_all.instrument_id%TYPE

665: CURSOR c_instr_assignment
666: (ci_assign_id IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE,
667: ci_payee_id IN iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE,
668: ci_instr_type IN iby_pmt_instr_uses_all.instrument_type%TYPE,
669: ci_instr_id IN iby_pmt_instr_uses_all.instrument_id%TYPE
670: )
671: IS
672: SELECT instrument_payment_use_id
673: FROM iby_pmt_instr_uses_all

Line 673: FROM iby_pmt_instr_uses_all

669: ci_instr_id IN iby_pmt_instr_uses_all.instrument_id%TYPE
670: )
671: IS
672: SELECT instrument_payment_use_id
673: FROM iby_pmt_instr_uses_all
674: WHERE (payment_flow = G_PMT_FLOW_DISBURSE)
675: AND ( (instrument_payment_use_id = NVL(ci_assign_id,-1))
676: OR (ext_pmt_party_id = ci_payee_id
677: AND instrument_type = ci_instr_type

Line 775: UPDATE iby_pmt_instr_uses_all

771: IF (x_assign_id IS NULL)
772: THEN
773: --Per bug 6851476
774: --Eleminating the expensive CONNECT BY clause
775: UPDATE iby_pmt_instr_uses_all
776: SET order_of_preference = order_of_preference + 1,
777: last_updated_by = fnd_global.user_id,
778: last_update_date = trunc(SYSDATE),
779: last_update_login = fnd_global.login_id,

Line 787: SELECT iby_pmt_instr_uses_all_s.nextval

783: AND order_of_preference >= l_priority;
784: END IF;
785:
786: IF (x_assign_id IS NULL) THEN
787: SELECT iby_pmt_instr_uses_all_s.nextval
788: INTO x_assign_id
789: FROM DUAL;
790:
791: INSERT INTO iby_pmt_instr_uses_all

Line 791: INSERT INTO iby_pmt_instr_uses_all

787: SELECT iby_pmt_instr_uses_all_s.nextval
788: INTO x_assign_id
789: FROM DUAL;
790:
791: INSERT INTO iby_pmt_instr_uses_all
792: (instrument_payment_use_id,
793: ext_pmt_party_id,
794: instrument_type,
795: instrument_id,

Line 830: UPDATE iby_pmt_instr_uses_all

826: trunc(SYSDATE),
827: fnd_global.login_id,
828: 1);
829: ELSE
830: UPDATE iby_pmt_instr_uses_all
831: SET
832: order_of_preference =
833: NVL(p_assignment_attribs.Priority,order_of_preference),
834: start_date = NVL(p_assignment_attribs.Start_Date,start_date),

Line 942: (ci_payee_id IN iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE)

938:
939: l_assign_count NUMBER := 0;
940:
941: CURSOR c_instr_assignments
942: (ci_payee_id IN iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE)
943: IS
944: SELECT instrument_payment_use_id,
945: instrument_type,
946: instrument_id,

Line 950: FROM iby_pmt_instr_uses_all

946: instrument_id,
947: order_of_preference,
948: start_date,
949: end_date
950: FROM iby_pmt_instr_uses_all
951: WHERE (payment_flow = G_PMT_FLOW_DISBURSE)
952: AND (ext_pmt_party_id = ci_payee_id);
953:
954: BEGIN

Line 1082: FROM iby_pmt_instr_uses_all u, iby_external_payees_all p

1078: CURSOR c_instr_assignments
1079: (ci_party_id IN iby_external_payees_all.payee_party_id%TYPE)
1080: IS
1081: SELECT DISTINCT u.instrument_type, u.instrument_id
1082: FROM iby_pmt_instr_uses_all u, iby_external_payees_all p
1083: WHERE (u.payment_flow = G_PMT_FLOW_DISBURSE)
1084: AND (u.ext_pmt_party_id = p.ext_payee_id)
1085: AND (p.payee_party_id = ci_party_id);
1086: