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_TRXN_SUMMARIES_ALL

Line 13: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,

9: /* parent SET trxn to the vendor. */
10:
11: PROCEDURE get_settrxninfo
12: (merchant_id_in IN IBY_Payee.PayeeID%TYPE,
13: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
14: split_id_in IN iby_trxn_extended.SplitID%TYPE,
15: payment_operation_in IN iby_trxn_summaries_all.PaymentMethodName%TYPE,
16: vendor_id_in IN IBY_BEPInfo.BEPID%TYPE,
17: status_out OUT NOCOPY iby_trxn_summaries_all.Status%TYPE,

Line 15: payment_operation_in IN iby_trxn_summaries_all.PaymentMethodName%TYPE,

11: PROCEDURE get_settrxninfo
12: (merchant_id_in IN IBY_Payee.PayeeID%TYPE,
13: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
14: split_id_in IN iby_trxn_extended.SplitID%TYPE,
15: payment_operation_in IN iby_trxn_summaries_all.PaymentMethodName%TYPE,
16: vendor_id_in IN IBY_BEPInfo.BEPID%TYPE,
17: status_out OUT NOCOPY iby_trxn_summaries_all.Status%TYPE,
18: prev_set_trxn_id_in_out IN OUT NOCOPY iby_trxn_extended.SETTrxnID%TYPE,
19: price_out OUT NOCOPY iby_trxn_summaries_all.Amount%TYPE,

Line 17: status_out OUT NOCOPY iby_trxn_summaries_all.Status%TYPE,

13: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
14: split_id_in IN iby_trxn_extended.SplitID%TYPE,
15: payment_operation_in IN iby_trxn_summaries_all.PaymentMethodName%TYPE,
16: vendor_id_in IN IBY_BEPInfo.BEPID%TYPE,
17: status_out OUT NOCOPY iby_trxn_summaries_all.Status%TYPE,
18: prev_set_trxn_id_in_out IN OUT NOCOPY iby_trxn_extended.SETTrxnID%TYPE,
19: price_out OUT NOCOPY iby_trxn_summaries_all.Amount%TYPE,
20: currency_out OUT NOCOPY iby_trxn_summaries_all.CurrencyNameCode%TYPE,
21: previous_price_out OUT NOCOPY iby_trxn_summaries_all.Amount%TYPE,

Line 19: price_out OUT NOCOPY iby_trxn_summaries_all.Amount%TYPE,

15: payment_operation_in IN iby_trxn_summaries_all.PaymentMethodName%TYPE,
16: vendor_id_in IN IBY_BEPInfo.BEPID%TYPE,
17: status_out OUT NOCOPY iby_trxn_summaries_all.Status%TYPE,
18: prev_set_trxn_id_in_out IN OUT NOCOPY iby_trxn_extended.SETTrxnID%TYPE,
19: price_out OUT NOCOPY iby_trxn_summaries_all.Amount%TYPE,
20: currency_out OUT NOCOPY iby_trxn_summaries_all.CurrencyNameCode%TYPE,
21: previous_price_out OUT NOCOPY iby_trxn_summaries_all.Amount%TYPE,
22: previous_currency_out OUT NOCOPY iby_trxn_summaries_all.CurrencyNameCode%TYPE)
23: IS

Line 20: currency_out OUT NOCOPY iby_trxn_summaries_all.CurrencyNameCode%TYPE,

16: vendor_id_in IN IBY_BEPInfo.BEPID%TYPE,
17: status_out OUT NOCOPY iby_trxn_summaries_all.Status%TYPE,
18: prev_set_trxn_id_in_out IN OUT NOCOPY iby_trxn_extended.SETTrxnID%TYPE,
19: price_out OUT NOCOPY iby_trxn_summaries_all.Amount%TYPE,
20: currency_out OUT NOCOPY iby_trxn_summaries_all.CurrencyNameCode%TYPE,
21: previous_price_out OUT NOCOPY iby_trxn_summaries_all.Amount%TYPE,
22: previous_currency_out OUT NOCOPY iby_trxn_summaries_all.CurrencyNameCode%TYPE)
23: IS
24: in_trxn_type NUMBER;

Line 21: previous_price_out OUT NOCOPY iby_trxn_summaries_all.Amount%TYPE,

17: status_out OUT NOCOPY iby_trxn_summaries_all.Status%TYPE,
18: prev_set_trxn_id_in_out IN OUT NOCOPY iby_trxn_extended.SETTrxnID%TYPE,
19: price_out OUT NOCOPY iby_trxn_summaries_all.Amount%TYPE,
20: currency_out OUT NOCOPY iby_trxn_summaries_all.CurrencyNameCode%TYPE,
21: previous_price_out OUT NOCOPY iby_trxn_summaries_all.Amount%TYPE,
22: previous_currency_out OUT NOCOPY iby_trxn_summaries_all.CurrencyNameCode%TYPE)
23: IS
24: in_trxn_type NUMBER;
25: num_trxns NUMBER;

Line 22: previous_currency_out OUT NOCOPY iby_trxn_summaries_all.CurrencyNameCode%TYPE)

18: prev_set_trxn_id_in_out IN OUT NOCOPY iby_trxn_extended.SETTrxnID%TYPE,
19: price_out OUT NOCOPY iby_trxn_summaries_all.Amount%TYPE,
20: currency_out OUT NOCOPY iby_trxn_summaries_all.CurrencyNameCode%TYPE,
21: previous_price_out OUT NOCOPY iby_trxn_summaries_all.Amount%TYPE,
22: previous_currency_out OUT NOCOPY iby_trxn_summaries_all.CurrencyNameCode%TYPE)
23: IS
24: in_trxn_type NUMBER;
25: num_trxns NUMBER;
26: num_succ_trxns NUMBER;

Line 331: (order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,

327: /* Procedure used to get the status for a particular SET */
328: /* trxn. The status_out will be set to some value if the */
329: /* order occurred previously, else it'll be null. */
330: PROCEDURE getStatus_SET
331: (order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
332: merchant_id_in IN IBY_Payee.PayeeID%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)

Line 335: status_out OUT NOCOPY iby_trxn_summaries_all.Status%TYPE)

331: (order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
332: merchant_id_in IN IBY_Payee.PayeeID%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;

Line 431: (order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,

427: /* Procedure used to get the status for a particular SET */
428: /* trxn. The status_out will be set to some value if the */
429: /* order occurred previously, else it'll be null. */
430: PROCEDURE getAmount_SET
431: (order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
432: merchant_id_in IN IBY_Payee.PayeeID%TYPE,
433: payment_operation_in IN VARCHAR2,
434: split_id_in IN iby_trxn_extended.SplitID%TYPE,
435: price_out OUT NOCOPY iby_trxn_summaries_all.Amount%TYPE,

Line 435: price_out OUT NOCOPY iby_trxn_summaries_all.Amount%TYPE,

431: (order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
432: merchant_id_in IN IBY_Payee.PayeeID%TYPE,
433: payment_operation_in IN VARCHAR2,
434: split_id_in IN iby_trxn_extended.SplitID%TYPE,
435: price_out OUT NOCOPY iby_trxn_summaries_all.Amount%TYPE,
436: currency_out OUT NOCOPY iby_trxn_summaries_all.CurrencyNameCode%TYPE)
437: IS
438: num_trxns NUMBER;
439: max_time DATE;

Line 436: currency_out OUT NOCOPY iby_trxn_summaries_all.CurrencyNameCode%TYPE)

432: merchant_id_in IN IBY_Payee.PayeeID%TYPE,
433: payment_operation_in IN VARCHAR2,
434: split_id_in IN iby_trxn_extended.SplitID%TYPE,
435: price_out OUT NOCOPY iby_trxn_summaries_all.Amount%TYPE,
436: currency_out OUT NOCOPY iby_trxn_summaries_all.CurrencyNameCode%TYPE)
437: IS
438: num_trxns NUMBER;
439: max_time DATE;
440: CURSOR s1(tx1 NUMBER,

Line 514: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,

510: /* processing. */
511:
512: PROCEDURE processsplitauth
513: (merchant_id_in IN IBY_Payee.PayeeID%TYPE,
514: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
515: prev_split_id_in IN iby_trxn_extended.SPlitID%TYPE,
516: split_id_in IN iby_trxn_extended.SPlitID%TYPE,
517: vendor_id_in IN IBY_Payee.PayeeID%TYPE,
518: status_out OUT NOCOPY iby_trxn_summaries_all.Status%TYPE,

Line 518: status_out OUT NOCOPY iby_trxn_summaries_all.Status%TYPE,

514: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
515: prev_split_id_in IN iby_trxn_extended.SPlitID%TYPE,
516: split_id_in IN iby_trxn_extended.SPlitID%TYPE,
517: vendor_id_in IN IBY_Payee.PayeeID%TYPE,
518: status_out OUT NOCOPY iby_trxn_summaries_all.Status%TYPE,
519: set_trxn_id_out IN OUT NOCOPY iby_trxn_extended.SETTrxnID%TYPE,
520: previous_price_out OUT NOCOPY iby_trxn_summaries_all.Amount%TYPE,
521: previous_currency_out OUT NOCOPY iby_trxn_summaries_all.CurrencyNameCode%TYPE)
522: IS

Line 520: previous_price_out OUT NOCOPY iby_trxn_summaries_all.Amount%TYPE,

516: split_id_in IN iby_trxn_extended.SPlitID%TYPE,
517: vendor_id_in IN IBY_Payee.PayeeID%TYPE,
518: status_out OUT NOCOPY iby_trxn_summaries_all.Status%TYPE,
519: set_trxn_id_out IN OUT NOCOPY iby_trxn_extended.SETTrxnID%TYPE,
520: previous_price_out OUT NOCOPY iby_trxn_summaries_all.Amount%TYPE,
521: previous_currency_out OUT NOCOPY iby_trxn_summaries_all.CurrencyNameCode%TYPE)
522: IS
523: num_trxns NUMBER;
524: max_time DATE;

Line 521: previous_currency_out OUT NOCOPY iby_trxn_summaries_all.CurrencyNameCode%TYPE)

517: vendor_id_in IN IBY_Payee.PayeeID%TYPE,
518: status_out OUT NOCOPY iby_trxn_summaries_all.Status%TYPE,
519: set_trxn_id_out IN OUT NOCOPY iby_trxn_extended.SETTrxnID%TYPE,
520: previous_price_out OUT NOCOPY iby_trxn_summaries_all.Amount%TYPE,
521: previous_currency_out OUT NOCOPY iby_trxn_summaries_all.CurrencyNameCode%TYPE)
522: IS
523: num_trxns NUMBER;
524: max_time DATE;
525: num_succ_trxns NUMBER;