DBA Data[Home] [Help]

APPS.OKL_PAM_PVT dependencies on OKL_API

Line 100: g_fnd_app CONSTANT VARCHAR2(200) := okl_api.g_fnd_app;

96: --------------------------------------------------------------------------------
97: -- GLOBAL MESSAGE CONSTANTS
98: --------------------------------------------------------------------------------
99:
100: g_fnd_app CONSTANT VARCHAR2(200) := okl_api.g_fnd_app;
101: g_form_unable_to_reserve_rec CONSTANT VARCHAR2(200) := okl_api.g_form_unable_to_reserve_rec;
102: g_form_record_deleted CONSTANT VARCHAR2(200) := okl_api.g_form_record_deleted;
103: g_form_record_changed CONSTANT VARCHAR2(200) := okl_api.g_form_record_changed;
104: g_record_logically_deleted CONSTANT VARCHAR2(200) := okl_api.g_record_logically_deleted;

Line 101: g_form_unable_to_reserve_rec CONSTANT VARCHAR2(200) := okl_api.g_form_unable_to_reserve_rec;

97: -- GLOBAL MESSAGE CONSTANTS
98: --------------------------------------------------------------------------------
99:
100: g_fnd_app CONSTANT VARCHAR2(200) := okl_api.g_fnd_app;
101: g_form_unable_to_reserve_rec CONSTANT VARCHAR2(200) := okl_api.g_form_unable_to_reserve_rec;
102: g_form_record_deleted CONSTANT VARCHAR2(200) := okl_api.g_form_record_deleted;
103: g_form_record_changed CONSTANT VARCHAR2(200) := okl_api.g_form_record_changed;
104: g_record_logically_deleted CONSTANT VARCHAR2(200) := okl_api.g_record_logically_deleted;
105: g_required_value CONSTANT VARCHAR2(200) := okl_api.g_required_value;

Line 102: g_form_record_deleted CONSTANT VARCHAR2(200) := okl_api.g_form_record_deleted;

98: --------------------------------------------------------------------------------
99:
100: g_fnd_app CONSTANT VARCHAR2(200) := okl_api.g_fnd_app;
101: g_form_unable_to_reserve_rec CONSTANT VARCHAR2(200) := okl_api.g_form_unable_to_reserve_rec;
102: g_form_record_deleted CONSTANT VARCHAR2(200) := okl_api.g_form_record_deleted;
103: g_form_record_changed CONSTANT VARCHAR2(200) := okl_api.g_form_record_changed;
104: g_record_logically_deleted CONSTANT VARCHAR2(200) := okl_api.g_record_logically_deleted;
105: g_required_value CONSTANT VARCHAR2(200) := okl_api.g_required_value;
106: g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;

Line 103: g_form_record_changed CONSTANT VARCHAR2(200) := okl_api.g_form_record_changed;

99:
100: g_fnd_app CONSTANT VARCHAR2(200) := okl_api.g_fnd_app;
101: g_form_unable_to_reserve_rec CONSTANT VARCHAR2(200) := okl_api.g_form_unable_to_reserve_rec;
102: g_form_record_deleted CONSTANT VARCHAR2(200) := okl_api.g_form_record_deleted;
103: g_form_record_changed CONSTANT VARCHAR2(200) := okl_api.g_form_record_changed;
104: g_record_logically_deleted CONSTANT VARCHAR2(200) := okl_api.g_record_logically_deleted;
105: g_required_value CONSTANT VARCHAR2(200) := okl_api.g_required_value;
106: g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;
107: g_col_name_token CONSTANT VARCHAR2(200) := okl_api.g_col_name_token;

Line 104: g_record_logically_deleted CONSTANT VARCHAR2(200) := okl_api.g_record_logically_deleted;

100: g_fnd_app CONSTANT VARCHAR2(200) := okl_api.g_fnd_app;
101: g_form_unable_to_reserve_rec CONSTANT VARCHAR2(200) := okl_api.g_form_unable_to_reserve_rec;
102: g_form_record_deleted CONSTANT VARCHAR2(200) := okl_api.g_form_record_deleted;
103: g_form_record_changed CONSTANT VARCHAR2(200) := okl_api.g_form_record_changed;
104: g_record_logically_deleted CONSTANT VARCHAR2(200) := okl_api.g_record_logically_deleted;
105: g_required_value CONSTANT VARCHAR2(200) := okl_api.g_required_value;
106: g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;
107: g_col_name_token CONSTANT VARCHAR2(200) := okl_api.g_col_name_token;
108: g_parent_table_token CONSTANT VARCHAR2(200) := okl_api.g_parent_table_token;

Line 105: g_required_value CONSTANT VARCHAR2(200) := okl_api.g_required_value;

101: g_form_unable_to_reserve_rec CONSTANT VARCHAR2(200) := okl_api.g_form_unable_to_reserve_rec;
102: g_form_record_deleted CONSTANT VARCHAR2(200) := okl_api.g_form_record_deleted;
103: g_form_record_changed CONSTANT VARCHAR2(200) := okl_api.g_form_record_changed;
104: g_record_logically_deleted CONSTANT VARCHAR2(200) := okl_api.g_record_logically_deleted;
105: g_required_value CONSTANT VARCHAR2(200) := okl_api.g_required_value;
106: g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;
107: g_col_name_token CONSTANT VARCHAR2(200) := okl_api.g_col_name_token;
108: g_parent_table_token CONSTANT VARCHAR2(200) := okl_api.g_parent_table_token;
109: g_child_table_token CONSTANT VARCHAR2(200) := okl_api.g_child_table_token;

Line 106: g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;

102: g_form_record_deleted CONSTANT VARCHAR2(200) := okl_api.g_form_record_deleted;
103: g_form_record_changed CONSTANT VARCHAR2(200) := okl_api.g_form_record_changed;
104: g_record_logically_deleted CONSTANT VARCHAR2(200) := okl_api.g_record_logically_deleted;
105: g_required_value CONSTANT VARCHAR2(200) := okl_api.g_required_value;
106: g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;
107: g_col_name_token CONSTANT VARCHAR2(200) := okl_api.g_col_name_token;
108: g_parent_table_token CONSTANT VARCHAR2(200) := okl_api.g_parent_table_token;
109: g_child_table_token CONSTANT VARCHAR2(200) := okl_api.g_child_table_token;
110: g_ret_sts_success CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_success;

Line 107: g_col_name_token CONSTANT VARCHAR2(200) := okl_api.g_col_name_token;

103: g_form_record_changed CONSTANT VARCHAR2(200) := okl_api.g_form_record_changed;
104: g_record_logically_deleted CONSTANT VARCHAR2(200) := okl_api.g_record_logically_deleted;
105: g_required_value CONSTANT VARCHAR2(200) := okl_api.g_required_value;
106: g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;
107: g_col_name_token CONSTANT VARCHAR2(200) := okl_api.g_col_name_token;
108: g_parent_table_token CONSTANT VARCHAR2(200) := okl_api.g_parent_table_token;
109: g_child_table_token CONSTANT VARCHAR2(200) := okl_api.g_child_table_token;
110: g_ret_sts_success CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_success;
111: g_ret_sts_unexp_error CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;

Line 108: g_parent_table_token CONSTANT VARCHAR2(200) := okl_api.g_parent_table_token;

104: g_record_logically_deleted CONSTANT VARCHAR2(200) := okl_api.g_record_logically_deleted;
105: g_required_value CONSTANT VARCHAR2(200) := okl_api.g_required_value;
106: g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;
107: g_col_name_token CONSTANT VARCHAR2(200) := okl_api.g_col_name_token;
108: g_parent_table_token CONSTANT VARCHAR2(200) := okl_api.g_parent_table_token;
109: g_child_table_token CONSTANT VARCHAR2(200) := okl_api.g_child_table_token;
110: g_ret_sts_success CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_success;
111: g_ret_sts_unexp_error CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;
112: g_ret_sts_error CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_error;

Line 109: g_child_table_token CONSTANT VARCHAR2(200) := okl_api.g_child_table_token;

105: g_required_value CONSTANT VARCHAR2(200) := okl_api.g_required_value;
106: g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;
107: g_col_name_token CONSTANT VARCHAR2(200) := okl_api.g_col_name_token;
108: g_parent_table_token CONSTANT VARCHAR2(200) := okl_api.g_parent_table_token;
109: g_child_table_token CONSTANT VARCHAR2(200) := okl_api.g_child_table_token;
110: g_ret_sts_success CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_success;
111: g_ret_sts_unexp_error CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;
112: g_ret_sts_error CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_error;
113: g_db_error CONSTANT VARCHAR2(12) := 'OKL_DB_ERROR';

Line 124: g_app_name CONSTANT VARCHAR2(3) := okl_api.g_app_name;

120: -- GLOBAL VARIABLES
121: --------------------------------------------------------------------------------
122:
123: g_pkg_name CONSTANT VARCHAR2(200) := 'OKL_PAM_PVT';
124: g_app_name CONSTANT VARCHAR2(3) := okl_api.g_app_name;
125:
126: --------------------------------------------------------------------------------
127: -- Procedures and Functions
128: --------------------------------------------------------------------------------

Line 137: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

133:
134: PROCEDURE add_language;
135:
136: PROCEDURE insert_row(p_api_version IN NUMBER
137: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
138: ,x_return_status OUT NOCOPY VARCHAR2
139: ,x_msg_count OUT NOCOPY NUMBER
140: ,x_msg_data OUT NOCOPY VARCHAR2
141: ,p_pamv_rec IN okl_pamv_rec

Line 145: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

141: ,p_pamv_rec IN okl_pamv_rec
142: ,x_pamv_rec OUT NOCOPY okl_pamv_rec);
143:
144: PROCEDURE insert_row(p_api_version IN NUMBER
145: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
146: ,x_return_status OUT NOCOPY VARCHAR2
147: ,x_msg_count OUT NOCOPY NUMBER
148: ,x_msg_data OUT NOCOPY VARCHAR2
149: ,p_pamv_tbl IN okl_pamv_tbl

Line 153: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

149: ,p_pamv_tbl IN okl_pamv_tbl
150: ,x_pamv_tbl OUT NOCOPY okl_pamv_tbl);
151:
152: PROCEDURE update_row(p_api_version IN NUMBER
153: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
154: ,x_return_status OUT NOCOPY VARCHAR2
155: ,x_msg_count OUT NOCOPY NUMBER
156: ,x_msg_data OUT NOCOPY VARCHAR2
157: ,p_pamv_rec IN okl_pamv_rec

Line 161: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

157: ,p_pamv_rec IN okl_pamv_rec
158: ,x_pamv_rec OUT NOCOPY okl_pamv_rec);
159:
160: PROCEDURE update_row(p_api_version IN NUMBER
161: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
162: ,x_return_status OUT NOCOPY VARCHAR2
163: ,x_msg_count OUT NOCOPY NUMBER
164: ,x_msg_data OUT NOCOPY VARCHAR2
165: ,p_pamv_tbl IN okl_pamv_tbl

Line 169: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

165: ,p_pamv_tbl IN okl_pamv_tbl
166: ,x_pamv_tbl OUT NOCOPY okl_pamv_tbl);
167:
168: PROCEDURE delete_row(p_api_version IN NUMBER
169: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
170: ,x_return_status OUT NOCOPY VARCHAR2
171: ,x_msg_count OUT NOCOPY NUMBER
172: ,x_msg_data OUT NOCOPY VARCHAR2
173: ,p_pamv_rec IN okl_pamv_rec);

Line 176: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

172: ,x_msg_data OUT NOCOPY VARCHAR2
173: ,p_pamv_rec IN okl_pamv_rec);
174:
175: PROCEDURE delete_row(p_api_version IN NUMBER
176: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
177: ,x_return_status OUT NOCOPY VARCHAR2
178: ,x_msg_count OUT NOCOPY NUMBER
179: ,x_msg_data OUT NOCOPY VARCHAR2
180: ,p_pamv_tbl IN okl_pamv_tbl);