1 PACKAGE WMS_SORT_CRITERIA_PKG AS
2 /* $Header: WMSHPCRS.pls 120.1 2005/06/21 02:13:13 appldev ship $ */
3
4 PROCEDURE INSERT_ROW (
5 x_rowid IN OUT NOCOPY VARCHAR2
6 ,x_rule_id IN NUMBER
7 ,x_sequence_number IN NUMBER
8 ,x_last_updated_by IN NUMBER
9 ,x_last_update_date IN DATE
10 ,x_created_by IN NUMBER
11 ,x_creation_date IN DATE
12 ,x_last_update_login IN NUMBER
13 ,x_parameter_id IN NUMBER
14 ,x_order_code IN NUMBER
15 ,x_attribute_category IN VARCHAR2
16 ,x_attribute1 IN VARCHAR2
17 ,x_attribute2 IN VARCHAR2
18 ,x_attribute3 IN VARCHAR2
19 ,x_attribute4 IN VARCHAR2
20 ,x_attribute5 IN VARCHAR2
21 ,x_attribute6 IN VARCHAR2
22 ,x_attribute7 IN VARCHAR2
23 ,x_attribute8 IN VARCHAR2
24 ,x_attribute9 IN VARCHAR2
25 ,x_attribute10 IN VARCHAR2
26 ,x_attribute11 IN VARCHAR2
27 ,x_attribute12 IN VARCHAR2
28 ,x_attribute13 IN VARCHAR2
29 ,x_attribute14 IN VARCHAR2
30 ,x_attribute15 IN VARCHAR2
31 );
32
33 PROCEDURE LOCK_ROW (
34 x_rowid IN VARCHAR2
35 ,x_rule_id IN NUMBER
36 ,x_sequence_number IN NUMBER
37 ,x_parameter_id IN NUMBER
38 ,x_order_code IN NUMBER
39 ,x_attribute_category IN VARCHAR2
40 ,x_attribute1 IN VARCHAR2
41 ,x_attribute2 IN VARCHAR2
42 ,x_attribute3 IN VARCHAR2
43 ,x_attribute4 IN VARCHAR2
44 ,x_attribute5 IN VARCHAR2
45 ,x_attribute6 IN VARCHAR2
46 ,x_attribute7 IN VARCHAR2
47 ,x_attribute8 IN VARCHAR2
48 ,x_attribute9 IN VARCHAR2
49 ,x_attribute10 IN VARCHAR2
50 ,x_attribute11 IN VARCHAR2
51 ,x_attribute12 IN VARCHAR2
52 ,x_attribute13 IN VARCHAR2
53 ,x_attribute14 IN VARCHAR2
54 ,x_attribute15 IN VARCHAR2
55 );
56
57 PROCEDURE UPDATE_ROW (
58 x_rowid IN VARCHAR2
59 ,x_rule_id IN NUMBER
60 ,x_sequence_number IN NUMBER
61 ,x_last_updated_by IN NUMBER
62 ,x_last_update_date IN DATE
63 ,x_last_update_login IN NUMBER
64 ,x_parameter_id IN NUMBER
65 ,x_order_code IN NUMBER
66 ,x_attribute_category IN VARCHAR2
67 ,x_attribute1 IN VARCHAR2
68 ,x_attribute2 IN VARCHAR2
69 ,x_attribute3 IN VARCHAR2
70 ,x_attribute4 IN VARCHAR2
71 ,x_attribute5 IN VARCHAR2
72 ,x_attribute6 IN VARCHAR2
73 ,x_attribute7 IN VARCHAR2
74 ,x_attribute8 IN VARCHAR2
75 ,x_attribute9 IN VARCHAR2
76 ,x_attribute10 IN VARCHAR2
77 ,x_attribute11 IN VARCHAR2
78 ,x_attribute12 IN VARCHAR2
79 ,x_attribute13 IN VARCHAR2
80 ,x_attribute14 IN VARCHAR2
81 ,x_attribute15 IN VARCHAR2
82 );
83
84 PROCEDURE DELETE_ROW (
85 x_rowid IN VARCHAR2
86 );
87
88 PROCEDURE LOAD_ROW (
89 X_RULE_ID IN NUMBER
90 ,x_OWNER IN VARCHAR2
91 ,X_SEQUENCE_NUMBER IN NUMBER
92 ,X_PARAMETER_ID IN NUMBER
93 ,X_ORDER_CODE IN NUMBER
94 ,X_ATTRIBUTE_CATEGORY IN VARCHAR2
95 ,X_ATTRIBUTE1 IN VARCHAR2
96 ,X_ATTRIBUTE2 IN VARCHAR2
97 ,X_ATTRIBUTE3 IN VARCHAR2
98 ,X_ATTRIBUTE4 IN VARCHAR2
99 ,X_ATTRIBUTE5 IN VARCHAR2
100 ,X_ATTRIBUTE6 IN VARCHAR2
101 ,X_ATTRIBUTE7 IN VARCHAR2
102 ,X_ATTRIBUTE8 IN VARCHAR2
103 ,X_ATTRIBUTE9 IN VARCHAR2
104 ,X_ATTRIBUTE10 IN VARCHAR2
105 ,X_ATTRIBUTE11 IN VARCHAR2
106 ,X_ATTRIBUTE12 IN VARCHAR2
107 ,X_ATTRIBUTE13 IN VARCHAR2
108 ,X_ATTRIBUTE14 IN VARCHAR2
109 ,X_ATTRIBUTE15 IN VARCHAR2
110 );
111 END WMS_SORT_CRITERIA_PKG;