DBA Data[Home] [Help]

APPS.IBY_PAYMENTMANAGERDB_PKG dependencies on IBY_PAYEE

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

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

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

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

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

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

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

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

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

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

Line 221: payee_id_in IN IBY_Payee.PayeeID%TYPE,

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

Line 233: payee_id_in IN IBY_Payee.PayeeID%TYPE,

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

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

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

Line 296: i_payeeid IN iby_payee.payeeid%type,

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

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

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