Line 94: SELECT BOM_STRUCTURE_TYPES_B_S.nextval INTO str_id FROM dual;
90:
91: IF (stype_exists = 0)
92: THEN
93: 94: SELECT BOM_STRUCTURE_TYPES_B_S.nextval INTO str_id FROM dual; 95:
96: INSERT INTO BOM_STRUCTURE_TYPES_B
97: (
98: STRUCTURE_TYPE_ID,
Line 160: FROM DUAL
156: X_Disable_Date,
157: X_Parent_Structure_Type_Id,
158: X_Enable_Attachments_Flag,
159: X_Allow_Subtypes 160: FROM DUAL 161: WHERE NOT EXISTS (SELECT 1 from BOM_STRUCTURE_TYPES_B
162: WHERE STRUCTURE_TYPE_NAME = X_Structure_Type_Name );
163:
164: