DBA Data[Home] [Help]

APPS.PQP_COPY_EAT dependencies on PQP_EXTRACT_ATTRIBUTES

Line 19: FROM pqp_extract_attributes

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

Line 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

Line 81: -- Insert into PQP_EXTRACT_ATTRIBUTES

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

Line 82: INSERT INTO pqp_extract_attributes

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