APPS.IBY_EVAL_RISKY_INSTR_PKG dependencies on IBY_IRF_RISKY_INSTR

Line 27: l_cc_hash1 iby_irf_risky_instr.cc_number_hash1%TYPE;

23: lx_cc_number iby_creditcard.ccnumber%TYPE;
24: lx_return_status VARCHAR2(1);
25: lx_msg_count NUMBER;
26: lx_msg_data VARCHAR2(200);
27: l_cc_hash1 iby_irf_risky_instr.cc_number_hash1%TYPE;
28: l_cc_hash2 iby_irf_risky_instr.cc_number_hash2%TYPE;
29: l_cc_strip_number iby_creditcard.ccnumber%TYPE;
30: begin
31: --dbms_output.put_line('ccnumber = '||i_ccnumber);

Line 28: l_cc_hash2 iby_irf_risky_instr.cc_number_hash2%TYPE;

24: lx_return_status VARCHAR2(1);
25: lx_msg_count NUMBER;
26: lx_msg_data VARCHAR2(200);
27: l_cc_hash1 iby_irf_risky_instr.cc_number_hash1%TYPE;
28: l_cc_hash2 iby_irf_risky_instr.cc_number_hash2%TYPE;
29: l_cc_strip_number iby_creditcard.ccnumber%TYPE;
30: begin
31: --dbms_output.put_line('ccnumber = '||i_ccnumber);
32: --dbms_output.put_line('instrid = '||to_char(i_instrid));

Line 52: from iby_irf_risky_instr

48: l_cc_hash1 := iby_security_pkg.get_hash(lx_cc_number,FND_API.G_FALSE);
49: l_cc_hash2 := iby_security_pkg.get_hash(lx_cc_number,FND_API.G_TRUE);
50: -- changed the query to include hash values in the column comparison
51: select count(*) into l_count
52: from iby_irf_risky_instr
53: where instrtype = 'CREDITCARD' and
54: cc_number_hash1 = l_cc_hash1 and
55: cc_number_hash2 = l_cc_hash2;
56: