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 12: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,

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

Line 14: payment_operation_in IN iby_trxn_summaries_all.PaymentMethodName%TYPE,

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

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

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

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

14: payment_operation_in IN iby_trxn_summaries_all.PaymentMethodName%TYPE,
15: vendor_id_in IN IBY_BEPInfo.BEPID%TYPE,
16: status_out OUT NOCOPY iby_trxn_summaries_all.Status%TYPE,
17: prev_set_trxn_id_in_out IN OUT NOCOPY iby_trxn_extended.SETTrxnID%TYPE,
18: price_out OUT NOCOPY iby_trxn_summaries_all.Amount%TYPE,
19: currency_out OUT NOCOPY iby_trxn_summaries_all.CurrencyNameCode%TYPE,
20: previous_price_out OUT NOCOPY iby_trxn_summaries_all.Amount%TYPE,
21: previous_currency_out OUT NOCOPY iby_trxn_summaries_all.CurrencyNameCode%TYPE);
22: /* Procedure used to get the status for a particular SET */

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

15: vendor_id_in IN IBY_BEPInfo.BEPID%TYPE,
16: status_out OUT NOCOPY iby_trxn_summaries_all.Status%TYPE,
17: prev_set_trxn_id_in_out IN OUT NOCOPY iby_trxn_extended.SETTrxnID%TYPE,
18: price_out OUT NOCOPY iby_trxn_summaries_all.Amount%TYPE,
19: currency_out OUT NOCOPY iby_trxn_summaries_all.CurrencyNameCode%TYPE,
20: previous_price_out OUT NOCOPY iby_trxn_summaries_all.Amount%TYPE,
21: previous_currency_out OUT NOCOPY iby_trxn_summaries_all.CurrencyNameCode%TYPE);
22: /* Procedure used to get the status for a particular SET */
23: /* trxn. The status_out will be set to some value if the */

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

16: status_out OUT NOCOPY iby_trxn_summaries_all.Status%TYPE,
17: prev_set_trxn_id_in_out IN OUT NOCOPY iby_trxn_extended.SETTrxnID%TYPE,
18: price_out OUT NOCOPY iby_trxn_summaries_all.Amount%TYPE,
19: currency_out OUT NOCOPY iby_trxn_summaries_all.CurrencyNameCode%TYPE,
20: previous_price_out OUT NOCOPY iby_trxn_summaries_all.Amount%TYPE,
21: previous_currency_out OUT NOCOPY iby_trxn_summaries_all.CurrencyNameCode%TYPE);
22: /* Procedure used to get the status for a particular SET */
23: /* trxn. The status_out will be set to some value if the */
24: /* order occurred previously, else it'll be null. */

Line 21: previous_currency_out OUT NOCOPY iby_trxn_summaries_all.CurrencyNameCode%TYPE);

17: prev_set_trxn_id_in_out IN OUT NOCOPY iby_trxn_extended.SETTrxnID%TYPE,
18: price_out OUT NOCOPY iby_trxn_summaries_all.Amount%TYPE,
19: currency_out OUT NOCOPY iby_trxn_summaries_all.CurrencyNameCode%TYPE,
20: previous_price_out OUT NOCOPY iby_trxn_summaries_all.Amount%TYPE,
21: previous_currency_out OUT NOCOPY iby_trxn_summaries_all.CurrencyNameCode%TYPE);
22: /* Procedure used to get the status for a particular SET */
23: /* trxn. The status_out will be set to some value if the */
24: /* order occurred previously, else it'll be null. */
25: PROCEDURE getStatus_SET

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

22: /* Procedure used to get the status for a particular SET */
23: /* trxn. The status_out will be set to some value if the */
24: /* order occurred previously, else it'll be null. */
25: PROCEDURE getStatus_SET
26: (order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
27: merchant_id_in IN IBY_Payee.PayeeID%TYPE,
28: payment_operation_in IN VARCHAR2,
29: split_id_in IN iby_trxn_extended.SplitID%TYPE,
30: status_out OUT NOCOPY iby_trxn_summaries_all.Status%TYPE);

Line 30: status_out OUT NOCOPY iby_trxn_summaries_all.Status%TYPE);

26: (order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
27: merchant_id_in IN IBY_Payee.PayeeID%TYPE,
28: payment_operation_in IN VARCHAR2,
29: split_id_in IN iby_trxn_extended.SplitID%TYPE,
30: status_out OUT NOCOPY iby_trxn_summaries_all.Status%TYPE);
31: PROCEDURE getAmount_SET
32: (order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
33: merchant_id_in IN IBY_Payee.PayeeID%TYPE,
34: payment_operation_in IN VARCHAR2,

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

28: payment_operation_in IN VARCHAR2,
29: split_id_in IN iby_trxn_extended.SplitID%TYPE,
30: status_out OUT NOCOPY iby_trxn_summaries_all.Status%TYPE);
31: PROCEDURE getAmount_SET
32: (order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
33: merchant_id_in IN IBY_Payee.PayeeID%TYPE,
34: payment_operation_in IN VARCHAR2,
35: split_id_in IN iby_trxn_extended.SplitID%TYPE,
36: price_out OUT NOCOPY iby_trxn_summaries_all.Amount%TYPE,

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

32: (order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
33: merchant_id_in IN IBY_Payee.PayeeID%TYPE,
34: payment_operation_in IN VARCHAR2,
35: split_id_in IN iby_trxn_extended.SplitID%TYPE,
36: price_out OUT NOCOPY iby_trxn_summaries_all.Amount%TYPE,
37: currency_out OUT NOCOPY iby_trxn_summaries_all.CurrencyNameCode%TYPE);
38: /* Procedure used for orasubsequentauth instead of the */
39: /* getStatus_SET procedure. It performs some special */
40: /* processing. */

Line 37: currency_out OUT NOCOPY iby_trxn_summaries_all.CurrencyNameCode%TYPE);

33: merchant_id_in IN IBY_Payee.PayeeID%TYPE,
34: payment_operation_in IN VARCHAR2,
35: split_id_in IN iby_trxn_extended.SplitID%TYPE,
36: price_out OUT NOCOPY iby_trxn_summaries_all.Amount%TYPE,
37: currency_out OUT NOCOPY iby_trxn_summaries_all.CurrencyNameCode%TYPE);
38: /* Procedure used for orasubsequentauth instead of the */
39: /* getStatus_SET procedure. It performs some special */
40: /* processing. */
41: PROCEDURE processsplitauth

Line 43: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,

39: /* getStatus_SET procedure. It performs some special */
40: /* processing. */
41: PROCEDURE processsplitauth
42: (merchant_id_in IN IBY_Payee.PayeeID%TYPE,
43: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
44: prev_split_id_in IN iby_trxn_extended.SPlitID%TYPE,
45: split_id_in IN iby_trxn_extended.SPlitID%TYPE,
46: vendor_id_in IN IBY_Payee.PayeeID%TYPE,
47: status_out OUT NOCOPY iby_trxn_summaries_all.Status%TYPE,

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

43: order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
44: prev_split_id_in IN iby_trxn_extended.SPlitID%TYPE,
45: split_id_in IN iby_trxn_extended.SPlitID%TYPE,
46: vendor_id_in IN IBY_Payee.PayeeID%TYPE,
47: status_out OUT NOCOPY iby_trxn_summaries_all.Status%TYPE,
48: set_trxn_id_out IN OUT NOCOPY iby_trxn_extended.SETTrxnID%TYPE,
49: previous_price_out OUT NOCOPY iby_trxn_summaries_all.Amount%TYPE,
50: previous_currency_out OUT NOCOPY iby_trxn_summaries_all.CurrencyNameCode%TYPE);
51: END iby_queryset_pkg;

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

45: split_id_in IN iby_trxn_extended.SPlitID%TYPE,
46: vendor_id_in IN IBY_Payee.PayeeID%TYPE,
47: status_out OUT NOCOPY iby_trxn_summaries_all.Status%TYPE,
48: set_trxn_id_out IN OUT NOCOPY iby_trxn_extended.SETTrxnID%TYPE,
49: previous_price_out OUT NOCOPY iby_trxn_summaries_all.Amount%TYPE,
50: previous_currency_out OUT NOCOPY iby_trxn_summaries_all.CurrencyNameCode%TYPE);
51: END iby_queryset_pkg;

Line 50: previous_currency_out OUT NOCOPY iby_trxn_summaries_all.CurrencyNameCode%TYPE);

46: vendor_id_in IN IBY_Payee.PayeeID%TYPE,
47: status_out OUT NOCOPY iby_trxn_summaries_all.Status%TYPE,
48: set_trxn_id_out IN OUT NOCOPY iby_trxn_extended.SETTrxnID%TYPE,
49: previous_price_out OUT NOCOPY iby_trxn_summaries_all.Amount%TYPE,
50: previous_currency_out OUT NOCOPY iby_trxn_summaries_all.CurrencyNameCode%TYPE);
51: END iby_queryset_pkg;