DBA Data[Home] [Help]

APPS.BOM_STRUCTURE_TYPES_PKG dependencies on DUAL

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: