APPS.BOM_OPERATION_NETWORKS_PKG dependencies on BOM_OPERATION_NETWORKS

Line 1: PACKAGE BODY BOM_OPERATION_NETWORKS_PKG as

1: PACKAGE BODY BOM_OPERATION_NETWORKS_PKG as
2: /* $Header: BOMOPNWB.pls 115.1 99/07/16 05:14:36 porting ship $ */
3:
4: PROCEDURE INSERT_ROW(X_ROW_ID IN OUT VARCHAR2,
5: x_from_op_seq_id NUMBER,

Line 31: CURSOR C IS SELECT rowid FROM BOM_OPERATION_NETWORKS

27: x_attribute13 VARCHAR2,
28: x_attribute14 VARCHAR2,
29: x_attribute15 VARCHAR2
30: ) IS
31: CURSOR C IS SELECT rowid FROM BOM_OPERATION_NETWORKS
32: WHERE FROM_OP_SEQ_ID = X_FROM_OP_SEQ_ID
33: AND TO_OP_SEQ_ID = X_TO_OP_SEQ_ID;
34:
35: BEGIN

Line 37: INSERT INTO BOM_OPERATION_NETWORKS(

33: AND TO_OP_SEQ_ID = X_TO_OP_SEQ_ID;
34:
35: BEGIN
36:
37: INSERT INTO BOM_OPERATION_NETWORKS(
38: from_op_seq_id,
39: to_op_seq_id,
40: transition_type,
41: planning_pct,

Line 157: FROM BOM_OPERATION_NETWORKS

153: attribute12,
154: attribute13,
155: attribute14,
156: attribute15
157: FROM BOM_OPERATION_NETWORKS
158: WHERE rowid = x_row_id
159: FOR UPDATE of from_op_seq_id NOWAIT;
160: Recinfo C%ROWTYPE;
161: BEGIN

Line 259: UPDATE BOM_OPERATION_NETWORKS SET

255: x_attribute14 VARCHAR2,
256: x_attribute15 VARCHAR2
257: ) IS
258: BEGIN
259: UPDATE BOM_OPERATION_NETWORKS SET
260: from_op_seq_id = x_from_op_seq_id,
261: to_op_seq_id = x_to_op_seq_id,
262: transition_type = x_transition_type,
263: planning_pct = x_planning_pct,

Line 296: DELETE FROM BOM_OPERATION_NETWORKS

292: END;
293:
294: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
295: BEGIN
296: DELETE FROM BOM_OPERATION_NETWORKS
297: WHERE rowid=x_rowid;
298: END Delete_Row;
299:
300: PROCEDURE CHECK_UNIQUE_LINK(X_ROWID VARCHAR2,

Line 318: (SELECT 1 FROM BOM_OPERATION_NETWORKS

314: FROM bom_operation_sequences
315: WHERE operation_sequence_id = x_to_op_seq_id;
316:
317: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS
318: (SELECT 1 FROM BOM_OPERATION_NETWORKS
319: WHERE from_op_seq_id = X_From_Op_Seq_Id
320: AND To_Op_Seq_Id = X_To_Op_Seq_Id
321: AND ((X_Rowid IS NULL) OR (ROWID <> X_Rowid))
322: );

Line 331: END BOM_OPERATION_NETWORKS_PKG;

327: FND_MESSAGE.SET_TOKEN('TO_OP_SEQ_ID',to_char(to_op_seq_num), FALSE);
328: APP_EXCEPTION.RAISE_EXCEPTION;
329: END;
330:
331: END BOM_OPERATION_NETWORKS_PKG;