DBA Data[Home] [Help]

APPS.B_STD_OP_PKG dependencies on BOM_STANDARD_OPERATIONS_S

Line 46: CURSOR C2 IS SELECT bom_standard_operations_s.nextval FROM sys.dual;

42:
43: ) IS
44: CURSOR C IS SELECT rowid FROM BOM_STANDARD_OPERATIONS
45: WHERE standard_operation_id = X_Standard_Operation_Id;
46: CURSOR C2 IS SELECT bom_standard_operations_s.nextval FROM sys.dual;
47: BEGIN
48: if (X_Standard_Operation_Id is NULL) then
49: OPEN C2;
50: FETCH C2 INTO X_Standard_Operation_Id;

Line 295: CURSOR C2 IS SELECT bom_standard_operations_s.nextval FROM sys.dual;

291: X_CHECK_SKILL NUMBER DEFAULT NULL
292: ) IS
293: CURSOR C IS SELECT rowid FROM BOM_STANDARD_OPERATIONS
294: WHERE standard_operation_id = X_Standard_Operation_Id;
295: CURSOR C2 IS SELECT bom_standard_operations_s.nextval FROM sys.dual;
296: BEGIN
297: if (X_Standard_Operation_Id is NULL) then
298: OPEN C2;
299: FETCH C2 INTO X_Standard_Operation_Id;