DBA Data[Home] [Help]

APPS.IBY_EXT_BANKACCT_PUB dependencies on IBY_SYS_SECURITY_OPTIONS

Line 39: (x_mask_setting OUT NOCOPY iby_sys_security_options.ext_ba_mask_setting%TYPE,

35: --
36: -- USE: Gets credit card mask settings
37: --
38: PROCEDURE Get_Mask_Settings
39: (x_mask_setting OUT NOCOPY iby_sys_security_options.ext_ba_mask_setting%TYPE,
40: x_unmask_len OUT NOCOPY iby_sys_security_options.ext_ba_unmask_len%TYPE
41: );
42:
43:

Line 40: x_unmask_len OUT NOCOPY iby_sys_security_options.ext_ba_unmask_len%TYPE

36: -- USE: Gets credit card mask settings
37: --
38: PROCEDURE Get_Mask_Settings
39: (x_mask_setting OUT NOCOPY iby_sys_security_options.ext_ba_mask_setting%TYPE,
40: x_unmask_len OUT NOCOPY iby_sys_security_options.ext_ba_unmask_len%TYPE
41: );
42:
43:
44: /*======================================================================

Line 4905: RETURN iby_sys_security_options.ext_ba_encryption_mode%TYPE

4901: --
4902: -- USE: Gets the bank account instrument encryption mode
4903: --
4904: FUNCTION Get_BA_Encrypt_Mode
4905: RETURN iby_sys_security_options.ext_ba_encryption_mode%TYPE
4906: IS
4907:
4908: l_mode iby_sys_security_options.ext_ba_encryption_mode%TYPE;
4909:

Line 4908: l_mode iby_sys_security_options.ext_ba_encryption_mode%TYPE;

4904: FUNCTION Get_BA_Encrypt_Mode
4905: RETURN iby_sys_security_options.ext_ba_encryption_mode%TYPE
4906: IS
4907:
4908: l_mode iby_sys_security_options.ext_ba_encryption_mode%TYPE;
4909:
4910: CURSOR c_encrypt_mode
4911: IS
4912: SELECT ext_ba_encryption_mode

Line 4913: FROM iby_sys_security_options;

4909:
4910: CURSOR c_encrypt_mode
4911: IS
4912: SELECT ext_ba_encryption_mode
4913: FROM iby_sys_security_options;
4914:
4915: BEGIN
4916: IF (c_encrypt_mode%ISOPEN) THEN CLOSE c_encrypt_mode; END IF;
4917:

Line 4952: p_mask_setting IN iby_sys_security_options.ext_ba_mask_setting%TYPE,

4948: END Mask_Bank_Number;
4949:
4950: PROCEDURE Compress_Bank_Number
4951: (p_bank_number IN VARCHAR2,
4952: p_mask_setting IN iby_sys_security_options.ext_ba_mask_setting%TYPE,
4953: p_unmask_len IN iby_sys_security_options.ext_ba_unmask_len%TYPE,
4954: x_compress_num OUT NOCOPY VARCHAR2,
4955: x_unmask_digits OUT NOCOPY VARCHAR2
4956: )

Line 4953: p_unmask_len IN iby_sys_security_options.ext_ba_unmask_len%TYPE,

4949:
4950: PROCEDURE Compress_Bank_Number
4951: (p_bank_number IN VARCHAR2,
4952: p_mask_setting IN iby_sys_security_options.ext_ba_mask_setting%TYPE,
4953: p_unmask_len IN iby_sys_security_options.ext_ba_unmask_len%TYPE,
4954: x_compress_num OUT NOCOPY VARCHAR2,
4955: x_unmask_digits OUT NOCOPY VARCHAR2
4956: )
4957: IS

Line 5052: l_mode iby_sys_security_options.ext_ba_encryption_mode%TYPE;

5048: )
5049: IS
5050: lx_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;
5051: lx_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;
5052: l_mode iby_sys_security_options.ext_ba_encryption_mode%TYPE;
5053: lx_key_error VARCHAR2(300);
5054:
5055: l_ba_num iby_ext_bank_accounts.bank_account_num%TYPE;
5056: l_iban iby_ext_bank_accounts.iban%TYPE;

Line 5256: l_mode iby_sys_security_options.ext_ba_encryption_mode%TYPE;

5252: (p_commit IN VARCHAR2,
5253: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE
5254: )
5255: IS
5256: l_mode iby_sys_security_options.ext_ba_encryption_mode%TYPE;
5257: lx_key_error VARCHAR2(300);
5258:
5259: lx_compress_num iby_ext_bank_accounts.bank_account_num%TYPE;
5260:

Line 5390: l_mode iby_sys_security_options.ext_ba_encryption_mode%TYPE;

5386: (p_commit IN VARCHAR2,
5387: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE
5388: )
5389: IS
5390: l_mode iby_sys_security_options.ext_ba_encryption_mode%TYPE;
5391: l_subkey iby_sys_security_subkeys.subkey_cipher_text%TYPE;
5392: l_ba_num iby_ext_bank_accounts.bank_account_num%TYPE;
5393: l_iban iby_ext_bank_accounts.iban%TYPE;
5394: l_e_ba iby_ext_bank_accounts.bank_account_num_electronic%TYPE;

Line 5513: (x_mask_setting OUT NOCOPY iby_sys_security_options.ext_ba_mask_setting%TYPE,

5509: --
5510: -- USE: Get bank account mask settings
5511: --
5512: PROCEDURE Get_Mask_Settings
5513: (x_mask_setting OUT NOCOPY iby_sys_security_options.ext_ba_mask_setting%TYPE,
5514: x_unmask_len OUT NOCOPY iby_sys_security_options.ext_ba_unmask_len%TYPE
5515: )
5516: IS
5517:

Line 5514: x_unmask_len OUT NOCOPY iby_sys_security_options.ext_ba_unmask_len%TYPE

5510: -- USE: Get bank account mask settings
5511: --
5512: PROCEDURE Get_Mask_Settings
5513: (x_mask_setting OUT NOCOPY iby_sys_security_options.ext_ba_mask_setting%TYPE,
5514: x_unmask_len OUT NOCOPY iby_sys_security_options.ext_ba_unmask_len%TYPE
5515: )
5516: IS
5517:
5518: CURSOR c_mask_setting

Line 5521: FROM iby_sys_security_options;

5517:
5518: CURSOR c_mask_setting
5519: IS
5520: SELECT ext_ba_mask_setting, ext_ba_unmask_len
5521: FROM iby_sys_security_options;
5522:
5523: BEGIN
5524: x_mask_setting := iby_security_pkg.G_MASK_PREFIX;
5525: