DBA Data[Home] [Help]

PACKAGE: APPS.BOM_OPERATION_NETWORKS_PKG

Source


1 PACKAGE BOM_OPERATION_NETWORKS_PKG AUTHID CURRENT_USER as
2 /* $Header: BOMOPNWS.pls 115.0 99/07/16 05:14:39 porting ship $ */
3   PROCEDURE INSERT_ROW(X_ROW_ID IN OUT VARCHAR2,
4               x_from_op_seq_id         NUMBER,
5               x_to_op_seq_id           NUMBER,
6               x_transition_type        NUMBER,
7               x_planning_pct           NUMBER,
8               x_last_updated_by        NUMBER,
9               x_creation_date          DATE,
10               x_last_update_date       DATE,
11               x_created_by             NUMBER,
12               x_last_update_login      NUMBER,
13               x_attribute_category     VARCHAR2,
14               x_attribute1             VARCHAR2,
15               x_attribute2             VARCHAR2,
16               x_attribute3             VARCHAR2,
17               x_attribute4             VARCHAR2,
18               x_attribute5             VARCHAR2,
19               x_attribute6             VARCHAR2,
20               x_attribute7             VARCHAR2,
21               x_attribute8             VARCHAR2,
22               x_attribute9             VARCHAR2,
23               x_attribute10            VARCHAR2,
24               x_attribute11            VARCHAR2,
25               x_attribute12            VARCHAR2,
26               x_attribute13            VARCHAR2,
27               x_attribute14            VARCHAR2,
28               x_attribute15            VARCHAR2
29          );
30 
31   PROCEDURE Lock_Row(X_ROW_ID    VARCHAR2,
32               x_from_op_seq_id     NUMBER,
33               x_to_op_seq_id       NUMBER,
34               x_transition_type    NUMBER,
35               x_planning_pct       NUMBER,
36               x_effectivity_date   DATE,
37               x_disable_date       DATE,
38               x_last_updated_by    NUMBER,
39               x_creation_date      DATE,
40               x_last_update_date   DATE,
41               x_created_by         NUMBER,
42               x_last_update_login  NUMBER,
43               x_attribute_category VARCHAR2,
44               x_attribute1         VARCHAR2,
45               x_attribute2         VARCHAR2,
46               x_attribute3         VARCHAR2,
47               x_attribute4         VARCHAR2,
48               x_attribute5         VARCHAR2,
49               x_attribute6         VARCHAR2,
50               x_attribute7         VARCHAR2,
51               x_attribute8         VARCHAR2,
52               x_attribute9         VARCHAR2,
53               x_attribute10         VARCHAR2,
54               x_attribute11         VARCHAR2,
55               x_attribute12         VARCHAR2,
56               x_attribute13         VARCHAR2,
57               x_attribute14         VARCHAR2,
58               x_attribute15         VARCHAR2
59          );
60 
61   PROCEDURE Update_Row(X_ROW_ID    VARCHAR2,
62               x_from_op_seq_id     NUMBER,
63               x_to_op_seq_id       NUMBER,
64               x_transition_type    NUMBER,
65               x_planning_pct       NUMBER,
66               x_effectivity_date   DATE,
67               x_disable_date       DATE,
68               x_last_updated_by    NUMBER,
69               x_creation_date      DATE,
70               x_last_update_date   DATE,
71               x_created_by         NUMBER,
72               x_last_update_login  NUMBER,
73               x_attribute_category VARCHAR2,
74               x_attribute1         VARCHAR2,
75               x_attribute2         VARCHAR2,
76               x_attribute3         VARCHAR2,
77               x_attribute4         VARCHAR2,
78               x_attribute5         VARCHAR2,
79               x_attribute6         VARCHAR2,
80               x_attribute7         VARCHAR2,
81               x_attribute8         VARCHAR2,
82               x_attribute9         VARCHAR2,
83               x_attribute10         VARCHAR2,
84               x_attribute11         VARCHAR2,
85               x_attribute12         VARCHAR2,
86               x_attribute13         VARCHAR2,
87               x_attribute14         VARCHAR2,
88               x_attribute15         VARCHAR2
89          );
90 
91      PROCEDURE Delete_Row(X_Rowid VARCHAR2);
92 
93      PROCEDURE CHECK_UNIQUE_LINK(X_ROWID VARCHAR2,
94                                  X_FROM_OP_SEQ_ID NUMBER,
95                                  X_TO_OP_SEQ_ID NUMBER);
96 END BOM_OPERATION_NETWORKS_PKG;