APPS.IBY_RISKYINSTR_PKG dependencies on IBY_SECURITY_PKG

Line 85: l_cc_hash1 := iby_security_pkg.get_hash

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
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

Line 87: l_cc_hash2 := iby_security_pkg.get_hash

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
91: WHERE payeeid = l_payeeid

Line 121: l_account_no_hash1 := iby_security_pkg.get_hash

117:
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

Line 123: l_account_no_hash2 := iby_security_pkg.get_hash

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
127: WHERE payeeid = l_payeeid

Line 223: l_cc_hash1 := iby_security_pkg.get_hash

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
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

Line 225: l_cc_hash2 := iby_security_pkg.get_hash

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
229: and instrtype = l_instrtype

Line 240: l_account_no_hash1 := iby_security_pkg.get_hash

236: end if;
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

Line 242: l_account_no_hash2 := iby_security_pkg.get_hash

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
246: and instrtype = l_instrtype