16: g_ret_sts_unexp_error CONSTANT VARCHAR2 (1)
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
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,
26: status_code okc_terms_templates_all.status_code%TYPE
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,
28: start_date okc_terms_templates_all.start_date%TYPE
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,
30: end_date okc_terms_templates_all.end_date%TYPE
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,
32: global_flag okc_terms_templates_all.global_flag%TYPE
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,
34: instruction_text okc_terms_templates_all.instruction_text%TYPE
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,
36: description okc_terms_templates_all.description%TYPE
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,
38: working_copy_flag okc_terms_templates_all.working_copy_flag%TYPE
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,
40: parent_template_id okc_terms_templates_all.parent_template_id%TYPE
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,
42: contract_expert_enabled okc_terms_templates_all.contract_expert_enabled%TYPE
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,
44: template_model_id okc_terms_templates_all.template_model_id%TYPE
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,
46: tmpl_numbering_scheme okc_terms_templates_all.tmpl_numbering_scheme%TYPE
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,
48: print_template_id okc_terms_templates_all.print_template_id%TYPE
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,
50: approval_wf_key okc_terms_templates_all.approval_wf_key%TYPE
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,
52: cz_export_wf_key okc_terms_templates_all.cz_export_wf_key%TYPE
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,
54: last_update_login NUMBER := 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,
56: created_by 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,
63: orig_system_reference_id1 okc_terms_templates_all.orig_system_reference_id1%TYPE
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,
65: orig_system_reference_id2 okc_terms_templates_all.orig_system_reference_id2%TYPE
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,
67: object_version_number NUMBER := 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
69: := okc_api.g_miss_char,
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,
72: attribute1 okc_terms_templates_all.attribute1%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,
74: attribute2 okc_terms_templates_all.attribute2%TYPE
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,
76: attribute3 okc_terms_templates_all.attribute3%TYPE
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,
78: attribute4 okc_terms_templates_all.attribute4%TYPE
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,
80: attribute5 okc_terms_templates_all.attribute5%TYPE
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,
82: attribute6 okc_terms_templates_all.attribute6%TYPE
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,
84: attribute7 okc_terms_templates_all.attribute7%TYPE
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,
86: attribute8 okc_terms_templates_all.attribute8%TYPE
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,
88: attribute9 okc_terms_templates_all.attribute9%TYPE
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,
90: attribute10 okc_terms_templates_all.attribute10%TYPE
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,
92: attribute11 okc_terms_templates_all.attribute11%TYPE
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,
94: attribute12 okc_terms_templates_all.attribute12%TYPE
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,
96: attribute13 okc_terms_templates_all.attribute13%TYPE
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,
98: attribute14 okc_terms_templates_all.attribute14%TYPE
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,
100: attribute15 okc_terms_templates_all.attribute15%TYPE
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,
102: xprt_request_id NUMBER := okc_api.g_miss_num,
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
104: := okc_api.g_miss_char,
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,
107: LANGUAGE okc_terms_templates_all.LANGUAGE%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,
109: translated_from_tmpl_id okc_terms_templates_all.translated_from_tmpl_id%TYPE
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,
111: status VARCHAR2 (1),
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)
113: );