1 package iby_queryset_pkg AUTHID CURRENT_USER as
2 /*$Header: ibyqsets.pls 115.5 2002/11/19 23:49:58 jleybovi ship $*/
3
4 /* This procedure gets the trxn info for this particular */
5 /* trxn. Given a PayeeID, order_id, split_id */
6 /* (splitId), payment_operation, and BEPID, it returns */
7 /* the status (if the operation occurred before -- useful for*/
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,
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
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,
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
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,
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;