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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: );
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:
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:
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: ------------