DBA Data[Home] [Help]

APPS.OKC_IMP_TERMS_TEMPLATES_PVT dependencies on OKC_TERMS_TEMPLATES_ALL

Line 20: template_id okc_terms_templates_all.template_id%TYPE

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

Line 22: template_name okc_terms_templates_all.template_name%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

Line 24: intent okc_terms_templates_all.intent%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

Line 26: status_code okc_terms_templates_all.status_code%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

Line 28: start_date okc_terms_templates_all.start_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

Line 30: end_date okc_terms_templates_all.end_date%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

Line 32: global_flag okc_terms_templates_all.global_flag%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

Line 34: instruction_text okc_terms_templates_all.instruction_text%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

Line 36: description okc_terms_templates_all.description%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

Line 38: working_copy_flag okc_terms_templates_all.working_copy_flag%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

Line 40: parent_template_id okc_terms_templates_all.parent_template_id%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

Line 42: contract_expert_enabled okc_terms_templates_all.contract_expert_enabled%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

Line 44: template_model_id okc_terms_templates_all.template_model_id%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

Line 46: tmpl_numbering_scheme okc_terms_templates_all.tmpl_numbering_scheme%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

Line 48: print_template_id okc_terms_templates_all.print_template_id%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

Line 50: approval_wf_key okc_terms_templates_all.approval_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,

Line 52: cz_export_wf_key okc_terms_templates_all.cz_export_wf_key%TYPE

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,

Line 59: org_id okc_terms_templates_all.org_id%TYPE

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

Line 61: orig_system_reference_code okc_terms_templates_all.orig_system_reference_code%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

Line 63: orig_system_reference_id1 okc_terms_templates_all.orig_system_reference_id1%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,

Line 65: orig_system_reference_id2 okc_terms_templates_all.orig_system_reference_id2%TYPE

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,

Line 68: hide_yn okc_terms_templates_all.hide_yn%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,
72: attribute1 okc_terms_templates_all.attribute1%TYPE

Line 70: attribute_category okc_terms_templates_all.attribute_category%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

Line 72: attribute1 okc_terms_templates_all.attribute1%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

Line 74: attribute2 okc_terms_templates_all.attribute2%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

Line 76: attribute3 okc_terms_templates_all.attribute3%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

Line 78: attribute4 okc_terms_templates_all.attribute4%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

Line 80: attribute5 okc_terms_templates_all.attribute5%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

Line 82: attribute6 okc_terms_templates_all.attribute6%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

Line 84: attribute7 okc_terms_templates_all.attribute7%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

Line 86: attribute8 okc_terms_templates_all.attribute8%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

Line 88: attribute9 okc_terms_templates_all.attribute9%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

Line 90: attribute10 okc_terms_templates_all.attribute10%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

Line 92: attribute11 okc_terms_templates_all.attribute11%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

Line 94: attribute12 okc_terms_templates_all.attribute12%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

Line 96: attribute13 okc_terms_templates_all.attribute13%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

Line 98: attribute14 okc_terms_templates_all.attribute14%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,

Line 100: attribute15 okc_terms_templates_all.attribute15%TYPE

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,

Line 103: xprt_clause_mandatory_flag okc_terms_templates_all.xprt_clause_mandatory_flag%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,
107: LANGUAGE okc_terms_templates_all.LANGUAGE%TYPE

Line 105: xprt_scn_code okc_terms_templates_all.xprt_scn_code%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

Line 107: LANGUAGE okc_terms_templates_all.LANGUAGE%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),

Line 109: translated_from_tmpl_id okc_terms_templates_all.translated_from_tmpl_id%TYPE

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