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.

[Home] [Help]

APPS.IBY_PAYMENTMANAGERDB_PKG dependencies on IBY_TRXN_SUMMARIES_ALL

Line 85: p_amount IN iby_trxn_summaries_all.amount%type

81: /* - bep_type_out: indicates whether the bep is a gateway or */
82: /* processor-model one */
83:
84: PROCEDURE listbep (
85: p_amount IN iby_trxn_summaries_all.amount%type
86: default null,
87: p_payment_channel_code IN iby_trxn_summaries_all.payment_channel_code%type default null,
88: p_currency IN iby_trxn_summaries_all.currencynamecode%type default null,
89: p_payee_id IN iby_trxn_summaries_all.payeeid%type

Line 87: p_payment_channel_code IN iby_trxn_summaries_all.payment_channel_code%type default null,

83:
84: PROCEDURE listbep (
85: p_amount IN iby_trxn_summaries_all.amount%type
86: default null,
87: p_payment_channel_code IN iby_trxn_summaries_all.payment_channel_code%type default null,
88: p_currency IN iby_trxn_summaries_all.currencynamecode%type default null,
89: p_payee_id IN iby_trxn_summaries_all.payeeid%type
90: default null,
91: p_cc_type IN VARCHAR2 default null,

Line 88: p_currency IN iby_trxn_summaries_all.currencynamecode%type default null,

84: PROCEDURE listbep (
85: p_amount IN iby_trxn_summaries_all.amount%type
86: default null,
87: p_payment_channel_code IN iby_trxn_summaries_all.payment_channel_code%type default null,
88: p_currency IN iby_trxn_summaries_all.currencynamecode%type default null,
89: p_payee_id IN iby_trxn_summaries_all.payeeid%type
90: default null,
91: p_cc_type IN VARCHAR2 default null,
92: p_cc_num IN iby_creditcard.ccnumber%type

Line 89: p_payee_id IN iby_trxn_summaries_all.payeeid%type

85: p_amount IN iby_trxn_summaries_all.amount%type
86: default null,
87: p_payment_channel_code IN iby_trxn_summaries_all.payment_channel_code%type default null,
88: p_currency IN iby_trxn_summaries_all.currencynamecode%type default null,
89: p_payee_id IN iby_trxn_summaries_all.payeeid%type
90: default null,
91: p_cc_type IN VARCHAR2 default null,
92: p_cc_num IN iby_creditcard.ccnumber%type
93: default null,

Line 96: p_org_id IN iby_trxn_summaries_all.org_id%type

92: p_cc_num IN iby_creditcard.ccnumber%type
93: default null,
94: p_aba_routing_no IN iby_bankacct.routingno%type
95: default null,
96: p_org_id IN iby_trxn_summaries_all.org_id%type
97: default null,
98: p_fin_app_type IN VARCHAR2 default null,
99: p_transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE default null,
100: p_payment_operation_in IN VARCHAR2,

Line 99: p_transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE default null,

95: default null,
96: p_org_id IN iby_trxn_summaries_all.org_id%type
97: default null,
98: p_fin_app_type IN VARCHAR2 default null,
99: p_transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE default null,
100: p_payment_operation_in IN VARCHAR2,
101: p_ecappid_in IN iby_ecapp.ecappid%type default null,
102: p_instr_subtype IN iby_trxn_summaries_all.instrsubtype%type default null,
103: p_bnf_routing_no IN iby_bankacct.routingno%type,

Line 102: p_instr_subtype IN iby_trxn_summaries_all.instrsubtype%type default null,

98: p_fin_app_type IN VARCHAR2 default null,
99: p_transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE default null,
100: p_payment_operation_in IN VARCHAR2,
101: p_ecappid_in IN iby_ecapp.ecappid%type default null,
102: p_instr_subtype IN iby_trxn_summaries_all.instrsubtype%type default null,
103: p_bnf_routing_no IN iby_bankacct.routingno%type,
104: p_merchant_bank_country IN VARCHAR2,
105: p_factored_flag IN iby_trxn_summaries_all.factored_flag%type default null,
106: p_int_bank_acct_id IN NUMBER,

Line 105: p_factored_flag IN iby_trxn_summaries_all.factored_flag%type default null,

101: p_ecappid_in IN iby_ecapp.ecappid%type default null,
102: p_instr_subtype IN iby_trxn_summaries_all.instrsubtype%type default null,
103: p_bnf_routing_no IN iby_bankacct.routingno%type,
104: p_merchant_bank_country IN VARCHAR2,
105: p_factored_flag IN iby_trxn_summaries_all.factored_flag%type default null,
106: p_int_bank_acct_id IN NUMBER,
107: p_br_signed_flag IN iby_trxn_summaries_all.br_signed_flag%TYPE,
108: p_br_drawee_issued_flag IN iby_trxn_summaries_all.br_drawee_issued_flag%TYPE,
109: p_ar_receipt_mth_id IN iby_trxn_summaries_all.ar_receipt_method_id%TYPE,

Line 107: p_br_signed_flag IN iby_trxn_summaries_all.br_signed_flag%TYPE,

103: p_bnf_routing_no IN iby_bankacct.routingno%type,
104: p_merchant_bank_country IN VARCHAR2,
105: p_factored_flag IN iby_trxn_summaries_all.factored_flag%type default null,
106: p_int_bank_acct_id IN NUMBER,
107: p_br_signed_flag IN iby_trxn_summaries_all.br_signed_flag%TYPE,
108: p_br_drawee_issued_flag IN iby_trxn_summaries_all.br_drawee_issued_flag%TYPE,
109: p_ar_receipt_mth_id IN iby_trxn_summaries_all.ar_receipt_method_id%TYPE,
110: px_payee_id_in_out IN OUT NOCOPY iby_payee.PayeeID%TYPE,
111: px_order_id_in_out IN OUT NOCOPY VARCHAR2,

Line 108: p_br_drawee_issued_flag IN iby_trxn_summaries_all.br_drawee_issued_flag%TYPE,

104: p_merchant_bank_country IN VARCHAR2,
105: p_factored_flag IN iby_trxn_summaries_all.factored_flag%type default null,
106: p_int_bank_acct_id IN NUMBER,
107: p_br_signed_flag IN iby_trxn_summaries_all.br_signed_flag%TYPE,
108: p_br_drawee_issued_flag IN iby_trxn_summaries_all.br_drawee_issued_flag%TYPE,
109: p_ar_receipt_mth_id IN iby_trxn_summaries_all.ar_receipt_method_id%TYPE,
110: px_payee_id_in_out IN OUT NOCOPY iby_payee.PayeeID%TYPE,
111: px_order_id_in_out IN OUT NOCOPY VARCHAR2,
112: px_payment_name_in_out IN OUT NOCOPY VARCHAR2,

Line 109: p_ar_receipt_mth_id IN iby_trxn_summaries_all.ar_receipt_method_id%TYPE,

105: p_factored_flag IN iby_trxn_summaries_all.factored_flag%type default null,
106: p_int_bank_acct_id IN NUMBER,
107: p_br_signed_flag IN iby_trxn_summaries_all.br_signed_flag%TYPE,
108: p_br_drawee_issued_flag IN iby_trxn_summaries_all.br_drawee_issued_flag%TYPE,
109: p_ar_receipt_mth_id IN iby_trxn_summaries_all.ar_receipt_method_id%TYPE,
110: px_payee_id_in_out IN OUT NOCOPY iby_payee.PayeeID%TYPE,
111: px_order_id_in_out IN OUT NOCOPY VARCHAR2,
112: px_payment_name_in_out IN OUT NOCOPY VARCHAR2,
113: px_bep_lang_in_out IN OUT NOCOPY VARCHAR2,

Line 133: p_amount IN iby_trxn_summaries_all.amount%type

129: IBY_FNDCPT_USER_CC_PF_VL.USER_CC_PROFILE_CODE%TYPE
130: );
131:
132: PROCEDURE listbep (
133: p_amount IN iby_trxn_summaries_all.amount%type
134: default null,
135: p_payment_channel_code IN iby_trxn_summaries_all.payment_channel_code%type,
136: p_currency IN iby_trxn_summaries_all.currencynamecode%type default null,
137: p_payee_id IN iby_trxn_summaries_all.payeeid%type

Line 135: p_payment_channel_code IN iby_trxn_summaries_all.payment_channel_code%type,

131:
132: PROCEDURE listbep (
133: p_amount IN iby_trxn_summaries_all.amount%type
134: default null,
135: p_payment_channel_code IN iby_trxn_summaries_all.payment_channel_code%type,
136: p_currency IN iby_trxn_summaries_all.currencynamecode%type default null,
137: p_payee_id IN iby_trxn_summaries_all.payeeid%type
138: default null,
139: p_cc_type IN VARCHAR2 default null,

Line 136: p_currency IN iby_trxn_summaries_all.currencynamecode%type default null,

132: PROCEDURE listbep (
133: p_amount IN iby_trxn_summaries_all.amount%type
134: default null,
135: p_payment_channel_code IN iby_trxn_summaries_all.payment_channel_code%type,
136: p_currency IN iby_trxn_summaries_all.currencynamecode%type default null,
137: p_payee_id IN iby_trxn_summaries_all.payeeid%type
138: default null,
139: p_cc_type IN VARCHAR2 default null,
140: p_cc_num IN iby_creditcard.ccnumber%type

Line 137: p_payee_id IN iby_trxn_summaries_all.payeeid%type

133: p_amount IN iby_trxn_summaries_all.amount%type
134: default null,
135: p_payment_channel_code IN iby_trxn_summaries_all.payment_channel_code%type,
136: p_currency IN iby_trxn_summaries_all.currencynamecode%type default null,
137: p_payee_id IN iby_trxn_summaries_all.payeeid%type
138: default null,
139: p_cc_type IN VARCHAR2 default null,
140: p_cc_num IN iby_creditcard.ccnumber%type
141: default null,

Line 144: p_org_id IN iby_trxn_summaries_all.org_id%type

140: p_cc_num IN iby_creditcard.ccnumber%type
141: default null,
142: p_aba_routing_no IN iby_bankacct.routingno%type
143: default null,
144: p_org_id IN iby_trxn_summaries_all.org_id%type
145: default null,
146: p_fin_app_type IN VARCHAR2 default null,
147: p_transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE default null,
148: p_payment_operation_in IN VARCHAR2,

Line 147: p_transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE default null,

143: default null,
144: p_org_id IN iby_trxn_summaries_all.org_id%type
145: default null,
146: p_fin_app_type IN VARCHAR2 default null,
147: p_transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE default null,
148: p_payment_operation_in IN VARCHAR2,
149: p_ecappid_in IN iby_ecapp.ecappid%type default null,
150: p_instr_subtype IN iby_trxn_summaries_all.instrsubtype%type default null,
151: p_bnf_routing_no IN iby_bankacct.routingno%type,

Line 150: p_instr_subtype IN iby_trxn_summaries_all.instrsubtype%type default null,

146: p_fin_app_type IN VARCHAR2 default null,
147: p_transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE default null,
148: p_payment_operation_in IN VARCHAR2,
149: p_ecappid_in IN iby_ecapp.ecappid%type default null,
150: p_instr_subtype IN iby_trxn_summaries_all.instrsubtype%type default null,
151: p_bnf_routing_no IN iby_bankacct.routingno%type,
152: p_factored_flag IN iby_trxn_summaries_all.factored_flag%type default null,
153: p_int_bank_acct_id IN NUMBER,
154:

Line 152: p_factored_flag IN iby_trxn_summaries_all.factored_flag%type default null,

148: p_payment_operation_in IN VARCHAR2,
149: p_ecappid_in IN iby_ecapp.ecappid%type default null,
150: p_instr_subtype IN iby_trxn_summaries_all.instrsubtype%type default null,
151: p_bnf_routing_no IN iby_bankacct.routingno%type,
152: p_factored_flag IN iby_trxn_summaries_all.factored_flag%type default null,
153: p_int_bank_acct_id IN NUMBER,
154:
155: p_br_signed_flag IN iby_trxn_summaries_all.br_signed_flag%TYPE,
156: p_br_drawee_issued_flag IN iby_trxn_summaries_all.br_drawee_issued_flag%TYPE,

Line 155: p_br_signed_flag IN iby_trxn_summaries_all.br_signed_flag%TYPE,

151: p_bnf_routing_no IN iby_bankacct.routingno%type,
152: p_factored_flag IN iby_trxn_summaries_all.factored_flag%type default null,
153: p_int_bank_acct_id IN NUMBER,
154:
155: p_br_signed_flag IN iby_trxn_summaries_all.br_signed_flag%TYPE,
156: p_br_drawee_issued_flag IN iby_trxn_summaries_all.br_drawee_issued_flag%TYPE,
157: p_ar_receipt_mth_id IN iby_trxn_summaries_all.ar_receipt_method_id%TYPE,
158: px_payee_id_in_out IN OUT NOCOPY iby_payee.PayeeID%TYPE,
159: px_order_id_in_out IN OUT NOCOPY VARCHAR2,

Line 156: p_br_drawee_issued_flag IN iby_trxn_summaries_all.br_drawee_issued_flag%TYPE,

152: p_factored_flag IN iby_trxn_summaries_all.factored_flag%type default null,
153: p_int_bank_acct_id IN NUMBER,
154:
155: p_br_signed_flag IN iby_trxn_summaries_all.br_signed_flag%TYPE,
156: p_br_drawee_issued_flag IN iby_trxn_summaries_all.br_drawee_issued_flag%TYPE,
157: p_ar_receipt_mth_id IN iby_trxn_summaries_all.ar_receipt_method_id%TYPE,
158: px_payee_id_in_out IN OUT NOCOPY iby_payee.PayeeID%TYPE,
159: px_order_id_in_out IN OUT NOCOPY VARCHAR2,
160: px_payment_name_in_out IN OUT NOCOPY VARCHAR2,

Line 157: p_ar_receipt_mth_id IN iby_trxn_summaries_all.ar_receipt_method_id%TYPE,

153: p_int_bank_acct_id IN NUMBER,
154:
155: p_br_signed_flag IN iby_trxn_summaries_all.br_signed_flag%TYPE,
156: p_br_drawee_issued_flag IN iby_trxn_summaries_all.br_drawee_issued_flag%TYPE,
157: p_ar_receipt_mth_id IN iby_trxn_summaries_all.ar_receipt_method_id%TYPE,
158: px_payee_id_in_out IN OUT NOCOPY iby_payee.PayeeID%TYPE,
159: px_order_id_in_out IN OUT NOCOPY VARCHAR2,
160: px_payment_name_in_out IN OUT NOCOPY VARCHAR2,
161: px_bep_lang_in_out IN OUT NOCOPY VARCHAR2,

Line 189: p_instr_type IN iby_trxn_summaries_all.InstrType%TYPE,

185: */
186: PROCEDURE listbep (
187: p_payee_id IN iby_bepkeys.OwnerId%TYPE,
188: p_bepkey IN iby_bepkeys.KEY%TYPE,
189: p_instr_type IN iby_trxn_summaries_all.InstrType%TYPE,
190: px_bep_suffix_in_out IN OUT NOCOPY iby_bepinfo.Suffix%TYPE,
191: x_bepid_out OUT NOCOPY iby_bepinfo.BepId%TYPE,
192: x_bep_url_out OUT NOCOPY iby_bepinfo.BaseUrl%TYPE,
193: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,

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

216: /* Internal procedure that gets the bep configuration by */
217: /* the order_id for a non-SET bep (since it looks in the */
218: /* IBY_TRANSACTIONS table). */
219: /* PROCEDURE getBepByOrderId
220: (order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
221: payee_id_in IN IBY_Payee.PayeeID%TYPE,
222: o_bepid OUT NOCOPY IBY_BEPInfo.BEPID%TYPE,
223: o_suffix OUT NOCOPY IBY_BEPInfo.Suffix%TYPE,
224: o_bep_base_url OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,

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

228: /* Internal procedure that gets the bep configuration by */
229: /* the order_id for a SET bep (since it looks in the */
230: /* IBY_TRANSACTIONS_SET table). */
231: /* PROCEDURE getBepByOrderId_SET
232: (order_id_in IN iby_trxn_summaries_all.TangibleID%TYPE,
233: payee_id_in IN IBY_Payee.PayeeID%TYPE,
234: v_id IN OUT NOCOPY IBY_BEPInfo.BEPID%TYPE,
235: v_suffix IN OUT NOCOPY IBY_BEPInfo.Suffix%TYPE,
236: v_base_url IN OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,

Line 302: i_payment_channel_code IN iby_trxn_summaries_all.payment_channel_code%type,

298: o_bepkey OUT NOCOPY iby_bepkeys.key%type,
299: o_fc_user_profile_code IN OUT NOCOPY VARCHAR2);
300:
301: PROCEDURE getDefaultBepId(i_mpayeeid IN iby_payee.mpayeeid%type,
302: i_payment_channel_code IN iby_trxn_summaries_all.payment_channel_code%type,
303: o_bepid OUT NOCOPY iby_bepinfo.bepid%type,
304: o_bepkey OUT NOCOPY iby_bepkeys.key%type,
305: o_fndcpt_user_profile_code OUT NOCOPY
306: IBY_FNDCPT_USER_CC_PF_VL.USER_CC_PROFILE_CODE%TYPE);

Line 319: p_amount IN iby_trxn_summaries_all.amount%type default null,

315: o_beptype OUT NOCOPY iby_bepinfo.bep_type%TYPE,
316: o_leadtime OUT NOCOPY iby_bepinfo.leadtime%TYPE);
317:
318: PROCEDURE populateRoutingFields(
319: p_amount IN iby_trxn_summaries_all.amount%type default null,
320: p_instr_type IN iby_trxn_summaries_all.instrtype%type
321: default null,
322: p_instr_subtype IN iby_trxn_summaries_all.instrsubtype%type
323: default null,

Line 320: p_instr_type IN iby_trxn_summaries_all.instrtype%type

316: o_leadtime OUT NOCOPY iby_bepinfo.leadtime%TYPE);
317:
318: PROCEDURE populateRoutingFields(
319: p_amount IN iby_trxn_summaries_all.amount%type default null,
320: p_instr_type IN iby_trxn_summaries_all.instrtype%type
321: default null,
322: p_instr_subtype IN iby_trxn_summaries_all.instrsubtype%type
323: default null,
324: p_currency IN iby_trxn_summaries_all.currencynamecode%type

Line 322: p_instr_subtype IN iby_trxn_summaries_all.instrsubtype%type

318: PROCEDURE populateRoutingFields(
319: p_amount IN iby_trxn_summaries_all.amount%type default null,
320: p_instr_type IN iby_trxn_summaries_all.instrtype%type
321: default null,
322: p_instr_subtype IN iby_trxn_summaries_all.instrsubtype%type
323: default null,
324: p_currency IN iby_trxn_summaries_all.currencynamecode%type
325: default null,
326: p_payee_id IN iby_trxn_summaries_all.payeeid%type default null,

Line 324: p_currency IN iby_trxn_summaries_all.currencynamecode%type

320: p_instr_type IN iby_trxn_summaries_all.instrtype%type
321: default null,
322: p_instr_subtype IN iby_trxn_summaries_all.instrsubtype%type
323: default null,
324: p_currency IN iby_trxn_summaries_all.currencynamecode%type
325: default null,
326: p_payee_id IN iby_trxn_summaries_all.payeeid%type default null,
327: p_cc_type IN VARCHAR2 default null,
328: p_cc_num IN iby_creditcard.ccnumber%type default null,

Line 326: p_payee_id IN iby_trxn_summaries_all.payeeid%type default null,

322: p_instr_subtype IN iby_trxn_summaries_all.instrsubtype%type
323: default null,
324: p_currency IN iby_trxn_summaries_all.currencynamecode%type
325: default null,
326: p_payee_id IN iby_trxn_summaries_all.payeeid%type default null,
327: p_cc_type IN VARCHAR2 default null,
328: p_cc_num IN iby_creditcard.ccnumber%type default null,
329: p_aba_routing_no IN iby_bankacct.routingno%type default null,
330: p_bnf_routing_no IN iby_bankacct.routingno%type default null,

Line 331: p_org_id IN iby_trxn_summaries_all.org_id%type default null,

327: p_cc_type IN VARCHAR2 default null,
328: p_cc_num IN iby_creditcard.ccnumber%type default null,
329: p_aba_routing_no IN iby_bankacct.routingno%type default null,
330: p_bnf_routing_no IN iby_bankacct.routingno%type default null,
331: p_org_id IN iby_trxn_summaries_all.org_id%type default null,
332: p_fin_app_type IN VARCHAR2 default null,
333: p_merchant_bank_country IN VARCHAR2,
334: p_factor_flag IN iby_trxn_summaries_all.factored_flag%type,
335: x_routingfields OUT NOCOPY RoutingAPIFields_rec_type

Line 334: p_factor_flag IN iby_trxn_summaries_all.factored_flag%type,

330: p_bnf_routing_no IN iby_bankacct.routingno%type default null,
331: p_org_id IN iby_trxn_summaries_all.org_id%type default null,
332: p_fin_app_type IN VARCHAR2 default null,
333: p_merchant_bank_country IN VARCHAR2,
334: p_factor_flag IN iby_trxn_summaries_all.factored_flag%type,
335: x_routingfields OUT NOCOPY RoutingAPIFields_rec_type
336: );
337:
338: END iby_paymentmanagerdb_pkg;