APPS.B_STD_OP_PKG dependencies on DUAL

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;

Line 1195: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS

1191: BEGIN
1192: -- Added If condition and wrote seperate sql's to handle x_line_id NULL condition.
1193: -- Bug 4173389
1194: If (X_Line_Id is NULL) Then
1195: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS
1196: (SELECT 1 FROM BOM_STANDARD_OPERATIONS
1197: WHERE Organization_Id = X_Organization_Id
1198: AND Operation_Code = X_Operation_Code
1199: AND (Operation_Type = X_Operation_Type

Line 1205: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS

1201: AND Line_Id IS NULL
1202: AND ((X_Rowid IS NULL) OR (ROWID <> X_Rowid))
1203: );
1204: Else
1205: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS
1206: (SELECT 1 FROM BOM_STANDARD_OPERATIONS
1207: WHERE Organization_Id = X_Organization_Id
1208: AND Operation_Code = X_Operation_Code
1209: AND (Operation_Type = X_Operation_Type

Line 1244: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS

1240: dummy NUMBER;
1241: x_line_code VARCHAR2(10);
1242: BEGIN
1243:
1244: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS
1245: (SELECT 1 FROM BOM_STANDARD_OPERATIONS
1246: WHERE Organization_Id = X_Organization_Id
1247: AND (Operation_Type = X_Operation_Type
1248: OR Operation_Type IS NULL)

Line 1269: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS

1265: PROCEDURE Check_References(X_Standard_Operation_Id NUMBER,
1266: X_Operation_Code VARCHAR2 ) IS
1267: dummy NUMBER;
1268: BEGIN
1269: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS
1270: (SELECT 1 FROM BOM_OPERATION_SEQUENCES
1271: WHERE STANDARD_OPERATION_ID = X_Standard_Operation_Id
1272: AND ((DISABLE_DATE > SYSDATE) OR (DISABLE_DATE IS NULL))
1273: );

Line 1325: SELECT 1 INTO l_dummy FROM DUAL WHERE NOT EXISTS

1321: PROCEDURE Check_Setup_Std_Op_Ref( P_Standard_Operation_Id NUMBER, -- BUG 4256393
1322: P_Operation_Code VARCHAR2 ) IS
1323: l_dummy NUMBER;
1324: BEGIN
1325: SELECT 1 INTO l_dummy FROM DUAL WHERE NOT EXISTS
1326: (SELECT 1 FROM BOM_SETUP_TRANSITIONS
1327: WHERE OPERATION_ID = P_Standard_Operation_Id
1328: );
1329: