APPS.B_STD_OP_PKG dependencies on BOM_STANDARD_OPERATIONS

Line 44: CURSOR C IS SELECT rowid FROM BOM_STANDARD_OPERATIONS

40: X_Operation_Yield_Enabled NUMBER DEFAULT NULL,
41: X_Shutdown_Type VARCHAR2 DEFAULT NULL
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

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 53: INSERT INTO BOM_STANDARD_OPERATIONS(

49: OPEN C2;
50: FETCH C2 INTO X_Standard_Operation_Id;
51: CLOSE C2;
52: end if;
53: INSERT INTO BOM_STANDARD_OPERATIONS(
54: standard_operation_id,
55: operation_code,
56: operation_type,
57: line_id,

Line 293: CURSOR C IS SELECT rowid FROM BOM_STANDARD_OPERATIONS

289: X_TRACK_MULTIPLE_RES_USAGE_DTS NUMBER,
290: -- Added for labor skills validation project
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

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 302: INSERT INTO BOM_STANDARD_OPERATIONS(

298: OPEN C2;
299: FETCH C2 INTO X_Standard_Operation_Id;
300: CLOSE C2;
301: end if;
302: INSERT INTO BOM_STANDARD_OPERATIONS(
303: standard_operation_id,
304: operation_code,
305: operation_type,
306: line_id,

Line 459: FROM BOM_STANDARD_OPERATIONS

455:
456: ) IS
457: CURSOR C IS
458: SELECT *
459: FROM BOM_STANDARD_OPERATIONS
460: WHERE rowid = X_Rowid
461: FOR UPDATE of Standard_Operation_Id NOWAIT;
462: Recinfo C%ROWTYPE;
463: BEGIN

Line 717: FROM BOM_STANDARD_OPERATIONS

713: X_CHECK_SKILL NUMBER DEFAULT NULL
714: ) IS
715: CURSOR C IS
716: SELECT *
717: FROM BOM_STANDARD_OPERATIONS
718: WHERE rowid = X_Rowid
719: FOR UPDATE of Standard_Operation_Id NOWAIT;
720: Recinfo C%ROWTYPE;
721: BEGIN

Line 919: UPDATE BOM_STANDARD_OPERATIONS

915: X_Shutdown_Type VARCHAR2 DEFAULT NULL
916:
917: ) IS
918: BEGIN
919: UPDATE BOM_STANDARD_OPERATIONS
920: SET
921: standard_operation_id = X_Standard_Operation_Id,
922: operation_code = X_Operation_Code,
923: operation_type = X_Operation_Type,

Line 1111: UPDATE BOM_STANDARD_OPERATIONS

1107: X_TRACK_MULTIPLE_RES_USAGE_DTS NUMBER,
1108: X_CHECK_SKILL NUMBER DEFAULT NULL
1109: ) IS
1110: BEGIN
1111: UPDATE BOM_STANDARD_OPERATIONS
1112: SET
1113: standard_operation_id = X_Standard_Operation_Id,
1114: operation_code = X_Operation_Code,
1115: operation_type = X_Operation_Type,

Line 1174: DELETE FROM BOM_STANDARD_OPERATIONS

1170:
1171: PROCEDURE Delete_Row(X_Rowid VARCHAR2,
1172: X_Standard_Operation_Id NUMBER) IS
1173: BEGIN
1174: DELETE FROM BOM_STANDARD_OPERATIONS
1175: WHERE rowid = X_Rowid;
1176:
1177: if (SQL%NOTFOUND) then
1178: Raise NO_DATA_FOUND;

Line 1196: (SELECT 1 FROM BOM_STANDARD_OPERATIONS

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
1200: OR Operation_Type IS NULL)

Line 1206: (SELECT 1 FROM BOM_STANDARD_OPERATIONS

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
1210: OR Operation_Type IS NULL)

Line 1245: (SELECT 1 FROM BOM_STANDARD_OPERATIONS

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)
1249: AND (Line_Id = X_Line_Id