APPS.BOM_DEPARTMENTS_PKG dependencies on BOM_DEPARTMENTS_S
Line 41: CURSOR C2 IS SELECT bom_departments_s.nextval FROM sys.dual;
37: X_Maint_Cost_Category VARCHAR2 DEFAULT NULL
38: ) IS
39: CURSOR C IS SELECT rowid FROM BOM_DEPARTMENTS
40: WHERE department_id = X_Department_Id; 41: CURSOR C2 IS SELECT bom_departments_s.nextval FROM sys.dual; 42: BEGIN
43: if (X_Department_Id is NULL) then
44: OPEN C2;
45: FETCH C2 INTO X_Department_Id;