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 53: /* IBY_BEPINFO table. */

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

122: x_bep_username_out OUT NOCOPY IBY_BEPInfo.BEPUsername%TYPE,
123: x_bep_passwd_out OUT NOCOPY IBY_BEPInfo.BEPPassword%TYPE,
124: x_security_out OUT NOCOPY NUMBER,
125: x_setnoinit_flag_out OUT NOCOPY NUMBER,
126: x_lead_time_out OUT NOCOPY iby_bepinfo.leadtime%TYPE,
127: x_bep_type_out OUT NOCOPY IBY_BEPInfo.Bep_Type%TYPE,
128: x_fndcpt_user_profile_code_out OUT NOCOPY
129: IBY_FNDCPT_USER_CC_PF_VL.USER_CC_PROFILE_CODE%TYPE
130: );

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

186: PROCEDURE listbep (
187: p_payee_id IN iby_bepkeys.OwnerId%TYPE,
188: p_bepkey IN iby_bepkeys.KEY%TYPE,
189: p_instr_type IN iby_trxn_summaries_all.InstrType%TYPE,
190: px_bep_suffix_in_out IN OUT NOCOPY iby_bepinfo.Suffix%TYPE,
191: x_bepid_out OUT NOCOPY iby_bepinfo.BepId%TYPE,
192: x_bep_url_out OUT NOCOPY iby_bepinfo.BaseUrl%TYPE,
193: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
194: x_bep_username_out OUT NOCOPY iby_bepinfo.BEPUsername%TYPE,

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

187: p_payee_id IN iby_bepkeys.OwnerId%TYPE,
188: p_bepkey IN iby_bepkeys.KEY%TYPE,
189: p_instr_type IN iby_trxn_summaries_all.InstrType%TYPE,
190: px_bep_suffix_in_out IN OUT NOCOPY iby_bepinfo.Suffix%TYPE,
191: x_bepid_out OUT NOCOPY iby_bepinfo.BepId%TYPE,
192: x_bep_url_out OUT NOCOPY iby_bepinfo.BaseUrl%TYPE,
193: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
194: x_bep_username_out OUT NOCOPY iby_bepinfo.BEPUsername%TYPE,
195: x_bep_passwd_out OUT NOCOPY iby_bepinfo.BEPPassword%TYPE,

Line 192: x_bep_url_out OUT NOCOPY iby_bepinfo.BaseUrl%TYPE,

188: p_bepkey IN iby_bepkeys.KEY%TYPE,
189: p_instr_type IN iby_trxn_summaries_all.InstrType%TYPE,
190: px_bep_suffix_in_out IN OUT NOCOPY iby_bepinfo.Suffix%TYPE,
191: x_bepid_out OUT NOCOPY iby_bepinfo.BepId%TYPE,
192: x_bep_url_out OUT NOCOPY iby_bepinfo.BaseUrl%TYPE,
193: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
194: x_bep_username_out OUT NOCOPY iby_bepinfo.BEPUsername%TYPE,
195: x_bep_passwd_out OUT NOCOPY iby_bepinfo.BEPPassword%TYPE,
196: x_security_out OUT NOCOPY NUMBER,

Line 194: x_bep_username_out OUT NOCOPY iby_bepinfo.BEPUsername%TYPE,

190: px_bep_suffix_in_out IN OUT NOCOPY iby_bepinfo.Suffix%TYPE,
191: x_bepid_out OUT NOCOPY iby_bepinfo.BepId%TYPE,
192: x_bep_url_out OUT NOCOPY iby_bepinfo.BaseUrl%TYPE,
193: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
194: x_bep_username_out OUT NOCOPY iby_bepinfo.BEPUsername%TYPE,
195: x_bep_passwd_out OUT NOCOPY iby_bepinfo.BEPPassword%TYPE,
196: x_security_out OUT NOCOPY NUMBER,
197: x_setnoinit_flag_out OUT NOCOPY NUMBER,
198: x_bep_type_out OUT NOCOPY iby_bepinfo.Bep_Type%TYPE,

Line 195: x_bep_passwd_out OUT NOCOPY iby_bepinfo.BEPPassword%TYPE,

191: x_bepid_out OUT NOCOPY iby_bepinfo.BepId%TYPE,
192: x_bep_url_out OUT NOCOPY iby_bepinfo.BaseUrl%TYPE,
193: x_bep_pmtscheme_out OUT NOCOPY iby_pmtschemes.PmtSchemeName%TYPE,
194: x_bep_username_out OUT NOCOPY iby_bepinfo.BEPUsername%TYPE,
195: x_bep_passwd_out OUT NOCOPY iby_bepinfo.BEPPassword%TYPE,
196: x_security_out OUT NOCOPY NUMBER,
197: x_setnoinit_flag_out OUT NOCOPY NUMBER,
198: x_bep_type_out OUT NOCOPY iby_bepinfo.Bep_Type%TYPE,
199: x_bep_lang_out OUT NOCOPY VARCHAR2,

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

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

Line 200: x_lead_time_out OUT NOCOPY iby_bepinfo.leadtime%TYPE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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);
238: */
239:
240: /* Internal procedure that gets the bep configuration by */

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 292: i_suffix IN iby_bepinfo.suffix%type,

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

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

Line 303: o_bepid OUT NOCOPY iby_bepinfo.bepid%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
306: IBY_FNDCPT_USER_CC_PF_VL.USER_CC_PROFILE_CODE%TYPE);
307:

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

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

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

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

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

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

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

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

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

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

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

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

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

311: o_baseurl OUT NOCOPY iby_bepinfo.baseurl%type,
312: o_securityscheme OUT NOCOPY iby_bepinfo.securityscheme%type,
313: o_bepusername OUT NOCOPY iby_bepinfo.bepusername%type,
314: o_beppassword OUT NOCOPY iby_bepinfo.beppassword%type,
315: o_beptype OUT NOCOPY iby_bepinfo.bep_type%TYPE,
316: o_leadtime OUT NOCOPY iby_bepinfo.leadtime%TYPE);
317:
318: PROCEDURE populateRoutingFields(
319: p_amount IN iby_trxn_summaries_all.amount%type default null,

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

312: o_securityscheme OUT NOCOPY iby_bepinfo.securityscheme%type,
313: o_bepusername OUT NOCOPY iby_bepinfo.bepusername%type,
314: o_beppassword OUT NOCOPY iby_bepinfo.beppassword%type,
315: o_beptype OUT NOCOPY iby_bepinfo.bep_type%TYPE,
316: o_leadtime OUT NOCOPY iby_bepinfo.leadtime%TYPE);
317:
318: PROCEDURE populateRoutingFields(
319: p_amount IN iby_trxn_summaries_all.amount%type default null,
320: p_instr_type IN iby_trxn_summaries_all.instrtype%type