1 PACKAGE OKE_NUMBER_OPTIONS_PKG AUTHID CURRENT_USER AS
2 /* $Header: OKENMOPS.pls 115.4 2002/11/21 23:01:53 ybchen ship $ */
3 PROCEDURE INSERT_ROW
4 ( X_ROWID IN OUT NOCOPY VARCHAR2
5 , X_K_TYPE_CODE IN VARCHAR2
6 , X_BUY_OR_SELL IN VARCHAR2
7 , X_CREATION_DATE IN DATE
8 , X_CREATED_BY IN NUMBER
9 , X_LAST_UPDATE_DATE IN DATE
10 , X_LAST_UPDATED_BY IN NUMBER
11 , X_LAST_UPDATE_LOGIN IN NUMBER
12 , X_CONTRACT_NUM_MODE IN VARCHAR2
13 , X_MANUAL_CONTRACT_NUM_TYPE IN VARCHAR2
14 , X_NEXT_CONTRACT_NUM IN NUMBER
15 , X_CONTRACT_NUM_INCREMENT IN NUMBER
16 , X_CONTRACT_NUM_WIDTH IN NUMBER
17 , X_CHGREQ_NUM_MODE IN VARCHAR2
18 , X_MANUAL_CHGREQ_NUM_TYPE IN VARCHAR2
19 , X_CHGREQ_NUM_START_NUMBER IN NUMBER
20 , X_CHGREQ_NUM_INCREMENT IN NUMBER
21 , X_CHGREQ_NUM_WIDTH IN NUMBER
22 , X_LINE_NUM_START_NUMBER IN NUMBER
23 , X_LINE_NUM_INCREMENT IN NUMBER
24 , X_LINE_NUM_WIDTH IN NUMBER
25 , X_SUBLINE_NUM_START_NUMBER IN NUMBER
26 , X_SUBLINE_NUM_INCREMENT IN NUMBER
27 , X_SUBLINE_NUM_WIDTH IN NUMBER
28 , X_DELV_NUM_START_NUMBER IN NUMBER
29 , X_DELV_NUM_INCREMENT IN NUMBER
30 , X_DELV_NUM_WIDTH IN NUMBER
31 , X_ATTRIBUTE_CATEGORY IN VARCHAR2
32 , X_ATTRIBUTE1 IN VARCHAR2
33 , X_ATTRIBUTE2 IN VARCHAR2
34 , X_ATTRIBUTE3 IN VARCHAR2
35 , X_ATTRIBUTE4 IN VARCHAR2
36 , X_ATTRIBUTE5 IN VARCHAR2
37 , X_ATTRIBUTE6 IN VARCHAR2
38 , X_ATTRIBUTE7 IN VARCHAR2
39 , X_ATTRIBUTE8 IN VARCHAR2
40 , X_ATTRIBUTE9 IN VARCHAR2
41 , X_ATTRIBUTE10 IN VARCHAR2
42 , X_ATTRIBUTE11 IN VARCHAR2
43 , X_ATTRIBUTE12 IN VARCHAR2
44 , X_ATTRIBUTE13 IN VARCHAR2
45 , X_ATTRIBUTE14 IN VARCHAR2
46 , X_ATTRIBUTE15 IN VARCHAR2
47 );
48
49 PROCEDURE LOCK_ROW
50 ( X_ROWID IN VARCHAR2
51 , X_K_TYPE_CODE IN VARCHAR2
52 , X_BUY_OR_SELL IN VARCHAR2
53 , X_CREATION_DATE IN DATE
54 , X_CREATED_BY IN NUMBER
55 , X_LAST_UPDATE_DATE IN DATE
56 , X_LAST_UPDATED_BY IN NUMBER
57 , X_LAST_UPDATE_LOGIN IN NUMBER
58 , X_CONTRACT_NUM_MODE IN VARCHAR2
59 , X_MANUAL_CONTRACT_NUM_TYPE IN VARCHAR2
60 , X_NEXT_CONTRACT_NUM IN NUMBER
61 , X_CONTRACT_NUM_INCREMENT IN NUMBER
62 , X_CONTRACT_NUM_WIDTH IN NUMBER
63 , X_CHGREQ_NUM_MODE IN VARCHAR2
64 , X_MANUAL_CHGREQ_NUM_TYPE IN VARCHAR2
65 , X_CHGREQ_NUM_START_NUMBER IN NUMBER
66 , X_CHGREQ_NUM_INCREMENT IN NUMBER
67 , X_CHGREQ_NUM_WIDTH IN NUMBER
68 , X_LINE_NUM_START_NUMBER IN NUMBER
69 , X_LINE_NUM_INCREMENT IN NUMBER
70 , X_LINE_NUM_WIDTH IN NUMBER
71 , X_SUBLINE_NUM_START_NUMBER IN NUMBER
72 , X_SUBLINE_NUM_INCREMENT IN NUMBER
73 , X_SUBLINE_NUM_WIDTH IN NUMBER
74 , X_DELV_NUM_START_NUMBER IN NUMBER
75 , X_DELV_NUM_INCREMENT IN NUMBER
76 , X_DELV_NUM_WIDTH IN NUMBER
77 , X_ATTRIBUTE_CATEGORY IN VARCHAR2
78 , X_ATTRIBUTE1 IN VARCHAR2
79 , X_ATTRIBUTE2 IN VARCHAR2
80 , X_ATTRIBUTE3 IN VARCHAR2
81 , X_ATTRIBUTE4 IN VARCHAR2
82 , X_ATTRIBUTE5 IN VARCHAR2
83 , X_ATTRIBUTE6 IN VARCHAR2
84 , X_ATTRIBUTE7 IN VARCHAR2
85 , X_ATTRIBUTE8 IN VARCHAR2
86 , X_ATTRIBUTE9 IN VARCHAR2
87 , X_ATTRIBUTE10 IN VARCHAR2
88 , X_ATTRIBUTE11 IN VARCHAR2
89 , X_ATTRIBUTE12 IN VARCHAR2
90 , X_ATTRIBUTE13 IN VARCHAR2
91 , X_ATTRIBUTE14 IN VARCHAR2
92 , X_ATTRIBUTE15 IN VARCHAR2
93 );
94
95 PROCEDURE UPDATE_ROW
96 ( X_K_TYPE_CODE IN VARCHAR2
97 , X_BUY_OR_SELL IN VARCHAR2
98 , X_LAST_UPDATE_DATE IN DATE
99 , X_LAST_UPDATED_BY IN NUMBER
100 , X_LAST_UPDATE_LOGIN IN NUMBER
101 , X_CONTRACT_NUM_MODE IN VARCHAR2
102 , X_MANUAL_CONTRACT_NUM_TYPE IN VARCHAR2
103 , X_NEXT_CONTRACT_NUM IN NUMBER
104 , X_CONTRACT_NUM_INCREMENT IN NUMBER
105 , X_CONTRACT_NUM_WIDTH IN NUMBER
106 , X_CHGREQ_NUM_MODE IN VARCHAR2
107 , X_MANUAL_CHGREQ_NUM_TYPE IN VARCHAR2
108 , X_CHGREQ_NUM_START_NUMBER IN NUMBER
109 , X_CHGREQ_NUM_INCREMENT IN NUMBER
110 , X_CHGREQ_NUM_WIDTH IN NUMBER
111 , X_LINE_NUM_START_NUMBER IN NUMBER
112 , X_LINE_NUM_INCREMENT IN NUMBER
113 , X_LINE_NUM_WIDTH IN NUMBER
114 , X_SUBLINE_NUM_START_NUMBER IN NUMBER
115 , X_SUBLINE_NUM_INCREMENT IN NUMBER
116 , X_SUBLINE_NUM_WIDTH IN NUMBER
117 , X_DELV_NUM_START_NUMBER IN NUMBER
118 , X_DELV_NUM_INCREMENT IN NUMBER
119 , X_DELV_NUM_WIDTH IN NUMBER
120 , X_ATTRIBUTE_CATEGORY IN VARCHAR2
121 , X_ATTRIBUTE1 IN VARCHAR2
122 , X_ATTRIBUTE2 IN VARCHAR2
123 , X_ATTRIBUTE3 IN VARCHAR2
124 , X_ATTRIBUTE4 IN VARCHAR2
125 , X_ATTRIBUTE5 IN VARCHAR2
126 , X_ATTRIBUTE6 IN VARCHAR2
127 , X_ATTRIBUTE7 IN VARCHAR2
128 , X_ATTRIBUTE8 IN VARCHAR2
129 , X_ATTRIBUTE9 IN VARCHAR2
130 , X_ATTRIBUTE10 IN VARCHAR2
131 , X_ATTRIBUTE11 IN VARCHAR2
132 , X_ATTRIBUTE12 IN VARCHAR2
133 , X_ATTRIBUTE13 IN VARCHAR2
134 , X_ATTRIBUTE14 IN VARCHAR2
135 , X_ATTRIBUTE15 IN VARCHAR2
136 );
137
138 END OKE_NUMBER_OPTIONS_PKG;
[Home] [Help]