APPS.IBY_SCHED dependencies on IBY_TRXN_FI

Line 745: function updPmtStatus (in_psreqid in iby_trxn_fi.psreqid%type,

741:
742: end update_ecapp;
743:
744:
745: function updPmtStatus (in_psreqid in iby_trxn_fi.psreqid%type,
746: in_dtpmtprc in varchar2, -- YYYYMMDD
747: in_pmtprcst in varchar2, -- 'PAID','UNPAID','FAILED','PAYFAILED'
748: in_srvrid in iby_trxn_fi.srvid%type,
749: in_refinfo in iby_trxn_fi.referencecode%type)

Line 748: in_srvrid in iby_trxn_fi.srvid%type,

744:
745: function updPmtStatus (in_psreqid in iby_trxn_fi.psreqid%type,
746: in_dtpmtprc in varchar2, -- YYYYMMDD
747: in_pmtprcst in varchar2, -- 'PAID','UNPAID','FAILED','PAYFAILED'
748: in_srvrid in iby_trxn_fi.srvid%type,
749: in_refinfo in iby_trxn_fi.referencecode%type)
750: return number -- nonzero if rows were updated.
751: is
752: begin

Line 749: in_refinfo in iby_trxn_fi.referencecode%type)

745: function updPmtStatus (in_psreqid in iby_trxn_fi.psreqid%type,
746: in_dtpmtprc in varchar2, -- YYYYMMDD
747: in_pmtprcst in varchar2, -- 'PAID','UNPAID','FAILED','PAYFAILED'
748: in_srvrid in iby_trxn_fi.srvid%type,
749: in_refinfo in iby_trxn_fi.referencecode%type)
750: return number -- nonzero if rows were updated.
751: is
752: begin
753: update iby_trxn_summaries_all

Line 758: (select trxnmid from iby_trxn_fi where psreqid = in_psreqid);

754: set status = decode(in_pmtprcst, 'PAID', 0, 'UNPAID', 17, 'FAILED',
755: 16, 'PAYFAILED', 16, 16),
756: updatedate = to_date(in_dtpmtprc,'YYYYMMDD'), needsupdt = 'Y'
757: where trxnmid in
758: (select trxnmid from iby_trxn_fi where psreqid = in_psreqid);
759: if SQL%NOTFOUND
760: then return 0;
761: end if;
762: update iby_trxn_fi set srvid = in_srvrid, referencecode = in_refinfo

Line 762: update iby_trxn_fi set srvid = in_srvrid, referencecode = in_refinfo

758: (select trxnmid from iby_trxn_fi where psreqid = in_psreqid);
759: if SQL%NOTFOUND
760: then return 0;
761: end if;
762: update iby_trxn_fi set srvid = in_srvrid, referencecode = in_refinfo
763: where psreqid = in_psreqid;
764: if SQL%NOTFOUND
765: then return 0;
766: end if;

Line 825: UPDATE iby_trxn_fi

821:
822: IF ( SQL%NOTFOUND ) THEN
823: o_status_arr( l_index ) := c_FAIL;
824: ELSE
825: UPDATE iby_trxn_fi
826: SET referencecode = i_refCode_arr( l_index ),
827: srvId = i_srvrId_arr( l_index ),
828: AUXMSG = i_auxMsg_arr( l_index ),
829: PROCESSFEE = i_fee_arr( l_index )