716: l_api_version_number CONSTANT NUMBER := 1.0;
717:
718: xProgress VARCHAR2(80);
719: l_interface_column_id NUMBER;
720: l_interface_column_name ece_interface_columns.interface_column_name%TYPE;
721: l_interface_column_value VARCHAR2(500);
722: l_interface_column_datatype ece_interface_columns.data_type%TYPE;
723: l_rule_type ece_column_rules.rule_type%TYPE;
724: l_rule_id NUMBER;
718: xProgress VARCHAR2(80);
719: l_interface_column_id NUMBER;
720: l_interface_column_name ece_interface_columns.interface_column_name%TYPE;
721: l_interface_column_value VARCHAR2(500);
722: l_interface_column_datatype ece_interface_columns.data_type%TYPE;
723: l_rule_type ece_column_rules.rule_type%TYPE;
724: l_rule_id NUMBER;
725: l_action_code ece_column_rules.action_code%TYPE;
726: l_valid_rule VARCHAR2(1):= 'Y';