[Home] [Help]
PACKAGE: APPS.WSH_DOC_SEQ_CTG_S
Source
1 PACKAGE wsh_doc_seq_ctg_s AUTHID CURRENT_USER AS
2 -- $Header: WSHVDOCS.pls 115.4 2002/11/12 02:05:02 nparikh ship $
3
4 --------------------
5 -- TYPE DECLARATIONS
6 --------------------
7
8 -- currently not used. planned to be used as the parameter for a cover routine
9 -- that accepts a record type and in turn calls the table handler procedures
10
11 TYPE category_rectype IS RECORD
12 ( row_id varchar2(200) -- to confirm this length
13 , doc_sequence_category_id
14 wsh_doc_sequence_categories.doc_sequence_category_id%type
15 , location_id wsh_doc_sequence_categories.location_id%type
16 , document_type wsh_doc_sequence_categories.document_type%type
17 , document_code wsh_doc_sequence_categories.document_code%type
18 , application_id wsh_doc_sequence_categories.application_id%type
19 , category_code wsh_doc_sequence_categories.category_code%type
20 , prefix wsh_doc_sequence_categories.prefix%type
21 , suffix wsh_doc_sequence_categories.suffix%type
22 , delimiter wsh_doc_sequence_categories.delimiter%type
23 , enabled_flag wsh_doc_sequence_categories.enabled_flag%type
24 , created_by wsh_doc_sequence_categories.created_by%type
25 , creation_date wsh_doc_sequence_categories.creation_date%type
26 , last_updated_by wsh_doc_sequence_categories.last_updated_by%type
27 , last_update_date wsh_doc_sequence_categories.last_update_date%type
28 , last_update_login wsh_doc_sequence_categories.last_update_login%type
29 , program_application_id
30 wsh_doc_sequence_categories.program_application_id%type
31 , program_id wsh_doc_sequence_categories.program_id%type
32 , program_update_date wsh_doc_sequence_categories.program_update_date%type
33 , request_id wsh_doc_sequence_categories.request_id%type
34 , attribute_category wsh_doc_sequence_categories.attribute_category%type
35 , attribute1 wsh_doc_sequence_categories.attribute1%type
36 , attribute2 wsh_doc_sequence_categories.attribute2%type
37 , attribute3 wsh_doc_sequence_categories.attribute3%type
38 , attribute4 wsh_doc_sequence_categories.attribute4%type
39 , attribute5 wsh_doc_sequence_categories.attribute5%type
40 , attribute6 wsh_doc_sequence_categories.attribute6%type
41 , attribute7 wsh_doc_sequence_categories.attribute7%type
42 , attribute8 wsh_doc_sequence_categories.attribute8%type
43 , attribute9 wsh_doc_sequence_categories.attribute9%type
44 , attribute10 wsh_doc_sequence_categories.attribute10%type
45 , attribute11 wsh_doc_sequence_categories.attribute11%type
46 , attribute12 wsh_doc_sequence_categories.attribute12%type
47 , attribute13 wsh_doc_sequence_categories.attribute13%type
48 , attribute14 wsh_doc_sequence_categories.attribute14%type
49 , attribute15 wsh_doc_sequence_categories.attribute15%type
50 );
51
52
53 ------------
54 -- CONSTANTS
55 ------------
56
57 -------------------
58 -- PUBLIC VARIABLES
59 -------------------
60
61 ---------------------------
62 -- PROCEDURES AND FUNCTIONS
63 ---------------------------
64
65
66 PROCEDURE insert_row
67 ( x_rowid IN OUT NOCOPY VARCHAR2
68 , x_doc_sequence_category_id NUMBER
69 , x_location_id NUMBER
70 , x_document_type VARCHAR2
71 , x_document_code VARCHAR2
72 , x_application_id VARCHAR2
73 , x_category_code VARCHAR2
74 , x_name VARCHAR2
75 , x_description VARCHAR2
76 , x_prefix VARCHAR2
77 , x_suffix VARCHAR2
78 , x_delimiter VARCHAR2
79 , x_enabled_flag VARCHAR2
80 , x_created_by NUMBER
81 , x_creation_date DATE
82 , x_last_updated_by NUMBER
83 , x_last_update_date DATE
84 , x_last_update_login NUMBER
85 , x_program_application_id NUMBER
86 , x_program_id NUMBER
87 , x_program_update_date DATE
88 , x_request_id NUMBER
89 , x_attribute_category VARCHAR2
90 , x_attribute1 VARCHAR2
91 , x_attribute2 VARCHAR2
92 , x_attribute3 VARCHAR2
93 , x_attribute4 VARCHAR2
94 , x_attribute5 VARCHAR2
95 , x_attribute6 VARCHAR2
96 , x_attribute7 VARCHAR2
97 , x_attribute8 VARCHAR2
98 , x_attribute9 VARCHAR2
99 , x_attribute10 VARCHAR2
100 , x_attribute11 VARCHAR2
101 , x_attribute12 VARCHAR2
102 , x_attribute13 VARCHAR2
103 , x_attribute14 VARCHAR2
104 , x_attribute15 VARCHAR2
105 );
106
107
108 PROCEDURE update_row
109 ( x_rowid VARCHAR2
110 , x_doc_sequence_category_id NUMBER
111 , x_location_id NUMBER
112 , x_document_type VARCHAR2
113 , x_document_code VARCHAR2
114 , x_application_id VARCHAR2
115 , x_category_code VARCHAR2
116 , x_name VARCHAR2
117 , x_description VARCHAR2
118 , x_prefix VARCHAR2
119 , x_suffix VARCHAR2
120 , x_delimiter VARCHAR2
121 , x_enabled_flag VARCHAR2
122 , x_created_by NUMBER
123 , x_creation_date DATE
124 , x_last_updated_by NUMBER
125 , x_last_update_date DATE
126 , x_last_update_login NUMBER
127 , x_program_application_id NUMBER
128 , x_program_id NUMBER
129 , x_program_update_date DATE
130 , x_request_id NUMBER
131 , x_attribute_category VARCHAR2
132 , x_attribute1 VARCHAR2
133 , x_attribute2 VARCHAR2
134 , x_attribute3 VARCHAR2
135 , x_attribute4 VARCHAR2
136 , x_attribute5 VARCHAR2
137 , x_attribute6 VARCHAR2
138 , x_attribute7 VARCHAR2
139 , x_attribute8 VARCHAR2
140 , x_attribute9 VARCHAR2
141 , x_attribute10 VARCHAR2
142 , x_attribute11 VARCHAR2
143 , x_attribute12 VARCHAR2
144 , x_attribute13 VARCHAR2
145 , x_attribute14 VARCHAR2
146 , x_attribute15 VARCHAR2
147 );
148
149 PROCEDURE lock_row
150 ( x_rowid VARCHAR2
151 , x_doc_sequence_category_id NUMBER
152 , x_location_id NUMBER
153 , x_document_type VARCHAR2
154 , x_document_code VARCHAR2
155 , x_application_id VARCHAR2
156 , x_category_code VARCHAR2
157 , x_prefix VARCHAR2
158 , x_suffix VARCHAR2
159 , x_delimiter VARCHAR2
160 , x_enabled_flag VARCHAR2
161 , x_created_by NUMBER
162 , x_creation_date DATE
163 , x_last_updated_by NUMBER
164 , x_last_update_date DATE
165 , x_last_update_login NUMBER
166 , x_program_application_id NUMBER
167 , x_program_id NUMBER
168 , x_program_update_date DATE
169 , x_request_id NUMBER
170 , x_attribute_category VARCHAR2
171 , x_attribute1 VARCHAR2
172 , x_attribute2 VARCHAR2
173 , x_attribute3 VARCHAR2
174 , x_attribute4 VARCHAR2
175 , x_attribute5 VARCHAR2
176 , x_attribute6 VARCHAR2
177 , x_attribute7 VARCHAR2
178 , x_attribute8 VARCHAR2
179 , x_attribute9 VARCHAR2
180 , x_attribute10 VARCHAR2
181 , x_attribute11 VARCHAR2
182 , x_attribute12 VARCHAR2
183 , x_attribute13 VARCHAR2
184 , x_attribute14 VARCHAR2
185 , x_attribute15 VARCHAR2
186 );
187
188 PROCEDURE delete_row ( x_rowid VARCHAR2 );
189
190 END wsh_doc_seq_ctg_s;