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_TRXN_SUMMARIES_ALL

Line 32: iby_trxn_summaries_all d

28: select ccnumber,
29: expirydate,
30: accttype
31: from iby_creditcard_v c,
32: iby_trxn_summaries_all d
33: where d.payerinstrid = cin_payerinstrid
34: and d.payerinstrid = c.instrid;
35:
36: cursor c_payeeBankInfo (cin_payeeid in iby_trans_fi_v.payeeid%type) is

Line 42: iby_trxn_summaries_all d

38: b.branch_party_id,
39: b.ext_bank_account_id,
40: b.bank_account_type
41: from iby_ext_bank_accounts_v b,
42: iby_trxn_summaries_all d
43: where d.payeeid = cin_payeeid
44: and d.payeeinstrid = b.ext_bank_account_id;
45:
46: cursor c_tangibleInfo (cin_tangibleid in iby_trans_fi_v.tangibleid%type) is

Line 110: iby_trxn_summaries_all d

106: b.branch_party_id,
107: b.ext_bank_account_id,
108: b.bank_account_type
109: from iby_ext_bank_accounts_v b,
110: iby_trxn_summaries_all d
111: where d.payerinstrid = cin_payerinstrid
112: and d.payerinstrid = b.ext_bank_account_id;
113:
114:

Line 121: iby_trxn_summaries_all d

117: b.branch_party_id,
118: b.ext_bank_account_id,
119: b.bank_account_type
120: from iby_ext_bank_accounts_v b,
121: iby_trxn_summaries_all d
122: where d.payeeid = cin_payeeid
123: and d.payeeinstrid = b.ext_bank_account_id;
124:
125: cursor c_tangibleInfo (cin_tangibleid in iby_trans_fi_v.tangibleid%type) is

Line 220: FROM iby_trxn_summaries_all b,

216: b.updatedate,
217: b.reqtype,
218: c.referencecode,
219: b.trxnmid
220: FROM iby_trxn_summaries_all b,
221: iby_trxn_core c
222: WHERE(b.trxnmid = c.trxnmid)
223: AND b.reqtype <> 'ORAPMTREQ'
224: AND b.status not in (1, 0, 11, 100, 111)

Line 262: FROM iby_trxn_summaries_all trxn,

258: trxn.STATUS,
259: trxn.UPDATEDATE,
260: trxn.REQTYPE,
261: trxn.TRXNMID
262: FROM iby_trxn_summaries_all trxn,
263: iby_pmtschemes scheme,
264: iby_bepkeys bep
265: WHERE trxn.needsupdt IN ('Y','F')
266: AND trxn.bepid = scheme.bepid

Line 436: UPDATE iby_trxn_summaries_all

432:
433: -- Doing the bulk update instead of Row-by-Row
434: IF l_updapp_success THEN
435: FORALL j IN 1..l_recordCounter
436: UPDATE iby_trxn_summaries_all
437: SET NeedsUpdt = DECODE(upper(o_statusindiv_Tab(j)), 'TRUE', 'N', 'F')
438: WHERE trxnmid = txn_mid_Tab(j);
439: iby_debug_pub.add('Updation of iby_trxn_summaries_all successful' ,
440: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

Line 439: iby_debug_pub.add('Updation of iby_trxn_summaries_all successful' ,

435: FORALL j IN 1..l_recordCounter
436: UPDATE iby_trxn_summaries_all
437: SET NeedsUpdt = DECODE(upper(o_statusindiv_Tab(j)), 'TRUE', 'N', 'F')
438: WHERE trxnmid = txn_mid_Tab(j);
439: iby_debug_pub.add('Updation of iby_trxn_summaries_all successful' ,
440: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
441: END IF;
442: END IF;
443: END LOOP;

Line 451: UPDATE iby_trxn_summaries_all

447:
448: EXCEPTION
449: WHEN OTHERS THEN
450: FOR k IN 1..i LOOP
451: UPDATE iby_trxn_summaries_all
452: SET NeedsUpdt = 'F'
453: WHERE trxnmid = txn_mid_Tab(k);
454: END LOOP;
455: commit;

Line 556: -- 1. count(*) from iby_trxn_summaries_all retrieves 838

552: -- across to the calling API. Changed the logic so that the extension of table
553: -- happens as and when it is required. By doing that we can minimize the usage
554: -- of select query for retrieving the totalrows.
555: -- For e.g, consider a typical example:
556: -- 1. count(*) from iby_trxn_summaries_all retrieves 838
557: -- 2. JTF tables get initialized with this number
558: -- 3. The "i" value in the For loops is "145" in this scenario
559: -- 4. The remaining elements in the JTF table is null
560: -- 5. To avoid this the tables are getting extended in the loop itself.

Line 565: --FROM iby_trxn_summaries_all

561:
562: -- finding the total number of rows
563: --SELECT count(*)
564: --INTO totalRows
565: --FROM iby_trxn_summaries_all
566: --WHERE needsupdt IN ('Y','F')
567: --AND ecappid = in_ecappid;
568:
569: --IF( totalRows < 1 ) THEN

Line 701: UPDATE iby_trxn_summaries_all

697:
698: -- Doing the bulk update instead of Row-by-Row
699: FORALL j IN 1..i
700: --if (o_statusindiv_Tab(j) = 'TRUE') then
701: UPDATE iby_trxn_summaries_all
702: SET NeedsUpdt = DECODE(upper(o_statusindiv_Tab(j)), 'TRUE', 'N', 'F')
703: WHERE trxnmid = txn_mid_Tab(j);
704: --else
705: -- UPDATE iby_trxn_summaries_all

Line 705: -- UPDATE iby_trxn_summaries_all

701: UPDATE iby_trxn_summaries_all
702: SET NeedsUpdt = DECODE(upper(o_statusindiv_Tab(j)), 'TRUE', 'N', 'F')
703: WHERE trxnmid = txn_mid_Tab(j);
704: --else
705: -- UPDATE iby_trxn_summaries_all
706: -- SET NeedsUpdt = 'F'
707: -- WHERE trxnmid = txn_mid_Tab(j);
708: --end if;
709: --END LOOP;

Line 710: iby_debug_pub.add('Updation of iby_trxn_summaries_all successful' ,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

706: -- SET NeedsUpdt = 'F'
707: -- WHERE trxnmid = txn_mid_Tab(j);
708: --end if;
709: --END LOOP;
710: iby_debug_pub.add('Updation of iby_trxn_summaries_all successful' ,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
711:
712: END IF;
713:
714: EXCEPTION

Line 735: UPDATE iby_trxn_summaries_all

731:
732: EXCEPTION
733: WHEN OTHERS THEN
734: FOR k IN 1..i LOOP
735: UPDATE iby_trxn_summaries_all
736: SET NeedsUpdt = 'F'
737: WHERE trxnmid = txn_mid_Tab(k);
738: END LOOP;
739: commit;

Line 753: update iby_trxn_summaries_all

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
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

Line 813: UPDATE iby_trxn_summaries_all

809: o_status_arr( l_index ) := c_SUCCESS;
810:
811: BEGIN -- Nested block begins
812:
813: UPDATE iby_trxn_summaries_all
814: SET status = decode( l_status, i_unchanged_status, status, l_status),
815: errorlocation = i_errLoc_arr( l_index ),
816: BEPCode = i_errCode_arr( l_index ),
817: BEPMessage = i_errMsg_arr( l_index ),

Line 832: --FROM IBY_TRXN_SUMMARIES_ALL

828: AUXMSG = i_auxMsg_arr( l_index ),
829: PROCESSFEE = i_fee_arr( l_index )
830: WHERE TRXNMID = i_trxnMId_arr( l_index );
831: --(SELECT TRXNMID
832: --FROM IBY_TRXN_SUMMARIES_ALL
833: --WHERE TANGIBLEID = i_tangibleId_arr( l_index )
834: --);
835:
836: IF ( SQL%NOTFOUND ) THEN