DBA Data[Home] [Help]

APPS.IBY_RISKYINSTR_PKG dependencies on FND_API

Line 81: (1.0, FND_API.G_FALSE, i_riskyinstr(i).CreditCard_Num,

77: IF ( l_instrtype = 'CREDITCARD' ) then
78: -- Added for bug# 7228388
79: -- Strip the symbols
80: IBY_CC_VALIDATE.StripCC
81: (1.0, FND_API.G_FALSE, i_riskyinstr(i).CreditCard_Num,
82: IBY_CC_VALIDATE.c_FillerChars,
83: lx_return_status, lx_msg_count, lx_msg_data, lx_cc_number);
84: -- Get hash values of the credit number
85: l_cc_hash1 := iby_security_pkg.get_hash

Line 86: (lx_cc_number,FND_API.G_FALSE);

82: IBY_CC_VALIDATE.c_FillerChars,
83: lx_return_status, lx_msg_count, lx_msg_data, lx_cc_number);
84: -- Get hash values of the credit number
85: l_cc_hash1 := iby_security_pkg.get_hash
86: (lx_cc_number,FND_API.G_FALSE);
87: l_cc_hash2 := iby_security_pkg.get_hash
88: (lx_cc_number,FND_API.G_TRUE);
89: SELECT COUNT(-1) INTO l_riskinscount
90: FROM iby_irf_risky_instr

Line 88: (lx_cc_number,FND_API.G_TRUE);

84: -- Get hash values of the credit number
85: l_cc_hash1 := iby_security_pkg.get_hash
86: (lx_cc_number,FND_API.G_FALSE);
87: l_cc_hash2 := iby_security_pkg.get_hash
88: (lx_cc_number,FND_API.G_TRUE);
89: SELECT COUNT(-1) INTO l_riskinscount
90: FROM iby_irf_risky_instr
91: WHERE payeeid = l_payeeid
92: and instrtype = l_instrtype

Line 122: (i_riskyinstr(i).Account_Num,FND_API.G_FALSE);

118:
119: ELSIF ( l_instrtype = 'BANKACCOUNT') then
120: -- Get the hash values of the account number
121: l_account_no_hash1 := iby_security_pkg.get_hash
122: (i_riskyinstr(i).Account_Num,FND_API.G_FALSE);
123: l_account_no_hash2 := iby_security_pkg.get_hash
124: (i_riskyinstr(i).Account_Num,FND_API.G_TRUE);
125: SELECT COUNT(-1) INTO l_riskinscount
126: FROM iby_irf_risky_instr

Line 124: (i_riskyinstr(i).Account_Num,FND_API.G_TRUE);

120: -- Get the hash values of the account number
121: l_account_no_hash1 := iby_security_pkg.get_hash
122: (i_riskyinstr(i).Account_Num,FND_API.G_FALSE);
123: l_account_no_hash2 := iby_security_pkg.get_hash
124: (i_riskyinstr(i).Account_Num,FND_API.G_TRUE);
125: SELECT COUNT(-1) INTO l_riskinscount
126: FROM iby_irf_risky_instr
127: WHERE payeeid = l_payeeid
128: and instrtype = l_instrtype

Line 219: (1.0, FND_API.G_FALSE, i_riskyinstr(i).CreditCard_Num,

215: IF (l_instrtype = 'CREDITCARD') then
216: -- Included hash1 and hash2 values as part of bug#7228388
217: -- Strip symbols from the credit card, if any
218: IBY_CC_VALIDATE.StripCC
219: (1.0, FND_API.G_FALSE, i_riskyinstr(i).CreditCard_Num,
220: IBY_CC_VALIDATE.c_FillerChars,
221: lx_return_status, lx_msg_count, lx_msg_data, lx_cc_number);
222: -- Get hash values of the credit number
223: l_cc_hash1 := iby_security_pkg.get_hash

Line 224: (lx_cc_number,FND_API.G_FALSE);

220: IBY_CC_VALIDATE.c_FillerChars,
221: lx_return_status, lx_msg_count, lx_msg_data, lx_cc_number);
222: -- Get hash values of the credit number
223: l_cc_hash1 := iby_security_pkg.get_hash
224: (lx_cc_number,FND_API.G_FALSE);
225: l_cc_hash2 := iby_security_pkg.get_hash
226: (lx_cc_number,FND_API.G_TRUE);
227: Delete FROM iby_irf_risky_instr
228: WHERE payeeid = l_payeeid

Line 226: (lx_cc_number,FND_API.G_TRUE);

222: -- Get hash values of the credit number
223: l_cc_hash1 := iby_security_pkg.get_hash
224: (lx_cc_number,FND_API.G_FALSE);
225: l_cc_hash2 := iby_security_pkg.get_hash
226: (lx_cc_number,FND_API.G_TRUE);
227: Delete FROM iby_irf_risky_instr
228: WHERE payeeid = l_payeeid
229: and instrtype = l_instrtype
230: and cc_number_hash1 = l_cc_hash1

Line 241: (i_riskyinstr(i).Account_Num,FND_API.G_FALSE);

237: ELSIF ( l_instrtype = 'BANKACCOUNT' ) then
238: -- Included hash1 and hash2 values as part of bug#7228187
239: -- Get hash values of the account number
240: l_account_no_hash1 := iby_security_pkg.get_hash
241: (i_riskyinstr(i).Account_Num,FND_API.G_FALSE);
242: l_account_no_hash2 := iby_security_pkg.get_hash
243: (i_riskyinstr(i).Account_Num,FND_API.G_TRUE);
244: Delete FROM iby_irf_risky_instr
245: WHERE payeeid = l_payeeid

Line 243: (i_riskyinstr(i).Account_Num,FND_API.G_TRUE);

239: -- Get hash values of the account number
240: l_account_no_hash1 := iby_security_pkg.get_hash
241: (i_riskyinstr(i).Account_Num,FND_API.G_FALSE);
242: l_account_no_hash2 := iby_security_pkg.get_hash
243: (i_riskyinstr(i).Account_Num,FND_API.G_TRUE);
244: Delete FROM iby_irf_risky_instr
245: WHERE payeeid = l_payeeid
246: and instrtype = l_instrtype
247: and routing_no = i_riskyinstr(i).Routing_Num