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_QUERYCC_PKG dependencies on IBY_TRXN_SUMMARIES_ALL

Line 55: CURSOR s1(i_reqtype1 iby_trxn_summaries_all.reqtype%type,

51: IS
52:
53: loc_status iby_transactions_v.status%TYPE;
54:
55: CURSOR s1(i_reqtype1 iby_trxn_summaries_all.reqtype%type,
56: i_reqtype2 iby_trxn_summaries_all.reqtype%type DEFAULT
57: NULL)
58: IS
59: SELECT status, bepid, bepkey, transactionid, trxnref

Line 56: i_reqtype2 iby_trxn_summaries_all.reqtype%type DEFAULT

52:
53: loc_status iby_transactions_v.status%TYPE;
54:
55: CURSOR s1(i_reqtype1 iby_trxn_summaries_all.reqtype%type,
56: i_reqtype2 iby_trxn_summaries_all.reqtype%type DEFAULT
57: NULL)
58: IS
59: SELECT status, bepid, bepkey, transactionid, trxnref
60: FROM iby_trxn_summaries_all

Line 60: FROM iby_trxn_summaries_all

56: i_reqtype2 iby_trxn_summaries_all.reqtype%type DEFAULT
57: NULL)
58: IS
59: SELECT status, bepid, bepkey, transactionid, trxnref
60: FROM iby_trxn_summaries_all
61: WHERE tangibleid = order_id_in
62: AND payeeid = merchant_id_in
63: AND reqtype IN (i_reqtype1, i_reqtype2)
64: AND reqtype IS NOT NULL -- to ignore the 2nd arg

Line 224: loc_order_id iby_trxn_summaries_all.Tangibleid%TYPE;

220: order_id_out OUT NOCOPY VARCHAR2)
221:
222: AS
223:
224: loc_order_id iby_trxn_summaries_all.Tangibleid%TYPE;
225:
226: CURSOR o1 IS
227: SELECT order_Id
228: FROM iby_transactions_v trn, iby_bepinfo ven

Line 261: trxnid_in IN iby_trxn_summaries_all.transactionid%TYPE,

257: END getorderid;
258:
259: PROCEDURE getTrxnInfo
260: (
261: trxnid_in IN iby_trxn_summaries_all.transactionid%TYPE,
262: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
263: trxntypeid_aux_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
264: status_in IN iby_trxn_summaries_all.status%TYPE,
265: status_aux_in IN iby_trxn_summaries_all.status%TYPE,

Line 262: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,

258:
259: PROCEDURE getTrxnInfo
260: (
261: trxnid_in IN iby_trxn_summaries_all.transactionid%TYPE,
262: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
263: trxntypeid_aux_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
264: status_in IN iby_trxn_summaries_all.status%TYPE,
265: status_aux_in IN iby_trxn_summaries_all.status%TYPE,
266: amount_out OUT NOCOPY iby_trxn_summaries_all.amount%TYPE,

Line 263: trxntypeid_aux_in IN iby_trxn_summaries_all.trxntypeid%TYPE,

259: PROCEDURE getTrxnInfo
260: (
261: trxnid_in IN iby_trxn_summaries_all.transactionid%TYPE,
262: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
263: trxntypeid_aux_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
264: status_in IN iby_trxn_summaries_all.status%TYPE,
265: status_aux_in IN iby_trxn_summaries_all.status%TYPE,
266: amount_out OUT NOCOPY iby_trxn_summaries_all.amount%TYPE,
267: currency_out OUT NOCOPY iby_trxn_summaries_all.currencynamecode%TYPE,

Line 264: status_in IN iby_trxn_summaries_all.status%TYPE,

260: (
261: trxnid_in IN iby_trxn_summaries_all.transactionid%TYPE,
262: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
263: trxntypeid_aux_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
264: status_in IN iby_trxn_summaries_all.status%TYPE,
265: status_aux_in IN iby_trxn_summaries_all.status%TYPE,
266: amount_out OUT NOCOPY iby_trxn_summaries_all.amount%TYPE,
267: currency_out OUT NOCOPY iby_trxn_summaries_all.currencynamecode%TYPE,
268: status_out OUT NOCOPY iby_trxn_summaries_all.status%TYPE

Line 265: status_aux_in IN iby_trxn_summaries_all.status%TYPE,

261: trxnid_in IN iby_trxn_summaries_all.transactionid%TYPE,
262: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
263: trxntypeid_aux_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
264: status_in IN iby_trxn_summaries_all.status%TYPE,
265: status_aux_in IN iby_trxn_summaries_all.status%TYPE,
266: amount_out OUT NOCOPY iby_trxn_summaries_all.amount%TYPE,
267: currency_out OUT NOCOPY iby_trxn_summaries_all.currencynamecode%TYPE,
268: status_out OUT NOCOPY iby_trxn_summaries_all.status%TYPE
269: )

Line 266: amount_out OUT NOCOPY iby_trxn_summaries_all.amount%TYPE,

262: trxntypeid_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
263: trxntypeid_aux_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
264: status_in IN iby_trxn_summaries_all.status%TYPE,
265: status_aux_in IN iby_trxn_summaries_all.status%TYPE,
266: amount_out OUT NOCOPY iby_trxn_summaries_all.amount%TYPE,
267: currency_out OUT NOCOPY iby_trxn_summaries_all.currencynamecode%TYPE,
268: status_out OUT NOCOPY iby_trxn_summaries_all.status%TYPE
269: )
270: IS

Line 267: currency_out OUT NOCOPY iby_trxn_summaries_all.currencynamecode%TYPE,

263: trxntypeid_aux_in IN iby_trxn_summaries_all.trxntypeid%TYPE,
264: status_in IN iby_trxn_summaries_all.status%TYPE,
265: status_aux_in IN iby_trxn_summaries_all.status%TYPE,
266: amount_out OUT NOCOPY iby_trxn_summaries_all.amount%TYPE,
267: currency_out OUT NOCOPY iby_trxn_summaries_all.currencynamecode%TYPE,
268: status_out OUT NOCOPY iby_trxn_summaries_all.status%TYPE
269: )
270: IS
271: BEGIN

Line 268: status_out OUT NOCOPY iby_trxn_summaries_all.status%TYPE

264: status_in IN iby_trxn_summaries_all.status%TYPE,
265: status_aux_in IN iby_trxn_summaries_all.status%TYPE,
266: amount_out OUT NOCOPY iby_trxn_summaries_all.amount%TYPE,
267: currency_out OUT NOCOPY iby_trxn_summaries_all.currencynamecode%TYPE,
268: status_out OUT NOCOPY iby_trxn_summaries_all.status%TYPE
269: )
270: IS
271: BEGIN
272: SELECT amount, currencynamecode, status

Line 274: FROM iby_trxn_summaries_all

270: IS
271: BEGIN
272: SELECT amount, currencynamecode, status
273: INTO amount_out,currency_out, status_out
274: FROM iby_trxn_summaries_all
275: WHERE (transactionid=trxnid_in) AND (trxntypeid IN (trxntypeid_in,trxntypeid_aux_in))
276: AND (status in (status_in,status_aux_in));
277: EXCEPTION
278: