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 15: p_amount IN iby_trxn_summaries_all.amount%type,

11: --IN: 1-15
12: --OUT: 12-28
13:
14: PROCEDURE listbep (
15: p_amount IN iby_trxn_summaries_all.amount%type,
16: p_payment_channel_code IN iby_trxn_summaries_all.payment_channel_code%type,
17: p_currency IN iby_trxn_summaries_all.currencynamecode%type,
18: p_payee_id IN iby_trxn_summaries_all.payeeid%type,
19: p_cc_type IN VARCHAR2,

Line 16: p_payment_channel_code IN iby_trxn_summaries_all.payment_channel_code%type,

12: --OUT: 12-28
13:
14: PROCEDURE listbep (
15: p_amount IN iby_trxn_summaries_all.amount%type,
16: p_payment_channel_code IN iby_trxn_summaries_all.payment_channel_code%type,
17: p_currency IN iby_trxn_summaries_all.currencynamecode%type,
18: p_payee_id IN iby_trxn_summaries_all.payeeid%type,
19: p_cc_type IN VARCHAR2,
20: p_cc_num IN iby_creditcard.ccnumber%type,

Line 17: p_currency IN iby_trxn_summaries_all.currencynamecode%type,

13:
14: PROCEDURE listbep (
15: p_amount IN iby_trxn_summaries_all.amount%type,
16: p_payment_channel_code IN iby_trxn_summaries_all.payment_channel_code%type,
17: p_currency IN iby_trxn_summaries_all.currencynamecode%type,
18: p_payee_id IN iby_trxn_summaries_all.payeeid%type,
19: p_cc_type IN VARCHAR2,
20: p_cc_num IN iby_creditcard.ccnumber%type,
21: p_aba_routing_no IN iby_bankacct.routingno%type,

Line 18: p_payee_id IN iby_trxn_summaries_all.payeeid%type,

14: PROCEDURE listbep (
15: p_amount IN iby_trxn_summaries_all.amount%type,
16: p_payment_channel_code IN iby_trxn_summaries_all.payment_channel_code%type,
17: p_currency IN iby_trxn_summaries_all.currencynamecode%type,
18: p_payee_id IN iby_trxn_summaries_all.payeeid%type,
19: p_cc_type IN VARCHAR2,
20: p_cc_num IN iby_creditcard.ccnumber%type,
21: p_aba_routing_no IN iby_bankacct.routingno%type,
22: p_org_id IN iby_trxn_summaries_all.org_id%type,

Line 22: p_org_id IN iby_trxn_summaries_all.org_id%type,

18: p_payee_id IN iby_trxn_summaries_all.payeeid%type,
19: p_cc_type IN VARCHAR2,
20: p_cc_num IN iby_creditcard.ccnumber%type,
21: p_aba_routing_no IN iby_bankacct.routingno%type,
22: p_org_id IN iby_trxn_summaries_all.org_id%type,
23: p_fin_app_type IN VARCHAR2,
24: p_transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE,
25: p_payment_operation_in IN VARCHAR2,
26: p_ecappid_in IN iby_ecapp.ecappid%type,

Line 24: p_transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE,

20: p_cc_num IN iby_creditcard.ccnumber%type,
21: p_aba_routing_no IN iby_bankacct.routingno%type,
22: p_org_id IN iby_trxn_summaries_all.org_id%type,
23: p_fin_app_type IN VARCHAR2,
24: p_transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE,
25: p_payment_operation_in IN VARCHAR2,
26: p_ecappid_in IN iby_ecapp.ecappid%type,
27: p_instr_subtype IN iby_trxn_summaries_all.instrsubtype%type,
28: p_bnf_routing_no IN iby_bankacct.routingno%type,

Line 27: p_instr_subtype IN iby_trxn_summaries_all.instrsubtype%type,

23: p_fin_app_type IN VARCHAR2,
24: p_transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE,
25: p_payment_operation_in IN VARCHAR2,
26: p_ecappid_in IN iby_ecapp.ecappid%type,
27: p_instr_subtype IN iby_trxn_summaries_all.instrsubtype%type,
28: p_bnf_routing_no IN iby_bankacct.routingno%type,
29: p_factored_flag IN iby_trxn_summaries_all.factored_flag%type,
30: p_int_bank_acct_id IN NUMBER,
31: p_br_signed_flag IN iby_trxn_summaries_all.br_signed_flag%TYPE,

Line 29: p_factored_flag IN iby_trxn_summaries_all.factored_flag%type,

25: p_payment_operation_in IN VARCHAR2,
26: p_ecappid_in IN iby_ecapp.ecappid%type,
27: p_instr_subtype IN iby_trxn_summaries_all.instrsubtype%type,
28: p_bnf_routing_no IN iby_bankacct.routingno%type,
29: p_factored_flag IN iby_trxn_summaries_all.factored_flag%type,
30: p_int_bank_acct_id IN NUMBER,
31: p_br_signed_flag IN iby_trxn_summaries_all.br_signed_flag%TYPE,
32: p_br_drawee_issued_flag IN iby_trxn_summaries_all.br_drawee_issued_flag%TYPE,
33: p_ar_receipt_mth_id IN iby_trxn_summaries_all.ar_receipt_method_id%TYPE,

Line 31: p_br_signed_flag IN iby_trxn_summaries_all.br_signed_flag%TYPE,

27: p_instr_subtype IN iby_trxn_summaries_all.instrsubtype%type,
28: p_bnf_routing_no IN iby_bankacct.routingno%type,
29: p_factored_flag IN iby_trxn_summaries_all.factored_flag%type,
30: p_int_bank_acct_id IN NUMBER,
31: p_br_signed_flag IN iby_trxn_summaries_all.br_signed_flag%TYPE,
32: p_br_drawee_issued_flag IN iby_trxn_summaries_all.br_drawee_issued_flag%TYPE,
33: p_ar_receipt_mth_id IN iby_trxn_summaries_all.ar_receipt_method_id%TYPE,
34: px_payee_id_in_out IN OUT NOCOPY iby_payee.PayeeID%TYPE,
35: px_order_id_in_out IN OUT NOCOPY VARCHAR2,

Line 32: p_br_drawee_issued_flag IN iby_trxn_summaries_all.br_drawee_issued_flag%TYPE,

28: p_bnf_routing_no IN iby_bankacct.routingno%type,
29: p_factored_flag IN iby_trxn_summaries_all.factored_flag%type,
30: p_int_bank_acct_id IN NUMBER,
31: p_br_signed_flag IN iby_trxn_summaries_all.br_signed_flag%TYPE,
32: p_br_drawee_issued_flag IN iby_trxn_summaries_all.br_drawee_issued_flag%TYPE,
33: p_ar_receipt_mth_id IN iby_trxn_summaries_all.ar_receipt_method_id%TYPE,
34: px_payee_id_in_out IN OUT NOCOPY iby_payee.PayeeID%TYPE,
35: px_order_id_in_out IN OUT NOCOPY VARCHAR2,
36: px_payment_name_in_out IN OUT NOCOPY VARCHAR2,

Line 33: p_ar_receipt_mth_id IN iby_trxn_summaries_all.ar_receipt_method_id%TYPE,

29: p_factored_flag IN iby_trxn_summaries_all.factored_flag%type,
30: p_int_bank_acct_id IN NUMBER,
31: p_br_signed_flag IN iby_trxn_summaries_all.br_signed_flag%TYPE,
32: p_br_drawee_issued_flag IN iby_trxn_summaries_all.br_drawee_issued_flag%TYPE,
33: p_ar_receipt_mth_id IN iby_trxn_summaries_all.ar_receipt_method_id%TYPE,
34: px_payee_id_in_out IN OUT NOCOPY iby_payee.PayeeID%TYPE,
35: px_order_id_in_out IN OUT NOCOPY VARCHAR2,
36: px_payment_name_in_out IN OUT NOCOPY VARCHAR2,
37: px_bep_lang_in_out IN OUT NOCOPY VARCHAR2,

Line 101: p_amount IN iby_trxn_summaries_all.amount%type,

97:
98: END listbep;
99:
100: PROCEDURE listbep (
101: p_amount IN iby_trxn_summaries_all.amount%type,
102: p_payment_channel_code IN iby_trxn_summaries_all.payment_channel_code%type,
103: p_currency IN iby_trxn_summaries_all.currencynamecode%type,
104: p_payee_id IN iby_trxn_summaries_all.payeeid%type,
105: p_cc_type IN VARCHAR2,

Line 102: p_payment_channel_code IN iby_trxn_summaries_all.payment_channel_code%type,

98: END listbep;
99:
100: PROCEDURE listbep (
101: p_amount IN iby_trxn_summaries_all.amount%type,
102: p_payment_channel_code IN iby_trxn_summaries_all.payment_channel_code%type,
103: p_currency IN iby_trxn_summaries_all.currencynamecode%type,
104: p_payee_id IN iby_trxn_summaries_all.payeeid%type,
105: p_cc_type IN VARCHAR2,
106: p_cc_num IN iby_creditcard.ccnumber%type,

Line 103: p_currency IN iby_trxn_summaries_all.currencynamecode%type,

99:
100: PROCEDURE listbep (
101: p_amount IN iby_trxn_summaries_all.amount%type,
102: p_payment_channel_code IN iby_trxn_summaries_all.payment_channel_code%type,
103: p_currency IN iby_trxn_summaries_all.currencynamecode%type,
104: p_payee_id IN iby_trxn_summaries_all.payeeid%type,
105: p_cc_type IN VARCHAR2,
106: p_cc_num IN iby_creditcard.ccnumber%type,
107: p_aba_routing_no IN iby_bankacct.routingno%type,

Line 104: p_payee_id IN iby_trxn_summaries_all.payeeid%type,

100: PROCEDURE listbep (
101: p_amount IN iby_trxn_summaries_all.amount%type,
102: p_payment_channel_code IN iby_trxn_summaries_all.payment_channel_code%type,
103: p_currency IN iby_trxn_summaries_all.currencynamecode%type,
104: p_payee_id IN iby_trxn_summaries_all.payeeid%type,
105: p_cc_type IN VARCHAR2,
106: p_cc_num IN iby_creditcard.ccnumber%type,
107: p_aba_routing_no IN iby_bankacct.routingno%type,
108: p_org_id IN iby_trxn_summaries_all.org_id%type,

Line 108: p_org_id IN iby_trxn_summaries_all.org_id%type,

104: p_payee_id IN iby_trxn_summaries_all.payeeid%type,
105: p_cc_type IN VARCHAR2,
106: p_cc_num IN iby_creditcard.ccnumber%type,
107: p_aba_routing_no IN iby_bankacct.routingno%type,
108: p_org_id IN iby_trxn_summaries_all.org_id%type,
109: p_fin_app_type IN VARCHAR2,
110: p_transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE,
111: p_payment_operation_in IN VARCHAR2,
112: p_ecappid_in IN iby_ecapp.ecappid%type,

Line 110: p_transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE,

106: p_cc_num IN iby_creditcard.ccnumber%type,
107: p_aba_routing_no IN iby_bankacct.routingno%type,
108: p_org_id IN iby_trxn_summaries_all.org_id%type,
109: p_fin_app_type IN VARCHAR2,
110: p_transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE,
111: p_payment_operation_in IN VARCHAR2,
112: p_ecappid_in IN iby_ecapp.ecappid%type,
113: p_instr_subtype IN iby_trxn_summaries_all.instrsubtype%type,
114: p_bnf_routing_no IN iby_bankacct.routingno%type,

Line 113: p_instr_subtype IN iby_trxn_summaries_all.instrsubtype%type,

109: p_fin_app_type IN VARCHAR2,
110: p_transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE,
111: p_payment_operation_in IN VARCHAR2,
112: p_ecappid_in IN iby_ecapp.ecappid%type,
113: p_instr_subtype IN iby_trxn_summaries_all.instrsubtype%type,
114: p_bnf_routing_no IN iby_bankacct.routingno%type,
115: p_merchant_bank_country IN VARCHAR2,
116: p_factored_flag IN iby_trxn_summaries_all.factored_flag%type,
117: p_int_bank_acct_id IN NUMBER,

Line 116: p_factored_flag IN iby_trxn_summaries_all.factored_flag%type,

112: p_ecappid_in IN iby_ecapp.ecappid%type,
113: p_instr_subtype IN iby_trxn_summaries_all.instrsubtype%type,
114: p_bnf_routing_no IN iby_bankacct.routingno%type,
115: p_merchant_bank_country IN VARCHAR2,
116: p_factored_flag IN iby_trxn_summaries_all.factored_flag%type,
117: p_int_bank_acct_id IN NUMBER,
118: p_br_signed_flag IN iby_trxn_summaries_all.br_signed_flag%TYPE,
119: p_br_drawee_issued_flag IN iby_trxn_summaries_all.br_drawee_issued_flag%TYPE,
120: p_ar_receipt_mth_id IN iby_trxn_summaries_all.ar_receipt_method_id%TYPE,

Line 118: p_br_signed_flag IN iby_trxn_summaries_all.br_signed_flag%TYPE,

114: p_bnf_routing_no IN iby_bankacct.routingno%type,
115: p_merchant_bank_country IN VARCHAR2,
116: p_factored_flag IN iby_trxn_summaries_all.factored_flag%type,
117: p_int_bank_acct_id IN NUMBER,
118: p_br_signed_flag IN iby_trxn_summaries_all.br_signed_flag%TYPE,
119: p_br_drawee_issued_flag IN iby_trxn_summaries_all.br_drawee_issued_flag%TYPE,
120: p_ar_receipt_mth_id IN iby_trxn_summaries_all.ar_receipt_method_id%TYPE,
121: px_payee_id_in_out IN OUT NOCOPY iby_payee.PayeeID%TYPE,
122: px_order_id_in_out IN OUT NOCOPY VARCHAR2,

Line 119: p_br_drawee_issued_flag IN iby_trxn_summaries_all.br_drawee_issued_flag%TYPE,

115: p_merchant_bank_country IN VARCHAR2,
116: p_factored_flag IN iby_trxn_summaries_all.factored_flag%type,
117: p_int_bank_acct_id IN NUMBER,
118: p_br_signed_flag IN iby_trxn_summaries_all.br_signed_flag%TYPE,
119: p_br_drawee_issued_flag IN iby_trxn_summaries_all.br_drawee_issued_flag%TYPE,
120: p_ar_receipt_mth_id IN iby_trxn_summaries_all.ar_receipt_method_id%TYPE,
121: px_payee_id_in_out IN OUT NOCOPY iby_payee.PayeeID%TYPE,
122: px_order_id_in_out IN OUT NOCOPY VARCHAR2,
123: px_payment_name_in_out IN OUT NOCOPY VARCHAR2,

Line 120: p_ar_receipt_mth_id IN iby_trxn_summaries_all.ar_receipt_method_id%TYPE,

116: p_factored_flag IN iby_trxn_summaries_all.factored_flag%type,
117: p_int_bank_acct_id IN NUMBER,
118: p_br_signed_flag IN iby_trxn_summaries_all.br_signed_flag%TYPE,
119: p_br_drawee_issued_flag IN iby_trxn_summaries_all.br_drawee_issued_flag%TYPE,
120: p_ar_receipt_mth_id IN iby_trxn_summaries_all.ar_receipt_method_id%TYPE,
121: px_payee_id_in_out IN OUT NOCOPY iby_payee.PayeeID%TYPE,
122: px_order_id_in_out IN OUT NOCOPY VARCHAR2,
123: px_payment_name_in_out IN OUT NOCOPY VARCHAR2,
124: px_bep_lang_in_out IN OUT NOCOPY VARCHAR2,

Line 159: l_instr_type iby_trxn_summaries_all.instrtype%TYPE;

155: l_bepname iby_bepinfo.name%type;
156:
157: -- *** R12 Modification *** ---
158: -- Added variables l_instr_type and l_mpayeeid
159: l_instr_type iby_trxn_summaries_all.instrtype%TYPE;
160: l_mpayeeid iby_payee.mpayeeid%TYPE;
161: l_bank_id ce_bank_accounts_v.bank_id%TYPE;
162:
163: BEGIN

Line 340: FROM iby_trxn_summaries_all a, iby_tangible b

336: -- [bug # 1925098]
337: --
338: l_routing_fields.instr_type, x_bep_key_out,
339: x_fndcpt_user_profile_code_out
340: FROM iby_trxn_summaries_all a, iby_tangible b
341: WHERE TransactionID = p_transaction_id_in
342: AND a.mtangibleid = b.mtangibleid
343: -- previously must have succeeded ones
344: -- 100 is for processors, indicating it is in an open batch

Line 456: p_instr_type IN iby_trxn_summaries_all.InstrType%TYPE,

452:
453: PROCEDURE listbep (
454: p_payee_id IN iby_bepkeys.OwnerId%TYPE,
455: p_bepkey IN iby_bepkeys.KEY%TYPE,
456: p_instr_type IN iby_trxn_summaries_all.InstrType%TYPE,
457: px_bep_suffix_in_out IN OUT NOCOPY iby_bepinfo.Suffix%TYPE,
458: x_bepid_out OUT NOCOPY iby_bepinfo.BepId%TYPE,
459: x_bep_url_out OUT NOCOPY iby_bepinfo.BaseUrl%TYPE,
460: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,

Line 470: l_op_type iby_trxn_summaries_all.reqtype%TYPE;

466: x_bep_lang_out OUT NOCOPY VARCHAR2,
467: x_lead_time_out OUT NOCOPY iby_bepinfo.leadtime%TYPE
468: )
469: IS
470: l_op_type iby_trxn_summaries_all.reqtype%TYPE;
471: l_base_url IBY_BEPInfo.BaseURL%TYPE;
472: l_key_count NUMBER;
473:
474: BEGIN

Line 1207: i_payment_channel_code IN iby_trxn_summaries_all.payment_channel_code%type,

1203:
1204: END getBepIdByPmtName;
1205:
1206: PROCEDURE getDefaultBepId(i_mpayeeid IN iby_payee.mpayeeid%type,
1207: i_payment_channel_code IN iby_trxn_summaries_all.payment_channel_code%type,
1208: o_bepid OUT NOCOPY iby_bepinfo.bepid%type,
1209: o_bepkey OUT NOCOPY iby_bepkeys.key%type,
1210: o_fndcpt_user_profile_code OUT NOCOPY
1211: IBY_FNDCPT_USER_CC_PF_VL.USER_CC_PROFILE_CODE%TYPE)

Line 1217: ci_payment_channel_code iby_trxn_summaries_all.payment_channel_code%type)

1213: -- *** R12 Modification *** ---
1214: -- Cursor retrieves default bep key and FndcptUserProfileCode
1215: -- given the mpayeeid and payment channel code
1216: CURSOR c_defaultBep(ci_mpayeeid iby_payee.mpayeeid%type,
1217: ci_payment_channel_code iby_trxn_summaries_all.payment_channel_code%type)
1218: IS
1219: SELECT a.bepid,
1220: c.key,
1221: a.fndcpt_user_profile_code

Line 1276: p_amount IN iby_trxn_summaries_all.amount%type,

1272: close c_getBepById;
1273: END getBepById;
1274:
1275: PROCEDURE populateRoutingFields(
1276: p_amount IN iby_trxn_summaries_all.amount%type,
1277: p_instr_type IN iby_trxn_summaries_all.instrtype%type,
1278: p_instr_subtype IN iby_trxn_summaries_all.instrsubtype%type,
1279: p_currency IN iby_trxn_summaries_all.currencynamecode%type,
1280: p_payee_id IN iby_trxn_summaries_all.payeeid%type,

Line 1277: p_instr_type IN iby_trxn_summaries_all.instrtype%type,

1273: END getBepById;
1274:
1275: PROCEDURE populateRoutingFields(
1276: p_amount IN iby_trxn_summaries_all.amount%type,
1277: p_instr_type IN iby_trxn_summaries_all.instrtype%type,
1278: p_instr_subtype IN iby_trxn_summaries_all.instrsubtype%type,
1279: p_currency IN iby_trxn_summaries_all.currencynamecode%type,
1280: p_payee_id IN iby_trxn_summaries_all.payeeid%type,
1281: p_cc_type IN VARCHAR2,

Line 1278: p_instr_subtype IN iby_trxn_summaries_all.instrsubtype%type,

1274:
1275: PROCEDURE populateRoutingFields(
1276: p_amount IN iby_trxn_summaries_all.amount%type,
1277: p_instr_type IN iby_trxn_summaries_all.instrtype%type,
1278: p_instr_subtype IN iby_trxn_summaries_all.instrsubtype%type,
1279: p_currency IN iby_trxn_summaries_all.currencynamecode%type,
1280: p_payee_id IN iby_trxn_summaries_all.payeeid%type,
1281: p_cc_type IN VARCHAR2,
1282: p_cc_num IN iby_creditcard.ccnumber%type,

Line 1279: p_currency IN iby_trxn_summaries_all.currencynamecode%type,

1275: PROCEDURE populateRoutingFields(
1276: p_amount IN iby_trxn_summaries_all.amount%type,
1277: p_instr_type IN iby_trxn_summaries_all.instrtype%type,
1278: p_instr_subtype IN iby_trxn_summaries_all.instrsubtype%type,
1279: p_currency IN iby_trxn_summaries_all.currencynamecode%type,
1280: p_payee_id IN iby_trxn_summaries_all.payeeid%type,
1281: p_cc_type IN VARCHAR2,
1282: p_cc_num IN iby_creditcard.ccnumber%type,
1283: p_aba_routing_no IN iby_bankacct.routingno%type,

Line 1280: p_payee_id IN iby_trxn_summaries_all.payeeid%type,

1276: p_amount IN iby_trxn_summaries_all.amount%type,
1277: p_instr_type IN iby_trxn_summaries_all.instrtype%type,
1278: p_instr_subtype IN iby_trxn_summaries_all.instrsubtype%type,
1279: p_currency IN iby_trxn_summaries_all.currencynamecode%type,
1280: p_payee_id IN iby_trxn_summaries_all.payeeid%type,
1281: p_cc_type IN VARCHAR2,
1282: p_cc_num IN iby_creditcard.ccnumber%type,
1283: p_aba_routing_no IN iby_bankacct.routingno%type,
1284: p_bnf_routing_no IN iby_bankacct.routingno%type,

Line 1285: p_org_id IN iby_trxn_summaries_all.org_id%type,

1281: p_cc_type IN VARCHAR2,
1282: p_cc_num IN iby_creditcard.ccnumber%type,
1283: p_aba_routing_no IN iby_bankacct.routingno%type,
1284: p_bnf_routing_no IN iby_bankacct.routingno%type,
1285: p_org_id IN iby_trxn_summaries_all.org_id%type,
1286: p_fin_app_type IN VARCHAR2,
1287: p_merchant_bank_country IN VARCHAR2,
1288: p_factor_flag IN iby_trxn_summaries_all.factored_flag%type,
1289: x_routingfields OUT NOCOPY RoutingAPIFields_rec_type

Line 1288: p_factor_flag IN iby_trxn_summaries_all.factored_flag%type,

1284: p_bnf_routing_no IN iby_bankacct.routingno%type,
1285: p_org_id IN iby_trxn_summaries_all.org_id%type,
1286: p_fin_app_type IN VARCHAR2,
1287: p_merchant_bank_country IN VARCHAR2,
1288: p_factor_flag IN iby_trxn_summaries_all.factored_flag%type,
1289: x_routingfields OUT NOCOPY RoutingAPIFields_rec_type
1290: )
1291: IS
1292: