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_PAYMENTMANAGERDB_PKG dependencies on IBY_TRXN_SUMMARIES_ALL

Line 87: p_amount IN iby_trxn_summaries_all.amount%type

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

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

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

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

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

Line 91: p_payee_id IN iby_trxn_summaries_all.payeeid%type

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

Line 98: p_org_id IN iby_trxn_summaries_all.org_id%type

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

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

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

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

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

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

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

Line 109: p_br_signed_flag IN iby_trxn_summaries_all.br_signed_flag%TYPE,

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

Line 110: p_br_drawee_issued_flag IN iby_trxn_summaries_all.br_drawee_issued_flag%TYPE,

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

Line 111: p_ar_receipt_mth_id IN iby_trxn_summaries_all.ar_receipt_method_id%TYPE,

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

Line 136: p_amount IN iby_trxn_summaries_all.amount%type

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

Line 138: p_payment_channel_code IN iby_trxn_summaries_all.payment_channel_code%type,

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

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

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

Line 140: p_payee_id IN iby_trxn_summaries_all.payeeid%type

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

Line 147: p_org_id IN iby_trxn_summaries_all.org_id%type

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

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

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

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

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

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

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

Line 158: p_br_signed_flag IN iby_trxn_summaries_all.br_signed_flag%TYPE,

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

Line 159: p_br_drawee_issued_flag IN iby_trxn_summaries_all.br_drawee_issued_flag%TYPE,

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

Line 160: p_ar_receipt_mth_id IN iby_trxn_summaries_all.ar_receipt_method_id%TYPE,

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

Line 192: p_instr_type IN iby_trxn_summaries_all.InstrType%TYPE,

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

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

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

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

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

Line 305: i_payment_channel_code IN iby_trxn_summaries_all.payment_channel_code%type,

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

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

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

Line 323: p_instr_type IN iby_trxn_summaries_all.instrtype%type

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

Line 325: p_instr_subtype IN iby_trxn_summaries_all.instrsubtype%type

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

Line 327: p_currency IN iby_trxn_summaries_all.currencynamecode%type

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

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

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

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

330: p_cc_type IN VARCHAR2 default null,
331: p_cc_num IN iby_creditcard.ccnumber%type default null,
332: p_aba_routing_no IN iby_bankacct.routingno%type default null,
333: p_bnf_routing_no IN iby_bankacct.routingno%type default null,
334: p_org_id IN iby_trxn_summaries_all.org_id%type default null,
335: p_fin_app_type IN VARCHAR2 default null,
336: p_merchant_bank_country IN VARCHAR2,
337: p_factor_flag IN iby_trxn_summaries_all.factored_flag%type,
338: p_payer_bank_country IN VARCHAR2,

Line 337: p_factor_flag IN iby_trxn_summaries_all.factored_flag%type,

333: p_bnf_routing_no IN iby_bankacct.routingno%type default null,
334: p_org_id IN iby_trxn_summaries_all.org_id%type default null,
335: p_fin_app_type IN VARCHAR2 default null,
336: p_merchant_bank_country IN VARCHAR2,
337: p_factor_flag IN iby_trxn_summaries_all.factored_flag%type,
338: p_payer_bank_country IN VARCHAR2,
339: x_routingfields OUT NOCOPY RoutingAPIFields_rec_type
340: );
341: