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_CREDITCARD_PKG dependencies on IBY_IRF_RISKY_INSTR

Line 2286: l_cc_hash1 iby_irf_risky_instr.cc_number_hash1%TYPE;

2282: lx_msg_count NUMBER;
2283: lx_msg_data VARCHAR2(200);
2284:
2285: --variables to store the creditcard number hash values
2286: l_cc_hash1 iby_irf_risky_instr.cc_number_hash1%TYPE;
2287: l_cc_hash2 iby_irf_risky_instr.cc_number_hash2%TYPE;
2288:
2289: --variables to store the account number hash values
2290: l_acct_no_hash1 iby_irf_risky_instr.acct_number_hash1%TYPE;

Line 2287: l_cc_hash2 iby_irf_risky_instr.cc_number_hash2%TYPE;

2283: lx_msg_data VARCHAR2(200);
2284:
2285: --variables to store the creditcard number hash values
2286: l_cc_hash1 iby_irf_risky_instr.cc_number_hash1%TYPE;
2287: l_cc_hash2 iby_irf_risky_instr.cc_number_hash2%TYPE;
2288:
2289: --variables to store the account number hash values
2290: l_acct_no_hash1 iby_irf_risky_instr.acct_number_hash1%TYPE;
2291: l_acct_no_hash2 iby_irf_risky_instr.acct_number_hash2%TYPE;

Line 2290: l_acct_no_hash1 iby_irf_risky_instr.acct_number_hash1%TYPE;

2286: l_cc_hash1 iby_irf_risky_instr.cc_number_hash1%TYPE;
2287: l_cc_hash2 iby_irf_risky_instr.cc_number_hash2%TYPE;
2288:
2289: --variables to store the account number hash values
2290: l_acct_no_hash1 iby_irf_risky_instr.acct_number_hash1%TYPE;
2291: l_acct_no_hash2 iby_irf_risky_instr.acct_number_hash2%TYPE;
2292:
2293: --Variables to store the number of cerditcard numbers
2294: --or account numbers that are updated

Line 2291: l_acct_no_hash2 iby_irf_risky_instr.acct_number_hash2%TYPE;

2287: l_cc_hash2 iby_irf_risky_instr.cc_number_hash2%TYPE;
2288:
2289: --variables to store the account number hash values
2290: l_acct_no_hash1 iby_irf_risky_instr.acct_number_hash1%TYPE;
2291: l_acct_no_hash2 iby_irf_risky_instr.acct_number_hash2%TYPE;
2292:
2293: --Variables to store the number of cerditcard numbers
2294: --or account numbers that are updated
2295: no_cc NUMBER;

Line 2298: -- Cursor will fetch all the records from IBY_IRF_RISKY_INSTR

2294: --or account numbers that are updated
2295: no_cc NUMBER;
2296: no_acct NUMBER;
2297:
2298: -- Cursor will fetch all the records from IBY_IRF_RISKY_INSTR
2299: -- and lock them for UPDATE
2300:
2301: CURSOR get_risky_instruments IS
2302: SELECT payeeid, instrtype,

Line 2307: FROM iby_irf_risky_instr

2303: account_no, creditcard_no,
2304: cc_number_hash1, cc_number_hash2,
2305: acct_number_hash1, acct_number_hash2,
2306: object_version_number, last_update_date
2307: FROM iby_irf_risky_instr
2308: FOR UPDATE;
2309:
2310: l_dbg_mod VARCHAR2(100) := 'iby.plsql.IBY_CREDITCARD_PKG' || '.' || 'Upgrade_Risky_Instruments';
2311:

Line 2339: UPDATE iby_irf_risky_instr

2335: (lx_cc_number,FND_API.G_FALSE);
2336: l_cc_hash2 := iby_security_pkg.get_hash
2337: (lx_cc_number,FND_API.G_TRUE);
2338:
2339: UPDATE iby_irf_risky_instr
2340: SET creditcard_no = NULL,
2341: cc_number_hash1 = l_cc_hash1,
2342: cc_number_hash2 = l_cc_hash2,
2343: object_version_number = risky_instr_rec.object_version_number + 1,

Line 2358: UPDATE iby_irf_risky_instr

2354: (risky_instr_rec.account_no,FND_API.G_FALSE);
2355: l_acct_no_hash2 := iby_security_pkg.get_hash
2356: (risky_instr_rec.account_no,FND_API.G_TRUE);
2357:
2358: UPDATE iby_irf_risky_instr
2359: SET account_no = NULL,
2360: acct_number_hash1 = l_acct_no_hash1,
2361: acct_number_hash2 = l_acct_no_hash2,
2362: object_version_number = risky_instr_rec.object_version_number + 1,

Line 2477: -- Upgrade the data in IBY_IRF_RISKY_INSTR

2473: WHEN OTHERS THEN
2474: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Exception thrown during ASO_PAYMENT_INT.PURGE_ASO_PAYMENTS_DATA invocation. '|| SQLERRM);
2475: END;
2476:
2477: -- Upgrade the data in IBY_IRF_RISKY_INSTR
2478: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Upgrading Data in IBY_IRF_RISKY_INSTR. Timestamp: '||TO_CHAR(systimestamp,'SSSSS.FF'));
2479: Upgrade_Risky_Instruments('T');
2480: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Finshed Upgrading Data in IBY_IRF_RISKY_INSTR. Timestamp: '||TO_CHAR(systimestamp,'SSSSS.FF'));
2481: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Exit.');

Line 2478: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Upgrading Data in IBY_IRF_RISKY_INSTR. Timestamp: '||TO_CHAR(systimestamp,'SSSSS.FF'));

2474: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Exception thrown during ASO_PAYMENT_INT.PURGE_ASO_PAYMENTS_DATA invocation. '|| SQLERRM);
2475: END;
2476:
2477: -- Upgrade the data in IBY_IRF_RISKY_INSTR
2478: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Upgrading Data in IBY_IRF_RISKY_INSTR. Timestamp: '||TO_CHAR(systimestamp,'SSSSS.FF'));
2479: Upgrade_Risky_Instruments('T');
2480: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Finshed Upgrading Data in IBY_IRF_RISKY_INSTR. Timestamp: '||TO_CHAR(systimestamp,'SSSSS.FF'));
2481: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Exit.');
2482:

Line 2480: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Finshed Upgrading Data in IBY_IRF_RISKY_INSTR. Timestamp: '||TO_CHAR(systimestamp,'SSSSS.FF'));

2476:
2477: -- Upgrade the data in IBY_IRF_RISKY_INSTR
2478: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Upgrading Data in IBY_IRF_RISKY_INSTR. Timestamp: '||TO_CHAR(systimestamp,'SSSSS.FF'));
2479: Upgrade_Risky_Instruments('T');
2480: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Finshed Upgrading Data in IBY_IRF_RISKY_INSTR. Timestamp: '||TO_CHAR(systimestamp,'SSSSS.FF'));
2481: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Exit.');
2482:
2483:
2484: END Purge_Sensitive_Data;