176: l_proc_name varchar2(80) DEFAULT '';
177: l_rowid rowid;
178: l_sub_class_rule_id number;
179: l_sub_classification_id number;
180: l_user_id number DEFAULT fnd_global.user_id;
181: l_login_id number DEFAULT fnd_global.login_id;
182: l_business_group_id number;
183: l_effective_start_date date;
184: proc_element_type_id number;
177: l_rowid rowid;
178: l_sub_class_rule_id number;
179: l_sub_classification_id number;
180: l_user_id number DEFAULT fnd_global.user_id;
181: l_login_id number DEFAULT fnd_global.login_id;
182: l_business_group_id number;
183: l_effective_start_date date;
184: proc_element_type_id number;
185: duplicate_sub_clas EXCEPTION;