eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_SCHED dependencies on IBY_TRANS_CORE_V

Line 169: TYPE txn_mid_TabTyp is TABLE OF iby_trans_core_v.trxnmid%TYPE

165:
166:
167: -- Overloaded procedure
168: procedure update_ecapp is
169: TYPE txn_mid_TabTyp is TABLE OF iby_trans_core_v.trxnmid%TYPE
170: INDEX BY BINARY_INTEGER;
171:
172: o_status VARCHAR2(80);
173: o_errcode VARCHAR2(80);

Line 464: TYPE txn_mid_TabTyp is TABLE OF iby_trans_core_v.trxnmid%TYPE

460: procedure update_ecapp (in_ecappid in iby_ecapp.ecappid%type)
461: is
462:
463:
464: TYPE txn_mid_TabTyp is TABLE OF iby_trans_core_v.trxnmid%TYPE
465: INDEX BY BINARY_INTEGER;
466:
467: o_status VARCHAR2(80);
468: o_errcode VARCHAR2(80);

Line 492: SELECT iby_trans_core_v.TRANSACTIONID,

488:
489: -- Updated the where clause so that the transactions initiated from
490: -- OM will also be picked up this cursor (bug# 8239041)
491: CURSOR c_trans_core (cin_ecappid in iby_ecapp.ecappid%type) IS
492: SELECT iby_trans_core_v.TRANSACTIONID,
493: iby_trans_core_v.STATUS,
494: iby_trans_core_v.UPDATEDATE,
495: iby_trans_core_v.REQTYPE,
496: iby_trans_core_v.REFERENCECODE,

Line 493: iby_trans_core_v.STATUS,

489: -- Updated the where clause so that the transactions initiated from
490: -- OM will also be picked up this cursor (bug# 8239041)
491: CURSOR c_trans_core (cin_ecappid in iby_ecapp.ecappid%type) IS
492: SELECT iby_trans_core_v.TRANSACTIONID,
493: iby_trans_core_v.STATUS,
494: iby_trans_core_v.UPDATEDATE,
495: iby_trans_core_v.REQTYPE,
496: iby_trans_core_v.REFERENCECODE,
497: iby_trans_core_v.TRXNMID

Line 494: iby_trans_core_v.UPDATEDATE,

490: -- OM will also be picked up this cursor (bug# 8239041)
491: CURSOR c_trans_core (cin_ecappid in iby_ecapp.ecappid%type) IS
492: SELECT iby_trans_core_v.TRANSACTIONID,
493: iby_trans_core_v.STATUS,
494: iby_trans_core_v.UPDATEDATE,
495: iby_trans_core_v.REQTYPE,
496: iby_trans_core_v.REFERENCECODE,
497: iby_trans_core_v.TRXNMID
498: FROM iby_trans_core_v

Line 495: iby_trans_core_v.REQTYPE,

491: CURSOR c_trans_core (cin_ecappid in iby_ecapp.ecappid%type) IS
492: SELECT iby_trans_core_v.TRANSACTIONID,
493: iby_trans_core_v.STATUS,
494: iby_trans_core_v.UPDATEDATE,
495: iby_trans_core_v.REQTYPE,
496: iby_trans_core_v.REFERENCECODE,
497: iby_trans_core_v.TRXNMID
498: FROM iby_trans_core_v
499: WHERE iby_trans_core_v.needsupdt IN ('Y','F')

Line 496: iby_trans_core_v.REFERENCECODE,

492: SELECT iby_trans_core_v.TRANSACTIONID,
493: iby_trans_core_v.STATUS,
494: iby_trans_core_v.UPDATEDATE,
495: iby_trans_core_v.REQTYPE,
496: iby_trans_core_v.REFERENCECODE,
497: iby_trans_core_v.TRXNMID
498: FROM iby_trans_core_v
499: WHERE iby_trans_core_v.needsupdt IN ('Y','F')
500: --AND iby_trans_core_v.ecappid = DECODE(cin_ecappid, '222', cin_ecappid, iby_trans_core_v.ecappid);

Line 497: iby_trans_core_v.TRXNMID

493: iby_trans_core_v.STATUS,
494: iby_trans_core_v.UPDATEDATE,
495: iby_trans_core_v.REQTYPE,
496: iby_trans_core_v.REFERENCECODE,
497: iby_trans_core_v.TRXNMID
498: FROM iby_trans_core_v
499: WHERE iby_trans_core_v.needsupdt IN ('Y','F')
500: --AND iby_trans_core_v.ecappid = DECODE(cin_ecappid, '222', cin_ecappid, iby_trans_core_v.ecappid);
501: AND iby_trans_core_v.ecappid = DECODE(cin_ecappid, '222', iby_trans_core_v.ecappid,cin_ecappid);

Line 498: FROM iby_trans_core_v

494: iby_trans_core_v.UPDATEDATE,
495: iby_trans_core_v.REQTYPE,
496: iby_trans_core_v.REFERENCECODE,
497: iby_trans_core_v.TRXNMID
498: FROM iby_trans_core_v
499: WHERE iby_trans_core_v.needsupdt IN ('Y','F')
500: --AND iby_trans_core_v.ecappid = DECODE(cin_ecappid, '222', cin_ecappid, iby_trans_core_v.ecappid);
501: AND iby_trans_core_v.ecappid = DECODE(cin_ecappid, '222', iby_trans_core_v.ecappid,cin_ecappid);
502:

Line 499: WHERE iby_trans_core_v.needsupdt IN ('Y','F')

495: iby_trans_core_v.REQTYPE,
496: iby_trans_core_v.REFERENCECODE,
497: iby_trans_core_v.TRXNMID
498: FROM iby_trans_core_v
499: WHERE iby_trans_core_v.needsupdt IN ('Y','F')
500: --AND iby_trans_core_v.ecappid = DECODE(cin_ecappid, '222', cin_ecappid, iby_trans_core_v.ecappid);
501: AND iby_trans_core_v.ecappid = DECODE(cin_ecappid, '222', iby_trans_core_v.ecappid,cin_ecappid);
502:
503:

Line 500: --AND iby_trans_core_v.ecappid = DECODE(cin_ecappid, '222', cin_ecappid, iby_trans_core_v.ecappid);

496: iby_trans_core_v.REFERENCECODE,
497: iby_trans_core_v.TRXNMID
498: FROM iby_trans_core_v
499: WHERE iby_trans_core_v.needsupdt IN ('Y','F')
500: --AND iby_trans_core_v.ecappid = DECODE(cin_ecappid, '222', cin_ecappid, iby_trans_core_v.ecappid);
501: AND iby_trans_core_v.ecappid = DECODE(cin_ecappid, '222', iby_trans_core_v.ecappid,cin_ecappid);
502:
503:
504: CURSOR c_trans_fi (cin_ecappid in iby_ecapp.ecappid%type) IS

Line 501: AND iby_trans_core_v.ecappid = DECODE(cin_ecappid, '222', iby_trans_core_v.ecappid,cin_ecappid);

497: iby_trans_core_v.TRXNMID
498: FROM iby_trans_core_v
499: WHERE iby_trans_core_v.needsupdt IN ('Y','F')
500: --AND iby_trans_core_v.ecappid = DECODE(cin_ecappid, '222', cin_ecappid, iby_trans_core_v.ecappid);
501: AND iby_trans_core_v.ecappid = DECODE(cin_ecappid, '222', iby_trans_core_v.ecappid,cin_ecappid);
502:
503:
504: CURSOR c_trans_fi (cin_ecappid in iby_ecapp.ecappid%type) IS
505: SELECT iby_trans_fi_v.TRANSACTIONID,