APPS.ZPB_METADATA_PKG dependencies on ZPB_TABLES_SEQ

Line 167: SELECT zpb_tables_seq.NEXTVAL INTO l_table_rec.TableId FROM DUAL;

163: where table_id = l_table_rec.TableId;
164:
165: exception
166: when NO_DATA_FOUND then
167: SELECT zpb_tables_seq.NEXTVAL INTO l_table_rec.TableId FROM DUAL;
168: insert_flag := true;
169: end;
170: end if;
171:

Line 2163: SELECT zpb_tables_seq.NEXTVAL INTO m_hr_shar_table_en.tableId FROM DUAL;

2159: m_shar_table_exists := false;
2160:
2161: exception
2162: when NO_DATA_FOUND then
2163: SELECT zpb_tables_seq.NEXTVAL INTO m_hr_shar_table_en.tableId FROM DUAL;
2164:
2165: m_shar_table_exists := true;
2166: end;
2167:

Line 2191: SELECT zpb_tables_seq.NEXTVAL INTO m_hr_pers_table_en.tableId FROM DUAL;

2187: m_pers_table_exists :=false;
2188:
2189: exception
2190: when NO_DATA_FOUND then
2191: SELECT zpb_tables_seq.NEXTVAL INTO m_hr_pers_table_en.tableId FROM DUAL;
2192: m_pers_table_exists :=true;
2193: end;
2194:
2195: -- dbms_output.put_line('Hier Shar Table ID: ' || m_hr_shar_table_en.tableId );