APPS.IBY_HASH_REGENERATOR dependencies on IBY_VIEW_PARAMETERS_GT

Line 27: p_sys_key IN iby_view_parameters_gt.value%TYPE,

23: (
24: p_creditcards_flag IN VARCHAR2,
25: p_bankaccounts_flag IN VARCHAR2,
26: p_transactions_flag IN VARCHAR2,
27: p_sys_key IN iby_view_parameters_gt.value%TYPE,
28: p_force_create IN VARCHAR2
29: )
30: IS
31:

Line 41: l_sys_key iby_view_parameters_gt.value%TYPE;

37:
38: l_ba_id iby_ext_bank_accounts.ext_bank_account_id%TYPE;
39: l_ba_num iby_ext_bank_accounts.bank_account_num%TYPE;
40:
41: l_sys_key iby_view_parameters_gt.value%TYPE;
42: l_force_create VARCHAR2(1);
43:
44: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.Regenerate_Hash';
45:

Line 46: CURSOR get_credit_cards(p_sys_key iby_view_parameters_gt.value%TYPE) IS

42: l_force_create VARCHAR2(1);
43:
44: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.Regenerate_Hash';
45:
46: CURSOR get_credit_cards(p_sys_key iby_view_parameters_gt.value%TYPE) IS
47: SELECT
48: b.instrid instrid,
49: iby_creditcard_pkg.uncipher_ccnumber
50: (

Line 58: CURSOR get_bank_accounts(p_sys_key iby_view_parameters_gt.value%TYPE) IS

54: b.ccnumber credit_card_number2
55: FROM
56: iby_creditcard b;
57:
58: CURSOR get_bank_accounts(p_sys_key iby_view_parameters_gt.value%TYPE) IS
59: SELECT
60: b.ext_bank_account_id ext_bank_account_id,
61: iby_ext_bankacct_pub.uncipher_bank_number
62: (

Line 98: CURSOR get_txn_credit_cards(p_sys_key iby_view_parameters_gt.value%TYPE) IS

94: AND (b.iban_sec_segment_id = ibs.sec_segment_id(+))
95: AND (ibs.sec_subkey_id = ibk.sec_subkey_id(+));
96:
97:
98: CURSOR get_txn_credit_cards(p_sys_key iby_view_parameters_gt.value%TYPE) IS
99: SELECT tx.trxnmid,
100: iby_transactioncc_pkg.unencrypt_instr_num (
101: tx.instrnumber, NULL, NULL, p_sys_key, k.subkey_cipher_text,
102: tx.instrnum_sec_segment_id, seg.segment_cipher_text,

Line 127: CURSOR get_txn_bank_accounts(p_sys_key iby_view_parameters_gt.value%TYPE) IS

123: WHERE instrnum_sec_segment_id IS NULL
124: AND tx.instrtype = 'CREDITCARD'
125: AND tx.instrnumber IS NOT NULL;
126:
127: CURSOR get_txn_bank_accounts(p_sys_key iby_view_parameters_gt.value%TYPE) IS
128: SELECT tx.trxnmid,
129: iby_utility_pvt.decode64(instrnumber) bank_account_number,
130: instrnumber bank_account_number2
131: FROM iby_trxn_summaries_all tx

Line 378: p_sys_key IN iby_view_parameters_gt.value%TYPE

374: (
375: p_creditcards_flag IN VARCHAR2,
376: p_bankaccounts_flag IN VARCHAR2,
377: p_transactions_flag IN VARCHAR2,
378: p_sys_key IN iby_view_parameters_gt.value%TYPE
379: )
380: IS
381: BEGIN
382: Regenerate_Hash