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_BEPINFO

Line 55: /* IBY_BEPINFO table. */

51: /* - payment_operation_in: an IN parameter with the name of */
52: /* the current operation type, e.g., orainv, ORAPMTREQ */
53: /* - BEPID_out: an OUT parameter with the numeric value */
54: /* of the bep id corresponding to BEP_ID in the */
55: /* IBY_BEPINFO table. */
56: /* - bep_suffix_in: an OUT parameter of bep suffix. */
57: /* Corresponds to the SUFFIX column in the IBY_BEPINFO table*/
58: /* - bep_url_out: an OUT parameter that contains the URL */
59: /* to access the bep. It's a combination of the base */

Line 57: /* Corresponds to the SUFFIX column in the IBY_BEPINFO table*/

53: /* - BEPID_out: an OUT parameter with the numeric value */
54: /* of the bep id corresponding to BEP_ID in the */
55: /* IBY_BEPINFO table. */
56: /* - bep_suffix_in: an OUT parameter of bep suffix. */
57: /* Corresponds to the SUFFIX column in the IBY_BEPINFO table*/
58: /* - bep_url_out: an OUT parameter that contains the URL */
59: /* to access the bep. It's a combination of the base */
60: /* URL in the IBY_BEPINFO table, plus add'l info based upon */
61: /* the bep pmtscheme plus the trxn type. */

Line 60: /* URL in the IBY_BEPINFO table, plus add'l info based upon */

56: /* - bep_suffix_in: an OUT parameter of bep suffix. */
57: /* Corresponds to the SUFFIX column in the IBY_BEPINFO table*/
58: /* - bep_url_out: an OUT parameter that contains the URL */
59: /* to access the bep. It's a combination of the base */
60: /* URL in the IBY_BEPINFO table, plus add'l info based upon */
61: /* the bep pmtscheme plus the trxn type. */
62: /* - bep_key_out: an OUT parameter set up for this */
63: /* payee/bep combination, the KEY in the */
64: /* IBY_bepkey table. */

Line 119: x_bepid_out OUT NOCOPY iby_BEPInfo.BEPID%TYPE,

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,
122: x_bep_key_out OUT NOCOPY IBY_BEPKeys.Key%TYPE,
123: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,

Line 120: x_bep_suffix_out OUT NOCOPY IBY_BEPInfo.Suffix%TYPE,

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,
122: x_bep_key_out OUT NOCOPY IBY_BEPKeys.Key%TYPE,
123: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
124: x_bep_username_out OUT NOCOPY IBY_BEPInfo.BEPUsername%TYPE,

Line 121: x_bep_url_out OUT NOCOPY IBY_BEPInfo.BaseURL%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,
122: x_bep_key_out OUT NOCOPY IBY_BEPKeys.Key%TYPE,
123: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
124: x_bep_username_out OUT NOCOPY IBY_BEPInfo.BEPUsername%TYPE,
125: x_bep_passwd_out OUT NOCOPY IBY_BEPInfo.BEPPassword%TYPE,

Line 124: x_bep_username_out OUT NOCOPY IBY_BEPInfo.BEPUsername%TYPE,

120: x_bep_suffix_out OUT NOCOPY IBY_BEPInfo.Suffix%TYPE,
121: x_bep_url_out OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,
122: x_bep_key_out OUT NOCOPY IBY_BEPKeys.Key%TYPE,
123: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
124: x_bep_username_out OUT NOCOPY IBY_BEPInfo.BEPUsername%TYPE,
125: x_bep_passwd_out OUT NOCOPY IBY_BEPInfo.BEPPassword%TYPE,
126: x_security_out OUT NOCOPY NUMBER,
127: x_setnoinit_flag_out OUT NOCOPY NUMBER,
128: x_lead_time_out OUT NOCOPY iby_bepinfo.leadtime%TYPE,

Line 125: x_bep_passwd_out OUT NOCOPY IBY_BEPInfo.BEPPassword%TYPE,

121: x_bep_url_out OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,
122: x_bep_key_out OUT NOCOPY IBY_BEPKeys.Key%TYPE,
123: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
124: x_bep_username_out OUT NOCOPY IBY_BEPInfo.BEPUsername%TYPE,
125: x_bep_passwd_out OUT NOCOPY IBY_BEPInfo.BEPPassword%TYPE,
126: x_security_out OUT NOCOPY NUMBER,
127: x_setnoinit_flag_out OUT NOCOPY NUMBER,
128: x_lead_time_out OUT NOCOPY iby_bepinfo.leadtime%TYPE,
129: x_bep_type_out OUT NOCOPY IBY_BEPInfo.Bep_Type%TYPE,

Line 128: x_lead_time_out OUT NOCOPY iby_bepinfo.leadtime%TYPE,

124: x_bep_username_out OUT NOCOPY IBY_BEPInfo.BEPUsername%TYPE,
125: x_bep_passwd_out OUT NOCOPY IBY_BEPInfo.BEPPassword%TYPE,
126: x_security_out OUT NOCOPY NUMBER,
127: x_setnoinit_flag_out OUT NOCOPY NUMBER,
128: x_lead_time_out OUT NOCOPY iby_bepinfo.leadtime%TYPE,
129: x_bep_type_out OUT NOCOPY IBY_BEPInfo.Bep_Type%TYPE,
130: x_fndcpt_user_profile_code_out OUT NOCOPY
131: IBY_FNDCPT_USER_CC_PF_VL.USER_CC_PROFILE_CODE%TYPE,
132: p_payer_bank_country IN VARCHAR2

Line 129: x_bep_type_out OUT NOCOPY IBY_BEPInfo.Bep_Type%TYPE,

125: x_bep_passwd_out OUT NOCOPY IBY_BEPInfo.BEPPassword%TYPE,
126: x_security_out OUT NOCOPY NUMBER,
127: x_setnoinit_flag_out OUT NOCOPY NUMBER,
128: x_lead_time_out OUT NOCOPY iby_bepinfo.leadtime%TYPE,
129: x_bep_type_out OUT NOCOPY IBY_BEPInfo.Bep_Type%TYPE,
130: x_fndcpt_user_profile_code_out OUT NOCOPY
131: IBY_FNDCPT_USER_CC_PF_VL.USER_CC_PROFILE_CODE%TYPE,
132: p_payer_bank_country IN VARCHAR2
133: );

Line 168: x_bepid_out OUT NOCOPY iby_BEPInfo.BEPID%TYPE,

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,
171: x_bep_key_out OUT NOCOPY IBY_BEPKeys.Key%TYPE,
172: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,

Line 169: x_bep_suffix_out OUT NOCOPY IBY_BEPInfo.Suffix%TYPE,

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,
171: x_bep_key_out OUT NOCOPY IBY_BEPKeys.Key%TYPE,
172: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
173: x_bep_username_out OUT NOCOPY IBY_BEPInfo.BEPUsername%TYPE,

Line 170: x_bep_url_out OUT NOCOPY IBY_BEPInfo.BaseURL%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,
171: x_bep_key_out OUT NOCOPY IBY_BEPKeys.Key%TYPE,
172: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
173: x_bep_username_out OUT NOCOPY IBY_BEPInfo.BEPUsername%TYPE,
174: x_bep_passwd_out OUT NOCOPY IBY_BEPInfo.BEPPassword%TYPE,

Line 173: x_bep_username_out OUT NOCOPY IBY_BEPInfo.BEPUsername%TYPE,

169: x_bep_suffix_out OUT NOCOPY IBY_BEPInfo.Suffix%TYPE,
170: x_bep_url_out OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,
171: x_bep_key_out OUT NOCOPY IBY_BEPKeys.Key%TYPE,
172: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
173: x_bep_username_out OUT NOCOPY IBY_BEPInfo.BEPUsername%TYPE,
174: x_bep_passwd_out OUT NOCOPY IBY_BEPInfo.BEPPassword%TYPE,
175: x_security_out OUT NOCOPY NUMBER,
176: x_setnoinit_flag_out OUT NOCOPY NUMBER,
177: x_lead_time_out OUT NOCOPY iby_bepinfo.leadtime%TYPE,

Line 174: x_bep_passwd_out OUT NOCOPY IBY_BEPInfo.BEPPassword%TYPE,

170: x_bep_url_out OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,
171: x_bep_key_out OUT NOCOPY IBY_BEPKeys.Key%TYPE,
172: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
173: x_bep_username_out OUT NOCOPY IBY_BEPInfo.BEPUsername%TYPE,
174: x_bep_passwd_out OUT NOCOPY IBY_BEPInfo.BEPPassword%TYPE,
175: x_security_out OUT NOCOPY NUMBER,
176: x_setnoinit_flag_out OUT NOCOPY NUMBER,
177: x_lead_time_out OUT NOCOPY iby_bepinfo.leadtime%TYPE,
178: x_bep_type_out OUT NOCOPY IBY_BEPInfo.Bep_Type%TYPE,

Line 177: x_lead_time_out OUT NOCOPY iby_bepinfo.leadtime%TYPE,

173: x_bep_username_out OUT NOCOPY IBY_BEPInfo.BEPUsername%TYPE,
174: x_bep_passwd_out OUT NOCOPY IBY_BEPInfo.BEPPassword%TYPE,
175: x_security_out OUT NOCOPY NUMBER,
176: x_setnoinit_flag_out OUT NOCOPY NUMBER,
177: x_lead_time_out OUT NOCOPY iby_bepinfo.leadtime%TYPE,
178: x_bep_type_out OUT NOCOPY IBY_BEPInfo.Bep_Type%TYPE,
179: x_fndcpt_user_profile_code_out OUT NOCOPY
180: IBY_FNDCPT_USER_CC_PF_VL.USER_CC_PROFILE_CODE%TYPE
181: );

Line 178: x_bep_type_out OUT NOCOPY IBY_BEPInfo.Bep_Type%TYPE,

174: x_bep_passwd_out OUT NOCOPY IBY_BEPInfo.BEPPassword%TYPE,
175: x_security_out OUT NOCOPY NUMBER,
176: x_setnoinit_flag_out OUT NOCOPY NUMBER,
177: x_lead_time_out OUT NOCOPY iby_bepinfo.leadtime%TYPE,
178: x_bep_type_out OUT NOCOPY IBY_BEPInfo.Bep_Type%TYPE,
179: x_fndcpt_user_profile_code_out OUT NOCOPY
180: IBY_FNDCPT_USER_CC_PF_VL.USER_CC_PROFILE_CODE%TYPE
181: );
182:

Line 193: px_bep_suffix_in_out IN OUT NOCOPY iby_bepinfo.Suffix%TYPE,

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,
197: x_bep_username_out OUT NOCOPY iby_bepinfo.BEPUsername%TYPE,

Line 194: x_bepid_out OUT NOCOPY iby_bepinfo.BepId%TYPE,

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,
197: x_bep_username_out OUT NOCOPY iby_bepinfo.BEPUsername%TYPE,
198: x_bep_passwd_out OUT NOCOPY iby_bepinfo.BEPPassword%TYPE,

Line 195: x_bep_url_out OUT NOCOPY iby_bepinfo.BaseUrl%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,
197: x_bep_username_out OUT NOCOPY iby_bepinfo.BEPUsername%TYPE,
198: x_bep_passwd_out OUT NOCOPY iby_bepinfo.BEPPassword%TYPE,
199: x_security_out OUT NOCOPY NUMBER,

Line 197: x_bep_username_out OUT NOCOPY iby_bepinfo.BEPUsername%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,
197: x_bep_username_out OUT NOCOPY iby_bepinfo.BEPUsername%TYPE,
198: x_bep_passwd_out OUT NOCOPY iby_bepinfo.BEPPassword%TYPE,
199: x_security_out OUT NOCOPY NUMBER,
200: x_setnoinit_flag_out OUT NOCOPY NUMBER,
201: x_bep_type_out OUT NOCOPY iby_bepinfo.Bep_Type%TYPE,

Line 198: x_bep_passwd_out OUT NOCOPY iby_bepinfo.BEPPassword%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,
197: x_bep_username_out OUT NOCOPY iby_bepinfo.BEPUsername%TYPE,
198: x_bep_passwd_out OUT NOCOPY iby_bepinfo.BEPPassword%TYPE,
199: x_security_out OUT NOCOPY NUMBER,
200: x_setnoinit_flag_out OUT NOCOPY NUMBER,
201: x_bep_type_out OUT NOCOPY iby_bepinfo.Bep_Type%TYPE,
202: x_bep_lang_out OUT NOCOPY VARCHAR2,

Line 201: x_bep_type_out OUT NOCOPY iby_bepinfo.Bep_Type%TYPE,

197: x_bep_username_out OUT NOCOPY iby_bepinfo.BEPUsername%TYPE,
198: x_bep_passwd_out OUT NOCOPY iby_bepinfo.BEPPassword%TYPE,
199: x_security_out OUT NOCOPY NUMBER,
200: x_setnoinit_flag_out OUT NOCOPY NUMBER,
201: x_bep_type_out OUT NOCOPY iby_bepinfo.Bep_Type%TYPE,
202: x_bep_lang_out OUT NOCOPY VARCHAR2,
203: x_lead_time_out OUT NOCOPY iby_bepinfo.leadtime%TYPE
204: );
205:

Line 203: x_lead_time_out OUT NOCOPY iby_bepinfo.leadtime%TYPE

199: x_security_out OUT NOCOPY NUMBER,
200: x_setnoinit_flag_out OUT NOCOPY NUMBER,
201: x_bep_type_out OUT NOCOPY iby_bepinfo.Bep_Type%TYPE,
202: x_bep_lang_out OUT NOCOPY VARCHAR2,
203: x_lead_time_out OUT NOCOPY iby_bepinfo.leadtime%TYPE
204: );
205:
206:
207: /* Internal procedure to get the bep configuration by the */

Line 213: o_bepid OUT NOCOPY IBY_BEPInfo.BEPID%TYPE,

209:
210: /* PROCEDURE getBepByPmtName
211: (payment_name_in IN iby_routinginfo.PaymentMethodName%TYPE,
212: o_payment_method_id OUT NOCOPY iby_routinginfo.PaymentMethodID%TYPE,
213: o_bepid OUT NOCOPY IBY_BEPInfo.BEPID%TYPE,
214: o_suffix OUT NOCOPY IBY_BEPInfo.suffix%TYPE,
215: o_bep_base_url OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,
216: o_pmtschemeName OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
217: instr_type_in IN iby_accttype.instrtype%type);*/

Line 214: o_suffix OUT NOCOPY IBY_BEPInfo.suffix%TYPE,

210: /* PROCEDURE getBepByPmtName
211: (payment_name_in IN iby_routinginfo.PaymentMethodName%TYPE,
212: o_payment_method_id OUT NOCOPY iby_routinginfo.PaymentMethodID%TYPE,
213: o_bepid OUT NOCOPY IBY_BEPInfo.BEPID%TYPE,
214: o_suffix OUT NOCOPY IBY_BEPInfo.suffix%TYPE,
215: o_bep_base_url OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,
216: o_pmtschemeName OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
217: instr_type_in IN iby_accttype.instrtype%type);*/
218:

Line 215: o_bep_base_url OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,

211: (payment_name_in IN iby_routinginfo.PaymentMethodName%TYPE,
212: o_payment_method_id OUT NOCOPY iby_routinginfo.PaymentMethodID%TYPE,
213: o_bepid OUT NOCOPY IBY_BEPInfo.BEPID%TYPE,
214: o_suffix OUT NOCOPY IBY_BEPInfo.suffix%TYPE,
215: o_bep_base_url OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,
216: o_pmtschemeName OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
217: instr_type_in IN iby_accttype.instrtype%type);*/
218:
219: /* Internal procedure that gets the bep configuration by */

Line 225: o_bepid OUT NOCOPY IBY_BEPInfo.BEPID%TYPE,

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,
229: i_instrtype IN iby_accttype.instrtype%type);

Line 226: o_suffix OUT NOCOPY IBY_BEPInfo.Suffix%TYPE,

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,
229: i_instrtype IN iby_accttype.instrtype%type);
230: */

Line 227: o_bep_base_url OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,

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,
229: i_instrtype IN iby_accttype.instrtype%type);
230: */
231: /* Internal procedure that gets the bep configuration by */

Line 237: v_id IN OUT NOCOPY IBY_BEPInfo.BEPID%TYPE,

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);
241: */

Line 238: v_suffix IN OUT NOCOPY IBY_BEPInfo.Suffix%TYPE,

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);
241: */
242:

Line 239: v_base_url IN OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,

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);
241: */
242:
243: /* Internal procedure that gets the bep configuration by */

Line 246: (i_suffix IN IBY_BEPInfo.Suffix%TYPE,

242:
243: /* Internal procedure that gets the bep configuration by */
244: /* bep suffix. */
245: PROCEDURE getBepBySuffix
246: (i_suffix IN IBY_BEPInfo.Suffix%TYPE,
247: o_bepid OUT NOCOPY IBY_BEPInfo.BEPID%TYPE,
248: o_bep_base_url OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,
249: o_pmtschemename OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
250: i_instrtype IN iby_accttype.instrtype%type );

Line 247: o_bepid OUT NOCOPY IBY_BEPInfo.BEPID%TYPE,

243: /* Internal procedure that gets the bep configuration by */
244: /* bep suffix. */
245: PROCEDURE getBepBySuffix
246: (i_suffix IN IBY_BEPInfo.Suffix%TYPE,
247: o_bepid OUT NOCOPY IBY_BEPInfo.BEPID%TYPE,
248: o_bep_base_url OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,
249: o_pmtschemename OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
250: i_instrtype IN iby_accttype.instrtype%type );
251:

Line 248: o_bep_base_url OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,

244: /* bep suffix. */
245: PROCEDURE getBepBySuffix
246: (i_suffix IN IBY_BEPInfo.Suffix%TYPE,
247: o_bepid OUT NOCOPY IBY_BEPInfo.BEPID%TYPE,
248: o_bep_base_url OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,
249: o_pmtschemename OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
250: i_instrtype IN iby_accttype.instrtype%type );
251:
252:

Line 275: PROCEDURE getBEPLang(i_bepid IN iby_bepinfo.bepid%type,

271:
272: /* Procedure: getBEPLang
273: * Function: fetch valid nlslang based on input lang
274: */
275: PROCEDURE getBEPLang(i_bepid IN iby_bepinfo.bepid%type,
276: io_beplang IN OUT NOCOPY iby_beplangs.beplang%type);
277: /*
278: * This function is a wrapper around the getBEPLang() procedure.
279: * The purpose of this wrapper is to make the NLS lang available

Line 283: /* FUNCTION getNLSLang(i_bepid IN iby_bepinfo.bepid%type,

279: * The purpose of this wrapper is to make the NLS lang available
280: * as a return parameter (so that it can be used in an SQL statement).
281: */
282: /* comment out for now */
283: /* FUNCTION getNLSLang(i_bepid IN iby_bepinfo.bepid%type,
284: io_beplang IN OUT NOCOPY iby_beplangs.beplang%type);
285: */
286:
287: PROCEDURE getPmtSchemeName(i_bepid IN iby_bepinfo.bepid%type,

Line 287: PROCEDURE getPmtSchemeName(i_bepid IN iby_bepinfo.bepid%type,

283: /* FUNCTION getNLSLang(i_bepid IN iby_bepinfo.bepid%type,
284: io_beplang IN OUT NOCOPY iby_beplangs.beplang%type);
285: */
286:
287: PROCEDURE getPmtSchemeName(i_bepid IN iby_bepinfo.bepid%type,
288: i_instrtype IN iby_accttype.instrtype%type,
289: o_pmtschemename OUT
290: iby_pmtschemes.pmtschemename%type);
291:

Line 292: PROCEDURE getBepUrl(i_base_url IN iby_bepinfo.baseurl%type,

288: i_instrtype IN iby_accttype.instrtype%type,
289: o_pmtschemename OUT
290: iby_pmtschemes.pmtschemename%type);
291:
292: PROCEDURE getBepUrl(i_base_url IN iby_bepinfo.baseurl%type,
293: i_payment_op IN VARCHAR2,
294: i_pmtschemename IN iby_pmtschemes.pmtschemename%type,
295: i_suffix IN iby_bepinfo.suffix%type,
296: o_bep_url OUT NOCOPY VARCHAR2);

Line 295: i_suffix IN iby_bepinfo.suffix%type,

291:
292: PROCEDURE getBepUrl(i_base_url IN iby_bepinfo.baseurl%type,
293: i_payment_op IN VARCHAR2,
294: i_pmtschemename IN iby_pmtschemes.pmtschemename%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,

Line 300: o_bepid OUT NOCOPY iby_bepinfo.bepid%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:
304: PROCEDURE getDefaultBepId(i_mpayeeid IN iby_payee.mpayeeid%type,

Line 306: o_bepid OUT NOCOPY iby_bepinfo.bepid%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);
310:

Line 312: PROCEDURE getBepById(i_bepid IN iby_bepinfo.bepid%type,

308: o_fndcpt_user_profile_code OUT NOCOPY
309: IBY_FNDCPT_USER_CC_PF_VL.USER_CC_PROFILE_CODE%TYPE);
310:
311:
312: PROCEDURE getBepById(i_bepid IN iby_bepinfo.bepid%type,
313: o_suffix OUT NOCOPY iby_bepinfo.suffix%type,
314: o_baseurl OUT NOCOPY iby_bepinfo.baseurl%type,
315: o_securityscheme OUT NOCOPY iby_bepinfo.securityscheme%type,
316: o_bepusername OUT NOCOPY iby_bepinfo.bepusername%type,

Line 313: o_suffix OUT NOCOPY iby_bepinfo.suffix%type,

309: IBY_FNDCPT_USER_CC_PF_VL.USER_CC_PROFILE_CODE%TYPE);
310:
311:
312: PROCEDURE getBepById(i_bepid IN iby_bepinfo.bepid%type,
313: o_suffix OUT NOCOPY iby_bepinfo.suffix%type,
314: o_baseurl OUT NOCOPY iby_bepinfo.baseurl%type,
315: o_securityscheme OUT NOCOPY iby_bepinfo.securityscheme%type,
316: o_bepusername OUT NOCOPY iby_bepinfo.bepusername%type,
317: o_beppassword OUT NOCOPY iby_bepinfo.beppassword%type,

Line 314: o_baseurl OUT NOCOPY iby_bepinfo.baseurl%type,

310:
311:
312: PROCEDURE getBepById(i_bepid IN iby_bepinfo.bepid%type,
313: o_suffix OUT NOCOPY iby_bepinfo.suffix%type,
314: o_baseurl OUT NOCOPY iby_bepinfo.baseurl%type,
315: o_securityscheme OUT NOCOPY iby_bepinfo.securityscheme%type,
316: o_bepusername OUT NOCOPY iby_bepinfo.bepusername%type,
317: o_beppassword OUT NOCOPY iby_bepinfo.beppassword%type,
318: o_beptype OUT NOCOPY iby_bepinfo.bep_type%TYPE,

Line 315: o_securityscheme OUT NOCOPY iby_bepinfo.securityscheme%type,

311:
312: PROCEDURE getBepById(i_bepid IN iby_bepinfo.bepid%type,
313: o_suffix OUT NOCOPY iby_bepinfo.suffix%type,
314: o_baseurl OUT NOCOPY iby_bepinfo.baseurl%type,
315: o_securityscheme OUT NOCOPY iby_bepinfo.securityscheme%type,
316: o_bepusername OUT NOCOPY iby_bepinfo.bepusername%type,
317: o_beppassword OUT NOCOPY iby_bepinfo.beppassword%type,
318: o_beptype OUT NOCOPY iby_bepinfo.bep_type%TYPE,
319: o_leadtime OUT NOCOPY iby_bepinfo.leadtime%TYPE);

Line 316: o_bepusername OUT NOCOPY iby_bepinfo.bepusername%type,

312: PROCEDURE getBepById(i_bepid IN iby_bepinfo.bepid%type,
313: o_suffix OUT NOCOPY iby_bepinfo.suffix%type,
314: o_baseurl OUT NOCOPY iby_bepinfo.baseurl%type,
315: o_securityscheme OUT NOCOPY iby_bepinfo.securityscheme%type,
316: o_bepusername OUT NOCOPY iby_bepinfo.bepusername%type,
317: o_beppassword OUT NOCOPY iby_bepinfo.beppassword%type,
318: o_beptype OUT NOCOPY iby_bepinfo.bep_type%TYPE,
319: o_leadtime OUT NOCOPY iby_bepinfo.leadtime%TYPE);
320:

Line 317: o_beppassword OUT NOCOPY iby_bepinfo.beppassword%type,

313: o_suffix OUT NOCOPY iby_bepinfo.suffix%type,
314: o_baseurl OUT NOCOPY iby_bepinfo.baseurl%type,
315: o_securityscheme OUT NOCOPY iby_bepinfo.securityscheme%type,
316: o_bepusername OUT NOCOPY iby_bepinfo.bepusername%type,
317: o_beppassword OUT NOCOPY iby_bepinfo.beppassword%type,
318: o_beptype OUT NOCOPY iby_bepinfo.bep_type%TYPE,
319: o_leadtime OUT NOCOPY iby_bepinfo.leadtime%TYPE);
320:
321: PROCEDURE populateRoutingFields(

Line 318: o_beptype OUT NOCOPY iby_bepinfo.bep_type%TYPE,

314: o_baseurl OUT NOCOPY iby_bepinfo.baseurl%type,
315: o_securityscheme OUT NOCOPY iby_bepinfo.securityscheme%type,
316: o_bepusername OUT NOCOPY iby_bepinfo.bepusername%type,
317: o_beppassword OUT NOCOPY iby_bepinfo.beppassword%type,
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,

Line 319: o_leadtime OUT NOCOPY iby_bepinfo.leadtime%TYPE);

315: o_securityscheme OUT NOCOPY iby_bepinfo.securityscheme%type,
316: o_bepusername OUT NOCOPY iby_bepinfo.bepusername%type,
317: o_beppassword OUT NOCOPY iby_bepinfo.beppassword%type,
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