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_PAYEE

Line 34: px_payee_id_in_out IN OUT NOCOPY iby_payee.PayeeID%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,
38: x_payee_username_out OUT NOCOPY iby_payee.Username%TYPE,

Line 38: x_payee_username_out OUT NOCOPY iby_payee.Username%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,
38: x_payee_username_out OUT NOCOPY iby_payee.Username%TYPE,
39: x_payee_passwd_out OUT NOCOPY iby_payee.Password%TYPE,
40: x_payee_operation_out OUT NOCOPY NUMBER,
41: x_bepid_out OUT NOCOPY iby_BEPInfo.BEPID%TYPE,
42: x_bep_suffix_out OUT NOCOPY IBY_BEPInfo.Suffix%TYPE,

Line 39: x_payee_passwd_out OUT NOCOPY iby_payee.Password%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,
38: x_payee_username_out OUT NOCOPY iby_payee.Username%TYPE,
39: x_payee_passwd_out OUT NOCOPY iby_payee.Password%TYPE,
40: x_payee_operation_out OUT NOCOPY NUMBER,
41: x_bepid_out OUT NOCOPY iby_BEPInfo.BEPID%TYPE,
42: x_bep_suffix_out OUT NOCOPY IBY_BEPInfo.Suffix%TYPE,
43: x_bep_url_out OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,

Line 122: px_payee_id_in_out IN OUT NOCOPY iby_payee.PayeeID%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,
126: x_payee_username_out OUT NOCOPY iby_payee.Username%TYPE,

Line 126: x_payee_username_out OUT NOCOPY iby_payee.Username%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,
126: x_payee_username_out OUT NOCOPY iby_payee.Username%TYPE,
127: x_payee_passwd_out OUT NOCOPY iby_payee.Password%TYPE,
128: x_payee_operation_out OUT NOCOPY NUMBER,
129: x_bepid_out OUT NOCOPY iby_BEPInfo.BEPID%TYPE,
130: x_bep_suffix_out OUT NOCOPY IBY_BEPInfo.Suffix%TYPE,

Line 127: x_payee_passwd_out OUT NOCOPY iby_payee.Password%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,
126: x_payee_username_out OUT NOCOPY iby_payee.Username%TYPE,
127: x_payee_passwd_out OUT NOCOPY iby_payee.Password%TYPE,
128: x_payee_operation_out OUT NOCOPY NUMBER,
129: x_bepid_out OUT NOCOPY iby_BEPInfo.BEPID%TYPE,
130: x_bep_suffix_out OUT NOCOPY IBY_BEPInfo.Suffix%TYPE,
131: x_bep_url_out OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,

Line 156: l_payeename iby_payee.name%type;

152:
153: l_currency VARCHAR2(15);
154: l_position NUMBER;
155:
156: l_payeename iby_payee.name%type;
157: l_bepname iby_bepinfo.name%type;
158:
159: -- *** R12 Modification *** ---
160: -- Added variables l_instr_type and l_mpayeeid

Line 162: l_mpayeeid iby_payee.mpayeeid%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
166: iby_debug_pub.add('ENTER',iby_debug_pub.G_LEVEL_PROCEDURE,l_module_name);

Line 209: FROM IBY_PAYEE a

205:
206: --- *** R12 Modification *** ---
207: -- Fetch MPayeeId from PayeeId
208: SELECT a.mpayeeid INTO l_mpayeeid
209: FROM IBY_PAYEE a
210: WHERE a.payeeid = p_payee_id;
211: iby_debug_pub.add('debug pt 6',iby_debug_pub.G_LEVEL_PROCEDURE,l_module_name);
212:
213: /*

Line 248: IF (not iby_payee_pkg.payeeExists(p_ecappid_in, p_payee_id)) THEN

244:
245: iby_debug_pub.add('debug pt 2',iby_debug_pub.G_LEVEL_PROCEDURE,l_module_name);
246: IF ((l_pay_op = 'ORAPMTREQ') OR (l_pay_op = 'ORAPMTCREDIT') OR (l_pay_op = 'ORAPMTBATCHREQ')) THEN
247:
248: IF (not iby_payee_pkg.payeeExists(p_ecappid_in, p_payee_id)) THEN
249: raise_application_error(-20000, 'IBY_20515#', FALSE);
250: END IF; -- If payee does not exist
251: iby_debug_pub.add('debug pt 3',iby_debug_pub.G_LEVEL_PROCEDURE,l_module_name);
252: -- Apply routingrules and find the routing rule (pmt

Line 296: SELECT p.name INTO l_payeename FROM iby_payee p

292: END IF;
293:
294: IF ( x_bep_key_out IS NULL) THEN
295: -- Default BEP Key has not been configured
296: SELECT p.name INTO l_payeename FROM iby_payee p
297: WHERE px_payee_id_in_out = p.payeeid;
298: SELECT b.name INTO l_bepname FROM iby_bepinfo b
299: WHERE x_bepid_out = b.bepid;
300: raise_application_error(-20000, 'IBY_25002#PAYEENAME='

Line 426: FROM iby_payee

422: -- the value 2147483647 is the maximum integer value as set in the UI
423: SELECT Username, Password, '2147483647'
424: INTO x_payee_username_out, x_payee_passwd_out,
425: x_payee_operation_out
426: FROM iby_payee
427: WHERE PayeeID = px_payee_id_in_out
428: AND upper(Activestatus) = 'Y';
429:
430: -- make sure payee support accepted payment instrument

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

1012: /* Procedure: checkPayeeByAccpPmtMthd
1013: * Function: to make sure given instrument type is supported by payee
1014: */
1015:
1016: PROCEDURE checkPayeeByAccpPmtMthd(i_payeeid iby_payee.payeeid%type,
1017: i_instr_type iby_accttype.instrtype%type)
1018: IS
1019: l_instr_type iby_accttype.instrtype%type;
1020: l_fin_payee_flag iby_payee.financing_payee_flag%type;

Line 1020: l_fin_payee_flag iby_payee.financing_payee_flag%type;

1016: PROCEDURE checkPayeeByAccpPmtMthd(i_payeeid iby_payee.payeeid%type,
1017: i_instr_type iby_accttype.instrtype%type)
1018: IS
1019: l_instr_type iby_accttype.instrtype%type;
1020: l_fin_payee_flag iby_payee.financing_payee_flag%type;
1021:
1022: cursor c_get_instrtype(ci_payeeid iby_payee.payeeid%type,
1023: ci_instr_type iby_accttype.instrtype%type)
1024: IS

Line 1022: cursor c_get_instrtype(ci_payeeid iby_payee.payeeid%type,

1018: IS
1019: l_instr_type iby_accttype.instrtype%type;
1020: l_fin_payee_flag iby_payee.financing_payee_flag%type;
1021:
1022: cursor c_get_instrtype(ci_payeeid iby_payee.payeeid%type,
1023: ci_instr_type iby_accttype.instrtype%type)
1024: IS
1025:
1026: SELECT instrtype FROM iby_accttype a, iby_accppmtmthd b

Line 1032: cursor c_get_fin_payee_flag(ci_payeeid iby_payee.payeeid%type)

1028: AND b.payeeid = ci_payeeid
1029: AND b.status = 1
1030: AND a.instrtype = ci_instr_type;
1031:
1032: cursor c_get_fin_payee_flag(ci_payeeid iby_payee.payeeid%type)
1033: IS
1034: SELECT FINANCING_PAYEE_FLAG FROM iby_payee
1035: WHERE payeeid = ci_payeeid;
1036: BEGIN

Line 1034: SELECT FINANCING_PAYEE_FLAG FROM iby_payee

1030: AND a.instrtype = ci_instr_type;
1031:
1032: cursor c_get_fin_payee_flag(ci_payeeid iby_payee.payeeid%type)
1033: IS
1034: SELECT FINANCING_PAYEE_FLAG FROM iby_payee
1035: WHERE payeeid = ci_payeeid;
1036: BEGIN
1037:
1038: IF (i_instr_type = 'FINANCING') THEN

Line 1245: i_payeeid IN iby_payee.payeeid%type,

1241: END IF;
1242: END getBepUrl;
1243:
1244: PROCEDURE getBepIdByPmtName(i_paymentmethodname IN VARCHAR2,
1245: i_payeeid IN iby_payee.payeeid%type,
1246: o_bepid OUT NOCOPY iby_bepinfo.bepid%type,
1247: o_bepkey OUT NOCOPY iby_bepkeys.key%type,
1248: o_fc_user_profile_code IN OUT NOCOPY VARCHAR2)
1249: IS

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

1272: END IF;
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

Line 1286: CURSOR c_defaultBep(ci_mpayeeid iby_payee.mpayeeid%type,

1282: IS
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,