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_QUERYSET_PKG dependencies on IBY_TRANSACTIONS_SET_V

Line 80: FROM iby_transactions_set_v

76: -- See how many trxns of type SET (PREQ=2) or AUTH
77: -- of this order_id, trxn_id occurred before
78: SELECT count(*)
79: INTO num_trxns
80: FROM iby_transactions_set_v
81: WHERE order_id = order_id_in
82: AND merchant_id = merchant_id_in
83: AND trxn_type IN (2)
84: AND split_id = split_id_in

Line 96: FROM iby_transactions_set_v TRX

92: -- Only one matching trxn, so get the SET trxn id
93: -- dbms_output.put_line('Getting SET Trxn ID');
94: SELECT TRX.set_trxn_id, TRX.amount, TRX.currency
95: INTO prev_set_trxn_id_in_out,price_out,currency_out
96: FROM iby_transactions_set_v TRX
97: WHERE order_id = order_id_in
98: AND merchant_id = merchant_id_in
99: AND trxn_type IN (2)
100: AND split_id = split_id_in

Line 125: FROM iby_transactions_set_v

121: -- See how many trxns of type SET (PREQ=2) or AUTH
122: -- of this order_id, trxn_id occurred before
123: SELECT count(*)
124: INTO num_trxns
125: FROM iby_transactions_set_v
126: WHERE order_id = order_id_in
127: AND merchant_id = merchant_id_in
128: AND trxn_type IN (2,4,101) -- auth, authrev, or subsequentauth
129: AND split_id = split_id_in

Line 141: FROM iby_transactions_set_v

137: -- If two transactions match, then get the authrev, which will be
138: -- later than the auth or the subsequentauth
139: SELECT count(*)
140: INTO num_trxns
141: FROM iby_transactions_set_v
142: WHERE order_id = order_id_in
143: AND merchant_id = merchant_id_in
144: AND trxn_type = 4 -- authrev
145: AND split_id = split_id_in

Line 156: FROM iby_transactions_set_v TRX

152: -- Only one matching trxn, so get the SET trxn id
153: -- dbms_output.put_line('Getting SET Trxn ID');
154: SELECT TRX.set_trxn_id, TRX.amount, TRX.currency
155: INTO prev_set_trxn_id_in_out,price_out,currency_out
156: FROM iby_transactions_set_v TRX
157: WHERE order_id = order_id_in
158: AND merchant_id = merchant_id_in
159: AND trxn_type = 4 --authrev
160: AND split_id = split_id_in

Line 185: FROM iby_transactions_set_v TRX

181: -- dbms_output.put_line('Getting SET Trxn ID');
182:
183: SELECT TRX.set_trxn_id, TRX.amount, TRX.currency
184: INTO prev_set_trxn_id_in_out,price_out,currency_out
185: FROM iby_transactions_set_v TRX
186: WHERE order_id = order_id_in
187: AND merchant_id = merchant_id_in
188: AND trxn_type IN (2, 4, 101)
189: AND split_id = split_id_in

Line 214: FROM iby_transactions_set_v

210: -- dbms_output.put_line('In ORASET_CAPREV or CREDIT, m_id, o_id, m_tx_id: '||merchant_id_in||' '||order_id_in||' '||split_id_in);
211: -- See if trxn is duplicate
212: SELECT count(*)
213: INTO num_trxns
214: FROM iby_transactions_set_v
215: WHERE order_id = order_id_in
216: AND merchant_id = merchant_id_in
217: AND ( trxn_type IN (8, 9)
218: OR

Line 228: FROM iby_transactions_set_v TRX

224: -- dbms_output.put_line('Getting SET Trxn ID');
225:
226: SELECT TRX.set_trxn_id, TRX.amount, TRX.currency
227: INTO prev_set_trxn_id_in_out,price_out,currency_out
228: FROM iby_transactions_set_v TRX
229: WHERE order_id = order_id_in
230: AND merchant_id = merchant_id_in
231: AND ( trxn_type IN (8, 9)
232: OR

Line 252: FROM iby_transactions_set_v

248: -- dbms_output.put_line('In ORASET_CREDITREV, m_id, o_id, m_tx_id: '||merchant_id_in||' '||order_id_in||' '||split_id_in);
249: -- See if trxn is duplicate
250: SELECT count(*)
251: INTO num_trxns
252: FROM iby_transactions_set_v
253: WHERE order_id = order_id_in
254: AND merchant_id = merchant_id_in
255: AND trxn_type = 5
256: AND split_id = split_id_in;

Line 264: FROM iby_transactions_set_v TRX

260: -- dbms_output.put_line('Getting SET Trxn ID');
261:
262: SELECT TRX.set_trxn_id, TRX.amount, TRX.currency
263: INTO prev_set_trxn_id_in_out,price_out,currency_out
264: FROM iby_transactions_set_v TRX
265: WHERE order_id = order_id_in
266: AND merchant_id = merchant_id_in
267: AND trxn_type = 5
268: AND split_id = split_id_in;

Line 337: loc_status iby_transactions_set_v.status%TYPE;

333: payment_operation_in IN VARCHAR2,
334: split_id_in IN iby_trxn_extended.SplitID%TYPE,
335: status_out OUT NOCOPY iby_trxn_summaries_all.Status%TYPE)
336: IS
337: loc_status iby_transactions_set_v.status%TYPE;
338: num_trxns NUMBER;
339: max_time DATE;
340: CURSOR s1(tx1 NUMBER,
341: tx2 NUMBER DEFAULT NULL) IS

Line 343: FROM iby_transactions_set_v

339: max_time DATE;
340: CURSOR s1(tx1 NUMBER,
341: tx2 NUMBER DEFAULT NULL) IS
342: SELECT status
343: FROM iby_transactions_set_v
344: WHERE order_id = order_id_in
345: AND merchant_id = merchant_id_in
346: AND trxn_type IN (tx1, tx2)
347: AND split_id = split_id_in

Line 396: FROM iby_transactions_set_v

392: -- PInitReq (request_type=1) and one for PReq (request_type=2)
393: -- Get number of PReq trxns
394: SELECT count(*)
395: INTO num_trxns
396: FROM iby_transactions_set_v
397: WHERE order_id = order_id_in
398: AND merchant_id = merchant_id_in
399: AND trxn_type in (2,3)
400: AND request_type = 2;

Line 410: FROM iby_transactions_set_v

406: ELSE
407: -- A previous PReq was found
408: SELECT status
409: INTO loc_status
410: FROM iby_transactions_set_v
411: WHERE order_id = order_id_in
412: AND merchant_id = merchant_id_in
413: AND trxn_type in (2,3)
414: AND request_type = 2

Line 443: FROM iby_transactions_set_v

439: max_time DATE;
440: CURSOR s1(tx1 NUMBER,
441: tx2 NUMBER DEFAULT NULL) IS
442: SELECT amount,currency
443: FROM iby_transactions_set_v
444: WHERE order_id = order_id_in
445: AND merchant_id = merchant_id_in
446: AND trxn_type IN (tx1, tx2)
447: AND split_id = split_id_in

Line 486: FROM iby_transactions_set_v

482: -- PInitReq (request_type=1) and one for PReq (request_type=2)
483: -- Get number of PReq trxns
484: SELECT count(*)
485: INTO num_trxns
486: FROM iby_transactions_set_v
487: WHERE order_id = order_id_in
488: AND merchant_id = merchant_id_in
489: AND trxn_type in (2,3)
490: AND request_type = 2;

Line 497: FROM iby_transactions_set_v

493: THEN
494: -- A previous PReq was found
495: SELECT amount,currency
496: INTO price_out, currency_out
497: FROM iby_transactions_set_v
498: WHERE order_id = order_id_in
499: AND merchant_id = merchant_id_in
500: AND trxn_type in (2,3)
501: AND request_type = 2

Line 536: FROM iby_transactions_set_v

532: getAmount_SET(order_id_in, merchant_id_in,'ORASET_AUTH', split_id_in, previous_price_out,previous_currency_out);
533: -- See if trxn is duplicate
534: SELECT count(*)
535: INTO num_trxns
536: FROM iby_transactions_set_v
537: WHERE order_id = order_id_in
538: AND merchant_id = merchant_id_in
539: AND split_id = split_id_in
540: AND trxn_type = 101;

Line 550: FROM iby_transactions_set_v

546: -- transaction
547: -- dbms_output.put_line('Dup txn id');
548: SELECT status
549: INTO status_out
550: FROM iby_transactions_set_v
551: WHERE order_id = order_id_in
552: AND merchant_id = merchant_id_in
553: AND split_id = split_id_in
554: AND trxn_type = 101;

Line 560: FROM iby_transactions_set_v

556:
557: -- Get count number of successful parent set trxn ids
558: SELECT count(*)
559: INTO num_trxns
560: FROM iby_transactions_set_v
561: WHERE order_id = order_id_in
562: AND merchant_id = merchant_id_in
563: AND split_id = prev_split_id_in
564: AND trxn_type IN (2, 101)

Line 579: FROM iby_transactions_set_v

575: -- Get previous SET transaction id and
576: -- subsequent authorization indicator
577: SELECT set_trxn_id, subseq_auth_ind
578: INTO set_trxn_id_out, auth_ind
579: FROM iby_transactions_set_v
580: WHERE order_id = order_id_in
581: AND merchant_id = merchant_id_in
582: AND split_id = prev_split_id_in
583: AND trxn_type IN (2,101)