14: PROCEDURE Get_UID( X_sca_rule_attribute_id IN OUT NOCOPY NUMBER) IS
15:
16: BEGIN
17:
18: SELECT cn_sca_rule_attributes_s.nextval
19: INTO X_sca_rule_attribute_id
20: FROM sys.dual;
21:
22: END Get_UID;
173: ,x_Last_Update_Login NUMBER) IS
174:
175: l_user_name cn_sca_rule_attributes.user_column_name%TYPE;
176: l_value_set_id cn_sca_rule_attributes.value_set_id%TYPE;
177: l_destination_column cn_sca_rule_attributes.src_column_name%TYPE;
178: l_enable_flag cn_sca_rule_attributes.enabled_flag%TYPE;
179: l_datatype cn_sca_rule_attributes.datatype%TYPE;
180: l_trx_source_column_name cn_sca_rule_attributes.trx_src_column_name%TYPE;
181: l_transaction_source cn_sca_rule_attributes.transaction_source%TYPE;