APPS.B_STD_OP_RES_PKG dependencies on BOM_STD_OP_RESOURCES

Line 118: CURSOR C IS SELECT rowid FROM BOM_STD_OP_RESOURCES

114: X_Attribute15 VARCHAR2 DEFAULT NULL,
115: X_SCHEDULE_SEQ_NUM NUMBER DEFAULT NULL, -- Bug#14550670
116: X_PRINCIPLE_FLAG NUMBER DEFAULT NULL -- Bug#14550670
117: ) IS
118: CURSOR C IS SELECT rowid FROM BOM_STD_OP_RESOURCES
119: WHERE standard_operation_id = X_Standard_Operation_Id
120: AND resource_seq_num = X_Resource_Seq_Num;
121:
122: BEGIN

Line 123: INSERT INTO BOM_STD_OP_RESOURCES(

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

Line 308: FROM BOM_STD_OP_RESOURCES

304: X_PRINCIPLE_FLAG NUMBER DEFAULT NULL -- Bug#14550670
305: ) IS
306: CURSOR C IS
307: SELECT *
308: FROM BOM_STD_OP_RESOURCES
309: WHERE rowid = X_Rowid
310: FOR UPDATE of Standard_Operation_Id, Substitute_Group_Num NOWAIT;
311: Recinfo C%ROWTYPE;
312: BEGIN

Line 529: UPDATE BOM_STD_OP_RESOURCES

525: X_SCHEDULE_SEQ_NUM NUMBER DEFAULT NULL, -- Bug#14550670
526: X_PRINCIPLE_FLAG NUMBER DEFAULT NULL -- Bug#14550670
527: ) IS
528: BEGIN
529: UPDATE BOM_STD_OP_RESOURCES
530: SET
531: standard_operation_id = X_Standard_Operation_Id,
532: resource_id = X_Resource_Id,
533: substitute_group_num = X_Substitute_Group_Num,

Line 574: DELETE FROM BOM_STD_OP_RESOURCES

570: END Update_Row;
571:
572: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
573: BEGIN
574: DELETE FROM BOM_STD_OP_RESOURCES
575: WHERE rowid = X_Rowid;
576:
577: if (SQL%NOTFOUND) then
578: RAISE NO_DATA_FOUND;

Line 588: (SELECT 1 FROM BOM_STD_OP_RESOURCES

584: X_Resource_Seq_Num NUMBER) IS
585: dummy NUMBER;
586: BEGIN
587: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS
588: (SELECT 1 FROM BOM_STD_OP_RESOURCES
589: WHERE Standard_Operation_Id = X_Standard_Operation_Id
590: AND Resource_Seq_Num = X_Resource_Seq_Num
591: AND ((X_Rowid IS NULL) OR (ROWID <> X_Rowid))
592: );