69: --------------------------------------------------------------------------------
70: -- GLOBAL MESSAGE CONSTANTS
71: --------------------------------------------------------------------------------
72:
73: g_fnd_app CONSTANT varchar2(200) := okl_api.g_fnd_app;
74: g_form_unable_to_reserve_rec CONSTANT varchar2(200) := okl_api.g_form_unable_to_reserve_rec;
75: g_form_record_deleted CONSTANT varchar2(200) := okl_api.g_form_record_deleted;
76: g_form_record_changed CONSTANT varchar2(200) := okl_api.g_form_record_changed;
77: g_record_logically_deleted CONSTANT varchar2(200) := okl_api.g_record_logically_deleted;
70: -- GLOBAL MESSAGE CONSTANTS
71: --------------------------------------------------------------------------------
72:
73: g_fnd_app CONSTANT varchar2(200) := okl_api.g_fnd_app;
74: g_form_unable_to_reserve_rec CONSTANT varchar2(200) := okl_api.g_form_unable_to_reserve_rec;
75: g_form_record_deleted CONSTANT varchar2(200) := okl_api.g_form_record_deleted;
76: g_form_record_changed CONSTANT varchar2(200) := okl_api.g_form_record_changed;
77: g_record_logically_deleted CONSTANT varchar2(200) := okl_api.g_record_logically_deleted;
78: g_required_value CONSTANT varchar2(200) := okl_api.g_required_value;
71: --------------------------------------------------------------------------------
72:
73: g_fnd_app CONSTANT varchar2(200) := okl_api.g_fnd_app;
74: g_form_unable_to_reserve_rec CONSTANT varchar2(200) := okl_api.g_form_unable_to_reserve_rec;
75: g_form_record_deleted CONSTANT varchar2(200) := okl_api.g_form_record_deleted;
76: g_form_record_changed CONSTANT varchar2(200) := okl_api.g_form_record_changed;
77: g_record_logically_deleted CONSTANT varchar2(200) := okl_api.g_record_logically_deleted;
78: g_required_value CONSTANT varchar2(200) := okl_api.g_required_value;
79: g_invalid_value CONSTANT varchar2(200) := okl_api.g_invalid_value;
72:
73: g_fnd_app CONSTANT varchar2(200) := okl_api.g_fnd_app;
74: g_form_unable_to_reserve_rec CONSTANT varchar2(200) := okl_api.g_form_unable_to_reserve_rec;
75: g_form_record_deleted CONSTANT varchar2(200) := okl_api.g_form_record_deleted;
76: g_form_record_changed CONSTANT varchar2(200) := okl_api.g_form_record_changed;
77: g_record_logically_deleted CONSTANT varchar2(200) := okl_api.g_record_logically_deleted;
78: g_required_value CONSTANT varchar2(200) := okl_api.g_required_value;
79: g_invalid_value CONSTANT varchar2(200) := okl_api.g_invalid_value;
80: g_col_name_token CONSTANT varchar2(200) := okl_api.g_col_name_token;
73: g_fnd_app CONSTANT varchar2(200) := okl_api.g_fnd_app;
74: g_form_unable_to_reserve_rec CONSTANT varchar2(200) := okl_api.g_form_unable_to_reserve_rec;
75: g_form_record_deleted CONSTANT varchar2(200) := okl_api.g_form_record_deleted;
76: g_form_record_changed CONSTANT varchar2(200) := okl_api.g_form_record_changed;
77: g_record_logically_deleted CONSTANT varchar2(200) := okl_api.g_record_logically_deleted;
78: g_required_value CONSTANT varchar2(200) := okl_api.g_required_value;
79: g_invalid_value CONSTANT varchar2(200) := okl_api.g_invalid_value;
80: g_col_name_token CONSTANT varchar2(200) := okl_api.g_col_name_token;
81: g_parent_table_token CONSTANT varchar2(200) := okl_api.g_parent_table_token;
74: g_form_unable_to_reserve_rec CONSTANT varchar2(200) := okl_api.g_form_unable_to_reserve_rec;
75: g_form_record_deleted CONSTANT varchar2(200) := okl_api.g_form_record_deleted;
76: g_form_record_changed CONSTANT varchar2(200) := okl_api.g_form_record_changed;
77: g_record_logically_deleted CONSTANT varchar2(200) := okl_api.g_record_logically_deleted;
78: g_required_value CONSTANT varchar2(200) := okl_api.g_required_value;
79: g_invalid_value CONSTANT varchar2(200) := okl_api.g_invalid_value;
80: g_col_name_token CONSTANT varchar2(200) := okl_api.g_col_name_token;
81: g_parent_table_token CONSTANT varchar2(200) := okl_api.g_parent_table_token;
82: g_child_table_token CONSTANT varchar2(200) := okl_api.g_child_table_token;
75: g_form_record_deleted CONSTANT varchar2(200) := okl_api.g_form_record_deleted;
76: g_form_record_changed CONSTANT varchar2(200) := okl_api.g_form_record_changed;
77: g_record_logically_deleted CONSTANT varchar2(200) := okl_api.g_record_logically_deleted;
78: g_required_value CONSTANT varchar2(200) := okl_api.g_required_value;
79: g_invalid_value CONSTANT varchar2(200) := okl_api.g_invalid_value;
80: g_col_name_token CONSTANT varchar2(200) := okl_api.g_col_name_token;
81: g_parent_table_token CONSTANT varchar2(200) := okl_api.g_parent_table_token;
82: g_child_table_token CONSTANT varchar2(200) := okl_api.g_child_table_token;
83:
76: g_form_record_changed CONSTANT varchar2(200) := okl_api.g_form_record_changed;
77: g_record_logically_deleted CONSTANT varchar2(200) := okl_api.g_record_logically_deleted;
78: g_required_value CONSTANT varchar2(200) := okl_api.g_required_value;
79: g_invalid_value CONSTANT varchar2(200) := okl_api.g_invalid_value;
80: g_col_name_token CONSTANT varchar2(200) := okl_api.g_col_name_token;
81: g_parent_table_token CONSTANT varchar2(200) := okl_api.g_parent_table_token;
82: g_child_table_token CONSTANT varchar2(200) := okl_api.g_child_table_token;
83:
84: --------------------------------------------------------------------------------
77: g_record_logically_deleted CONSTANT varchar2(200) := okl_api.g_record_logically_deleted;
78: g_required_value CONSTANT varchar2(200) := okl_api.g_required_value;
79: g_invalid_value CONSTANT varchar2(200) := okl_api.g_invalid_value;
80: g_col_name_token CONSTANT varchar2(200) := okl_api.g_col_name_token;
81: g_parent_table_token CONSTANT varchar2(200) := okl_api.g_parent_table_token;
82: g_child_table_token CONSTANT varchar2(200) := okl_api.g_child_table_token;
83:
84: --------------------------------------------------------------------------------
85: -- GLOBAL VARIABLES
78: g_required_value CONSTANT varchar2(200) := okl_api.g_required_value;
79: g_invalid_value CONSTANT varchar2(200) := okl_api.g_invalid_value;
80: g_col_name_token CONSTANT varchar2(200) := okl_api.g_col_name_token;
81: g_parent_table_token CONSTANT varchar2(200) := okl_api.g_parent_table_token;
82: g_child_table_token CONSTANT varchar2(200) := okl_api.g_child_table_token;
83:
84: --------------------------------------------------------------------------------
85: -- GLOBAL VARIABLES
86: --------------------------------------------------------------------------------
85: -- GLOBAL VARIABLES
86: --------------------------------------------------------------------------------
87:
88: g_pkg_name CONSTANT varchar2(200) := 'OKL_ECC_PVT';
89: g_app_name CONSTANT varchar2(3) := okl_api.g_app_name;
90:
91: --------------------------------------------------------------------------------
92: -- Procedures and Functions
93: --------------------------------------------------------------------------------
98:
99: PROCEDURE add_language;
100:
101: PROCEDURE insert_row(p_api_version IN number
102: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
103: ,x_return_status OUT NOCOPY varchar2
104: ,x_msg_count OUT NOCOPY number
105: ,x_msg_data OUT NOCOPY varchar2
106: ,p_eccv_rec IN okl_eccv_rec
106: ,p_eccv_rec IN okl_eccv_rec
107: ,x_eccv_rec OUT NOCOPY okl_eccv_rec);
108:
109: PROCEDURE insert_row(p_api_version IN number
110: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
111: ,x_return_status OUT NOCOPY varchar2
112: ,x_msg_count OUT NOCOPY number
113: ,x_msg_data OUT NOCOPY varchar2
114: ,p_eccv_tbl IN okl_eccv_tbl
114: ,p_eccv_tbl IN okl_eccv_tbl
115: ,x_eccv_tbl OUT NOCOPY okl_eccv_tbl);
116:
117: PROCEDURE update_row(p_api_version IN number
118: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
119: ,x_return_status OUT NOCOPY varchar2
120: ,x_msg_count OUT NOCOPY number
121: ,x_msg_data OUT NOCOPY varchar2
122: ,p_eccv_rec IN okl_eccv_rec
122: ,p_eccv_rec IN okl_eccv_rec
123: ,x_eccv_rec OUT NOCOPY okl_eccv_rec);
124:
125: PROCEDURE update_row(p_api_version IN number
126: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
127: ,x_return_status OUT NOCOPY varchar2
128: ,x_msg_count OUT NOCOPY number
129: ,x_msg_data OUT NOCOPY varchar2
130: ,p_eccv_tbl IN okl_eccv_tbl
130: ,p_eccv_tbl IN okl_eccv_tbl
131: ,x_eccv_tbl OUT NOCOPY okl_eccv_tbl);
132:
133: PROCEDURE delete_row(p_api_version IN number
134: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
135: ,x_return_status OUT NOCOPY varchar2
136: ,x_msg_count OUT NOCOPY number
137: ,x_msg_data OUT NOCOPY varchar2
138: ,p_eccv_rec IN okl_eccv_rec);
137: ,x_msg_data OUT NOCOPY varchar2
138: ,p_eccv_rec IN okl_eccv_rec);
139:
140: PROCEDURE delete_row(p_api_version IN number
141: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
142: ,x_return_status OUT NOCOPY varchar2
143: ,x_msg_count OUT NOCOPY number
144: ,x_msg_data OUT NOCOPY varchar2
145: ,p_eccv_tbl IN okl_eccv_tbl);