APPS.B_STD_SUB_OP_RES_PKG dependencies on BOM_STD_SUB_OP_RESOURCES

Line 40: CURSOR C IS SELECT rowid FROM BOM_STD_SUB_OP_RESOURCES

36: X_Attribute14 VARCHAR2,
37: X_Attribute15 VARCHAR2,
38: X_Schedule_Seq_Num NUMBER -- Bug 7370692
39: ) IS
40: CURSOR C IS SELECT rowid FROM BOM_STD_SUB_OP_RESOURCES
41: WHERE standard_operation_id = X_Standard_Operation_Id
42: AND replacement_group_num = X_Replacement_Group_Num;
43:
44: BEGIN

Line 45: INSERT INTO BOM_STD_SUB_OP_RESOURCES(

41: WHERE standard_operation_id = X_Standard_Operation_Id
42: AND replacement_group_num = X_Replacement_Group_Num;
43:
44: BEGIN
45: INSERT INTO BOM_STD_SUB_OP_RESOURCES(
46: standard_operation_id,
47: resource_id,
48: SUBSTITUTE_GROUP_NUM,
49: REPLACEMENT_GROUP_NUM,

Line 161: FROM BOM_STD_SUB_OP_RESOURCES

157: X_Schedule_Seq_Num NUMBER -- Bug 7370692
158: ) IS
159: CURSOR C IS
160: SELECT *
161: FROM BOM_STD_SUB_OP_RESOURCES
162: WHERE rowid = X_Rowid
163: FOR UPDATE of Standard_Operation_Id, Replacement_Group_Num NOWAIT;
164: Recinfo C%ROWTYPE;
165: BEGIN

Line 307: UPDATE BOM_STD_SUB_OP_RESOURCES

303: X_Attribute15 VARCHAR2 DEFAULT NULL,
304: X_Schedule_Seq_Num NUMBER -- Bug 7370692
305: ) IS
306: BEGIN
307: UPDATE BOM_STD_SUB_OP_RESOURCES
308: SET
309: standard_operation_id = X_Standard_Operation_Id,
310: resource_id = X_Resource_Id,
311: activity_id = X_Activity_Id,

Line 352: DELETE FROM BOM_STD_SUB_OP_RESOURCES

348:
349:
350: PROCEDURE Delete_Row_Sub(X_Rowid VARCHAR2) IS
351: BEGIN
352: DELETE FROM BOM_STD_SUB_OP_RESOURCES
353: WHERE rowid = X_Rowid;
354:
355: if (SQL%NOTFOUND) then
356: RAISE NO_DATA_FOUND;