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

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

Line 103: p_payment_channel_code IN iby_trxn_summaries_all.payment_channel_code%type,

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

Line 104: p_currency IN iby_trxn_summaries_all.currencynamecode%type,

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

Line 105: p_payee_id IN iby_trxn_summaries_all.payeeid%type,

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

Line 109: p_org_id IN iby_trxn_summaries_all.org_id%type,

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

Line 111: p_transaction_id_in IN iby_trxn_summaries_all.TransactionID%TYPE,

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

Line 114: p_instr_subtype IN iby_trxn_summaries_all.instrsubtype%type,

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

Line 117: p_factored_flag IN iby_trxn_summaries_all.factored_flag%type,

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

Line 119: p_br_signed_flag IN iby_trxn_summaries_all.br_signed_flag%TYPE,

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

Line 120: p_br_drawee_issued_flag IN iby_trxn_summaries_all.br_drawee_issued_flag%TYPE,

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

Line 121: p_ar_receipt_mth_id IN iby_trxn_summaries_all.ar_receipt_method_id%TYPE,

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

Line 161: l_instr_type iby_trxn_summaries_all.instrtype%TYPE;

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

Line 354: FROM iby_trxn_summaries_all a, iby_tangible b

350: -- [bug # 1925098]
351: --
352: l_routing_fields.instr_type, x_bep_key_out,
353: x_fndcpt_user_profile_code_out
354: FROM iby_trxn_summaries_all a, iby_tangible b
355: WHERE TransactionID = p_transaction_id_in
356: AND a.mtangibleid = b.mtangibleid
357: -- previously must have succeeded ones
358: -- 100 is for processors, indicating it is in an open batch

Line 474: p_instr_type IN iby_trxn_summaries_all.InstrType%TYPE,

470:
471: PROCEDURE listbep (
472: p_payee_id IN iby_bepkeys.OwnerId%TYPE,
473: p_bepkey IN iby_bepkeys.KEY%TYPE,
474: p_instr_type IN iby_trxn_summaries_all.InstrType%TYPE,
475: px_bep_suffix_in_out IN OUT NOCOPY iby_bepinfo.Suffix%TYPE,
476: x_bepid_out OUT NOCOPY iby_bepinfo.BepId%TYPE,
477: x_bep_url_out OUT NOCOPY iby_bepinfo.BaseUrl%TYPE,
478: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,

Line 488: l_op_type iby_trxn_summaries_all.reqtype%TYPE;

484: x_bep_lang_out OUT NOCOPY VARCHAR2,
485: x_lead_time_out OUT NOCOPY iby_bepinfo.leadtime%TYPE
486: )
487: IS
488: l_op_type iby_trxn_summaries_all.reqtype%TYPE;
489: l_base_url IBY_BEPInfo.BaseURL%TYPE;
490: l_key_count NUMBER;
491:
492: BEGIN

Line 1277: i_payment_channel_code IN iby_trxn_summaries_all.payment_channel_code%type,

1273:
1274: END getBepIdByPmtName;
1275:
1276: PROCEDURE getDefaultBepId(i_mpayeeid IN iby_payee.mpayeeid%type,
1277: i_payment_channel_code IN iby_trxn_summaries_all.payment_channel_code%type,
1278: o_bepid OUT NOCOPY iby_bepinfo.bepid%type,
1279: o_bepkey OUT NOCOPY iby_bepkeys.key%type,
1280: o_fndcpt_user_profile_code OUT NOCOPY
1281: IBY_FNDCPT_USER_CC_PF_VL.USER_CC_PROFILE_CODE%TYPE)

Line 1287: ci_payment_channel_code iby_trxn_summaries_all.payment_channel_code%type)

1283: -- *** R12 Modification *** ---
1284: -- Cursor retrieves default bep key and FndcptUserProfileCode
1285: -- given the mpayeeid and payment channel code
1286: CURSOR c_defaultBep(ci_mpayeeid iby_payee.mpayeeid%type,
1287: ci_payment_channel_code iby_trxn_summaries_all.payment_channel_code%type)
1288: IS
1289: SELECT a.bepid,
1290: c.key,
1291: a.fndcpt_user_profile_code

Line 1346: p_amount IN iby_trxn_summaries_all.amount%type,

1342: close c_getBepById;
1343: END getBepById;
1344:
1345: PROCEDURE populateRoutingFields(
1346: p_amount IN iby_trxn_summaries_all.amount%type,
1347: p_instr_type IN iby_trxn_summaries_all.instrtype%type,
1348: p_instr_subtype IN iby_trxn_summaries_all.instrsubtype%type,
1349: p_currency IN iby_trxn_summaries_all.currencynamecode%type,
1350: p_payee_id IN iby_trxn_summaries_all.payeeid%type,

Line 1347: p_instr_type IN iby_trxn_summaries_all.instrtype%type,

1343: END getBepById;
1344:
1345: PROCEDURE populateRoutingFields(
1346: p_amount IN iby_trxn_summaries_all.amount%type,
1347: p_instr_type IN iby_trxn_summaries_all.instrtype%type,
1348: p_instr_subtype IN iby_trxn_summaries_all.instrsubtype%type,
1349: p_currency IN iby_trxn_summaries_all.currencynamecode%type,
1350: p_payee_id IN iby_trxn_summaries_all.payeeid%type,
1351: p_cc_type IN VARCHAR2,

Line 1348: p_instr_subtype IN iby_trxn_summaries_all.instrsubtype%type,

1344:
1345: PROCEDURE populateRoutingFields(
1346: p_amount IN iby_trxn_summaries_all.amount%type,
1347: p_instr_type IN iby_trxn_summaries_all.instrtype%type,
1348: p_instr_subtype IN iby_trxn_summaries_all.instrsubtype%type,
1349: p_currency IN iby_trxn_summaries_all.currencynamecode%type,
1350: p_payee_id IN iby_trxn_summaries_all.payeeid%type,
1351: p_cc_type IN VARCHAR2,
1352: p_cc_num IN iby_creditcard.ccnumber%type,

Line 1349: p_currency IN iby_trxn_summaries_all.currencynamecode%type,

1345: PROCEDURE populateRoutingFields(
1346: p_amount IN iby_trxn_summaries_all.amount%type,
1347: p_instr_type IN iby_trxn_summaries_all.instrtype%type,
1348: p_instr_subtype IN iby_trxn_summaries_all.instrsubtype%type,
1349: p_currency IN iby_trxn_summaries_all.currencynamecode%type,
1350: p_payee_id IN iby_trxn_summaries_all.payeeid%type,
1351: p_cc_type IN VARCHAR2,
1352: p_cc_num IN iby_creditcard.ccnumber%type,
1353: p_aba_routing_no IN iby_bankacct.routingno%type,

Line 1350: p_payee_id IN iby_trxn_summaries_all.payeeid%type,

1346: p_amount IN iby_trxn_summaries_all.amount%type,
1347: p_instr_type IN iby_trxn_summaries_all.instrtype%type,
1348: p_instr_subtype IN iby_trxn_summaries_all.instrsubtype%type,
1349: p_currency IN iby_trxn_summaries_all.currencynamecode%type,
1350: p_payee_id IN iby_trxn_summaries_all.payeeid%type,
1351: p_cc_type IN VARCHAR2,
1352: p_cc_num IN iby_creditcard.ccnumber%type,
1353: p_aba_routing_no IN iby_bankacct.routingno%type,
1354: p_bnf_routing_no IN iby_bankacct.routingno%type,

Line 1355: p_org_id IN iby_trxn_summaries_all.org_id%type,

1351: p_cc_type IN VARCHAR2,
1352: p_cc_num IN iby_creditcard.ccnumber%type,
1353: p_aba_routing_no IN iby_bankacct.routingno%type,
1354: p_bnf_routing_no IN iby_bankacct.routingno%type,
1355: p_org_id IN iby_trxn_summaries_all.org_id%type,
1356: p_fin_app_type IN VARCHAR2,
1357: p_merchant_bank_country IN VARCHAR2,
1358: p_factor_flag IN iby_trxn_summaries_all.factored_flag%type,
1359: p_payer_bank_country IN VARCHAR2,

Line 1358: p_factor_flag IN iby_trxn_summaries_all.factored_flag%type,

1354: p_bnf_routing_no IN iby_bankacct.routingno%type,
1355: p_org_id IN iby_trxn_summaries_all.org_id%type,
1356: p_fin_app_type IN VARCHAR2,
1357: p_merchant_bank_country IN VARCHAR2,
1358: p_factor_flag IN iby_trxn_summaries_all.factored_flag%type,
1359: p_payer_bank_country IN VARCHAR2,
1360: x_routingfields OUT NOCOPY RoutingAPIFields_rec_type
1361: )
1362: IS