37: procedure update_ecapp (in_ecappid in iby_ecapp.ecappid%type);
38:
39: procedure update_ecapp;
40:
41: function updPmtStatus (in_psreqid in iby_trxn_fi.psreqid%type,
42: in_dtpmtprc in varchar2, -- YYYMMDD
43: in_pmtprcst in varchar2, -- 'PAID','UNPAID','FAILED','PAYFAILED'
44: in_srvrid in iby_trxn_fi.srvid%type,
45: in_refinfo in iby_trxn_fi.referencecode%type)
40:
41: function updPmtStatus (in_psreqid in iby_trxn_fi.psreqid%type,
42: in_dtpmtprc in varchar2, -- YYYMMDD
43: in_pmtprcst in varchar2, -- 'PAID','UNPAID','FAILED','PAYFAILED'
44: in_srvrid in iby_trxn_fi.srvid%type,
45: in_refinfo in iby_trxn_fi.referencecode%type)
46: return number; -- nonzero if rows were updated.
47:
48: procedure update_trxn_status( i_unchanged_status IN NUMBER,
41: function updPmtStatus (in_psreqid in iby_trxn_fi.psreqid%type,
42: in_dtpmtprc in varchar2, -- YYYMMDD
43: in_pmtprcst in varchar2, -- 'PAID','UNPAID','FAILED','PAYFAILED'
44: in_srvrid in iby_trxn_fi.srvid%type,
45: in_refinfo in iby_trxn_fi.referencecode%type)
46: return number; -- nonzero if rows were updated.
47:
48: procedure update_trxn_status( i_unchanged_status IN NUMBER,
49: i_numTrxns IN NUMBER,