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.

[Home] [Help]

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 121: px_payee_id_in_out IN OUT NOCOPY iby_payee.PayeeID%TYPE,

117: p_int_bank_acct_id IN NUMBER,
118: p_br_signed_flag IN iby_trxn_summaries_all.br_signed_flag%TYPE,
119: p_br_drawee_issued_flag IN iby_trxn_summaries_all.br_drawee_issued_flag%TYPE,
120: p_ar_receipt_mth_id IN iby_trxn_summaries_all.ar_receipt_method_id%TYPE,
121: px_payee_id_in_out IN OUT NOCOPY iby_payee.PayeeID%TYPE,
122: px_order_id_in_out IN OUT NOCOPY VARCHAR2,
123: px_payment_name_in_out IN OUT NOCOPY VARCHAR2,
124: px_bep_lang_in_out IN OUT NOCOPY VARCHAR2,
125: x_payee_username_out OUT NOCOPY iby_payee.Username%TYPE,

Line 125: x_payee_username_out OUT NOCOPY iby_payee.Username%TYPE,

121: px_payee_id_in_out IN OUT NOCOPY iby_payee.PayeeID%TYPE,
122: px_order_id_in_out IN OUT NOCOPY VARCHAR2,
123: px_payment_name_in_out IN OUT NOCOPY VARCHAR2,
124: px_bep_lang_in_out IN OUT NOCOPY VARCHAR2,
125: x_payee_username_out OUT NOCOPY iby_payee.Username%TYPE,
126: x_payee_passwd_out OUT NOCOPY iby_payee.Password%TYPE,
127: x_payee_operation_out OUT NOCOPY NUMBER,
128: x_bepid_out OUT NOCOPY iby_BEPInfo.BEPID%TYPE,
129: x_bep_suffix_out OUT NOCOPY IBY_BEPInfo.Suffix%TYPE,

Line 126: x_payee_passwd_out OUT NOCOPY iby_payee.Password%TYPE,

122: px_order_id_in_out IN OUT NOCOPY VARCHAR2,
123: px_payment_name_in_out IN OUT NOCOPY VARCHAR2,
124: px_bep_lang_in_out IN OUT NOCOPY VARCHAR2,
125: x_payee_username_out OUT NOCOPY iby_payee.Username%TYPE,
126: x_payee_passwd_out OUT NOCOPY iby_payee.Password%TYPE,
127: x_payee_operation_out OUT NOCOPY NUMBER,
128: x_bepid_out OUT NOCOPY iby_BEPInfo.BEPID%TYPE,
129: x_bep_suffix_out OUT NOCOPY IBY_BEPInfo.Suffix%TYPE,
130: x_bep_url_out OUT NOCOPY IBY_BEPInfo.BaseURL%TYPE,

Line 154: l_payeename iby_payee.name%type;

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

Line 160: l_mpayeeid iby_payee.mpayeeid%TYPE;

156:
157: -- *** R12 Modification *** ---
158: -- Added variables l_instr_type and l_mpayeeid
159: l_instr_type iby_trxn_summaries_all.instrtype%TYPE;
160: l_mpayeeid iby_payee.mpayeeid%TYPE;
161: l_bank_id ce_bank_accounts_v.bank_id%TYPE;
162:
163: BEGIN
164: iby_debug_pub.add('ENTER',iby_debug_pub.G_LEVEL_PROCEDURE,l_module_name);

Line 207: FROM IBY_PAYEE a

203:
204: --- *** R12 Modification *** ---
205: -- Fetch MPayeeId from PayeeId
206: SELECT a.mpayeeid INTO l_mpayeeid
207: FROM IBY_PAYEE a
208: WHERE a.payeeid = p_payee_id;
209: iby_debug_pub.add('debug pt 6',iby_debug_pub.G_LEVEL_PROCEDURE,l_module_name);
210: IF (NOT p_int_bank_acct_id IS NULL) THEN
211: SELECT bank_id INTO l_bank_id

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

230:
231: iby_debug_pub.add('debug pt 2',iby_debug_pub.G_LEVEL_PROCEDURE,l_module_name);
232: IF ((l_pay_op = 'ORAPMTREQ') OR (l_pay_op = 'ORAPMTCREDIT') OR (l_pay_op = 'ORAPMTBATCHREQ')) THEN
233:
234: IF (not iby_payee_pkg.payeeExists(p_ecappid_in, p_payee_id)) THEN
235: raise_application_error(-20000, 'IBY_20515#', FALSE);
236: END IF; -- If payee does not exist
237: iby_debug_pub.add('debug pt 3',iby_debug_pub.G_LEVEL_PROCEDURE,l_module_name);
238: -- Apply routingrules and find the routing rule (pmt

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

278: END IF;
279:
280: IF ( x_bep_key_out IS NULL) THEN
281: -- Default BEP Key has not been configured
282: SELECT p.name INTO l_payeename FROM iby_payee p
283: WHERE px_payee_id_in_out = p.payeeid;
284: SELECT b.name INTO l_bepname FROM iby_bepinfo b
285: WHERE x_bepid_out = b.bepid;
286: raise_application_error(-20000, 'IBY_25002#PAYEENAME='

Line 408: FROM iby_payee

404: -- the value 2147483647 is the maximum integer value as set in the UI
405: SELECT Username, Password, '2147483647'
406: INTO x_payee_username_out, x_payee_passwd_out,
407: x_payee_operation_out
408: FROM iby_payee
409: WHERE PayeeID = px_payee_id_in_out
410: AND upper(Activestatus) = 'Y';
411:
412: -- make sure payee support accepted payment instrument

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

942: /* Procedure: checkPayeeByAccpPmtMthd
943: * Function: to make sure given instrument type is supported by payee
944: */
945:
946: PROCEDURE checkPayeeByAccpPmtMthd(i_payeeid iby_payee.payeeid%type,
947: i_instr_type iby_accttype.instrtype%type)
948: IS
949: l_instr_type iby_accttype.instrtype%type;
950: l_fin_payee_flag iby_payee.financing_payee_flag%type;

Line 950: l_fin_payee_flag iby_payee.financing_payee_flag%type;

946: PROCEDURE checkPayeeByAccpPmtMthd(i_payeeid iby_payee.payeeid%type,
947: i_instr_type iby_accttype.instrtype%type)
948: IS
949: l_instr_type iby_accttype.instrtype%type;
950: l_fin_payee_flag iby_payee.financing_payee_flag%type;
951:
952: cursor c_get_instrtype(ci_payeeid iby_payee.payeeid%type,
953: ci_instr_type iby_accttype.instrtype%type)
954: IS

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

948: IS
949: l_instr_type iby_accttype.instrtype%type;
950: l_fin_payee_flag iby_payee.financing_payee_flag%type;
951:
952: cursor c_get_instrtype(ci_payeeid iby_payee.payeeid%type,
953: ci_instr_type iby_accttype.instrtype%type)
954: IS
955:
956: SELECT instrtype FROM iby_accttype a, iby_accppmtmthd b

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

958: AND b.payeeid = ci_payeeid
959: AND b.status = 1
960: AND a.instrtype = ci_instr_type;
961:
962: cursor c_get_fin_payee_flag(ci_payeeid iby_payee.payeeid%type)
963: IS
964: SELECT FINANCING_PAYEE_FLAG FROM iby_payee
965: WHERE payeeid = ci_payeeid;
966: BEGIN

Line 964: SELECT FINANCING_PAYEE_FLAG FROM iby_payee

960: AND a.instrtype = ci_instr_type;
961:
962: cursor c_get_fin_payee_flag(ci_payeeid iby_payee.payeeid%type)
963: IS
964: SELECT FINANCING_PAYEE_FLAG FROM iby_payee
965: WHERE payeeid = ci_payeeid;
966: BEGIN
967:
968: IF (i_instr_type = 'FINANCING') THEN

Line 1175: i_payeeid IN iby_payee.payeeid%type,

1171: END IF;
1172: END getBepUrl;
1173:
1174: PROCEDURE getBepIdByPmtName(i_paymentmethodname IN VARCHAR2,
1175: i_payeeid IN iby_payee.payeeid%type,
1176: o_bepid OUT NOCOPY iby_bepinfo.bepid%type,
1177: o_bepkey OUT NOCOPY iby_bepkeys.key%type,
1178: o_fc_user_profile_code IN OUT NOCOPY VARCHAR2)
1179: IS

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

1202: END IF;
1203:
1204: END getBepIdByPmtName;
1205:
1206: PROCEDURE getDefaultBepId(i_mpayeeid IN iby_payee.mpayeeid%type,
1207: i_payment_channel_code IN iby_trxn_summaries_all.payment_channel_code%type,
1208: o_bepid OUT NOCOPY iby_bepinfo.bepid%type,
1209: o_bepkey OUT NOCOPY iby_bepkeys.key%type,
1210: o_fndcpt_user_profile_code OUT NOCOPY

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

1212: IS
1213: -- *** R12 Modification *** ---
1214: -- Cursor retrieves default bep key and FndcptUserProfileCode
1215: -- given the mpayeeid and payment channel code
1216: CURSOR c_defaultBep(ci_mpayeeid iby_payee.mpayeeid%type,
1217: ci_payment_channel_code iby_trxn_summaries_all.payment_channel_code%type)
1218: IS
1219: SELECT a.bepid,
1220: c.key,