APPS.IBY_CREDITCARD_PKG dependencies on IBY_CREDITCARD_PKG

Line 1: PACKAGE BODY iby_creditcard_pkg AS

1: PACKAGE BODY iby_creditcard_pkg AS
2: /*$Header: ibyccb.pls 120.84.12020000.2 2013/04/12 15:06:14 dhati ship $*/
3:
4: --Variable to store the supplemental cardholder data encryption flag
5: enc_supl_data iby_sys_security_options.encrypt_supplemental_card_data%TYPE;

Line 177: l_dbg_mod VARCHAR2(100) := 'iby.plsql.IBY_CREDITCARD_PKG' || '.' || 'encrypt_chname';

173: x_mask_setting OUT NOCOPY iby_sys_security_options.credit_card_mask_setting%TYPE,
174: x_unmask_len OUT NOCOPY iby_sys_security_options.credit_card_unmask_len%TYPE
175: )
176: IS
177: l_dbg_mod VARCHAR2(100) := 'iby.plsql.IBY_CREDITCARD_PKG' || '.' || 'encrypt_chname';
178: BEGIN
179: IBY_SECURITY_PKG.encrypt_chname(p_sec_key,
180: p_chname,
181: p_segment_id,

Line 831: l_dbg_mod VARCHAR2(100) := 'iby.plsql.IBY_CREDITCARD_PKG' || '.' || 'Update_Card';

827: l_invalidation_reason VARCHAR2(100) := NULL;
828: l_allow_invalid_card VARCHAR2(1);
829: l_new_issuer iby_creditcard.card_issuer_code%TYPE := NULL;
830:
831: l_dbg_mod VARCHAR2(100) := 'iby.plsql.IBY_CREDITCARD_PKG' || '.' || 'Update_Card';
832:
833: BEGIN
834: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
835: l_allow_invalid_card := NVL(p_allow_invalid_card, 'N');

Line 1112: l_dbg_mod VARCHAR2(100) := 'iby.plsql.IBY_CREDITCARD_PKG' || '.' || 'check_card_validity';

1108: x_invalid_flag OUT NOCOPY iby_creditcard.invalid_flag%TYPE,
1109: x_invalidation_reason OUT NOCOPY iby_creditcard.invalidation_reason%TYPE
1110: )
1111: IS
1112: l_dbg_mod VARCHAR2(100) := 'iby.plsql.IBY_CREDITCARD_PKG' || '.' || 'check_card_validity';
1113: l_expired VARCHAR2(1) := NULL;
1114: l_card_issuer1 iby_creditcard.card_issuer_code%TYPE;
1115: l_card_issuer2 iby_creditcard.card_issuer_code%TYPE;
1116: l_temp_issuer iby_creditcard.card_issuer_code%TYPE;

Line 1422: l_dbg_mod VARCHAR2(100) := 'iby.plsql.IBY_CREDITCARD_PKG' || '.' || 'Encrypt_Instruments';

1418: l_expired_flag VARCHAR2(1);
1419: l_encrypted VARCHAR2(1);
1420: l_enc_supl_data VARCHAR2(1);
1421:
1422: l_dbg_mod VARCHAR2(100) := 'iby.plsql.IBY_CREDITCARD_PKG' || '.' || 'Encrypt_Instruments';
1423:
1424:
1425: CURSOR c_card
1426: IS

Line 2077: l_dbg_mod VARCHAR2(100) := 'IBY_CREDITCARD_PKG' || '.' ||

2073: syskey_checked VARCHAR2(1) := 'N';
2074: cnt NUMBER := 0;
2075:
2076: l_api_name CONSTANT VARCHAR2(30) := 'Mark_Expired_Cards';
2077: l_dbg_mod VARCHAR2(100) := 'IBY_CREDITCARD_PKG' || '.' ||
2078: l_api_name;
2079:
2080: CURSOR c_card
2081: IS

Line 2147: l_dbg_mod VARCHAR2(100) := 'IBY_CREDITCARD_PKG' || '.' ||

2143: p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE
2144: )
2145: IS
2146: l_api_name CONSTANT VARCHAR2(30) := 'Upgrade_Encrypted_Instruments';
2147: l_dbg_mod VARCHAR2(100) := 'IBY_CREDITCARD_PKG' || '.' ||
2148: l_api_name;
2149:
2150: l_exp_segment_id NUMBER;
2151: l_expired_flag VARCHAR2(1);

Line 2310: l_dbg_mod VARCHAR2(100) := 'iby.plsql.IBY_CREDITCARD_PKG' || '.' || 'Upgrade_Risky_Instruments';

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:
2312: BEGIN
2313: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Enter..');
2314: no_cc := 0;

Line 2397: l_dbg_mod VARCHAR2(100) := 'iby.plsql.IBY_CREDITCARD_PKG' || '.' || 'Purge_Sensitive_Data';

2393: x_batch_size IN NUMBER,
2394: x_num_workers IN NUMBER
2395: )
2396: IS
2397: l_dbg_mod VARCHAR2(100) := 'iby.plsql.IBY_CREDITCARD_PKG' || '.' || 'Purge_Sensitive_Data';
2398: req_id VARCHAR2(30);
2399: plsql_block VARCHAR2(500);
2400: x_req_id NUMBER;
2401: l_call_status BOOLEAN;

Line 2486: END iby_creditcard_pkg;

2482:
2483:
2484: END Purge_Sensitive_Data;
2485:
2486: END iby_creditcard_pkg;