15: ) IS
16:
17: CURSOR c_ext_attr IS
18: SELECT *
19: FROM pqp_extract_attributes
20: WHERE ext_dfn_id = p_curr_ext_dfn_id;
21:
22: CURSOR c_get_seq IS
23: SELECT pqp_extract_attributes_s.nextval
19: FROM pqp_extract_attributes
20: WHERE ext_dfn_id = p_curr_ext_dfn_id;
21:
22: CURSOR c_get_seq IS
23: SELECT pqp_extract_attributes_s.nextval
24: FROM dual;
25:
26: CURSOR c_new_ext_name IS
27: SELECT name
77: OPEN c_get_seq;
78: FETCH c_get_seq INTO l_new_seq_id;
79: CLOSE c_get_seq;
80:
81: -- Insert into PQP_EXTRACT_ATTRIBUTES
82: INSERT INTO pqp_extract_attributes
83: (extract_attribute_id
84: ,ext_dfn_id
85: ,ext_dfn_name
78: FETCH c_get_seq INTO l_new_seq_id;
79: CLOSE c_get_seq;
80:
81: -- Insert into PQP_EXTRACT_ATTRIBUTES
82: INSERT INTO pqp_extract_attributes
83: (extract_attribute_id
84: ,ext_dfn_id
85: ,ext_dfn_name
86: ,ext_dfn_type