4: -- GLOBAL VARIABLES
5: ------------------------------------------------------------------------------
6: g_pkg_name CONSTANT VARCHAR2 (200)
7: := 'OKC_IMP_TERMS_TEMPLATES_PVT';
8: g_app_name CONSTANT VARCHAR2 (3) := okc_api.g_app_name;
9: ------------------------------------------------------------------------------
10: -- GLOBAL CONSTANTS
11: ------------------------------------------------------------------------------
12: g_false CONSTANT VARCHAR2 (1) := fnd_api.g_false;
17: := fnd_api.g_ret_sts_unexp_error;
18:
19: TYPE terms_template_rec_type IS RECORD (
20: template_id okc_terms_templates_all.template_id%TYPE
21: := okc_api.g_miss_num,
22: template_name okc_terms_templates_all.template_name%TYPE
23: := okc_api.g_miss_char,
24: intent okc_terms_templates_all.intent%TYPE
25: := okc_api.g_miss_char,
19: TYPE terms_template_rec_type IS RECORD (
20: template_id okc_terms_templates_all.template_id%TYPE
21: := okc_api.g_miss_num,
22: template_name okc_terms_templates_all.template_name%TYPE
23: := okc_api.g_miss_char,
24: intent okc_terms_templates_all.intent%TYPE
25: := okc_api.g_miss_char,
26: status_code okc_terms_templates_all.status_code%TYPE
27: := okc_api.g_miss_char,
21: := okc_api.g_miss_num,
22: template_name okc_terms_templates_all.template_name%TYPE
23: := okc_api.g_miss_char,
24: intent okc_terms_templates_all.intent%TYPE
25: := okc_api.g_miss_char,
26: status_code okc_terms_templates_all.status_code%TYPE
27: := okc_api.g_miss_char,
28: start_date okc_terms_templates_all.start_date%TYPE
29: := okc_api.g_miss_date,
23: := okc_api.g_miss_char,
24: intent okc_terms_templates_all.intent%TYPE
25: := okc_api.g_miss_char,
26: status_code okc_terms_templates_all.status_code%TYPE
27: := okc_api.g_miss_char,
28: start_date okc_terms_templates_all.start_date%TYPE
29: := okc_api.g_miss_date,
30: end_date okc_terms_templates_all.end_date%TYPE
31: := okc_api.g_miss_date,
25: := okc_api.g_miss_char,
26: status_code okc_terms_templates_all.status_code%TYPE
27: := okc_api.g_miss_char,
28: start_date okc_terms_templates_all.start_date%TYPE
29: := okc_api.g_miss_date,
30: end_date okc_terms_templates_all.end_date%TYPE
31: := okc_api.g_miss_date,
32: global_flag okc_terms_templates_all.global_flag%TYPE
33: := okc_api.g_miss_char,
27: := okc_api.g_miss_char,
28: start_date okc_terms_templates_all.start_date%TYPE
29: := okc_api.g_miss_date,
30: end_date okc_terms_templates_all.end_date%TYPE
31: := okc_api.g_miss_date,
32: global_flag okc_terms_templates_all.global_flag%TYPE
33: := okc_api.g_miss_char,
34: instruction_text okc_terms_templates_all.instruction_text%TYPE
35: := okc_api.g_miss_char,
29: := okc_api.g_miss_date,
30: end_date okc_terms_templates_all.end_date%TYPE
31: := okc_api.g_miss_date,
32: global_flag okc_terms_templates_all.global_flag%TYPE
33: := okc_api.g_miss_char,
34: instruction_text okc_terms_templates_all.instruction_text%TYPE
35: := okc_api.g_miss_char,
36: description okc_terms_templates_all.description%TYPE
37: := okc_api.g_miss_char,
31: := okc_api.g_miss_date,
32: global_flag okc_terms_templates_all.global_flag%TYPE
33: := okc_api.g_miss_char,
34: instruction_text okc_terms_templates_all.instruction_text%TYPE
35: := okc_api.g_miss_char,
36: description okc_terms_templates_all.description%TYPE
37: := okc_api.g_miss_char,
38: working_copy_flag okc_terms_templates_all.working_copy_flag%TYPE
39: := okc_api.g_miss_char,
33: := okc_api.g_miss_char,
34: instruction_text okc_terms_templates_all.instruction_text%TYPE
35: := okc_api.g_miss_char,
36: description okc_terms_templates_all.description%TYPE
37: := okc_api.g_miss_char,
38: working_copy_flag okc_terms_templates_all.working_copy_flag%TYPE
39: := okc_api.g_miss_char,
40: parent_template_id okc_terms_templates_all.parent_template_id%TYPE
41: := okc_api.g_miss_num,
35: := okc_api.g_miss_char,
36: description okc_terms_templates_all.description%TYPE
37: := okc_api.g_miss_char,
38: working_copy_flag okc_terms_templates_all.working_copy_flag%TYPE
39: := okc_api.g_miss_char,
40: parent_template_id okc_terms_templates_all.parent_template_id%TYPE
41: := okc_api.g_miss_num,
42: contract_expert_enabled okc_terms_templates_all.contract_expert_enabled%TYPE
43: := okc_api.g_miss_char,
37: := okc_api.g_miss_char,
38: working_copy_flag okc_terms_templates_all.working_copy_flag%TYPE
39: := okc_api.g_miss_char,
40: parent_template_id okc_terms_templates_all.parent_template_id%TYPE
41: := okc_api.g_miss_num,
42: contract_expert_enabled okc_terms_templates_all.contract_expert_enabled%TYPE
43: := okc_api.g_miss_char,
44: template_model_id okc_terms_templates_all.template_model_id%TYPE
45: := okc_api.g_miss_num,
39: := okc_api.g_miss_char,
40: parent_template_id okc_terms_templates_all.parent_template_id%TYPE
41: := okc_api.g_miss_num,
42: contract_expert_enabled okc_terms_templates_all.contract_expert_enabled%TYPE
43: := okc_api.g_miss_char,
44: template_model_id okc_terms_templates_all.template_model_id%TYPE
45: := okc_api.g_miss_num,
46: tmpl_numbering_scheme okc_terms_templates_all.tmpl_numbering_scheme%TYPE
47: := okc_api.g_miss_num,
41: := okc_api.g_miss_num,
42: contract_expert_enabled okc_terms_templates_all.contract_expert_enabled%TYPE
43: := okc_api.g_miss_char,
44: template_model_id okc_terms_templates_all.template_model_id%TYPE
45: := okc_api.g_miss_num,
46: tmpl_numbering_scheme okc_terms_templates_all.tmpl_numbering_scheme%TYPE
47: := okc_api.g_miss_num,
48: print_template_id okc_terms_templates_all.print_template_id%TYPE
49: := okc_api.g_miss_num,
43: := okc_api.g_miss_char,
44: template_model_id okc_terms_templates_all.template_model_id%TYPE
45: := okc_api.g_miss_num,
46: tmpl_numbering_scheme okc_terms_templates_all.tmpl_numbering_scheme%TYPE
47: := okc_api.g_miss_num,
48: print_template_id okc_terms_templates_all.print_template_id%TYPE
49: := okc_api.g_miss_num,
50: approval_wf_key okc_terms_templates_all.approval_wf_key%TYPE
51: := okc_api.g_miss_char,
45: := okc_api.g_miss_num,
46: tmpl_numbering_scheme okc_terms_templates_all.tmpl_numbering_scheme%TYPE
47: := okc_api.g_miss_num,
48: print_template_id okc_terms_templates_all.print_template_id%TYPE
49: := okc_api.g_miss_num,
50: approval_wf_key okc_terms_templates_all.approval_wf_key%TYPE
51: := okc_api.g_miss_char,
52: cz_export_wf_key okc_terms_templates_all.cz_export_wf_key%TYPE
53: := okc_api.g_miss_char,
47: := okc_api.g_miss_num,
48: print_template_id okc_terms_templates_all.print_template_id%TYPE
49: := okc_api.g_miss_num,
50: approval_wf_key okc_terms_templates_all.approval_wf_key%TYPE
51: := okc_api.g_miss_char,
52: cz_export_wf_key okc_terms_templates_all.cz_export_wf_key%TYPE
53: := okc_api.g_miss_char,
54: last_update_login NUMBER := okc_api.g_miss_num,
55: creation_date DATE := okc_api.g_miss_date,
49: := okc_api.g_miss_num,
50: approval_wf_key okc_terms_templates_all.approval_wf_key%TYPE
51: := okc_api.g_miss_char,
52: cz_export_wf_key okc_terms_templates_all.cz_export_wf_key%TYPE
53: := okc_api.g_miss_char,
54: last_update_login NUMBER := okc_api.g_miss_num,
55: creation_date DATE := okc_api.g_miss_date,
56: created_by NUMBER := okc_api.g_miss_num,
57: last_updated_by NUMBER := okc_api.g_miss_num,
50: approval_wf_key okc_terms_templates_all.approval_wf_key%TYPE
51: := okc_api.g_miss_char,
52: cz_export_wf_key okc_terms_templates_all.cz_export_wf_key%TYPE
53: := okc_api.g_miss_char,
54: last_update_login NUMBER := okc_api.g_miss_num,
55: creation_date DATE := okc_api.g_miss_date,
56: created_by NUMBER := okc_api.g_miss_num,
57: last_updated_by NUMBER := okc_api.g_miss_num,
58: last_update_date DATE := okc_api.g_miss_date,
51: := okc_api.g_miss_char,
52: cz_export_wf_key okc_terms_templates_all.cz_export_wf_key%TYPE
53: := okc_api.g_miss_char,
54: last_update_login NUMBER := okc_api.g_miss_num,
55: creation_date DATE := okc_api.g_miss_date,
56: created_by NUMBER := okc_api.g_miss_num,
57: last_updated_by NUMBER := okc_api.g_miss_num,
58: last_update_date DATE := okc_api.g_miss_date,
59: org_id okc_terms_templates_all.org_id%TYPE
52: cz_export_wf_key okc_terms_templates_all.cz_export_wf_key%TYPE
53: := okc_api.g_miss_char,
54: last_update_login NUMBER := okc_api.g_miss_num,
55: creation_date DATE := okc_api.g_miss_date,
56: created_by NUMBER := okc_api.g_miss_num,
57: last_updated_by NUMBER := okc_api.g_miss_num,
58: last_update_date DATE := okc_api.g_miss_date,
59: org_id okc_terms_templates_all.org_id%TYPE
60: := okc_api.g_miss_num,
53: := okc_api.g_miss_char,
54: last_update_login NUMBER := okc_api.g_miss_num,
55: creation_date DATE := okc_api.g_miss_date,
56: created_by NUMBER := okc_api.g_miss_num,
57: last_updated_by NUMBER := okc_api.g_miss_num,
58: last_update_date DATE := okc_api.g_miss_date,
59: org_id okc_terms_templates_all.org_id%TYPE
60: := okc_api.g_miss_num,
61: orig_system_reference_code okc_terms_templates_all.orig_system_reference_code%TYPE
54: last_update_login NUMBER := okc_api.g_miss_num,
55: creation_date DATE := okc_api.g_miss_date,
56: created_by NUMBER := okc_api.g_miss_num,
57: last_updated_by NUMBER := okc_api.g_miss_num,
58: last_update_date DATE := okc_api.g_miss_date,
59: org_id okc_terms_templates_all.org_id%TYPE
60: := okc_api.g_miss_num,
61: orig_system_reference_code okc_terms_templates_all.orig_system_reference_code%TYPE
62: := okc_api.g_miss_char,
56: created_by NUMBER := okc_api.g_miss_num,
57: last_updated_by NUMBER := okc_api.g_miss_num,
58: last_update_date DATE := okc_api.g_miss_date,
59: org_id okc_terms_templates_all.org_id%TYPE
60: := okc_api.g_miss_num,
61: orig_system_reference_code okc_terms_templates_all.orig_system_reference_code%TYPE
62: := okc_api.g_miss_char,
63: orig_system_reference_id1 okc_terms_templates_all.orig_system_reference_id1%TYPE
64: := okc_api.g_miss_num,
58: last_update_date DATE := okc_api.g_miss_date,
59: org_id okc_terms_templates_all.org_id%TYPE
60: := okc_api.g_miss_num,
61: orig_system_reference_code okc_terms_templates_all.orig_system_reference_code%TYPE
62: := okc_api.g_miss_char,
63: orig_system_reference_id1 okc_terms_templates_all.orig_system_reference_id1%TYPE
64: := okc_api.g_miss_num,
65: orig_system_reference_id2 okc_terms_templates_all.orig_system_reference_id2%TYPE
66: := okc_api.g_miss_num,
60: := okc_api.g_miss_num,
61: orig_system_reference_code okc_terms_templates_all.orig_system_reference_code%TYPE
62: := okc_api.g_miss_char,
63: orig_system_reference_id1 okc_terms_templates_all.orig_system_reference_id1%TYPE
64: := okc_api.g_miss_num,
65: orig_system_reference_id2 okc_terms_templates_all.orig_system_reference_id2%TYPE
66: := okc_api.g_miss_num,
67: object_version_number NUMBER := okc_api.g_miss_num,
68: hide_yn okc_terms_templates_all.hide_yn%TYPE
62: := okc_api.g_miss_char,
63: orig_system_reference_id1 okc_terms_templates_all.orig_system_reference_id1%TYPE
64: := okc_api.g_miss_num,
65: orig_system_reference_id2 okc_terms_templates_all.orig_system_reference_id2%TYPE
66: := okc_api.g_miss_num,
67: object_version_number NUMBER := okc_api.g_miss_num,
68: hide_yn okc_terms_templates_all.hide_yn%TYPE
69: := okc_api.g_miss_char,
70: attribute_category okc_terms_templates_all.attribute_category%TYPE
63: orig_system_reference_id1 okc_terms_templates_all.orig_system_reference_id1%TYPE
64: := okc_api.g_miss_num,
65: orig_system_reference_id2 okc_terms_templates_all.orig_system_reference_id2%TYPE
66: := okc_api.g_miss_num,
67: object_version_number NUMBER := okc_api.g_miss_num,
68: hide_yn okc_terms_templates_all.hide_yn%TYPE
69: := okc_api.g_miss_char,
70: attribute_category okc_terms_templates_all.attribute_category%TYPE
71: := okc_api.g_miss_char,
65: orig_system_reference_id2 okc_terms_templates_all.orig_system_reference_id2%TYPE
66: := okc_api.g_miss_num,
67: object_version_number NUMBER := okc_api.g_miss_num,
68: hide_yn okc_terms_templates_all.hide_yn%TYPE
69: := okc_api.g_miss_char,
70: attribute_category okc_terms_templates_all.attribute_category%TYPE
71: := okc_api.g_miss_char,
72: attribute1 okc_terms_templates_all.attribute1%TYPE
73: := okc_api.g_miss_char,
67: object_version_number NUMBER := okc_api.g_miss_num,
68: hide_yn okc_terms_templates_all.hide_yn%TYPE
69: := okc_api.g_miss_char,
70: attribute_category okc_terms_templates_all.attribute_category%TYPE
71: := okc_api.g_miss_char,
72: attribute1 okc_terms_templates_all.attribute1%TYPE
73: := okc_api.g_miss_char,
74: attribute2 okc_terms_templates_all.attribute2%TYPE
75: := okc_api.g_miss_char,
69: := okc_api.g_miss_char,
70: attribute_category okc_terms_templates_all.attribute_category%TYPE
71: := okc_api.g_miss_char,
72: attribute1 okc_terms_templates_all.attribute1%TYPE
73: := okc_api.g_miss_char,
74: attribute2 okc_terms_templates_all.attribute2%TYPE
75: := okc_api.g_miss_char,
76: attribute3 okc_terms_templates_all.attribute3%TYPE
77: := okc_api.g_miss_char,
71: := okc_api.g_miss_char,
72: attribute1 okc_terms_templates_all.attribute1%TYPE
73: := okc_api.g_miss_char,
74: attribute2 okc_terms_templates_all.attribute2%TYPE
75: := okc_api.g_miss_char,
76: attribute3 okc_terms_templates_all.attribute3%TYPE
77: := okc_api.g_miss_char,
78: attribute4 okc_terms_templates_all.attribute4%TYPE
79: := okc_api.g_miss_char,
73: := okc_api.g_miss_char,
74: attribute2 okc_terms_templates_all.attribute2%TYPE
75: := okc_api.g_miss_char,
76: attribute3 okc_terms_templates_all.attribute3%TYPE
77: := okc_api.g_miss_char,
78: attribute4 okc_terms_templates_all.attribute4%TYPE
79: := okc_api.g_miss_char,
80: attribute5 okc_terms_templates_all.attribute5%TYPE
81: := okc_api.g_miss_char,
75: := okc_api.g_miss_char,
76: attribute3 okc_terms_templates_all.attribute3%TYPE
77: := okc_api.g_miss_char,
78: attribute4 okc_terms_templates_all.attribute4%TYPE
79: := okc_api.g_miss_char,
80: attribute5 okc_terms_templates_all.attribute5%TYPE
81: := okc_api.g_miss_char,
82: attribute6 okc_terms_templates_all.attribute6%TYPE
83: := okc_api.g_miss_char,
77: := okc_api.g_miss_char,
78: attribute4 okc_terms_templates_all.attribute4%TYPE
79: := okc_api.g_miss_char,
80: attribute5 okc_terms_templates_all.attribute5%TYPE
81: := okc_api.g_miss_char,
82: attribute6 okc_terms_templates_all.attribute6%TYPE
83: := okc_api.g_miss_char,
84: attribute7 okc_terms_templates_all.attribute7%TYPE
85: := okc_api.g_miss_char,
79: := okc_api.g_miss_char,
80: attribute5 okc_terms_templates_all.attribute5%TYPE
81: := okc_api.g_miss_char,
82: attribute6 okc_terms_templates_all.attribute6%TYPE
83: := okc_api.g_miss_char,
84: attribute7 okc_terms_templates_all.attribute7%TYPE
85: := okc_api.g_miss_char,
86: attribute8 okc_terms_templates_all.attribute8%TYPE
87: := okc_api.g_miss_char,
81: := okc_api.g_miss_char,
82: attribute6 okc_terms_templates_all.attribute6%TYPE
83: := okc_api.g_miss_char,
84: attribute7 okc_terms_templates_all.attribute7%TYPE
85: := okc_api.g_miss_char,
86: attribute8 okc_terms_templates_all.attribute8%TYPE
87: := okc_api.g_miss_char,
88: attribute9 okc_terms_templates_all.attribute9%TYPE
89: := okc_api.g_miss_char,
83: := okc_api.g_miss_char,
84: attribute7 okc_terms_templates_all.attribute7%TYPE
85: := okc_api.g_miss_char,
86: attribute8 okc_terms_templates_all.attribute8%TYPE
87: := okc_api.g_miss_char,
88: attribute9 okc_terms_templates_all.attribute9%TYPE
89: := okc_api.g_miss_char,
90: attribute10 okc_terms_templates_all.attribute10%TYPE
91: := okc_api.g_miss_char,
85: := okc_api.g_miss_char,
86: attribute8 okc_terms_templates_all.attribute8%TYPE
87: := okc_api.g_miss_char,
88: attribute9 okc_terms_templates_all.attribute9%TYPE
89: := okc_api.g_miss_char,
90: attribute10 okc_terms_templates_all.attribute10%TYPE
91: := okc_api.g_miss_char,
92: attribute11 okc_terms_templates_all.attribute11%TYPE
93: := okc_api.g_miss_char,
87: := okc_api.g_miss_char,
88: attribute9 okc_terms_templates_all.attribute9%TYPE
89: := okc_api.g_miss_char,
90: attribute10 okc_terms_templates_all.attribute10%TYPE
91: := okc_api.g_miss_char,
92: attribute11 okc_terms_templates_all.attribute11%TYPE
93: := okc_api.g_miss_char,
94: attribute12 okc_terms_templates_all.attribute12%TYPE
95: := okc_api.g_miss_char,
89: := okc_api.g_miss_char,
90: attribute10 okc_terms_templates_all.attribute10%TYPE
91: := okc_api.g_miss_char,
92: attribute11 okc_terms_templates_all.attribute11%TYPE
93: := okc_api.g_miss_char,
94: attribute12 okc_terms_templates_all.attribute12%TYPE
95: := okc_api.g_miss_char,
96: attribute13 okc_terms_templates_all.attribute13%TYPE
97: := okc_api.g_miss_char,
91: := okc_api.g_miss_char,
92: attribute11 okc_terms_templates_all.attribute11%TYPE
93: := okc_api.g_miss_char,
94: attribute12 okc_terms_templates_all.attribute12%TYPE
95: := okc_api.g_miss_char,
96: attribute13 okc_terms_templates_all.attribute13%TYPE
97: := okc_api.g_miss_char,
98: attribute14 okc_terms_templates_all.attribute14%TYPE
99: := okc_api.g_miss_char,
93: := okc_api.g_miss_char,
94: attribute12 okc_terms_templates_all.attribute12%TYPE
95: := okc_api.g_miss_char,
96: attribute13 okc_terms_templates_all.attribute13%TYPE
97: := okc_api.g_miss_char,
98: attribute14 okc_terms_templates_all.attribute14%TYPE
99: := okc_api.g_miss_char,
100: attribute15 okc_terms_templates_all.attribute15%TYPE
101: := okc_api.g_miss_char,
95: := okc_api.g_miss_char,
96: attribute13 okc_terms_templates_all.attribute13%TYPE
97: := okc_api.g_miss_char,
98: attribute14 okc_terms_templates_all.attribute14%TYPE
99: := okc_api.g_miss_char,
100: attribute15 okc_terms_templates_all.attribute15%TYPE
101: := okc_api.g_miss_char,
102: xprt_request_id NUMBER := okc_api.g_miss_num,
103: xprt_clause_mandatory_flag okc_terms_templates_all.xprt_clause_mandatory_flag%TYPE
97: := okc_api.g_miss_char,
98: attribute14 okc_terms_templates_all.attribute14%TYPE
99: := okc_api.g_miss_char,
100: attribute15 okc_terms_templates_all.attribute15%TYPE
101: := okc_api.g_miss_char,
102: xprt_request_id NUMBER := okc_api.g_miss_num,
103: xprt_clause_mandatory_flag okc_terms_templates_all.xprt_clause_mandatory_flag%TYPE
104: := okc_api.g_miss_char,
105: xprt_scn_code okc_terms_templates_all.xprt_scn_code%TYPE
98: attribute14 okc_terms_templates_all.attribute14%TYPE
99: := okc_api.g_miss_char,
100: attribute15 okc_terms_templates_all.attribute15%TYPE
101: := okc_api.g_miss_char,
102: xprt_request_id NUMBER := okc_api.g_miss_num,
103: xprt_clause_mandatory_flag okc_terms_templates_all.xprt_clause_mandatory_flag%TYPE
104: := okc_api.g_miss_char,
105: xprt_scn_code okc_terms_templates_all.xprt_scn_code%TYPE
106: := okc_api.g_miss_char,
100: attribute15 okc_terms_templates_all.attribute15%TYPE
101: := okc_api.g_miss_char,
102: xprt_request_id NUMBER := okc_api.g_miss_num,
103: xprt_clause_mandatory_flag okc_terms_templates_all.xprt_clause_mandatory_flag%TYPE
104: := okc_api.g_miss_char,
105: xprt_scn_code okc_terms_templates_all.xprt_scn_code%TYPE
106: := okc_api.g_miss_char,
107: LANGUAGE okc_terms_templates_all.LANGUAGE%TYPE
108: := okc_api.g_miss_char,
102: xprt_request_id NUMBER := okc_api.g_miss_num,
103: xprt_clause_mandatory_flag okc_terms_templates_all.xprt_clause_mandatory_flag%TYPE
104: := okc_api.g_miss_char,
105: xprt_scn_code okc_terms_templates_all.xprt_scn_code%TYPE
106: := okc_api.g_miss_char,
107: LANGUAGE okc_terms_templates_all.LANGUAGE%TYPE
108: := okc_api.g_miss_char,
109: translated_from_tmpl_id okc_terms_templates_all.translated_from_tmpl_id%TYPE
110: := okc_api.g_miss_num,
104: := okc_api.g_miss_char,
105: xprt_scn_code okc_terms_templates_all.xprt_scn_code%TYPE
106: := okc_api.g_miss_char,
107: LANGUAGE okc_terms_templates_all.LANGUAGE%TYPE
108: := okc_api.g_miss_char,
109: translated_from_tmpl_id okc_terms_templates_all.translated_from_tmpl_id%TYPE
110: := okc_api.g_miss_num,
111: status VARCHAR2 (1),
112: errmsg VARCHAR2 (2500)
106: := okc_api.g_miss_char,
107: LANGUAGE okc_terms_templates_all.LANGUAGE%TYPE
108: := okc_api.g_miss_char,
109: translated_from_tmpl_id okc_terms_templates_all.translated_from_tmpl_id%TYPE
110: := okc_api.g_miss_num,
111: status VARCHAR2 (1),
112: errmsg VARCHAR2 (2500)
113: );
114:
116: INDEX BY PLS_INTEGER;
117:
118: TYPE tmpl_usage_rec_type IS RECORD (
119: allowed_tmpl_usages_id okc_allowed_tmpl_usages.allowed_tmpl_usages_id%TYPE
120: := okc_api.g_miss_num,
121:
122: document_type okc_allowed_tmpl_usages.document_type%TYPE
123: := okc_api.g_miss_char,
124: default_yn okc_allowed_tmpl_usages.default_yn%TYPE
119: allowed_tmpl_usages_id okc_allowed_tmpl_usages.allowed_tmpl_usages_id%TYPE
120: := okc_api.g_miss_num,
121:
122: document_type okc_allowed_tmpl_usages.document_type%TYPE
123: := okc_api.g_miss_char,
124: default_yn okc_allowed_tmpl_usages.default_yn%TYPE
125: := okc_api.g_miss_char,
126: last_update_login NUMBER := okc_api.g_miss_num,
127: creation_date DATE := okc_api.g_miss_date,
121:
122: document_type okc_allowed_tmpl_usages.document_type%TYPE
123: := okc_api.g_miss_char,
124: default_yn okc_allowed_tmpl_usages.default_yn%TYPE
125: := okc_api.g_miss_char,
126: last_update_login NUMBER := okc_api.g_miss_num,
127: creation_date DATE := okc_api.g_miss_date,
128: created_by NUMBER := okc_api.g_miss_num,
129: last_updated_by NUMBER := okc_api.g_miss_num,
122: document_type okc_allowed_tmpl_usages.document_type%TYPE
123: := okc_api.g_miss_char,
124: default_yn okc_allowed_tmpl_usages.default_yn%TYPE
125: := okc_api.g_miss_char,
126: last_update_login NUMBER := okc_api.g_miss_num,
127: creation_date DATE := okc_api.g_miss_date,
128: created_by NUMBER := okc_api.g_miss_num,
129: last_updated_by NUMBER := okc_api.g_miss_num,
130: last_update_date DATE := okc_api.g_miss_date,
123: := okc_api.g_miss_char,
124: default_yn okc_allowed_tmpl_usages.default_yn%TYPE
125: := okc_api.g_miss_char,
126: last_update_login NUMBER := okc_api.g_miss_num,
127: creation_date DATE := okc_api.g_miss_date,
128: created_by NUMBER := okc_api.g_miss_num,
129: last_updated_by NUMBER := okc_api.g_miss_num,
130: last_update_date DATE := okc_api.g_miss_date,
131: object_version_number NUMBER := okc_api.g_miss_num,
124: default_yn okc_allowed_tmpl_usages.default_yn%TYPE
125: := okc_api.g_miss_char,
126: last_update_login NUMBER := okc_api.g_miss_num,
127: creation_date DATE := okc_api.g_miss_date,
128: created_by NUMBER := okc_api.g_miss_num,
129: last_updated_by NUMBER := okc_api.g_miss_num,
130: last_update_date DATE := okc_api.g_miss_date,
131: object_version_number NUMBER := okc_api.g_miss_num,
132: attribute_category okc_allowed_tmpl_usages.attribute_category%TYPE
125: := okc_api.g_miss_char,
126: last_update_login NUMBER := okc_api.g_miss_num,
127: creation_date DATE := okc_api.g_miss_date,
128: created_by NUMBER := okc_api.g_miss_num,
129: last_updated_by NUMBER := okc_api.g_miss_num,
130: last_update_date DATE := okc_api.g_miss_date,
131: object_version_number NUMBER := okc_api.g_miss_num,
132: attribute_category okc_allowed_tmpl_usages.attribute_category%TYPE
133: := okc_api.g_miss_char,
126: last_update_login NUMBER := okc_api.g_miss_num,
127: creation_date DATE := okc_api.g_miss_date,
128: created_by NUMBER := okc_api.g_miss_num,
129: last_updated_by NUMBER := okc_api.g_miss_num,
130: last_update_date DATE := okc_api.g_miss_date,
131: object_version_number NUMBER := okc_api.g_miss_num,
132: attribute_category okc_allowed_tmpl_usages.attribute_category%TYPE
133: := okc_api.g_miss_char,
134: attribute1 okc_allowed_tmpl_usages.attribute1%TYPE
127: creation_date DATE := okc_api.g_miss_date,
128: created_by NUMBER := okc_api.g_miss_num,
129: last_updated_by NUMBER := okc_api.g_miss_num,
130: last_update_date DATE := okc_api.g_miss_date,
131: object_version_number NUMBER := okc_api.g_miss_num,
132: attribute_category okc_allowed_tmpl_usages.attribute_category%TYPE
133: := okc_api.g_miss_char,
134: attribute1 okc_allowed_tmpl_usages.attribute1%TYPE
135: := okc_api.g_miss_char,
129: last_updated_by NUMBER := okc_api.g_miss_num,
130: last_update_date DATE := okc_api.g_miss_date,
131: object_version_number NUMBER := okc_api.g_miss_num,
132: attribute_category okc_allowed_tmpl_usages.attribute_category%TYPE
133: := okc_api.g_miss_char,
134: attribute1 okc_allowed_tmpl_usages.attribute1%TYPE
135: := okc_api.g_miss_char,
136: attribute2 okc_allowed_tmpl_usages.attribute2%TYPE
137: := okc_api.g_miss_char,
131: object_version_number NUMBER := okc_api.g_miss_num,
132: attribute_category okc_allowed_tmpl_usages.attribute_category%TYPE
133: := okc_api.g_miss_char,
134: attribute1 okc_allowed_tmpl_usages.attribute1%TYPE
135: := okc_api.g_miss_char,
136: attribute2 okc_allowed_tmpl_usages.attribute2%TYPE
137: := okc_api.g_miss_char,
138: attribute3 okc_allowed_tmpl_usages.attribute3%TYPE
139: := okc_api.g_miss_char,
133: := okc_api.g_miss_char,
134: attribute1 okc_allowed_tmpl_usages.attribute1%TYPE
135: := okc_api.g_miss_char,
136: attribute2 okc_allowed_tmpl_usages.attribute2%TYPE
137: := okc_api.g_miss_char,
138: attribute3 okc_allowed_tmpl_usages.attribute3%TYPE
139: := okc_api.g_miss_char,
140: attribute4 okc_allowed_tmpl_usages.attribute4%TYPE
141: := okc_api.g_miss_char,
135: := okc_api.g_miss_char,
136: attribute2 okc_allowed_tmpl_usages.attribute2%TYPE
137: := okc_api.g_miss_char,
138: attribute3 okc_allowed_tmpl_usages.attribute3%TYPE
139: := okc_api.g_miss_char,
140: attribute4 okc_allowed_tmpl_usages.attribute4%TYPE
141: := okc_api.g_miss_char,
142: attribute5 okc_allowed_tmpl_usages.attribute5%TYPE
143: := okc_api.g_miss_char,
137: := okc_api.g_miss_char,
138: attribute3 okc_allowed_tmpl_usages.attribute3%TYPE
139: := okc_api.g_miss_char,
140: attribute4 okc_allowed_tmpl_usages.attribute4%TYPE
141: := okc_api.g_miss_char,
142: attribute5 okc_allowed_tmpl_usages.attribute5%TYPE
143: := okc_api.g_miss_char,
144: attribute6 okc_allowed_tmpl_usages.attribute6%TYPE
145: := okc_api.g_miss_char,
139: := okc_api.g_miss_char,
140: attribute4 okc_allowed_tmpl_usages.attribute4%TYPE
141: := okc_api.g_miss_char,
142: attribute5 okc_allowed_tmpl_usages.attribute5%TYPE
143: := okc_api.g_miss_char,
144: attribute6 okc_allowed_tmpl_usages.attribute6%TYPE
145: := okc_api.g_miss_char,
146: attribute7 okc_allowed_tmpl_usages.attribute7%TYPE
147: := okc_api.g_miss_char,
141: := okc_api.g_miss_char,
142: attribute5 okc_allowed_tmpl_usages.attribute5%TYPE
143: := okc_api.g_miss_char,
144: attribute6 okc_allowed_tmpl_usages.attribute6%TYPE
145: := okc_api.g_miss_char,
146: attribute7 okc_allowed_tmpl_usages.attribute7%TYPE
147: := okc_api.g_miss_char,
148: attribute8 okc_allowed_tmpl_usages.attribute8%TYPE
149: := okc_api.g_miss_char,
143: := okc_api.g_miss_char,
144: attribute6 okc_allowed_tmpl_usages.attribute6%TYPE
145: := okc_api.g_miss_char,
146: attribute7 okc_allowed_tmpl_usages.attribute7%TYPE
147: := okc_api.g_miss_char,
148: attribute8 okc_allowed_tmpl_usages.attribute8%TYPE
149: := okc_api.g_miss_char,
150: attribute9 okc_allowed_tmpl_usages.attribute9%TYPE
151: := okc_api.g_miss_char,
145: := okc_api.g_miss_char,
146: attribute7 okc_allowed_tmpl_usages.attribute7%TYPE
147: := okc_api.g_miss_char,
148: attribute8 okc_allowed_tmpl_usages.attribute8%TYPE
149: := okc_api.g_miss_char,
150: attribute9 okc_allowed_tmpl_usages.attribute9%TYPE
151: := okc_api.g_miss_char,
152: attribute10 okc_allowed_tmpl_usages.attribute10%TYPE
153: := okc_api.g_miss_char,
147: := okc_api.g_miss_char,
148: attribute8 okc_allowed_tmpl_usages.attribute8%TYPE
149: := okc_api.g_miss_char,
150: attribute9 okc_allowed_tmpl_usages.attribute9%TYPE
151: := okc_api.g_miss_char,
152: attribute10 okc_allowed_tmpl_usages.attribute10%TYPE
153: := okc_api.g_miss_char,
154: attribute11 okc_allowed_tmpl_usages.attribute11%TYPE
155: := okc_api.g_miss_char,
149: := okc_api.g_miss_char,
150: attribute9 okc_allowed_tmpl_usages.attribute9%TYPE
151: := okc_api.g_miss_char,
152: attribute10 okc_allowed_tmpl_usages.attribute10%TYPE
153: := okc_api.g_miss_char,
154: attribute11 okc_allowed_tmpl_usages.attribute11%TYPE
155: := okc_api.g_miss_char,
156: attribute12 okc_allowed_tmpl_usages.attribute12%TYPE
157: := okc_api.g_miss_char,
151: := okc_api.g_miss_char,
152: attribute10 okc_allowed_tmpl_usages.attribute10%TYPE
153: := okc_api.g_miss_char,
154: attribute11 okc_allowed_tmpl_usages.attribute11%TYPE
155: := okc_api.g_miss_char,
156: attribute12 okc_allowed_tmpl_usages.attribute12%TYPE
157: := okc_api.g_miss_char,
158: attribute13 okc_allowed_tmpl_usages.attribute13%TYPE
159: := okc_api.g_miss_char,
153: := okc_api.g_miss_char,
154: attribute11 okc_allowed_tmpl_usages.attribute11%TYPE
155: := okc_api.g_miss_char,
156: attribute12 okc_allowed_tmpl_usages.attribute12%TYPE
157: := okc_api.g_miss_char,
158: attribute13 okc_allowed_tmpl_usages.attribute13%TYPE
159: := okc_api.g_miss_char,
160: attribute14 okc_allowed_tmpl_usages.attribute14%TYPE
161: := okc_api.g_miss_char,
155: := okc_api.g_miss_char,
156: attribute12 okc_allowed_tmpl_usages.attribute12%TYPE
157: := okc_api.g_miss_char,
158: attribute13 okc_allowed_tmpl_usages.attribute13%TYPE
159: := okc_api.g_miss_char,
160: attribute14 okc_allowed_tmpl_usages.attribute14%TYPE
161: := okc_api.g_miss_char,
162: attribute15 okc_allowed_tmpl_usages.attribute15%TYPE
163: := okc_api.g_miss_char,
157: := okc_api.g_miss_char,
158: attribute13 okc_allowed_tmpl_usages.attribute13%TYPE
159: := okc_api.g_miss_char,
160: attribute14 okc_allowed_tmpl_usages.attribute14%TYPE
161: := okc_api.g_miss_char,
162: attribute15 okc_allowed_tmpl_usages.attribute15%TYPE
163: := okc_api.g_miss_char,
164: status VARCHAR2 (1),
165: errmsg VARCHAR2 (2500)
159: := okc_api.g_miss_char,
160: attribute14 okc_allowed_tmpl_usages.attribute14%TYPE
161: := okc_api.g_miss_char,
162: attribute15 okc_allowed_tmpl_usages.attribute15%TYPE
163: := okc_api.g_miss_char,
164: status VARCHAR2 (1),
165: errmsg VARCHAR2 (2500)
166: );
167:
169: INDEX BY PLS_INTEGER;
170:
171: TYPE section_rec_type IS RECORD (
172: ID okc_sections_b.ID%TYPE
173: := okc_api.g_miss_num,
174: scn_type okc_sections_b.scn_type%TYPE
175: := okc_api.g_miss_char,
176: chr_id okc_sections_b.chr_id%TYPE
177: := okc_api.g_miss_num,
171: TYPE section_rec_type IS RECORD (
172: ID okc_sections_b.ID%TYPE
173: := okc_api.g_miss_num,
174: scn_type okc_sections_b.scn_type%TYPE
175: := okc_api.g_miss_char,
176: chr_id okc_sections_b.chr_id%TYPE
177: := okc_api.g_miss_num,
178: sat_code okc_sections_b.sat_code%TYPE
179: := okc_api.g_miss_char,
173: := okc_api.g_miss_num,
174: scn_type okc_sections_b.scn_type%TYPE
175: := okc_api.g_miss_char,
176: chr_id okc_sections_b.chr_id%TYPE
177: := okc_api.g_miss_num,
178: sat_code okc_sections_b.sat_code%TYPE
179: := okc_api.g_miss_char,
180: section_sequence okc_sections_b.section_sequence%TYPE
181: := okc_api.g_miss_num,
175: := okc_api.g_miss_char,
176: chr_id okc_sections_b.chr_id%TYPE
177: := okc_api.g_miss_num,
178: sat_code okc_sections_b.sat_code%TYPE
179: := okc_api.g_miss_char,
180: section_sequence okc_sections_b.section_sequence%TYPE
181: := okc_api.g_miss_num,
182: object_version_number NUMBER := okc_api.g_miss_num,
183: created_by NUMBER := okc_api.g_miss_num,
177: := okc_api.g_miss_num,
178: sat_code okc_sections_b.sat_code%TYPE
179: := okc_api.g_miss_char,
180: section_sequence okc_sections_b.section_sequence%TYPE
181: := okc_api.g_miss_num,
182: object_version_number NUMBER := okc_api.g_miss_num,
183: created_by NUMBER := okc_api.g_miss_num,
184: creation_date okc_sections_b.creation_date%TYPE
185: := okc_api.g_miss_date,
178: sat_code okc_sections_b.sat_code%TYPE
179: := okc_api.g_miss_char,
180: section_sequence okc_sections_b.section_sequence%TYPE
181: := okc_api.g_miss_num,
182: object_version_number NUMBER := okc_api.g_miss_num,
183: created_by NUMBER := okc_api.g_miss_num,
184: creation_date okc_sections_b.creation_date%TYPE
185: := okc_api.g_miss_date,
186: last_updated_by NUMBER := okc_api.g_miss_num,
179: := okc_api.g_miss_char,
180: section_sequence okc_sections_b.section_sequence%TYPE
181: := okc_api.g_miss_num,
182: object_version_number NUMBER := okc_api.g_miss_num,
183: created_by NUMBER := okc_api.g_miss_num,
184: creation_date okc_sections_b.creation_date%TYPE
185: := okc_api.g_miss_date,
186: last_updated_by NUMBER := okc_api.g_miss_num,
187: last_update_date okc_sections_b.last_update_date%TYPE
181: := okc_api.g_miss_num,
182: object_version_number NUMBER := okc_api.g_miss_num,
183: created_by NUMBER := okc_api.g_miss_num,
184: creation_date okc_sections_b.creation_date%TYPE
185: := okc_api.g_miss_date,
186: last_updated_by NUMBER := okc_api.g_miss_num,
187: last_update_date okc_sections_b.last_update_date%TYPE
188: := okc_api.g_miss_date,
189: last_update_login NUMBER := okc_api.g_miss_num,
182: object_version_number NUMBER := okc_api.g_miss_num,
183: created_by NUMBER := okc_api.g_miss_num,
184: creation_date okc_sections_b.creation_date%TYPE
185: := okc_api.g_miss_date,
186: last_updated_by NUMBER := okc_api.g_miss_num,
187: last_update_date okc_sections_b.last_update_date%TYPE
188: := okc_api.g_miss_date,
189: last_update_login NUMBER := okc_api.g_miss_num,
190: label okc_sections_b.label%TYPE
184: creation_date okc_sections_b.creation_date%TYPE
185: := okc_api.g_miss_date,
186: last_updated_by NUMBER := okc_api.g_miss_num,
187: last_update_date okc_sections_b.last_update_date%TYPE
188: := okc_api.g_miss_date,
189: last_update_login NUMBER := okc_api.g_miss_num,
190: label okc_sections_b.label%TYPE
191: := okc_api.g_miss_char,
192: scn_id okc_sections_b.scn_id%TYPE
185: := okc_api.g_miss_date,
186: last_updated_by NUMBER := okc_api.g_miss_num,
187: last_update_date okc_sections_b.last_update_date%TYPE
188: := okc_api.g_miss_date,
189: last_update_login NUMBER := okc_api.g_miss_num,
190: label okc_sections_b.label%TYPE
191: := okc_api.g_miss_char,
192: scn_id okc_sections_b.scn_id%TYPE
193: := okc_api.g_miss_num,
187: last_update_date okc_sections_b.last_update_date%TYPE
188: := okc_api.g_miss_date,
189: last_update_login NUMBER := okc_api.g_miss_num,
190: label okc_sections_b.label%TYPE
191: := okc_api.g_miss_char,
192: scn_id okc_sections_b.scn_id%TYPE
193: := okc_api.g_miss_num,
194: attribute_category okc_sections_b.attribute_category%TYPE
195: := okc_api.g_miss_char,
189: last_update_login NUMBER := okc_api.g_miss_num,
190: label okc_sections_b.label%TYPE
191: := okc_api.g_miss_char,
192: scn_id okc_sections_b.scn_id%TYPE
193: := okc_api.g_miss_num,
194: attribute_category okc_sections_b.attribute_category%TYPE
195: := okc_api.g_miss_char,
196: attribute1 okc_sections_b.attribute1%TYPE
197: := okc_api.g_miss_char,
191: := okc_api.g_miss_char,
192: scn_id okc_sections_b.scn_id%TYPE
193: := okc_api.g_miss_num,
194: attribute_category okc_sections_b.attribute_category%TYPE
195: := okc_api.g_miss_char,
196: attribute1 okc_sections_b.attribute1%TYPE
197: := okc_api.g_miss_char,
198: attribute2 okc_sections_b.attribute2%TYPE
199: := okc_api.g_miss_char,
193: := okc_api.g_miss_num,
194: attribute_category okc_sections_b.attribute_category%TYPE
195: := okc_api.g_miss_char,
196: attribute1 okc_sections_b.attribute1%TYPE
197: := okc_api.g_miss_char,
198: attribute2 okc_sections_b.attribute2%TYPE
199: := okc_api.g_miss_char,
200: attribute3 okc_sections_b.attribute3%TYPE
201: := okc_api.g_miss_char,
195: := okc_api.g_miss_char,
196: attribute1 okc_sections_b.attribute1%TYPE
197: := okc_api.g_miss_char,
198: attribute2 okc_sections_b.attribute2%TYPE
199: := okc_api.g_miss_char,
200: attribute3 okc_sections_b.attribute3%TYPE
201: := okc_api.g_miss_char,
202: attribute4 okc_sections_b.attribute4%TYPE
203: := okc_api.g_miss_char,
197: := okc_api.g_miss_char,
198: attribute2 okc_sections_b.attribute2%TYPE
199: := okc_api.g_miss_char,
200: attribute3 okc_sections_b.attribute3%TYPE
201: := okc_api.g_miss_char,
202: attribute4 okc_sections_b.attribute4%TYPE
203: := okc_api.g_miss_char,
204: attribute5 okc_sections_b.attribute5%TYPE
205: := okc_api.g_miss_char,
199: := okc_api.g_miss_char,
200: attribute3 okc_sections_b.attribute3%TYPE
201: := okc_api.g_miss_char,
202: attribute4 okc_sections_b.attribute4%TYPE
203: := okc_api.g_miss_char,
204: attribute5 okc_sections_b.attribute5%TYPE
205: := okc_api.g_miss_char,
206: attribute6 okc_sections_b.attribute6%TYPE
207: := okc_api.g_miss_char,
201: := okc_api.g_miss_char,
202: attribute4 okc_sections_b.attribute4%TYPE
203: := okc_api.g_miss_char,
204: attribute5 okc_sections_b.attribute5%TYPE
205: := okc_api.g_miss_char,
206: attribute6 okc_sections_b.attribute6%TYPE
207: := okc_api.g_miss_char,
208: attribute7 okc_sections_b.attribute7%TYPE
209: := okc_api.g_miss_char,
203: := okc_api.g_miss_char,
204: attribute5 okc_sections_b.attribute5%TYPE
205: := okc_api.g_miss_char,
206: attribute6 okc_sections_b.attribute6%TYPE
207: := okc_api.g_miss_char,
208: attribute7 okc_sections_b.attribute7%TYPE
209: := okc_api.g_miss_char,
210: attribute8 okc_sections_b.attribute8%TYPE
211: := okc_api.g_miss_char,
205: := okc_api.g_miss_char,
206: attribute6 okc_sections_b.attribute6%TYPE
207: := okc_api.g_miss_char,
208: attribute7 okc_sections_b.attribute7%TYPE
209: := okc_api.g_miss_char,
210: attribute8 okc_sections_b.attribute8%TYPE
211: := okc_api.g_miss_char,
212: attribute9 okc_sections_b.attribute9%TYPE
213: := okc_api.g_miss_char,
207: := okc_api.g_miss_char,
208: attribute7 okc_sections_b.attribute7%TYPE
209: := okc_api.g_miss_char,
210: attribute8 okc_sections_b.attribute8%TYPE
211: := okc_api.g_miss_char,
212: attribute9 okc_sections_b.attribute9%TYPE
213: := okc_api.g_miss_char,
214: attribute10 okc_sections_b.attribute10%TYPE
215: := okc_api.g_miss_char,
209: := okc_api.g_miss_char,
210: attribute8 okc_sections_b.attribute8%TYPE
211: := okc_api.g_miss_char,
212: attribute9 okc_sections_b.attribute9%TYPE
213: := okc_api.g_miss_char,
214: attribute10 okc_sections_b.attribute10%TYPE
215: := okc_api.g_miss_char,
216: attribute11 okc_sections_b.attribute11%TYPE
217: := okc_api.g_miss_char,
211: := okc_api.g_miss_char,
212: attribute9 okc_sections_b.attribute9%TYPE
213: := okc_api.g_miss_char,
214: attribute10 okc_sections_b.attribute10%TYPE
215: := okc_api.g_miss_char,
216: attribute11 okc_sections_b.attribute11%TYPE
217: := okc_api.g_miss_char,
218: attribute12 okc_sections_b.attribute12%TYPE
219: := okc_api.g_miss_char,
213: := okc_api.g_miss_char,
214: attribute10 okc_sections_b.attribute10%TYPE
215: := okc_api.g_miss_char,
216: attribute11 okc_sections_b.attribute11%TYPE
217: := okc_api.g_miss_char,
218: attribute12 okc_sections_b.attribute12%TYPE
219: := okc_api.g_miss_char,
220: attribute13 okc_sections_b.attribute13%TYPE
221: := okc_api.g_miss_char,
215: := okc_api.g_miss_char,
216: attribute11 okc_sections_b.attribute11%TYPE
217: := okc_api.g_miss_char,
218: attribute12 okc_sections_b.attribute12%TYPE
219: := okc_api.g_miss_char,
220: attribute13 okc_sections_b.attribute13%TYPE
221: := okc_api.g_miss_char,
222: attribute14 okc_sections_b.attribute14%TYPE
223: := okc_api.g_miss_char,
217: := okc_api.g_miss_char,
218: attribute12 okc_sections_b.attribute12%TYPE
219: := okc_api.g_miss_char,
220: attribute13 okc_sections_b.attribute13%TYPE
221: := okc_api.g_miss_char,
222: attribute14 okc_sections_b.attribute14%TYPE
223: := okc_api.g_miss_char,
224: attribute15 okc_sections_b.attribute15%TYPE
225: := okc_api.g_miss_char,
219: := okc_api.g_miss_char,
220: attribute13 okc_sections_b.attribute13%TYPE
221: := okc_api.g_miss_char,
222: attribute14 okc_sections_b.attribute14%TYPE
223: := okc_api.g_miss_char,
224: attribute15 okc_sections_b.attribute15%TYPE
225: := okc_api.g_miss_char,
226: security_group_id okc_sections_b.security_group_id%TYPE
227: := okc_api.g_miss_num,
221: := okc_api.g_miss_char,
222: attribute14 okc_sections_b.attribute14%TYPE
223: := okc_api.g_miss_char,
224: attribute15 okc_sections_b.attribute15%TYPE
225: := okc_api.g_miss_char,
226: security_group_id okc_sections_b.security_group_id%TYPE
227: := okc_api.g_miss_num,
228: old_id okc_sections_b.old_id%TYPE
229: := okc_api.g_miss_num,
223: := okc_api.g_miss_char,
224: attribute15 okc_sections_b.attribute15%TYPE
225: := okc_api.g_miss_char,
226: security_group_id okc_sections_b.security_group_id%TYPE
227: := okc_api.g_miss_num,
228: old_id okc_sections_b.old_id%TYPE
229: := okc_api.g_miss_num,
230: document_type okc_sections_b.document_type%TYPE
231: := okc_api.g_miss_char,
225: := okc_api.g_miss_char,
226: security_group_id okc_sections_b.security_group_id%TYPE
227: := okc_api.g_miss_num,
228: old_id okc_sections_b.old_id%TYPE
229: := okc_api.g_miss_num,
230: document_type okc_sections_b.document_type%TYPE
231: := okc_api.g_miss_char,
232: document_id okc_sections_b.document_id%TYPE
233: := okc_api.g_miss_num,
227: := okc_api.g_miss_num,
228: old_id okc_sections_b.old_id%TYPE
229: := okc_api.g_miss_num,
230: document_type okc_sections_b.document_type%TYPE
231: := okc_api.g_miss_char,
232: document_id okc_sections_b.document_id%TYPE
233: := okc_api.g_miss_num,
234: scn_code okc_sections_b.scn_code%TYPE
235: := okc_api.g_miss_char,
229: := okc_api.g_miss_num,
230: document_type okc_sections_b.document_type%TYPE
231: := okc_api.g_miss_char,
232: document_id okc_sections_b.document_id%TYPE
233: := okc_api.g_miss_num,
234: scn_code okc_sections_b.scn_code%TYPE
235: := okc_api.g_miss_char,
236: description okc_sections_b.description%TYPE
237: := okc_api.g_miss_char,
231: := okc_api.g_miss_char,
232: document_id okc_sections_b.document_id%TYPE
233: := okc_api.g_miss_num,
234: scn_code okc_sections_b.scn_code%TYPE
235: := okc_api.g_miss_char,
236: description okc_sections_b.description%TYPE
237: := okc_api.g_miss_char,
238: amendment_description okc_sections_b.amendment_description%TYPE
239: := okc_api.g_miss_char,
233: := okc_api.g_miss_num,
234: scn_code okc_sections_b.scn_code%TYPE
235: := okc_api.g_miss_char,
236: description okc_sections_b.description%TYPE
237: := okc_api.g_miss_char,
238: amendment_description okc_sections_b.amendment_description%TYPE
239: := okc_api.g_miss_char,
240: amendment_operation_code okc_sections_b.amendment_operation_code%TYPE
241: := okc_api.g_miss_char,
235: := okc_api.g_miss_char,
236: description okc_sections_b.description%TYPE
237: := okc_api.g_miss_char,
238: amendment_description okc_sections_b.amendment_description%TYPE
239: := okc_api.g_miss_char,
240: amendment_operation_code okc_sections_b.amendment_operation_code%TYPE
241: := okc_api.g_miss_char,
242: orig_system_reference_code okc_sections_b.orig_system_reference_code%TYPE
243: := okc_api.g_miss_char,
237: := okc_api.g_miss_char,
238: amendment_description okc_sections_b.amendment_description%TYPE
239: := okc_api.g_miss_char,
240: amendment_operation_code okc_sections_b.amendment_operation_code%TYPE
241: := okc_api.g_miss_char,
242: orig_system_reference_code okc_sections_b.orig_system_reference_code%TYPE
243: := okc_api.g_miss_char,
244: orig_system_reference_id1 okc_sections_b.orig_system_reference_id1%TYPE
245: := okc_api.g_miss_num,
239: := okc_api.g_miss_char,
240: amendment_operation_code okc_sections_b.amendment_operation_code%TYPE
241: := okc_api.g_miss_char,
242: orig_system_reference_code okc_sections_b.orig_system_reference_code%TYPE
243: := okc_api.g_miss_char,
244: orig_system_reference_id1 okc_sections_b.orig_system_reference_id1%TYPE
245: := okc_api.g_miss_num,
246: orig_system_reference_id2 okc_sections_b.orig_system_reference_id2%TYPE
247: := okc_api.g_miss_num,
241: := okc_api.g_miss_char,
242: orig_system_reference_code okc_sections_b.orig_system_reference_code%TYPE
243: := okc_api.g_miss_char,
244: orig_system_reference_id1 okc_sections_b.orig_system_reference_id1%TYPE
245: := okc_api.g_miss_num,
246: orig_system_reference_id2 okc_sections_b.orig_system_reference_id2%TYPE
247: := okc_api.g_miss_num,
248: print_yn okc_sections_b.print_yn%TYPE
249: := okc_api.g_miss_char,
243: := okc_api.g_miss_char,
244: orig_system_reference_id1 okc_sections_b.orig_system_reference_id1%TYPE
245: := okc_api.g_miss_num,
246: orig_system_reference_id2 okc_sections_b.orig_system_reference_id2%TYPE
247: := okc_api.g_miss_num,
248: print_yn okc_sections_b.print_yn%TYPE
249: := okc_api.g_miss_char,
250: summary_amend_operation_code okc_sections_b.summary_amend_operation_code%TYPE
251: := okc_api.g_miss_char,
245: := okc_api.g_miss_num,
246: orig_system_reference_id2 okc_sections_b.orig_system_reference_id2%TYPE
247: := okc_api.g_miss_num,
248: print_yn okc_sections_b.print_yn%TYPE
249: := okc_api.g_miss_char,
250: summary_amend_operation_code okc_sections_b.summary_amend_operation_code%TYPE
251: := okc_api.g_miss_char,
252: heading okc_sections_b.heading%TYPE
253: := okc_api.g_miss_char,
247: := okc_api.g_miss_num,
248: print_yn okc_sections_b.print_yn%TYPE
249: := okc_api.g_miss_char,
250: summary_amend_operation_code okc_sections_b.summary_amend_operation_code%TYPE
251: := okc_api.g_miss_char,
252: heading okc_sections_b.heading%TYPE
253: := okc_api.g_miss_char,
254: last_amended_by okc_sections_b.last_amended_by%TYPE
255: := okc_api.g_miss_num,
249: := okc_api.g_miss_char,
250: summary_amend_operation_code okc_sections_b.summary_amend_operation_code%TYPE
251: := okc_api.g_miss_char,
252: heading okc_sections_b.heading%TYPE
253: := okc_api.g_miss_char,
254: last_amended_by okc_sections_b.last_amended_by%TYPE
255: := okc_api.g_miss_num,
256: last_amendment_date okc_sections_b.last_amendment_date%TYPE
257: := okc_api.g_miss_date,
251: := okc_api.g_miss_char,
252: heading okc_sections_b.heading%TYPE
253: := okc_api.g_miss_char,
254: last_amended_by okc_sections_b.last_amended_by%TYPE
255: := okc_api.g_miss_num,
256: last_amendment_date okc_sections_b.last_amendment_date%TYPE
257: := okc_api.g_miss_date,
258: status VARCHAR2 (1),
259: errmsg VARCHAR2 (2500)
253: := okc_api.g_miss_char,
254: last_amended_by okc_sections_b.last_amended_by%TYPE
255: := okc_api.g_miss_num,
256: last_amendment_date okc_sections_b.last_amendment_date%TYPE
257: := okc_api.g_miss_date,
258: status VARCHAR2 (1),
259: errmsg VARCHAR2 (2500)
260: );
261:
263: INDEX BY PLS_INTEGER;
264:
265: TYPE k_article_rec_type IS RECORD (
266: ID okc_k_articles_b.ID%TYPE
267: := okc_api.g_miss_num,
268: sav_sae_id okc_k_articles_b.sav_sae_id%TYPE
269: := okc_api.g_miss_num,
270: sav_sav_release okc_k_articles_b.sav_sav_release%TYPE
271: := okc_api.g_miss_char,
265: TYPE k_article_rec_type IS RECORD (
266: ID okc_k_articles_b.ID%TYPE
267: := okc_api.g_miss_num,
268: sav_sae_id okc_k_articles_b.sav_sae_id%TYPE
269: := okc_api.g_miss_num,
270: sav_sav_release okc_k_articles_b.sav_sav_release%TYPE
271: := okc_api.g_miss_char,
272: sbt_code okc_k_articles_b.sbt_code%TYPE
273: := okc_api.g_miss_char,
267: := okc_api.g_miss_num,
268: sav_sae_id okc_k_articles_b.sav_sae_id%TYPE
269: := okc_api.g_miss_num,
270: sav_sav_release okc_k_articles_b.sav_sav_release%TYPE
271: := okc_api.g_miss_char,
272: sbt_code okc_k_articles_b.sbt_code%TYPE
273: := okc_api.g_miss_char,
274: cat_type okc_k_articles_b.cat_type%TYPE
275: := okc_api.g_miss_char,
269: := okc_api.g_miss_num,
270: sav_sav_release okc_k_articles_b.sav_sav_release%TYPE
271: := okc_api.g_miss_char,
272: sbt_code okc_k_articles_b.sbt_code%TYPE
273: := okc_api.g_miss_char,
274: cat_type okc_k_articles_b.cat_type%TYPE
275: := okc_api.g_miss_char,
276: chr_id okc_k_articles_b.chr_id%TYPE
277: := okc_api.g_miss_num,
271: := okc_api.g_miss_char,
272: sbt_code okc_k_articles_b.sbt_code%TYPE
273: := okc_api.g_miss_char,
274: cat_type okc_k_articles_b.cat_type%TYPE
275: := okc_api.g_miss_char,
276: chr_id okc_k_articles_b.chr_id%TYPE
277: := okc_api.g_miss_num,
278: cle_id okc_k_articles_b.cle_id%TYPE
279: := okc_api.g_miss_num,
273: := okc_api.g_miss_char,
274: cat_type okc_k_articles_b.cat_type%TYPE
275: := okc_api.g_miss_char,
276: chr_id okc_k_articles_b.chr_id%TYPE
277: := okc_api.g_miss_num,
278: cle_id okc_k_articles_b.cle_id%TYPE
279: := okc_api.g_miss_num,
280: cat_id okc_k_articles_b.cat_id%TYPE
281: := okc_api.g_miss_num,
275: := okc_api.g_miss_char,
276: chr_id okc_k_articles_b.chr_id%TYPE
277: := okc_api.g_miss_num,
278: cle_id okc_k_articles_b.cle_id%TYPE
279: := okc_api.g_miss_num,
280: cat_id okc_k_articles_b.cat_id%TYPE
281: := okc_api.g_miss_num,
282: dnz_chr_id okc_k_articles_b.dnz_chr_id%TYPE
283: := okc_api.g_miss_num,
277: := okc_api.g_miss_num,
278: cle_id okc_k_articles_b.cle_id%TYPE
279: := okc_api.g_miss_num,
280: cat_id okc_k_articles_b.cat_id%TYPE
281: := okc_api.g_miss_num,
282: dnz_chr_id okc_k_articles_b.dnz_chr_id%TYPE
283: := okc_api.g_miss_num,
284: object_version_number NUMBER := okc_api.g_miss_num,
285: created_by NUMBER := okc_api.g_miss_num,
279: := okc_api.g_miss_num,
280: cat_id okc_k_articles_b.cat_id%TYPE
281: := okc_api.g_miss_num,
282: dnz_chr_id okc_k_articles_b.dnz_chr_id%TYPE
283: := okc_api.g_miss_num,
284: object_version_number NUMBER := okc_api.g_miss_num,
285: created_by NUMBER := okc_api.g_miss_num,
286: creation_date okc_k_articles_b.creation_date%TYPE
287: := okc_api.g_miss_date,
280: cat_id okc_k_articles_b.cat_id%TYPE
281: := okc_api.g_miss_num,
282: dnz_chr_id okc_k_articles_b.dnz_chr_id%TYPE
283: := okc_api.g_miss_num,
284: object_version_number NUMBER := okc_api.g_miss_num,
285: created_by NUMBER := okc_api.g_miss_num,
286: creation_date okc_k_articles_b.creation_date%TYPE
287: := okc_api.g_miss_date,
288: last_updated_by NUMBER := okc_api.g_miss_num,
281: := okc_api.g_miss_num,
282: dnz_chr_id okc_k_articles_b.dnz_chr_id%TYPE
283: := okc_api.g_miss_num,
284: object_version_number NUMBER := okc_api.g_miss_num,
285: created_by NUMBER := okc_api.g_miss_num,
286: creation_date okc_k_articles_b.creation_date%TYPE
287: := okc_api.g_miss_date,
288: last_updated_by NUMBER := okc_api.g_miss_num,
289: last_update_date okc_k_articles_b.last_update_date%TYPE
283: := okc_api.g_miss_num,
284: object_version_number NUMBER := okc_api.g_miss_num,
285: created_by NUMBER := okc_api.g_miss_num,
286: creation_date okc_k_articles_b.creation_date%TYPE
287: := okc_api.g_miss_date,
288: last_updated_by NUMBER := okc_api.g_miss_num,
289: last_update_date okc_k_articles_b.last_update_date%TYPE
290: := okc_api.g_miss_date,
291: fulltext_yn okc_k_articles_b.fulltext_yn%TYPE
284: object_version_number NUMBER := okc_api.g_miss_num,
285: created_by NUMBER := okc_api.g_miss_num,
286: creation_date okc_k_articles_b.creation_date%TYPE
287: := okc_api.g_miss_date,
288: last_updated_by NUMBER := okc_api.g_miss_num,
289: last_update_date okc_k_articles_b.last_update_date%TYPE
290: := okc_api.g_miss_date,
291: fulltext_yn okc_k_articles_b.fulltext_yn%TYPE
292: := okc_api.g_miss_char,
286: creation_date okc_k_articles_b.creation_date%TYPE
287: := okc_api.g_miss_date,
288: last_updated_by NUMBER := okc_api.g_miss_num,
289: last_update_date okc_k_articles_b.last_update_date%TYPE
290: := okc_api.g_miss_date,
291: fulltext_yn okc_k_articles_b.fulltext_yn%TYPE
292: := okc_api.g_miss_char,
293: last_update_login NUMBER := okc_api.g_miss_num,
294: attribute_category okc_k_articles_b.attribute_category%TYPE
288: last_updated_by NUMBER := okc_api.g_miss_num,
289: last_update_date okc_k_articles_b.last_update_date%TYPE
290: := okc_api.g_miss_date,
291: fulltext_yn okc_k_articles_b.fulltext_yn%TYPE
292: := okc_api.g_miss_char,
293: last_update_login NUMBER := okc_api.g_miss_num,
294: attribute_category okc_k_articles_b.attribute_category%TYPE
295: := okc_api.g_miss_char,
296: attribute1 okc_k_articles_b.attribute1%TYPE
289: last_update_date okc_k_articles_b.last_update_date%TYPE
290: := okc_api.g_miss_date,
291: fulltext_yn okc_k_articles_b.fulltext_yn%TYPE
292: := okc_api.g_miss_char,
293: last_update_login NUMBER := okc_api.g_miss_num,
294: attribute_category okc_k_articles_b.attribute_category%TYPE
295: := okc_api.g_miss_char,
296: attribute1 okc_k_articles_b.attribute1%TYPE
297: := okc_api.g_miss_char,
291: fulltext_yn okc_k_articles_b.fulltext_yn%TYPE
292: := okc_api.g_miss_char,
293: last_update_login NUMBER := okc_api.g_miss_num,
294: attribute_category okc_k_articles_b.attribute_category%TYPE
295: := okc_api.g_miss_char,
296: attribute1 okc_k_articles_b.attribute1%TYPE
297: := okc_api.g_miss_char,
298: attribute2 okc_k_articles_b.attribute2%TYPE
299: := okc_api.g_miss_char,
293: last_update_login NUMBER := okc_api.g_miss_num,
294: attribute_category okc_k_articles_b.attribute_category%TYPE
295: := okc_api.g_miss_char,
296: attribute1 okc_k_articles_b.attribute1%TYPE
297: := okc_api.g_miss_char,
298: attribute2 okc_k_articles_b.attribute2%TYPE
299: := okc_api.g_miss_char,
300: attribute3 okc_k_articles_b.attribute3%TYPE
301: := okc_api.g_miss_char,
295: := okc_api.g_miss_char,
296: attribute1 okc_k_articles_b.attribute1%TYPE
297: := okc_api.g_miss_char,
298: attribute2 okc_k_articles_b.attribute2%TYPE
299: := okc_api.g_miss_char,
300: attribute3 okc_k_articles_b.attribute3%TYPE
301: := okc_api.g_miss_char,
302: attribute4 okc_k_articles_b.attribute4%TYPE
303: := okc_api.g_miss_char,
297: := okc_api.g_miss_char,
298: attribute2 okc_k_articles_b.attribute2%TYPE
299: := okc_api.g_miss_char,
300: attribute3 okc_k_articles_b.attribute3%TYPE
301: := okc_api.g_miss_char,
302: attribute4 okc_k_articles_b.attribute4%TYPE
303: := okc_api.g_miss_char,
304: attribute5 okc_k_articles_b.attribute5%TYPE
305: := okc_api.g_miss_char,
299: := okc_api.g_miss_char,
300: attribute3 okc_k_articles_b.attribute3%TYPE
301: := okc_api.g_miss_char,
302: attribute4 okc_k_articles_b.attribute4%TYPE
303: := okc_api.g_miss_char,
304: attribute5 okc_k_articles_b.attribute5%TYPE
305: := okc_api.g_miss_char,
306: attribute6 okc_k_articles_b.attribute6%TYPE
307: := okc_api.g_miss_char,
301: := okc_api.g_miss_char,
302: attribute4 okc_k_articles_b.attribute4%TYPE
303: := okc_api.g_miss_char,
304: attribute5 okc_k_articles_b.attribute5%TYPE
305: := okc_api.g_miss_char,
306: attribute6 okc_k_articles_b.attribute6%TYPE
307: := okc_api.g_miss_char,
308: attribute7 okc_k_articles_b.attribute7%TYPE
309: := okc_api.g_miss_char,
303: := okc_api.g_miss_char,
304: attribute5 okc_k_articles_b.attribute5%TYPE
305: := okc_api.g_miss_char,
306: attribute6 okc_k_articles_b.attribute6%TYPE
307: := okc_api.g_miss_char,
308: attribute7 okc_k_articles_b.attribute7%TYPE
309: := okc_api.g_miss_char,
310: attribute8 okc_k_articles_b.attribute8%TYPE
311: := okc_api.g_miss_char,
305: := okc_api.g_miss_char,
306: attribute6 okc_k_articles_b.attribute6%TYPE
307: := okc_api.g_miss_char,
308: attribute7 okc_k_articles_b.attribute7%TYPE
309: := okc_api.g_miss_char,
310: attribute8 okc_k_articles_b.attribute8%TYPE
311: := okc_api.g_miss_char,
312: attribute9 okc_k_articles_b.attribute9%TYPE
313: := okc_api.g_miss_char,
307: := okc_api.g_miss_char,
308: attribute7 okc_k_articles_b.attribute7%TYPE
309: := okc_api.g_miss_char,
310: attribute8 okc_k_articles_b.attribute8%TYPE
311: := okc_api.g_miss_char,
312: attribute9 okc_k_articles_b.attribute9%TYPE
313: := okc_api.g_miss_char,
314: attribute10 okc_k_articles_b.attribute10%TYPE
315: := okc_api.g_miss_char,
309: := okc_api.g_miss_char,
310: attribute8 okc_k_articles_b.attribute8%TYPE
311: := okc_api.g_miss_char,
312: attribute9 okc_k_articles_b.attribute9%TYPE
313: := okc_api.g_miss_char,
314: attribute10 okc_k_articles_b.attribute10%TYPE
315: := okc_api.g_miss_char,
316: attribute11 okc_k_articles_b.attribute11%TYPE
317: := okc_api.g_miss_char,
311: := okc_api.g_miss_char,
312: attribute9 okc_k_articles_b.attribute9%TYPE
313: := okc_api.g_miss_char,
314: attribute10 okc_k_articles_b.attribute10%TYPE
315: := okc_api.g_miss_char,
316: attribute11 okc_k_articles_b.attribute11%TYPE
317: := okc_api.g_miss_char,
318: attribute12 okc_k_articles_b.attribute12%TYPE
319: := okc_api.g_miss_char,
313: := okc_api.g_miss_char,
314: attribute10 okc_k_articles_b.attribute10%TYPE
315: := okc_api.g_miss_char,
316: attribute11 okc_k_articles_b.attribute11%TYPE
317: := okc_api.g_miss_char,
318: attribute12 okc_k_articles_b.attribute12%TYPE
319: := okc_api.g_miss_char,
320: attribute13 okc_k_articles_b.attribute13%TYPE
321: := okc_api.g_miss_char,
315: := okc_api.g_miss_char,
316: attribute11 okc_k_articles_b.attribute11%TYPE
317: := okc_api.g_miss_char,
318: attribute12 okc_k_articles_b.attribute12%TYPE
319: := okc_api.g_miss_char,
320: attribute13 okc_k_articles_b.attribute13%TYPE
321: := okc_api.g_miss_char,
322: attribute14 okc_k_articles_b.attribute14%TYPE
323: := okc_api.g_miss_char,
317: := okc_api.g_miss_char,
318: attribute12 okc_k_articles_b.attribute12%TYPE
319: := okc_api.g_miss_char,
320: attribute13 okc_k_articles_b.attribute13%TYPE
321: := okc_api.g_miss_char,
322: attribute14 okc_k_articles_b.attribute14%TYPE
323: := okc_api.g_miss_char,
324: attribute15 okc_k_articles_b.attribute15%TYPE
325: := okc_api.g_miss_char,
319: := okc_api.g_miss_char,
320: attribute13 okc_k_articles_b.attribute13%TYPE
321: := okc_api.g_miss_char,
322: attribute14 okc_k_articles_b.attribute14%TYPE
323: := okc_api.g_miss_char,
324: attribute15 okc_k_articles_b.attribute15%TYPE
325: := okc_api.g_miss_char,
326: security_group_id okc_k_articles_b.security_group_id%TYPE
327: := okc_api.g_miss_num,
321: := okc_api.g_miss_char,
322: attribute14 okc_k_articles_b.attribute14%TYPE
323: := okc_api.g_miss_char,
324: attribute15 okc_k_articles_b.attribute15%TYPE
325: := okc_api.g_miss_char,
326: security_group_id okc_k_articles_b.security_group_id%TYPE
327: := okc_api.g_miss_num,
328: old_id okc_k_articles_b.old_id%TYPE
329: := okc_api.g_miss_num,
323: := okc_api.g_miss_char,
324: attribute15 okc_k_articles_b.attribute15%TYPE
325: := okc_api.g_miss_char,
326: security_group_id okc_k_articles_b.security_group_id%TYPE
327: := okc_api.g_miss_num,
328: old_id okc_k_articles_b.old_id%TYPE
329: := okc_api.g_miss_num,
330: document_type okc_k_articles_b.document_type%TYPE
331: := okc_api.g_miss_char,
325: := okc_api.g_miss_char,
326: security_group_id okc_k_articles_b.security_group_id%TYPE
327: := okc_api.g_miss_num,
328: old_id okc_k_articles_b.old_id%TYPE
329: := okc_api.g_miss_num,
330: document_type okc_k_articles_b.document_type%TYPE
331: := okc_api.g_miss_char,
332: document_id okc_k_articles_b.document_id%TYPE
333: := okc_api.g_miss_num,
327: := okc_api.g_miss_num,
328: old_id okc_k_articles_b.old_id%TYPE
329: := okc_api.g_miss_num,
330: document_type okc_k_articles_b.document_type%TYPE
331: := okc_api.g_miss_char,
332: document_id okc_k_articles_b.document_id%TYPE
333: := okc_api.g_miss_num,
334: source_flag okc_k_articles_b.source_flag%TYPE
335: := okc_api.g_miss_char,
329: := okc_api.g_miss_num,
330: document_type okc_k_articles_b.document_type%TYPE
331: := okc_api.g_miss_char,
332: document_id okc_k_articles_b.document_id%TYPE
333: := okc_api.g_miss_num,
334: source_flag okc_k_articles_b.source_flag%TYPE
335: := okc_api.g_miss_char,
336: mandatory_yn okc_k_articles_b.mandatory_yn%TYPE
337: := okc_api.g_miss_char,
331: := okc_api.g_miss_char,
332: document_id okc_k_articles_b.document_id%TYPE
333: := okc_api.g_miss_num,
334: source_flag okc_k_articles_b.source_flag%TYPE
335: := okc_api.g_miss_char,
336: mandatory_yn okc_k_articles_b.mandatory_yn%TYPE
337: := okc_api.g_miss_char,
338: scn_id okc_k_articles_b.scn_id%TYPE
339: := okc_api.g_miss_num,
333: := okc_api.g_miss_num,
334: source_flag okc_k_articles_b.source_flag%TYPE
335: := okc_api.g_miss_char,
336: mandatory_yn okc_k_articles_b.mandatory_yn%TYPE
337: := okc_api.g_miss_char,
338: scn_id okc_k_articles_b.scn_id%TYPE
339: := okc_api.g_miss_num,
340: label okc_k_articles_b.label%TYPE
341: := okc_api.g_miss_char,
335: := okc_api.g_miss_char,
336: mandatory_yn okc_k_articles_b.mandatory_yn%TYPE
337: := okc_api.g_miss_char,
338: scn_id okc_k_articles_b.scn_id%TYPE
339: := okc_api.g_miss_num,
340: label okc_k_articles_b.label%TYPE
341: := okc_api.g_miss_char,
342: display_sequence okc_k_articles_b.display_sequence%TYPE
343: := okc_api.g_miss_num,
337: := okc_api.g_miss_char,
338: scn_id okc_k_articles_b.scn_id%TYPE
339: := okc_api.g_miss_num,
340: label okc_k_articles_b.label%TYPE
341: := okc_api.g_miss_char,
342: display_sequence okc_k_articles_b.display_sequence%TYPE
343: := okc_api.g_miss_num,
344: amendment_description okc_k_articles_b.amendment_description%TYPE
345: := okc_api.g_miss_char,
339: := okc_api.g_miss_num,
340: label okc_k_articles_b.label%TYPE
341: := okc_api.g_miss_char,
342: display_sequence okc_k_articles_b.display_sequence%TYPE
343: := okc_api.g_miss_num,
344: amendment_description okc_k_articles_b.amendment_description%TYPE
345: := okc_api.g_miss_char,
346: article_version_id okc_k_articles_b.article_version_id%TYPE
347: := okc_api.g_miss_num,
341: := okc_api.g_miss_char,
342: display_sequence okc_k_articles_b.display_sequence%TYPE
343: := okc_api.g_miss_num,
344: amendment_description okc_k_articles_b.amendment_description%TYPE
345: := okc_api.g_miss_char,
346: article_version_id okc_k_articles_b.article_version_id%TYPE
347: := okc_api.g_miss_num,
348: orig_system_reference_code okc_k_articles_b.orig_system_reference_code%TYPE
349: := okc_api.g_miss_char,
343: := okc_api.g_miss_num,
344: amendment_description okc_k_articles_b.amendment_description%TYPE
345: := okc_api.g_miss_char,
346: article_version_id okc_k_articles_b.article_version_id%TYPE
347: := okc_api.g_miss_num,
348: orig_system_reference_code okc_k_articles_b.orig_system_reference_code%TYPE
349: := okc_api.g_miss_char,
350: orig_system_reference_id1 okc_k_articles_b.orig_system_reference_id1%TYPE
351: := okc_api.g_miss_num,
345: := okc_api.g_miss_char,
346: article_version_id okc_k_articles_b.article_version_id%TYPE
347: := okc_api.g_miss_num,
348: orig_system_reference_code okc_k_articles_b.orig_system_reference_code%TYPE
349: := okc_api.g_miss_char,
350: orig_system_reference_id1 okc_k_articles_b.orig_system_reference_id1%TYPE
351: := okc_api.g_miss_num,
352: orig_system_reference_id2 okc_k_articles_b.orig_system_reference_id2%TYPE
353: := okc_api.g_miss_num,
347: := okc_api.g_miss_num,
348: orig_system_reference_code okc_k_articles_b.orig_system_reference_code%TYPE
349: := okc_api.g_miss_char,
350: orig_system_reference_id1 okc_k_articles_b.orig_system_reference_id1%TYPE
351: := okc_api.g_miss_num,
352: orig_system_reference_id2 okc_k_articles_b.orig_system_reference_id2%TYPE
353: := okc_api.g_miss_num,
354: amendment_operation_code okc_k_articles_b.amendment_operation_code%TYPE
355: := okc_api.g_miss_char,
349: := okc_api.g_miss_char,
350: orig_system_reference_id1 okc_k_articles_b.orig_system_reference_id1%TYPE
351: := okc_api.g_miss_num,
352: orig_system_reference_id2 okc_k_articles_b.orig_system_reference_id2%TYPE
353: := okc_api.g_miss_num,
354: amendment_operation_code okc_k_articles_b.amendment_operation_code%TYPE
355: := okc_api.g_miss_char,
356: summary_amend_operation_code okc_k_articles_b.summary_amend_operation_code%TYPE
357: := okc_api.g_miss_char,
351: := okc_api.g_miss_num,
352: orig_system_reference_id2 okc_k_articles_b.orig_system_reference_id2%TYPE
353: := okc_api.g_miss_num,
354: amendment_operation_code okc_k_articles_b.amendment_operation_code%TYPE
355: := okc_api.g_miss_char,
356: summary_amend_operation_code okc_k_articles_b.summary_amend_operation_code%TYPE
357: := okc_api.g_miss_char,
358: change_nonstd_yn okc_k_articles_b.change_nonstd_yn%TYPE
359: := okc_api.g_miss_char,
353: := okc_api.g_miss_num,
354: amendment_operation_code okc_k_articles_b.amendment_operation_code%TYPE
355: := okc_api.g_miss_char,
356: summary_amend_operation_code okc_k_articles_b.summary_amend_operation_code%TYPE
357: := okc_api.g_miss_char,
358: change_nonstd_yn okc_k_articles_b.change_nonstd_yn%TYPE
359: := okc_api.g_miss_char,
360: print_text_yn okc_k_articles_b.print_text_yn%TYPE
361: := okc_api.g_miss_char,
355: := okc_api.g_miss_char,
356: summary_amend_operation_code okc_k_articles_b.summary_amend_operation_code%TYPE
357: := okc_api.g_miss_char,
358: change_nonstd_yn okc_k_articles_b.change_nonstd_yn%TYPE
359: := okc_api.g_miss_char,
360: print_text_yn okc_k_articles_b.print_text_yn%TYPE
361: := okc_api.g_miss_char,
362: ref_article_id okc_k_articles_b.ref_article_id%TYPE
363: := okc_api.g_miss_num,
357: := okc_api.g_miss_char,
358: change_nonstd_yn okc_k_articles_b.change_nonstd_yn%TYPE
359: := okc_api.g_miss_char,
360: print_text_yn okc_k_articles_b.print_text_yn%TYPE
361: := okc_api.g_miss_char,
362: ref_article_id okc_k_articles_b.ref_article_id%TYPE
363: := okc_api.g_miss_num,
364: ref_article_version_id okc_k_articles_b.ref_article_version_id%TYPE
365: := okc_api.g_miss_num,
359: := okc_api.g_miss_char,
360: print_text_yn okc_k_articles_b.print_text_yn%TYPE
361: := okc_api.g_miss_char,
362: ref_article_id okc_k_articles_b.ref_article_id%TYPE
363: := okc_api.g_miss_num,
364: ref_article_version_id okc_k_articles_b.ref_article_version_id%TYPE
365: := okc_api.g_miss_num,
366: orig_article_id okc_k_articles_b.orig_article_id%TYPE
367: := okc_api.g_miss_num,
361: := okc_api.g_miss_char,
362: ref_article_id okc_k_articles_b.ref_article_id%TYPE
363: := okc_api.g_miss_num,
364: ref_article_version_id okc_k_articles_b.ref_article_version_id%TYPE
365: := okc_api.g_miss_num,
366: orig_article_id okc_k_articles_b.orig_article_id%TYPE
367: := okc_api.g_miss_num,
368: last_amended_by okc_k_articles_b.last_amended_by%TYPE
369: := okc_api.g_miss_num,
363: := okc_api.g_miss_num,
364: ref_article_version_id okc_k_articles_b.ref_article_version_id%TYPE
365: := okc_api.g_miss_num,
366: orig_article_id okc_k_articles_b.orig_article_id%TYPE
367: := okc_api.g_miss_num,
368: last_amended_by okc_k_articles_b.last_amended_by%TYPE
369: := okc_api.g_miss_num,
370: last_amendment_date okc_k_articles_b.last_amendment_date%TYPE
371: := okc_api.g_miss_date,
365: := okc_api.g_miss_num,
366: orig_article_id okc_k_articles_b.orig_article_id%TYPE
367: := okc_api.g_miss_num,
368: last_amended_by okc_k_articles_b.last_amended_by%TYPE
369: := okc_api.g_miss_num,
370: last_amendment_date okc_k_articles_b.last_amendment_date%TYPE
371: := okc_api.g_miss_date,
372: mandatory_rwa okc_k_articles_b.mandatory_rwa%TYPE
373: := okc_api.g_miss_char,
367: := okc_api.g_miss_num,
368: last_amended_by okc_k_articles_b.last_amended_by%TYPE
369: := okc_api.g_miss_num,
370: last_amendment_date okc_k_articles_b.last_amendment_date%TYPE
371: := okc_api.g_miss_date,
372: mandatory_rwa okc_k_articles_b.mandatory_rwa%TYPE
373: := okc_api.g_miss_char,
374: status VARCHAR2 (1),
375: errmsg VARCHAR2 (2500)
369: := okc_api.g_miss_num,
370: last_amendment_date okc_k_articles_b.last_amendment_date%TYPE
371: := okc_api.g_miss_date,
372: mandatory_rwa okc_k_articles_b.mandatory_rwa%TYPE
373: := okc_api.g_miss_char,
374: status VARCHAR2 (1),
375: errmsg VARCHAR2 (2500)
376: );
377:
379: INDEX BY PLS_INTEGER;
380:
381: TYPE deliverable_rec_type IS RECORD (
382: deliverable_id okc_deliverables.deliverable_id%TYPE
383: := okc_api.g_miss_num,
384: business_document_type okc_deliverables.business_document_type%TYPE
385: := okc_api.g_miss_char,
386: business_document_id okc_deliverables.business_document_id%TYPE
387: := okc_api.g_miss_num,
381: TYPE deliverable_rec_type IS RECORD (
382: deliverable_id okc_deliverables.deliverable_id%TYPE
383: := okc_api.g_miss_num,
384: business_document_type okc_deliverables.business_document_type%TYPE
385: := okc_api.g_miss_char,
386: business_document_id okc_deliverables.business_document_id%TYPE
387: := okc_api.g_miss_num,
388: business_document_number okc_deliverables.business_document_number%TYPE
389: := okc_api.g_miss_char,
383: := okc_api.g_miss_num,
384: business_document_type okc_deliverables.business_document_type%TYPE
385: := okc_api.g_miss_char,
386: business_document_id okc_deliverables.business_document_id%TYPE
387: := okc_api.g_miss_num,
388: business_document_number okc_deliverables.business_document_number%TYPE
389: := okc_api.g_miss_char,
390: deliverable_type okc_deliverables.deliverable_type%TYPE
391: := okc_api.g_miss_char,
385: := okc_api.g_miss_char,
386: business_document_id okc_deliverables.business_document_id%TYPE
387: := okc_api.g_miss_num,
388: business_document_number okc_deliverables.business_document_number%TYPE
389: := okc_api.g_miss_char,
390: deliverable_type okc_deliverables.deliverable_type%TYPE
391: := okc_api.g_miss_char,
392: responsible_party okc_deliverables.responsible_party%TYPE
393: := okc_api.g_miss_char,
387: := okc_api.g_miss_num,
388: business_document_number okc_deliverables.business_document_number%TYPE
389: := okc_api.g_miss_char,
390: deliverable_type okc_deliverables.deliverable_type%TYPE
391: := okc_api.g_miss_char,
392: responsible_party okc_deliverables.responsible_party%TYPE
393: := okc_api.g_miss_char,
394: internal_party_contact_id okc_deliverables.internal_party_contact_id%TYPE
395: := okc_api.g_miss_num,
389: := okc_api.g_miss_char,
390: deliverable_type okc_deliverables.deliverable_type%TYPE
391: := okc_api.g_miss_char,
392: responsible_party okc_deliverables.responsible_party%TYPE
393: := okc_api.g_miss_char,
394: internal_party_contact_id okc_deliverables.internal_party_contact_id%TYPE
395: := okc_api.g_miss_num,
396: external_party_contact_id okc_deliverables.external_party_contact_id%TYPE
397: := okc_api.g_miss_num,
391: := okc_api.g_miss_char,
392: responsible_party okc_deliverables.responsible_party%TYPE
393: := okc_api.g_miss_char,
394: internal_party_contact_id okc_deliverables.internal_party_contact_id%TYPE
395: := okc_api.g_miss_num,
396: external_party_contact_id okc_deliverables.external_party_contact_id%TYPE
397: := okc_api.g_miss_num,
398: deliverable_name okc_deliverables.deliverable_name%TYPE
399: := okc_api.g_miss_char,
393: := okc_api.g_miss_char,
394: internal_party_contact_id okc_deliverables.internal_party_contact_id%TYPE
395: := okc_api.g_miss_num,
396: external_party_contact_id okc_deliverables.external_party_contact_id%TYPE
397: := okc_api.g_miss_num,
398: deliverable_name okc_deliverables.deliverable_name%TYPE
399: := okc_api.g_miss_char,
400: description okc_deliverables.description%TYPE
401: := okc_api.g_miss_char,
395: := okc_api.g_miss_num,
396: external_party_contact_id okc_deliverables.external_party_contact_id%TYPE
397: := okc_api.g_miss_num,
398: deliverable_name okc_deliverables.deliverable_name%TYPE
399: := okc_api.g_miss_char,
400: description okc_deliverables.description%TYPE
401: := okc_api.g_miss_char,
402: comments okc_deliverables.comments%TYPE
403: := okc_api.g_miss_char,
397: := okc_api.g_miss_num,
398: deliverable_name okc_deliverables.deliverable_name%TYPE
399: := okc_api.g_miss_char,
400: description okc_deliverables.description%TYPE
401: := okc_api.g_miss_char,
402: comments okc_deliverables.comments%TYPE
403: := okc_api.g_miss_char,
404: display_sequence okc_deliverables.display_sequence%TYPE
405: := okc_api.g_miss_num,
399: := okc_api.g_miss_char,
400: description okc_deliverables.description%TYPE
401: := okc_api.g_miss_char,
402: comments okc_deliverables.comments%TYPE
403: := okc_api.g_miss_char,
404: display_sequence okc_deliverables.display_sequence%TYPE
405: := okc_api.g_miss_num,
406: fixed_due_date_yn okc_deliverables.fixed_due_date_yn%TYPE
407: := okc_api.g_miss_char,
401: := okc_api.g_miss_char,
402: comments okc_deliverables.comments%TYPE
403: := okc_api.g_miss_char,
404: display_sequence okc_deliverables.display_sequence%TYPE
405: := okc_api.g_miss_num,
406: fixed_due_date_yn okc_deliverables.fixed_due_date_yn%TYPE
407: := okc_api.g_miss_char,
408: actual_due_date okc_deliverables.actual_due_date%TYPE
409: := okc_api.g_miss_date,
403: := okc_api.g_miss_char,
404: display_sequence okc_deliverables.display_sequence%TYPE
405: := okc_api.g_miss_num,
406: fixed_due_date_yn okc_deliverables.fixed_due_date_yn%TYPE
407: := okc_api.g_miss_char,
408: actual_due_date okc_deliverables.actual_due_date%TYPE
409: := okc_api.g_miss_date,
410: print_due_date_msg_name okc_deliverables.print_due_date_msg_name%TYPE
411: := okc_api.g_miss_char,
405: := okc_api.g_miss_num,
406: fixed_due_date_yn okc_deliverables.fixed_due_date_yn%TYPE
407: := okc_api.g_miss_char,
408: actual_due_date okc_deliverables.actual_due_date%TYPE
409: := okc_api.g_miss_date,
410: print_due_date_msg_name okc_deliverables.print_due_date_msg_name%TYPE
411: := okc_api.g_miss_char,
412: recurring_yn okc_deliverables.recurring_yn%TYPE
413: := okc_api.g_miss_char,
407: := okc_api.g_miss_char,
408: actual_due_date okc_deliverables.actual_due_date%TYPE
409: := okc_api.g_miss_date,
410: print_due_date_msg_name okc_deliverables.print_due_date_msg_name%TYPE
411: := okc_api.g_miss_char,
412: recurring_yn okc_deliverables.recurring_yn%TYPE
413: := okc_api.g_miss_char,
414: notify_prior_due_date_value okc_deliverables.notify_prior_due_date_value%TYPE
415: := okc_api.g_miss_num,
409: := okc_api.g_miss_date,
410: print_due_date_msg_name okc_deliverables.print_due_date_msg_name%TYPE
411: := okc_api.g_miss_char,
412: recurring_yn okc_deliverables.recurring_yn%TYPE
413: := okc_api.g_miss_char,
414: notify_prior_due_date_value okc_deliverables.notify_prior_due_date_value%TYPE
415: := okc_api.g_miss_num,
416: notify_prior_due_date_uom okc_deliverables.notify_prior_due_date_uom%TYPE
417: := okc_api.g_miss_char,
411: := okc_api.g_miss_char,
412: recurring_yn okc_deliverables.recurring_yn%TYPE
413: := okc_api.g_miss_char,
414: notify_prior_due_date_value okc_deliverables.notify_prior_due_date_value%TYPE
415: := okc_api.g_miss_num,
416: notify_prior_due_date_uom okc_deliverables.notify_prior_due_date_uom%TYPE
417: := okc_api.g_miss_char,
418: notify_prior_due_date_yn okc_deliverables.notify_prior_due_date_yn%TYPE
419: := okc_api.g_miss_char,
413: := okc_api.g_miss_char,
414: notify_prior_due_date_value okc_deliverables.notify_prior_due_date_value%TYPE
415: := okc_api.g_miss_num,
416: notify_prior_due_date_uom okc_deliverables.notify_prior_due_date_uom%TYPE
417: := okc_api.g_miss_char,
418: notify_prior_due_date_yn okc_deliverables.notify_prior_due_date_yn%TYPE
419: := okc_api.g_miss_char,
420: notify_completed_yn okc_deliverables.notify_completed_yn%TYPE
421: := okc_api.g_miss_char,
415: := okc_api.g_miss_num,
416: notify_prior_due_date_uom okc_deliverables.notify_prior_due_date_uom%TYPE
417: := okc_api.g_miss_char,
418: notify_prior_due_date_yn okc_deliverables.notify_prior_due_date_yn%TYPE
419: := okc_api.g_miss_char,
420: notify_completed_yn okc_deliverables.notify_completed_yn%TYPE
421: := okc_api.g_miss_char,
422: notify_overdue_yn okc_deliverables.notify_overdue_yn%TYPE
423: := okc_api.g_miss_char,
417: := okc_api.g_miss_char,
418: notify_prior_due_date_yn okc_deliverables.notify_prior_due_date_yn%TYPE
419: := okc_api.g_miss_char,
420: notify_completed_yn okc_deliverables.notify_completed_yn%TYPE
421: := okc_api.g_miss_char,
422: notify_overdue_yn okc_deliverables.notify_overdue_yn%TYPE
423: := okc_api.g_miss_char,
424: notify_escalation_yn okc_deliverables.notify_escalation_yn%TYPE
425: := okc_api.g_miss_char,
419: := okc_api.g_miss_char,
420: notify_completed_yn okc_deliverables.notify_completed_yn%TYPE
421: := okc_api.g_miss_char,
422: notify_overdue_yn okc_deliverables.notify_overdue_yn%TYPE
423: := okc_api.g_miss_char,
424: notify_escalation_yn okc_deliverables.notify_escalation_yn%TYPE
425: := okc_api.g_miss_char,
426: notify_escalation_value okc_deliverables.notify_escalation_value%TYPE
427: := okc_api.g_miss_num,
421: := okc_api.g_miss_char,
422: notify_overdue_yn okc_deliverables.notify_overdue_yn%TYPE
423: := okc_api.g_miss_char,
424: notify_escalation_yn okc_deliverables.notify_escalation_yn%TYPE
425: := okc_api.g_miss_char,
426: notify_escalation_value okc_deliverables.notify_escalation_value%TYPE
427: := okc_api.g_miss_num,
428: notify_escalation_uom okc_deliverables.notify_escalation_uom%TYPE
429: := okc_api.g_miss_char,
423: := okc_api.g_miss_char,
424: notify_escalation_yn okc_deliverables.notify_escalation_yn%TYPE
425: := okc_api.g_miss_char,
426: notify_escalation_value okc_deliverables.notify_escalation_value%TYPE
427: := okc_api.g_miss_num,
428: notify_escalation_uom okc_deliverables.notify_escalation_uom%TYPE
429: := okc_api.g_miss_char,
430: escalation_assignee okc_deliverables.escalation_assignee%TYPE
431: := okc_api.g_miss_num,
425: := okc_api.g_miss_char,
426: notify_escalation_value okc_deliverables.notify_escalation_value%TYPE
427: := okc_api.g_miss_num,
428: notify_escalation_uom okc_deliverables.notify_escalation_uom%TYPE
429: := okc_api.g_miss_char,
430: escalation_assignee okc_deliverables.escalation_assignee%TYPE
431: := okc_api.g_miss_num,
432: amendment_operation okc_deliverables.amendment_operation%TYPE
433: := okc_api.g_miss_char,
427: := okc_api.g_miss_num,
428: notify_escalation_uom okc_deliverables.notify_escalation_uom%TYPE
429: := okc_api.g_miss_char,
430: escalation_assignee okc_deliverables.escalation_assignee%TYPE
431: := okc_api.g_miss_num,
432: amendment_operation okc_deliverables.amendment_operation%TYPE
433: := okc_api.g_miss_char,
434: prior_notification_id okc_deliverables.prior_notification_id%TYPE
435: := okc_api.g_miss_num,
429: := okc_api.g_miss_char,
430: escalation_assignee okc_deliverables.escalation_assignee%TYPE
431: := okc_api.g_miss_num,
432: amendment_operation okc_deliverables.amendment_operation%TYPE
433: := okc_api.g_miss_char,
434: prior_notification_id okc_deliverables.prior_notification_id%TYPE
435: := okc_api.g_miss_num,
436: amendment_notes okc_deliverables.amendment_notes%TYPE
437: := okc_api.g_miss_char,
431: := okc_api.g_miss_num,
432: amendment_operation okc_deliverables.amendment_operation%TYPE
433: := okc_api.g_miss_char,
434: prior_notification_id okc_deliverables.prior_notification_id%TYPE
435: := okc_api.g_miss_num,
436: amendment_notes okc_deliverables.amendment_notes%TYPE
437: := okc_api.g_miss_char,
438: completed_notification_id okc_deliverables.completed_notification_id%TYPE
439: := okc_api.g_miss_num,
433: := okc_api.g_miss_char,
434: prior_notification_id okc_deliverables.prior_notification_id%TYPE
435: := okc_api.g_miss_num,
436: amendment_notes okc_deliverables.amendment_notes%TYPE
437: := okc_api.g_miss_char,
438: completed_notification_id okc_deliverables.completed_notification_id%TYPE
439: := okc_api.g_miss_num,
440: overdue_notification_id okc_deliverables.overdue_notification_id%TYPE
441: := okc_api.g_miss_num,
435: := okc_api.g_miss_num,
436: amendment_notes okc_deliverables.amendment_notes%TYPE
437: := okc_api.g_miss_char,
438: completed_notification_id okc_deliverables.completed_notification_id%TYPE
439: := okc_api.g_miss_num,
440: overdue_notification_id okc_deliverables.overdue_notification_id%TYPE
441: := okc_api.g_miss_num,
442: escalation_notification_id okc_deliverables.escalation_notification_id%TYPE
443: := okc_api.g_miss_num,
437: := okc_api.g_miss_char,
438: completed_notification_id okc_deliverables.completed_notification_id%TYPE
439: := okc_api.g_miss_num,
440: overdue_notification_id okc_deliverables.overdue_notification_id%TYPE
441: := okc_api.g_miss_num,
442: escalation_notification_id okc_deliverables.escalation_notification_id%TYPE
443: := okc_api.g_miss_num,
444: LANGUAGE okc_deliverables.LANGUAGE%TYPE
445: := okc_api.g_miss_char,
439: := okc_api.g_miss_num,
440: overdue_notification_id okc_deliverables.overdue_notification_id%TYPE
441: := okc_api.g_miss_num,
442: escalation_notification_id okc_deliverables.escalation_notification_id%TYPE
443: := okc_api.g_miss_num,
444: LANGUAGE okc_deliverables.LANGUAGE%TYPE
445: := okc_api.g_miss_char,
446: original_deliverable_id okc_deliverables.original_deliverable_id%TYPE
447: := okc_api.g_miss_num,
441: := okc_api.g_miss_num,
442: escalation_notification_id okc_deliverables.escalation_notification_id%TYPE
443: := okc_api.g_miss_num,
444: LANGUAGE okc_deliverables.LANGUAGE%TYPE
445: := okc_api.g_miss_char,
446: original_deliverable_id okc_deliverables.original_deliverable_id%TYPE
447: := okc_api.g_miss_num,
448: requester_id okc_deliverables.requester_id%TYPE
449: := okc_api.g_miss_num,
443: := okc_api.g_miss_num,
444: LANGUAGE okc_deliverables.LANGUAGE%TYPE
445: := okc_api.g_miss_char,
446: original_deliverable_id okc_deliverables.original_deliverable_id%TYPE
447: := okc_api.g_miss_num,
448: requester_id okc_deliverables.requester_id%TYPE
449: := okc_api.g_miss_num,
450: external_party_id okc_deliverables.external_party_id%TYPE
451: := okc_api.g_miss_num,
445: := okc_api.g_miss_char,
446: original_deliverable_id okc_deliverables.original_deliverable_id%TYPE
447: := okc_api.g_miss_num,
448: requester_id okc_deliverables.requester_id%TYPE
449: := okc_api.g_miss_num,
450: external_party_id okc_deliverables.external_party_id%TYPE
451: := okc_api.g_miss_num,
452: recurring_del_parent_id okc_deliverables.recurring_del_parent_id%TYPE
453: := okc_api.g_miss_num,
447: := okc_api.g_miss_num,
448: requester_id okc_deliverables.requester_id%TYPE
449: := okc_api.g_miss_num,
450: external_party_id okc_deliverables.external_party_id%TYPE
451: := okc_api.g_miss_num,
452: recurring_del_parent_id okc_deliverables.recurring_del_parent_id%TYPE
453: := okc_api.g_miss_num,
454: business_document_version okc_deliverables.business_document_version%TYPE
455: := okc_api.g_miss_num,
449: := okc_api.g_miss_num,
450: external_party_id okc_deliverables.external_party_id%TYPE
451: := okc_api.g_miss_num,
452: recurring_del_parent_id okc_deliverables.recurring_del_parent_id%TYPE
453: := okc_api.g_miss_num,
454: business_document_version okc_deliverables.business_document_version%TYPE
455: := okc_api.g_miss_num,
456: relative_st_date_duration okc_deliverables.relative_st_date_duration%TYPE
457: := okc_api.g_miss_num,
451: := okc_api.g_miss_num,
452: recurring_del_parent_id okc_deliverables.recurring_del_parent_id%TYPE
453: := okc_api.g_miss_num,
454: business_document_version okc_deliverables.business_document_version%TYPE
455: := okc_api.g_miss_num,
456: relative_st_date_duration okc_deliverables.relative_st_date_duration%TYPE
457: := okc_api.g_miss_num,
458: relative_st_date_uom okc_deliverables.relative_st_date_uom%TYPE
459: := okc_api.g_miss_char,
453: := okc_api.g_miss_num,
454: business_document_version okc_deliverables.business_document_version%TYPE
455: := okc_api.g_miss_num,
456: relative_st_date_duration okc_deliverables.relative_st_date_duration%TYPE
457: := okc_api.g_miss_num,
458: relative_st_date_uom okc_deliverables.relative_st_date_uom%TYPE
459: := okc_api.g_miss_char,
460: relative_st_date_event_id okc_deliverables.relative_st_date_event_id%TYPE
461: := okc_api.g_miss_num,
455: := okc_api.g_miss_num,
456: relative_st_date_duration okc_deliverables.relative_st_date_duration%TYPE
457: := okc_api.g_miss_num,
458: relative_st_date_uom okc_deliverables.relative_st_date_uom%TYPE
459: := okc_api.g_miss_char,
460: relative_st_date_event_id okc_deliverables.relative_st_date_event_id%TYPE
461: := okc_api.g_miss_num,
462: relative_end_date_duration okc_deliverables.relative_end_date_duration%TYPE
463: := okc_api.g_miss_num,
457: := okc_api.g_miss_num,
458: relative_st_date_uom okc_deliverables.relative_st_date_uom%TYPE
459: := okc_api.g_miss_char,
460: relative_st_date_event_id okc_deliverables.relative_st_date_event_id%TYPE
461: := okc_api.g_miss_num,
462: relative_end_date_duration okc_deliverables.relative_end_date_duration%TYPE
463: := okc_api.g_miss_num,
464: relative_end_date_uom okc_deliverables.relative_end_date_uom%TYPE
465: := okc_api.g_miss_char,
459: := okc_api.g_miss_char,
460: relative_st_date_event_id okc_deliverables.relative_st_date_event_id%TYPE
461: := okc_api.g_miss_num,
462: relative_end_date_duration okc_deliverables.relative_end_date_duration%TYPE
463: := okc_api.g_miss_num,
464: relative_end_date_uom okc_deliverables.relative_end_date_uom%TYPE
465: := okc_api.g_miss_char,
466: relative_end_date_event_id okc_deliverables.relative_end_date_event_id%TYPE
467: := okc_api.g_miss_num,
461: := okc_api.g_miss_num,
462: relative_end_date_duration okc_deliverables.relative_end_date_duration%TYPE
463: := okc_api.g_miss_num,
464: relative_end_date_uom okc_deliverables.relative_end_date_uom%TYPE
465: := okc_api.g_miss_char,
466: relative_end_date_event_id okc_deliverables.relative_end_date_event_id%TYPE
467: := okc_api.g_miss_num,
468: repeating_day_of_month okc_deliverables.repeating_day_of_month%TYPE
469: := okc_api.g_miss_char,
463: := okc_api.g_miss_num,
464: relative_end_date_uom okc_deliverables.relative_end_date_uom%TYPE
465: := okc_api.g_miss_char,
466: relative_end_date_event_id okc_deliverables.relative_end_date_event_id%TYPE
467: := okc_api.g_miss_num,
468: repeating_day_of_month okc_deliverables.repeating_day_of_month%TYPE
469: := okc_api.g_miss_char,
470: repeating_day_of_week okc_deliverables.repeating_day_of_week%TYPE
471: := okc_api.g_miss_char,
465: := okc_api.g_miss_char,
466: relative_end_date_event_id okc_deliverables.relative_end_date_event_id%TYPE
467: := okc_api.g_miss_num,
468: repeating_day_of_month okc_deliverables.repeating_day_of_month%TYPE
469: := okc_api.g_miss_char,
470: repeating_day_of_week okc_deliverables.repeating_day_of_week%TYPE
471: := okc_api.g_miss_char,
472: repeating_frequency_uom okc_deliverables.repeating_frequency_uom%TYPE
473: := okc_api.g_miss_char,
467: := okc_api.g_miss_num,
468: repeating_day_of_month okc_deliverables.repeating_day_of_month%TYPE
469: := okc_api.g_miss_char,
470: repeating_day_of_week okc_deliverables.repeating_day_of_week%TYPE
471: := okc_api.g_miss_char,
472: repeating_frequency_uom okc_deliverables.repeating_frequency_uom%TYPE
473: := okc_api.g_miss_char,
474: repeating_duration okc_deliverables.repeating_duration%TYPE
475: := okc_api.g_miss_num,
469: := okc_api.g_miss_char,
470: repeating_day_of_week okc_deliverables.repeating_day_of_week%TYPE
471: := okc_api.g_miss_char,
472: repeating_frequency_uom okc_deliverables.repeating_frequency_uom%TYPE
473: := okc_api.g_miss_char,
474: repeating_duration okc_deliverables.repeating_duration%TYPE
475: := okc_api.g_miss_num,
476: fixed_start_date okc_deliverables.fixed_start_date%TYPE
477: := okc_api.g_miss_date,
471: := okc_api.g_miss_char,
472: repeating_frequency_uom okc_deliverables.repeating_frequency_uom%TYPE
473: := okc_api.g_miss_char,
474: repeating_duration okc_deliverables.repeating_duration%TYPE
475: := okc_api.g_miss_num,
476: fixed_start_date okc_deliverables.fixed_start_date%TYPE
477: := okc_api.g_miss_date,
478: fixed_end_date okc_deliverables.fixed_end_date%TYPE
479: := okc_api.g_miss_date,
473: := okc_api.g_miss_char,
474: repeating_duration okc_deliverables.repeating_duration%TYPE
475: := okc_api.g_miss_num,
476: fixed_start_date okc_deliverables.fixed_start_date%TYPE
477: := okc_api.g_miss_date,
478: fixed_end_date okc_deliverables.fixed_end_date%TYPE
479: := okc_api.g_miss_date,
480: manage_yn okc_deliverables.manage_yn%TYPE
481: := okc_api.g_miss_char,
475: := okc_api.g_miss_num,
476: fixed_start_date okc_deliverables.fixed_start_date%TYPE
477: := okc_api.g_miss_date,
478: fixed_end_date okc_deliverables.fixed_end_date%TYPE
479: := okc_api.g_miss_date,
480: manage_yn okc_deliverables.manage_yn%TYPE
481: := okc_api.g_miss_char,
482: internal_party_id okc_deliverables.internal_party_id%TYPE
483: := okc_api.g_miss_num,
477: := okc_api.g_miss_date,
478: fixed_end_date okc_deliverables.fixed_end_date%TYPE
479: := okc_api.g_miss_date,
480: manage_yn okc_deliverables.manage_yn%TYPE
481: := okc_api.g_miss_char,
482: internal_party_id okc_deliverables.internal_party_id%TYPE
483: := okc_api.g_miss_num,
484: deliverable_status okc_deliverables.deliverable_status%TYPE
485: := okc_api.g_miss_char,
479: := okc_api.g_miss_date,
480: manage_yn okc_deliverables.manage_yn%TYPE
481: := okc_api.g_miss_char,
482: internal_party_id okc_deliverables.internal_party_id%TYPE
483: := okc_api.g_miss_num,
484: deliverable_status okc_deliverables.deliverable_status%TYPE
485: := okc_api.g_miss_char,
486: status_change_notes okc_deliverables.status_change_notes%TYPE
487: := okc_api.g_miss_char,
481: := okc_api.g_miss_char,
482: internal_party_id okc_deliverables.internal_party_id%TYPE
483: := okc_api.g_miss_num,
484: deliverable_status okc_deliverables.deliverable_status%TYPE
485: := okc_api.g_miss_char,
486: status_change_notes okc_deliverables.status_change_notes%TYPE
487: := okc_api.g_miss_char,
488: created_by NUMBER := okc_api.g_miss_num,
489: creation_date okc_deliverables.creation_date%TYPE
483: := okc_api.g_miss_num,
484: deliverable_status okc_deliverables.deliverable_status%TYPE
485: := okc_api.g_miss_char,
486: status_change_notes okc_deliverables.status_change_notes%TYPE
487: := okc_api.g_miss_char,
488: created_by NUMBER := okc_api.g_miss_num,
489: creation_date okc_deliverables.creation_date%TYPE
490: := okc_api.g_miss_date,
491: last_updated_by NUMBER := okc_api.g_miss_num,
484: deliverable_status okc_deliverables.deliverable_status%TYPE
485: := okc_api.g_miss_char,
486: status_change_notes okc_deliverables.status_change_notes%TYPE
487: := okc_api.g_miss_char,
488: created_by NUMBER := okc_api.g_miss_num,
489: creation_date okc_deliverables.creation_date%TYPE
490: := okc_api.g_miss_date,
491: last_updated_by NUMBER := okc_api.g_miss_num,
492: last_update_date okc_deliverables.last_update_date%TYPE
486: status_change_notes okc_deliverables.status_change_notes%TYPE
487: := okc_api.g_miss_char,
488: created_by NUMBER := okc_api.g_miss_num,
489: creation_date okc_deliverables.creation_date%TYPE
490: := okc_api.g_miss_date,
491: last_updated_by NUMBER := okc_api.g_miss_num,
492: last_update_date okc_deliverables.last_update_date%TYPE
493: := okc_api.g_miss_date,
494: last_update_login NUMBER := okc_api.g_miss_num,
487: := okc_api.g_miss_char,
488: created_by NUMBER := okc_api.g_miss_num,
489: creation_date okc_deliverables.creation_date%TYPE
490: := okc_api.g_miss_date,
491: last_updated_by NUMBER := okc_api.g_miss_num,
492: last_update_date okc_deliverables.last_update_date%TYPE
493: := okc_api.g_miss_date,
494: last_update_login NUMBER := okc_api.g_miss_num,
495: object_version_number NUMBER := okc_api.g_miss_num,
489: creation_date okc_deliverables.creation_date%TYPE
490: := okc_api.g_miss_date,
491: last_updated_by NUMBER := okc_api.g_miss_num,
492: last_update_date okc_deliverables.last_update_date%TYPE
493: := okc_api.g_miss_date,
494: last_update_login NUMBER := okc_api.g_miss_num,
495: object_version_number NUMBER := okc_api.g_miss_num,
496: attribute_category okc_deliverables.attribute_category%TYPE
497: := okc_api.g_miss_char,
490: := okc_api.g_miss_date,
491: last_updated_by NUMBER := okc_api.g_miss_num,
492: last_update_date okc_deliverables.last_update_date%TYPE
493: := okc_api.g_miss_date,
494: last_update_login NUMBER := okc_api.g_miss_num,
495: object_version_number NUMBER := okc_api.g_miss_num,
496: attribute_category okc_deliverables.attribute_category%TYPE
497: := okc_api.g_miss_char,
498: attribute1 okc_deliverables.attribute1%TYPE
491: last_updated_by NUMBER := okc_api.g_miss_num,
492: last_update_date okc_deliverables.last_update_date%TYPE
493: := okc_api.g_miss_date,
494: last_update_login NUMBER := okc_api.g_miss_num,
495: object_version_number NUMBER := okc_api.g_miss_num,
496: attribute_category okc_deliverables.attribute_category%TYPE
497: := okc_api.g_miss_char,
498: attribute1 okc_deliverables.attribute1%TYPE
499: := okc_api.g_miss_char,
493: := okc_api.g_miss_date,
494: last_update_login NUMBER := okc_api.g_miss_num,
495: object_version_number NUMBER := okc_api.g_miss_num,
496: attribute_category okc_deliverables.attribute_category%TYPE
497: := okc_api.g_miss_char,
498: attribute1 okc_deliverables.attribute1%TYPE
499: := okc_api.g_miss_char,
500: attribute2 okc_deliverables.attribute2%TYPE
501: := okc_api.g_miss_char,
495: object_version_number NUMBER := okc_api.g_miss_num,
496: attribute_category okc_deliverables.attribute_category%TYPE
497: := okc_api.g_miss_char,
498: attribute1 okc_deliverables.attribute1%TYPE
499: := okc_api.g_miss_char,
500: attribute2 okc_deliverables.attribute2%TYPE
501: := okc_api.g_miss_char,
502: attribute3 okc_deliverables.attribute3%TYPE
503: := okc_api.g_miss_char,
497: := okc_api.g_miss_char,
498: attribute1 okc_deliverables.attribute1%TYPE
499: := okc_api.g_miss_char,
500: attribute2 okc_deliverables.attribute2%TYPE
501: := okc_api.g_miss_char,
502: attribute3 okc_deliverables.attribute3%TYPE
503: := okc_api.g_miss_char,
504: attribute4 okc_deliverables.attribute4%TYPE
505: := okc_api.g_miss_char,
499: := okc_api.g_miss_char,
500: attribute2 okc_deliverables.attribute2%TYPE
501: := okc_api.g_miss_char,
502: attribute3 okc_deliverables.attribute3%TYPE
503: := okc_api.g_miss_char,
504: attribute4 okc_deliverables.attribute4%TYPE
505: := okc_api.g_miss_char,
506: attribute5 okc_deliverables.attribute5%TYPE
507: := okc_api.g_miss_char,
501: := okc_api.g_miss_char,
502: attribute3 okc_deliverables.attribute3%TYPE
503: := okc_api.g_miss_char,
504: attribute4 okc_deliverables.attribute4%TYPE
505: := okc_api.g_miss_char,
506: attribute5 okc_deliverables.attribute5%TYPE
507: := okc_api.g_miss_char,
508: attribute6 okc_deliverables.attribute6%TYPE
509: := okc_api.g_miss_char,
503: := okc_api.g_miss_char,
504: attribute4 okc_deliverables.attribute4%TYPE
505: := okc_api.g_miss_char,
506: attribute5 okc_deliverables.attribute5%TYPE
507: := okc_api.g_miss_char,
508: attribute6 okc_deliverables.attribute6%TYPE
509: := okc_api.g_miss_char,
510: attribute7 okc_deliverables.attribute7%TYPE
511: := okc_api.g_miss_char,
505: := okc_api.g_miss_char,
506: attribute5 okc_deliverables.attribute5%TYPE
507: := okc_api.g_miss_char,
508: attribute6 okc_deliverables.attribute6%TYPE
509: := okc_api.g_miss_char,
510: attribute7 okc_deliverables.attribute7%TYPE
511: := okc_api.g_miss_char,
512: attribute8 okc_deliverables.attribute8%TYPE
513: := okc_api.g_miss_char,
507: := okc_api.g_miss_char,
508: attribute6 okc_deliverables.attribute6%TYPE
509: := okc_api.g_miss_char,
510: attribute7 okc_deliverables.attribute7%TYPE
511: := okc_api.g_miss_char,
512: attribute8 okc_deliverables.attribute8%TYPE
513: := okc_api.g_miss_char,
514: attribute9 okc_deliverables.attribute9%TYPE
515: := okc_api.g_miss_char,
509: := okc_api.g_miss_char,
510: attribute7 okc_deliverables.attribute7%TYPE
511: := okc_api.g_miss_char,
512: attribute8 okc_deliverables.attribute8%TYPE
513: := okc_api.g_miss_char,
514: attribute9 okc_deliverables.attribute9%TYPE
515: := okc_api.g_miss_char,
516: attribute10 okc_deliverables.attribute10%TYPE
517: := okc_api.g_miss_char,
511: := okc_api.g_miss_char,
512: attribute8 okc_deliverables.attribute8%TYPE
513: := okc_api.g_miss_char,
514: attribute9 okc_deliverables.attribute9%TYPE
515: := okc_api.g_miss_char,
516: attribute10 okc_deliverables.attribute10%TYPE
517: := okc_api.g_miss_char,
518: attribute11 okc_deliverables.attribute11%TYPE
519: := okc_api.g_miss_char,
513: := okc_api.g_miss_char,
514: attribute9 okc_deliverables.attribute9%TYPE
515: := okc_api.g_miss_char,
516: attribute10 okc_deliverables.attribute10%TYPE
517: := okc_api.g_miss_char,
518: attribute11 okc_deliverables.attribute11%TYPE
519: := okc_api.g_miss_char,
520: attribute12 okc_deliverables.attribute12%TYPE
521: := okc_api.g_miss_char,
515: := okc_api.g_miss_char,
516: attribute10 okc_deliverables.attribute10%TYPE
517: := okc_api.g_miss_char,
518: attribute11 okc_deliverables.attribute11%TYPE
519: := okc_api.g_miss_char,
520: attribute12 okc_deliverables.attribute12%TYPE
521: := okc_api.g_miss_char,
522: attribute13 okc_deliverables.attribute13%TYPE
523: := okc_api.g_miss_char,
517: := okc_api.g_miss_char,
518: attribute11 okc_deliverables.attribute11%TYPE
519: := okc_api.g_miss_char,
520: attribute12 okc_deliverables.attribute12%TYPE
521: := okc_api.g_miss_char,
522: attribute13 okc_deliverables.attribute13%TYPE
523: := okc_api.g_miss_char,
524: attribute14 okc_deliverables.attribute14%TYPE
525: := okc_api.g_miss_char,
519: := okc_api.g_miss_char,
520: attribute12 okc_deliverables.attribute12%TYPE
521: := okc_api.g_miss_char,
522: attribute13 okc_deliverables.attribute13%TYPE
523: := okc_api.g_miss_char,
524: attribute14 okc_deliverables.attribute14%TYPE
525: := okc_api.g_miss_char,
526: attribute15 okc_deliverables.attribute15%TYPE
527: := okc_api.g_miss_char,
521: := okc_api.g_miss_char,
522: attribute13 okc_deliverables.attribute13%TYPE
523: := okc_api.g_miss_char,
524: attribute14 okc_deliverables.attribute14%TYPE
525: := okc_api.g_miss_char,
526: attribute15 okc_deliverables.attribute15%TYPE
527: := okc_api.g_miss_char,
528: disable_notifications_yn okc_deliverables.disable_notifications_yn%TYPE
529: := okc_api.g_miss_char,
523: := okc_api.g_miss_char,
524: attribute14 okc_deliverables.attribute14%TYPE
525: := okc_api.g_miss_char,
526: attribute15 okc_deliverables.attribute15%TYPE
527: := okc_api.g_miss_char,
528: disable_notifications_yn okc_deliverables.disable_notifications_yn%TYPE
529: := okc_api.g_miss_char,
530: last_amendment_date okc_deliverables.last_amendment_date%TYPE
531: := okc_api.g_miss_date,
525: := okc_api.g_miss_char,
526: attribute15 okc_deliverables.attribute15%TYPE
527: := okc_api.g_miss_char,
528: disable_notifications_yn okc_deliverables.disable_notifications_yn%TYPE
529: := okc_api.g_miss_char,
530: last_amendment_date okc_deliverables.last_amendment_date%TYPE
531: := okc_api.g_miss_date,
532: business_document_line_id okc_deliverables.business_document_line_id%TYPE
533: := okc_api.g_miss_num,
527: := okc_api.g_miss_char,
528: disable_notifications_yn okc_deliverables.disable_notifications_yn%TYPE
529: := okc_api.g_miss_char,
530: last_amendment_date okc_deliverables.last_amendment_date%TYPE
531: := okc_api.g_miss_date,
532: business_document_line_id okc_deliverables.business_document_line_id%TYPE
533: := okc_api.g_miss_num,
534: external_party_site_id okc_deliverables.external_party_site_id%TYPE
535: := okc_api.g_miss_num,
529: := okc_api.g_miss_char,
530: last_amendment_date okc_deliverables.last_amendment_date%TYPE
531: := okc_api.g_miss_date,
532: business_document_line_id okc_deliverables.business_document_line_id%TYPE
533: := okc_api.g_miss_num,
534: external_party_site_id okc_deliverables.external_party_site_id%TYPE
535: := okc_api.g_miss_num,
536: start_event_date okc_deliverables.start_event_date%TYPE
537: := okc_api.g_miss_date,
531: := okc_api.g_miss_date,
532: business_document_line_id okc_deliverables.business_document_line_id%TYPE
533: := okc_api.g_miss_num,
534: external_party_site_id okc_deliverables.external_party_site_id%TYPE
535: := okc_api.g_miss_num,
536: start_event_date okc_deliverables.start_event_date%TYPE
537: := okc_api.g_miss_date,
538: end_event_date okc_deliverables.end_event_date%TYPE
539: := okc_api.g_miss_date,
533: := okc_api.g_miss_num,
534: external_party_site_id okc_deliverables.external_party_site_id%TYPE
535: := okc_api.g_miss_num,
536: start_event_date okc_deliverables.start_event_date%TYPE
537: := okc_api.g_miss_date,
538: end_event_date okc_deliverables.end_event_date%TYPE
539: := okc_api.g_miss_date,
540: summary_amend_operation_code okc_deliverables.summary_amend_operation_code%TYPE
541: := okc_api.g_miss_char,
535: := okc_api.g_miss_num,
536: start_event_date okc_deliverables.start_event_date%TYPE
537: := okc_api.g_miss_date,
538: end_event_date okc_deliverables.end_event_date%TYPE
539: := okc_api.g_miss_date,
540: summary_amend_operation_code okc_deliverables.summary_amend_operation_code%TYPE
541: := okc_api.g_miss_char,
542: external_party_role okc_deliverables.external_party_role%TYPE
543: := okc_api.g_miss_char,
537: := okc_api.g_miss_date,
538: end_event_date okc_deliverables.end_event_date%TYPE
539: := okc_api.g_miss_date,
540: summary_amend_operation_code okc_deliverables.summary_amend_operation_code%TYPE
541: := okc_api.g_miss_char,
542: external_party_role okc_deliverables.external_party_role%TYPE
543: := okc_api.g_miss_char,
544: pay_hold_prior_due_date_yn okc_deliverables.pay_hold_prior_due_date_yn%TYPE
545: := okc_api.g_miss_char,
539: := okc_api.g_miss_date,
540: summary_amend_operation_code okc_deliverables.summary_amend_operation_code%TYPE
541: := okc_api.g_miss_char,
542: external_party_role okc_deliverables.external_party_role%TYPE
543: := okc_api.g_miss_char,
544: pay_hold_prior_due_date_yn okc_deliverables.pay_hold_prior_due_date_yn%TYPE
545: := okc_api.g_miss_char,
546: pay_hold_prior_due_date_value okc_deliverables.pay_hold_prior_due_date_value%TYPE
547: := okc_api.g_miss_num,
541: := okc_api.g_miss_char,
542: external_party_role okc_deliverables.external_party_role%TYPE
543: := okc_api.g_miss_char,
544: pay_hold_prior_due_date_yn okc_deliverables.pay_hold_prior_due_date_yn%TYPE
545: := okc_api.g_miss_char,
546: pay_hold_prior_due_date_value okc_deliverables.pay_hold_prior_due_date_value%TYPE
547: := okc_api.g_miss_num,
548: pay_hold_prior_due_date_uom okc_deliverables.pay_hold_prior_due_date_uom%TYPE
549: := okc_api.g_miss_char,
543: := okc_api.g_miss_char,
544: pay_hold_prior_due_date_yn okc_deliverables.pay_hold_prior_due_date_yn%TYPE
545: := okc_api.g_miss_char,
546: pay_hold_prior_due_date_value okc_deliverables.pay_hold_prior_due_date_value%TYPE
547: := okc_api.g_miss_num,
548: pay_hold_prior_due_date_uom okc_deliverables.pay_hold_prior_due_date_uom%TYPE
549: := okc_api.g_miss_char,
550: pay_hold_overdue_yn okc_deliverables.pay_hold_overdue_yn%TYPE
551: := okc_api.g_miss_char,
545: := okc_api.g_miss_char,
546: pay_hold_prior_due_date_value okc_deliverables.pay_hold_prior_due_date_value%TYPE
547: := okc_api.g_miss_num,
548: pay_hold_prior_due_date_uom okc_deliverables.pay_hold_prior_due_date_uom%TYPE
549: := okc_api.g_miss_char,
550: pay_hold_overdue_yn okc_deliverables.pay_hold_overdue_yn%TYPE
551: := okc_api.g_miss_char,
552: raise_completion_event_yn okc_deliverables.raise_completion_event_yn%TYPE
553: := okc_api.g_miss_char,
547: := okc_api.g_miss_num,
548: pay_hold_prior_due_date_uom okc_deliverables.pay_hold_prior_due_date_uom%TYPE
549: := okc_api.g_miss_char,
550: pay_hold_overdue_yn okc_deliverables.pay_hold_overdue_yn%TYPE
551: := okc_api.g_miss_char,
552: raise_completion_event_yn okc_deliverables.raise_completion_event_yn%TYPE
553: := okc_api.g_miss_char,
554: status VARCHAR2 (1),
555: errmsg VARCHAR2 (2500)
549: := okc_api.g_miss_char,
550: pay_hold_overdue_yn okc_deliverables.pay_hold_overdue_yn%TYPE
551: := okc_api.g_miss_char,
552: raise_completion_event_yn okc_deliverables.raise_completion_event_yn%TYPE
553: := okc_api.g_miss_char,
554: status VARCHAR2 (1),
555: errmsg VARCHAR2 (2500)
556: );
557: