1 PACKAGE WMS_STRATEGY_MEMBERS_PKG AS
2 /* $Header: WMSPPSMS.pls 120.1 2005/06/20 02:36:26 appldev ship $ */
3 --
4 PROCEDURE INSERT_ROW (
5 x_rowid IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
6 ,x_strategy_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_rule_id IN NUMBER
14 ,x_partial_success_allowed_flag IN VARCHAR2
15 ,x_effective_from IN DATE
16 ,x_effective_to IN DATE
17 ,x_attribute_category IN VARCHAR2
18 ,x_attribute1 IN VARCHAR2
19 ,x_attribute2 IN VARCHAR2
20 ,x_attribute3 IN VARCHAR2
21 ,x_attribute4 IN VARCHAR2
22 ,x_attribute5 IN VARCHAR2
23 ,x_attribute6 IN VARCHAR2
24 ,x_attribute7 IN VARCHAR2
25 ,x_attribute8 IN VARCHAR2
26 ,x_attribute9 IN VARCHAR2
27 ,x_attribute10 IN VARCHAR2
28 ,x_attribute11 IN VARCHAR2
29 ,x_attribute12 IN VARCHAR2
30 ,x_attribute13 IN VARCHAR2
31 ,x_attribute14 IN VARCHAR2
32 ,x_attribute15 IN VARCHAR2
33 ,x_date_type_code IN VARCHAR2
34 ,x_date_type_lookup_type IN VARCHAR2
35 ,x_date_type_from IN NUMBER
36 ,x_date_type_to IN NUMBER
37 );
38 --
39 PROCEDURE LOCK_ROW (
40 x_rowid IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
41 ,x_strategy_id IN NUMBER
42 ,x_sequence_number IN NUMBER
43 ,x_rule_id IN NUMBER
44 ,x_partial_success_allowed_flag IN VARCHAR2
45 ,x_effective_from IN DATE
46 ,x_effective_to IN DATE
47 ,x_attribute_category IN VARCHAR2
48 ,x_attribute1 IN VARCHAR2
49 ,x_attribute2 IN VARCHAR2
50 ,x_attribute3 IN VARCHAR2
51 ,x_attribute4 IN VARCHAR2
52 ,x_attribute5 IN VARCHAR2
53 ,x_attribute6 IN VARCHAR2
54 ,x_attribute7 IN VARCHAR2
55 ,x_attribute8 IN VARCHAR2
56 ,x_attribute9 IN VARCHAR2
57 ,x_attribute10 IN VARCHAR2
58 ,x_attribute11 IN VARCHAR2
59 ,x_attribute12 IN VARCHAR2
60 ,x_attribute13 IN VARCHAR2
61 ,x_attribute14 IN VARCHAR2
62 ,x_attribute15 IN VARCHAR2
63 ,x_date_type_code IN VARCHAR2
64 ,x_date_type_lookup_type IN VARCHAR2
65 ,x_date_type_from IN NUMBER
66 ,x_date_type_to IN NUMBER
67
68 );
69 --
70 PROCEDURE UPDATE_ROW (
71 x_rowid IN VARCHAR2
72 ,x_strategy_id IN NUMBER
73 ,x_sequence_number IN NUMBER
74 ,x_last_updated_by IN NUMBER
75 ,x_last_update_date IN DATE
76 ,x_last_update_login IN NUMBER
77 ,x_rule_id IN NUMBER
78 ,x_partial_success_allowed_flag IN VARCHAR2
79 ,x_effective_from IN DATE
80 ,x_effective_to IN DATE
81 ,x_attribute_category IN VARCHAR2
82 ,x_attribute1 IN VARCHAR2
83 ,x_attribute2 IN VARCHAR2
84 ,x_attribute3 IN VARCHAR2
85 ,x_attribute4 IN VARCHAR2
86 ,x_attribute5 IN VARCHAR2
87 ,x_attribute6 IN VARCHAR2
88 ,x_attribute7 IN VARCHAR2
89 ,x_attribute8 IN VARCHAR2
90 ,x_attribute9 IN VARCHAR2
91 ,x_attribute10 IN VARCHAR2
92 ,x_attribute11 IN VARCHAR2
93 ,x_attribute12 IN VARCHAR2
94 ,x_attribute13 IN VARCHAR2
95 ,x_attribute14 IN VARCHAR2
96 ,x_attribute15 IN VARCHAR2
97 ,x_date_type_code IN VARCHAR2
98 ,x_date_type_lookup_type IN VARCHAR2
99 ,x_date_type_from IN NUMBER
100 ,x_date_type_to IN NUMBER
101 );
102 --
103 PROCEDURE DELETE_ROW (
104 x_rowid IN VARCHAR2
105 );
106
107 PROCEDURE LOAD_ROW
108 (
109 x_strategy_id IN NUMBER
110 ,x_owner IN VARCHAR2
111 ,x_SEQUENCE_NUMBER IN NUMBER
112 ,x_RULE_ID IN NUMBER
113 ,x_PARTIAL_SUCCESS_ALLOWED_FLAG IN VARCHAR2
114 ,x_EFFECTIVE_FROM IN DATE
115 ,x_EFFECTIVE_TO IN DATE
116 ,x_DATE_TYPE_CODE IN VARCHAR2
117 ,x_DATE_TYPE_LOOKUP_TYPE IN VARCHAR2
118 ,x_DATE_TYPE_FROM IN NUMBER
119 ,x_DATE_TYPE_TO 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 END WMS_STRATEGY_MEMBERS_PKG;