[Home] [Help]
PACKAGE: APPS.JL_ZZ_GL_AXI_MODEL_RANGES_PKG
Source
1 PACKAGE JL_ZZ_GL_AXI_MODEL_RANGES_PKG AUTHID CURRENT_USER AS
2 /* $Header: jlzzgmrs.pls 115.2 2002/11/21 02:02:32 vsidhart ship $ */
3 ------------------------------------------------------------
4 -- Insert row procedure --
5 ------------------------------------------------------------
6 PROCEDURE Insert_Row (p_rowid IN OUT NOCOPY VARCHAR2
7 , p_model_id NUMBER
8 , p_last_update_date DATE
9 , p_last_updated_by NUMBER
10 , p_creation_date DATE
11 , p_created_by NUMBER
12 , p_last_update_login NUMBER
13 , p_set_of_books_id NUMBER
14 , p_segment1_low VARCHAR2
15 , p_segment1_high VARCHAR2
16 , p_segment2_low VARCHAR2
17 , p_segment2_high VARCHAR2
18 , p_segment3_low VARCHAR2
19 , p_segment3_high VARCHAR2
20 , p_segment4_low VARCHAR2
21 , p_segment4_high VARCHAR2
22 , p_segment5_low VARCHAR2
23 , p_segment5_high VARCHAR2
24 , p_segment6_low VARCHAR2
25 , p_segment6_high VARCHAR2
26 , p_segment7_low VARCHAR2
27 , p_segment7_high VARCHAR2
28 , p_segment8_low VARCHAR2
29 , p_segment8_high VARCHAR2
30 , p_segment9_low VARCHAR2
31 , p_segment9_high VARCHAR2
32 , p_segment10_low VARCHAR2
33 , p_segment10_high VARCHAR2
34 , p_segment11_low VARCHAR2
35 , p_segment11_high VARCHAR2
36 , p_segment12_low VARCHAR2
37 , p_segment12_high VARCHAR2
38 , p_segment13_low VARCHAR2
39 , p_segment13_high VARCHAR2
40 , p_segment14_low VARCHAR2
41 , p_segment14_high VARCHAR2
42 , p_segment15_low VARCHAR2
43 , p_segment15_high VARCHAR2
44 , p_segment16_low VARCHAR2
45 , p_segment16_high VARCHAR2
46 , p_segment17_low VARCHAR2
47 , p_segment17_high VARCHAR2
48 , p_segment18_low VARCHAR2
49 , p_segment18_high VARCHAR2
50 , p_segment19_low VARCHAR2
51 , p_segment19_high VARCHAR2
52 , p_segment20_low VARCHAR2
53 , p_segment20_high VARCHAR2
54 , p_segment21_low VARCHAR2
55 , p_segment21_high VARCHAR2
56 , p_segment22_low VARCHAR2
57 , p_segment22_high VARCHAR2
58 , p_segment23_low VARCHAR2
59 , p_segment23_high VARCHAR2
60 , p_segment24_low VARCHAR2
61 , p_segment24_high VARCHAR2
62 , p_segment25_low VARCHAR2
63 , p_segment25_high VARCHAR2
64 , p_segment26_low VARCHAR2
65 , p_segment26_high VARCHAR2
66 , p_segment27_low VARCHAR2
67 , p_segment27_high VARCHAR2
68 , p_segment28_low VARCHAR2
69 , p_segment28_high VARCHAR2
70 , p_segment29_low VARCHAR2
71 , p_segment29_high VARCHAR2
72 , p_segment30_low VARCHAR2
73 , p_segment30_high VARCHAR2
74 , p_attribute_category VARCHAR2
75 , p_attribute1 VARCHAR2
76 , p_attribute2 VARCHAR2
77 , p_attribute3 VARCHAR2
78 , p_attribute4 VARCHAR2
79 , p_attribute5 VARCHAR2
80 , p_attribute6 VARCHAR2
81 , p_attribute7 VARCHAR2
82 , p_attribute8 VARCHAR2
83 , p_attribute9 VARCHAR2
84 , p_attribute10 VARCHAR2
85 , p_attribute11 VARCHAR2
86 , p_attribute12 VARCHAR2
87 , p_attribute13 VARCHAR2
88 , p_attribute14 VARCHAR2
89 , p_attribute15 VARCHAR2
90 , p_calling_sequence VARCHAR2);
91
92
93 ------------------------------------------------------------
94 -- Update row procedure --
95 ------------------------------------------------------------
96 PROCEDURE Update_Row (p_rowid VARCHAR2
97 , p_model_id NUMBER
98 , p_last_update_date DATE
99 , p_last_updated_by NUMBER
100 , p_creation_date DATE
101 , p_created_by NUMBER
102 , p_last_update_login NUMBER
103 , p_set_of_books_id NUMBER
104 , p_segment1_low VARCHAR2
105 , p_segment1_high VARCHAR2
106 , p_segment2_low VARCHAR2
107 , p_segment2_high VARCHAR2
108 , p_segment3_low VARCHAR2
109 , p_segment3_high VARCHAR2
110 , p_segment4_low VARCHAR2
111 , p_segment4_high VARCHAR2
112 , p_segment5_low VARCHAR2
113 , p_segment5_high VARCHAR2
114 , p_segment6_low VARCHAR2
115 , p_segment6_high VARCHAR2
116 , p_segment7_low VARCHAR2
117 , p_segment7_high VARCHAR2
118 , p_segment8_low VARCHAR2
119 , p_segment8_high VARCHAR2
120 , p_segment9_low VARCHAR2
121 , p_segment9_high VARCHAR2
122 , p_segment10_low VARCHAR2
123 , p_segment10_high VARCHAR2
124 , p_segment11_low VARCHAR2
125 , p_segment11_high VARCHAR2
126 , p_segment12_low VARCHAR2
127 , p_segment12_high VARCHAR2
128 , p_segment13_low VARCHAR2
129 , p_segment13_high VARCHAR2
130 , p_segment14_low VARCHAR2
131 , p_segment14_high VARCHAR2
132 , p_segment15_low VARCHAR2
133 , p_segment15_high VARCHAR2
134 , p_segment16_low VARCHAR2
135 , p_segment16_high VARCHAR2
136 , p_segment17_low VARCHAR2
137 , p_segment17_high VARCHAR2
138 , p_segment18_low VARCHAR2
139 , p_segment18_high VARCHAR2
140 , p_segment19_low VARCHAR2
141 , p_segment19_high VARCHAR2
142 , p_segment20_low VARCHAR2
143 , p_segment20_high VARCHAR2
144 , p_segment21_low VARCHAR2
145 , p_segment21_high VARCHAR2
146 , p_segment22_low VARCHAR2
147 , p_segment22_high VARCHAR2
148 , p_segment23_low VARCHAR2
149 , p_segment23_high VARCHAR2
150 , p_segment24_low VARCHAR2
151 , p_segment24_high VARCHAR2
152 , p_segment25_low VARCHAR2
153 , p_segment25_high VARCHAR2
154 , p_segment26_low VARCHAR2
155 , p_segment26_high VARCHAR2
156 , p_segment27_low VARCHAR2
157 , p_segment27_high VARCHAR2
158 , p_segment28_low VARCHAR2
159 , p_segment28_high VARCHAR2
160 , p_segment29_low VARCHAR2
161 , p_segment29_high VARCHAR2
162 , p_segment30_low VARCHAR2
163 , p_segment30_high VARCHAR2
164 , p_attribute_category VARCHAR2
165 , p_attribute1 VARCHAR2
166 , p_attribute2 VARCHAR2
167 , p_attribute3 VARCHAR2
168 , p_attribute4 VARCHAR2
169 , p_attribute5 VARCHAR2
170 , p_attribute6 VARCHAR2
171 , p_attribute7 VARCHAR2
172 , p_attribute8 VARCHAR2
173 , p_attribute9 VARCHAR2
174 , p_attribute10 VARCHAR2
175 , p_attribute11 VARCHAR2
176 , p_attribute12 VARCHAR2
177 , p_attribute13 VARCHAR2
178 , p_attribute14 VARCHAR2
179 , p_attribute15 VARCHAR2
180 , p_calling_sequence VARCHAR2);
181
182
183 ------------------------------------------------------------
184 -- Delete row procedure --
185 ------------------------------------------------------------
186 PROCEDURE delete_row (p_rowid VARCHAR2
187 , p_calling_sequence IN VARCHAR2);
188
189
190 END JL_ZZ_GL_AXI_MODEL_RANGES_PKG;