DBA Data[Home] [Help]

APPS.CN_SCA_CRRULEATTR_PKG dependencies on CN_SCA_RULE_ATTRIBUTES_S

Line 18: SELECT cn_sca_rule_attributes_s.nextval

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;

Line 177: l_destination_column cn_sca_rule_attributes.src_column_name%TYPE;

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;