DBA Data[Home] [Help]

APPS.IBY_PAYMENTMANAGERDB_PKG dependencies on IBY_PAYEE

Line 45: /* id corresponding to PAYEE_ID in the IBY_PAYEE */

41: /* - For all other operations, go by the order_id */
42: /* */
43: /* The parameters are the following: */
44: /* - PayeeID_in: an IN parameter with the */
45: /* id corresponding to PAYEE_ID in the IBY_PAYEE */
46: /* table. */
47: /* - order_id_in: an IN parameter with the order_id of the */
48: /* current trxn. */
49: /* - payment_name_in: an optional IN parameter, routing rule */

Line 112: px_payee_id_in_out IN OUT NOCOPY iby_payee.PayeeID%TYPE,

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,
116: x_payee_username_out OUT NOCOPY iby_payee.Username%TYPE,

Line 116: x_payee_username_out OUT NOCOPY iby_payee.Username%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,
116: x_payee_username_out OUT NOCOPY iby_payee.Username%TYPE,
117: x_payee_passwd_out OUT NOCOPY iby_payee.Password%TYPE,
118: x_payee_operation_out OUT NOCOPY NUMBER,
119: x_bepid_out OUT NOCOPY iby_BEPInfo.BEPID%TYPE,
120: x_bep_suffix_out OUT NOCOPY IBY_BEPInfo.Suffix%TYPE,

Line 117: x_payee_passwd_out OUT NOCOPY iby_payee.Password%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,
116: x_payee_username_out OUT NOCOPY iby_payee.Username%TYPE,
117: x_payee_passwd_out OUT NOCOPY iby_payee.Password%TYPE,
118: x_payee_operation_out OUT NOCOPY NUMBER,
119: x_bepid_out OUT NOCOPY iby_BEPInfo.BEPID%TYPE,
120: x_bep_suffix_out OUT NOCOPY IBY_BEPInfo.Suffix%TYPE,
121: x_bep_url_out OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,

Line 161: px_payee_id_in_out IN OUT NOCOPY iby_payee.PayeeID%TYPE,

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,
165: x_payee_username_out OUT NOCOPY iby_payee.Username%TYPE,

Line 165: x_payee_username_out OUT NOCOPY iby_payee.Username%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,
165: x_payee_username_out OUT NOCOPY iby_payee.Username%TYPE,
166: x_payee_passwd_out OUT NOCOPY iby_payee.Password%TYPE,
167: x_payee_operation_out OUT NOCOPY NUMBER,
168: x_bepid_out OUT NOCOPY iby_BEPInfo.BEPID%TYPE,
169: x_bep_suffix_out OUT NOCOPY IBY_BEPInfo.Suffix%TYPE,

Line 166: x_payee_passwd_out OUT NOCOPY iby_payee.Password%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,
165: x_payee_username_out OUT NOCOPY iby_payee.Username%TYPE,
166: x_payee_passwd_out OUT NOCOPY iby_payee.Password%TYPE,
167: x_payee_operation_out OUT NOCOPY NUMBER,
168: x_bepid_out OUT NOCOPY iby_BEPInfo.BEPID%TYPE,
169: x_bep_suffix_out OUT NOCOPY IBY_BEPInfo.Suffix%TYPE,
170: x_bep_url_out OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,

Line 224: payee_id_in IN IBY_Payee.PayeeID%TYPE,

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,
228: o_pmtschemeName OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,

Line 236: payee_id_in IN IBY_Payee.PayeeID%TYPE,

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,
240: v_pmtscheme IN OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE);

Line 268: PROCEDURE checkPayeeByAccpPmtMthd(i_payeeid iby_payee.payeeid%type,

264: /* Procedure: checkPayeeByAccpPmtMthd
265: * Function: to make sure given instrument type is supported by payee
266: */
267:
268: PROCEDURE checkPayeeByAccpPmtMthd(i_payeeid iby_payee.payeeid%type,
269: i_instr_type iby_accttype.instrtype%type);
270:
271:
272: /* Procedure: getBEPLang

Line 299: i_payeeid IN iby_payee.payeeid%type,

295: i_suffix IN iby_bepinfo.suffix%type,
296: o_bep_url OUT NOCOPY VARCHAR2);
297:
298: PROCEDURE getBepIdByPmtName(i_paymentmethodname IN VARCHAR2,
299: i_payeeid IN iby_payee.payeeid%type,
300: o_bepid OUT NOCOPY iby_bepinfo.bepid%type,
301: o_bepkey OUT NOCOPY iby_bepkeys.key%type,
302: o_fc_user_profile_code IN OUT NOCOPY VARCHAR2);
303:

Line 304: PROCEDURE getDefaultBepId(i_mpayeeid IN iby_payee.mpayeeid%type,

300: o_bepid OUT NOCOPY iby_bepinfo.bepid%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