APPS.IBY_FIPAYMENTS_PKG dependencies on IBY_BEPINFO

Line 88: l_beptype iby_bepinfo.bep_type%type;

84: l_mpayeeid iby_payee.mpayeeid%type;
85: l_reference_code iby_trxn_summaries_all.proc_reference_code%type;
86: l_reference_amount iby_trxn_summaries_all.amount%type;
87: l_status iby_trxn_summaries_all.status%type;
88: l_beptype iby_bepinfo.bep_type%type;
89: l_trxntypeid iby_trxn_summaries_all.trxntypeid%TYPE;
90: l_reqtype iby_trxn_summaries_all.reqtype%TYPE;
91:
92: l_settle_cust_ref iby_trxn_summaries_all.

Line 173: SELECT NVL(bep_type,iby_bepinfo_pkg.C_BEPTYPE_GATEWAY)

169: * Get the bep type based on the bep id.
170: * This is used to determine what value to
171: * insert for transaction status.
172: */
173: SELECT NVL(bep_type,iby_bepinfo_pkg.C_BEPTYPE_GATEWAY)
174: INTO l_beptype
175: FROM IBY_BEPINFO
176: WHERE (bepid=i_bepid);
177:

Line 175: FROM IBY_BEPINFO

171: * insert for transaction status.
172: */
173: SELECT NVL(bep_type,iby_bepinfo_pkg.C_BEPTYPE_GATEWAY)
174: INTO l_beptype
175: FROM IBY_BEPINFO
176: WHERE (bepid=i_bepid);
177:
178: IF (l_beptype = iby_bepinfo_pkg.C_BEPTYPE_GATEWAY) THEN
179: /*

Line 178: IF (l_beptype = iby_bepinfo_pkg.C_BEPTYPE_GATEWAY) THEN

174: INTO l_beptype
175: FROM IBY_BEPINFO
176: WHERE (bepid=i_bepid);
177:
178: IF (l_beptype = iby_bepinfo_pkg.C_BEPTYPE_GATEWAY) THEN
179: /*
180: * For gateways, pending = status 11
181: */
182: l_status := 11;