APPS.B_STD_OP_RES_PKG dependencies on BOM_STD_OP_RESOURCES

Line 115: CURSOR C IS SELECT rowid FROM BOM_STD_OP_RESOURCES

111: X_Attribute13 VARCHAR2 DEFAULT NULL,
112: X_Attribute14 VARCHAR2 DEFAULT NULL,
113: X_Attribute15 VARCHAR2 DEFAULT NULL
114: ) IS
115: CURSOR C IS SELECT rowid FROM BOM_STD_OP_RESOURCES
116: WHERE standard_operation_id = X_Standard_Operation_Id
117: AND resource_seq_num = X_Resource_Seq_Num;
118:
119: BEGIN

Line 120: INSERT INTO BOM_STD_OP_RESOURCES(

116: WHERE standard_operation_id = X_Standard_Operation_Id
117: AND resource_seq_num = X_Resource_Seq_Num;
118:
119: BEGIN
120: INSERT INTO BOM_STD_OP_RESOURCES(
121: standard_operation_id,
122: resource_id,
123: substitute_group_num,
124: activity_id,

Line 296: FROM BOM_STD_OP_RESOURCES

292: X_Attribute15 VARCHAR2 DEFAULT NULL
293: ) IS
294: CURSOR C IS
295: SELECT *
296: FROM BOM_STD_OP_RESOURCES
297: WHERE rowid = X_Rowid
298: FOR UPDATE of Standard_Operation_Id, Substitute_Group_Num NOWAIT;
299: Recinfo C%ROWTYPE;
300: BEGIN

Line 504: UPDATE BOM_STD_OP_RESOURCES

500: X_Attribute14 VARCHAR2 DEFAULT NULL,
501: X_Attribute15 VARCHAR2 DEFAULT NULL
502: ) IS
503: BEGIN
504: UPDATE BOM_STD_OP_RESOURCES
505: SET
506: standard_operation_id = X_Standard_Operation_Id,
507: resource_id = X_Resource_Id,
508: substitute_group_num = X_Substitute_Group_Num,

Line 547: DELETE FROM BOM_STD_OP_RESOURCES

543: END Update_Row;
544:
545: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
546: BEGIN
547: DELETE FROM BOM_STD_OP_RESOURCES
548: WHERE rowid = X_Rowid;
549:
550: if (SQL%NOTFOUND) then
551: RAISE NO_DATA_FOUND;

Line 561: (SELECT 1 FROM BOM_STD_OP_RESOURCES

557: X_Resource_Seq_Num NUMBER) IS
558: dummy NUMBER;
559: BEGIN
560: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS
561: (SELECT 1 FROM BOM_STD_OP_RESOURCES
562: WHERE Standard_Operation_Id = X_Standard_Operation_Id
563: AND Resource_Seq_Num = X_Resource_Seq_Num
564: AND ((X_Rowid IS NULL) OR (ROWID <> X_Rowid))
565: );