APPS.IBY_SCHED dependencies on IBY_TRXN_FI

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

394:
395: end update_ecapp;
396:
397:
398: function updPmtStatus (in_psreqid in iby_trxn_fi.psreqid%type,
399: in_dtpmtprc in varchar2, -- YYYYMMDD
400: in_pmtprcst in varchar2, -- 'PAID','UNPAID','FAILED','PAYFAILED'
401: in_srvrid in iby_trxn_fi.srvid%type,
402: in_refinfo in iby_trxn_fi.referencecode%type)

Line 401: in_srvrid in iby_trxn_fi.srvid%type,

397:
398: function updPmtStatus (in_psreqid in iby_trxn_fi.psreqid%type,
399: in_dtpmtprc in varchar2, -- YYYYMMDD
400: in_pmtprcst in varchar2, -- 'PAID','UNPAID','FAILED','PAYFAILED'
401: in_srvrid in iby_trxn_fi.srvid%type,
402: in_refinfo in iby_trxn_fi.referencecode%type)
403: return number -- nonzero if rows were updated.
404: is
405: begin

Line 402: in_refinfo in iby_trxn_fi.referencecode%type)

398: function updPmtStatus (in_psreqid in iby_trxn_fi.psreqid%type,
399: in_dtpmtprc in varchar2, -- YYYYMMDD
400: in_pmtprcst in varchar2, -- 'PAID','UNPAID','FAILED','PAYFAILED'
401: in_srvrid in iby_trxn_fi.srvid%type,
402: in_refinfo in iby_trxn_fi.referencecode%type)
403: return number -- nonzero if rows were updated.
404: is
405: begin
406: update iby_trxn_summaries_all

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

407: set status = decode(in_pmtprcst, 'PAID', 0, 'UNPAID', 17, 'FAILED',
408: 16, 'PAYFAILED', 16, 16),
409: updatedate = to_date(in_dtpmtprc,'YYYYMMDD'), needsupdt = 'Y'
410: where trxnmid in
411: (select trxnmid from iby_trxn_fi where psreqid = in_psreqid);
412: if SQL%NOTFOUND
413: then return 0;
414: end if;
415: update iby_trxn_fi set srvid = in_srvrid, referencecode = in_refinfo

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

411: (select trxnmid from iby_trxn_fi where psreqid = in_psreqid);
412: if SQL%NOTFOUND
413: then return 0;
414: end if;
415: update iby_trxn_fi set srvid = in_srvrid, referencecode = in_refinfo
416: where psreqid = in_psreqid;
417: if SQL%NOTFOUND
418: then return 0;
419: end if;

Line 478: UPDATE iby_trxn_fi

474:
475: IF ( SQL%NOTFOUND ) THEN
476: o_status_arr( l_index ) := c_FAIL;
477: ELSE
478: UPDATE iby_trxn_fi
479: SET referencecode = i_refCode_arr( l_index ),
480: srvId = i_srvrId_arr( l_index ),
481: AUXMSG = i_auxMsg_arr( l_index ),
482: PROCESSFEE = i_fee_arr( l_index )