DBA Data[Home] [Help]

APPS.IBY_TRANSACTIONEFT_PKG dependencies on JTF_VARCHAR2_TABLE_100

Line 65: batch_ids_out OUT NOCOPY JTF_VARCHAR2_TABLE_100

61: f_instr_type IN iby_trxn_summaries_all.
62: instrtype%TYPE,
63: numtrxns_out OUT NOCOPY NUMBER,
64: mbatch_ids_out OUT NOCOPY JTF_NUMBER_TABLE,
65: batch_ids_out OUT NOCOPY JTF_VARCHAR2_TABLE_100
66: );
67:
68: /*
69: * This is the overloaded form of the previous API. This takes an array of

Line 80: profile_code_array IN JTF_VARCHAR2_TABLE_100,

76: * will not allow any modification and cancellation to these transactions.
77: */
78: PROCEDURE createBatchCloseTrxnsNew(
79: merch_batchid_in IN VARCHAR2,
80: profile_code_array IN JTF_VARCHAR2_TABLE_100,
81: merchant_id_in IN VARCHAR2,
82: vendor_id_in IN NUMBER,
83: vendor_key_in IN VARCHAR2,
84: newstatus_in IN NUMBER,

Line 107: batch_ids_out OUT NOCOPY JTF_VARCHAR2_TABLE_100

103: f_instr_type IN iby_trxn_summaries_all.
104: instrtype%TYPE,
105: numtrxns_out OUT NOCOPY NUMBER,
106: mbatch_ids_out OUT NOCOPY JTF_NUMBER_TABLE,
107: batch_ids_out OUT NOCOPY JTF_VARCHAR2_TABLE_100
108: );
109:
110: /*Update the batch and transactions status and other infomations based on the
111: payeeid and batchid */

Line 131: i_errCode_arr IN JTF_VARCHAR2_TABLE_100,

127: PROCEDURE updateTrxnResultStatus(
128: i_merch_batchid IN VARCHAR2,
129: i_merchant_id IN VARCHAR2,
130: i_status_arr IN JTF_NUMBER_TABLE,
131: i_errCode_arr IN JTF_VARCHAR2_TABLE_100,
132: i_errMsg_arr IN JTF_VARCHAR2_TABLE_300,
133: i_tangibleId_arr IN JTF_VARCHAR2_TABLE_100,
134: o_status_arr OUT NOCOPY JTF_NUMBER_TABLE,
135: o_error_code OUT NOCOPY NUMBER,

Line 133: i_tangibleId_arr IN JTF_VARCHAR2_TABLE_100,

129: i_merchant_id IN VARCHAR2,
130: i_status_arr IN JTF_NUMBER_TABLE,
131: i_errCode_arr IN JTF_VARCHAR2_TABLE_100,
132: i_errMsg_arr IN JTF_VARCHAR2_TABLE_300,
133: i_tangibleId_arr IN JTF_VARCHAR2_TABLE_100,
134: o_status_arr OUT NOCOPY JTF_NUMBER_TABLE,
135: o_error_code OUT NOCOPY NUMBER,
136: o_error_msg OUT NOCOPY VARCHAR2
137: );

Line 154: i_payerid IN JTF_VARCHAR2_TABLE_100,

150: i_orgid IN iby_trxn_summaries_all.org_id%TYPE,
151:
152: i_payerinstrid IN JTF_NUMBER_TABLE,
153: i_amount IN JTF_NUMBER_TABLE,
154: i_payerid IN JTF_VARCHAR2_TABLE_100,
155: i_tangibleid IN JTF_VARCHAR2_TABLE_100,
156: i_currency IN JTF_VARCHAR2_TABLE_100,
157: i_refinfo IN JTF_VARCHAR2_TABLE_100,
158: i_memo IN JTF_VARCHAR2_TABLE_100,

Line 155: i_tangibleid IN JTF_VARCHAR2_TABLE_100,

151:
152: i_payerinstrid IN JTF_NUMBER_TABLE,
153: i_amount IN JTF_NUMBER_TABLE,
154: i_payerid IN JTF_VARCHAR2_TABLE_100,
155: i_tangibleid IN JTF_VARCHAR2_TABLE_100,
156: i_currency IN JTF_VARCHAR2_TABLE_100,
157: i_refinfo IN JTF_VARCHAR2_TABLE_100,
158: i_memo IN JTF_VARCHAR2_TABLE_100,
159: i_OrderMedium IN JTF_VARCHAR2_TABLE_100,

Line 156: i_currency IN JTF_VARCHAR2_TABLE_100,

152: i_payerinstrid IN JTF_NUMBER_TABLE,
153: i_amount IN JTF_NUMBER_TABLE,
154: i_payerid IN JTF_VARCHAR2_TABLE_100,
155: i_tangibleid IN JTF_VARCHAR2_TABLE_100,
156: i_currency IN JTF_VARCHAR2_TABLE_100,
157: i_refinfo IN JTF_VARCHAR2_TABLE_100,
158: i_memo IN JTF_VARCHAR2_TABLE_100,
159: i_OrderMedium IN JTF_VARCHAR2_TABLE_100,
160: i_EftAuthMethod IN JTF_VARCHAR2_TABLE_100,

Line 157: i_refinfo IN JTF_VARCHAR2_TABLE_100,

153: i_amount IN JTF_NUMBER_TABLE,
154: i_payerid IN JTF_VARCHAR2_TABLE_100,
155: i_tangibleid IN JTF_VARCHAR2_TABLE_100,
156: i_currency IN JTF_VARCHAR2_TABLE_100,
157: i_refinfo IN JTF_VARCHAR2_TABLE_100,
158: i_memo IN JTF_VARCHAR2_TABLE_100,
159: i_OrderMedium IN JTF_VARCHAR2_TABLE_100,
160: i_EftAuthMethod IN JTF_VARCHAR2_TABLE_100,
161: i_instrsubtype IN JTF_VARCHAR2_TABLE_100,

Line 158: i_memo IN JTF_VARCHAR2_TABLE_100,

154: i_payerid IN JTF_VARCHAR2_TABLE_100,
155: i_tangibleid IN JTF_VARCHAR2_TABLE_100,
156: i_currency IN JTF_VARCHAR2_TABLE_100,
157: i_refinfo IN JTF_VARCHAR2_TABLE_100,
158: i_memo IN JTF_VARCHAR2_TABLE_100,
159: i_OrderMedium IN JTF_VARCHAR2_TABLE_100,
160: i_EftAuthMethod IN JTF_VARCHAR2_TABLE_100,
161: i_instrsubtype IN JTF_VARCHAR2_TABLE_100,
162: i_settledate IN JTF_DATE_TABLE,

Line 159: i_OrderMedium IN JTF_VARCHAR2_TABLE_100,

155: i_tangibleid IN JTF_VARCHAR2_TABLE_100,
156: i_currency IN JTF_VARCHAR2_TABLE_100,
157: i_refinfo IN JTF_VARCHAR2_TABLE_100,
158: i_memo IN JTF_VARCHAR2_TABLE_100,
159: i_OrderMedium IN JTF_VARCHAR2_TABLE_100,
160: i_EftAuthMethod IN JTF_VARCHAR2_TABLE_100,
161: i_instrsubtype IN JTF_VARCHAR2_TABLE_100,
162: i_settledate IN JTF_DATE_TABLE,
163: i_issuedate IN JTF_DATE_TABLE,

Line 160: i_EftAuthMethod IN JTF_VARCHAR2_TABLE_100,

156: i_currency IN JTF_VARCHAR2_TABLE_100,
157: i_refinfo IN JTF_VARCHAR2_TABLE_100,
158: i_memo IN JTF_VARCHAR2_TABLE_100,
159: i_OrderMedium IN JTF_VARCHAR2_TABLE_100,
160: i_EftAuthMethod IN JTF_VARCHAR2_TABLE_100,
161: i_instrsubtype IN JTF_VARCHAR2_TABLE_100,
162: i_settledate IN JTF_DATE_TABLE,
163: i_issuedate IN JTF_DATE_TABLE,
164: i_customerref IN JTF_VARCHAR2_TABLE_100,

Line 161: i_instrsubtype IN JTF_VARCHAR2_TABLE_100,

157: i_refinfo IN JTF_VARCHAR2_TABLE_100,
158: i_memo IN JTF_VARCHAR2_TABLE_100,
159: i_OrderMedium IN JTF_VARCHAR2_TABLE_100,
160: i_EftAuthMethod IN JTF_VARCHAR2_TABLE_100,
161: i_instrsubtype IN JTF_VARCHAR2_TABLE_100,
162: i_settledate IN JTF_DATE_TABLE,
163: i_issuedate IN JTF_DATE_TABLE,
164: i_customerref IN JTF_VARCHAR2_TABLE_100,
165: o_trxnId OUT NOCOPY JTF_NUMBER_TABLE

Line 164: i_customerref IN JTF_VARCHAR2_TABLE_100,

160: i_EftAuthMethod IN JTF_VARCHAR2_TABLE_100,
161: i_instrsubtype IN JTF_VARCHAR2_TABLE_100,
162: i_settledate IN JTF_DATE_TABLE,
163: i_issuedate IN JTF_DATE_TABLE,
164: i_customerref IN JTF_VARCHAR2_TABLE_100,
165: o_trxnId OUT NOCOPY JTF_NUMBER_TABLE
166: );
167:
168: /** Insert verify EFT transaction **/