22:
23: l_sqlcode varchar2(30);
24: l_error_message_code varchar2(30);
25:
26: l_new_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
27: l_new_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
28: l_new_menu_name_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
29: l_new_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
30: l_mod_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
23: l_sqlcode varchar2(30);
24: l_error_message_code varchar2(30);
25:
26: l_new_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
27: l_new_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
28: l_new_menu_name_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
29: l_new_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
30: l_mod_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
31: l_mod_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
24: l_error_message_code varchar2(30);
25:
26: l_new_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
27: l_new_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
28: l_new_menu_name_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
29: l_new_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
30: l_mod_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
31: l_mod_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
32: l_mod_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
26: l_new_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
27: l_new_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
28: l_new_menu_name_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
29: l_new_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
30: l_mod_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
31: l_mod_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
32: l_mod_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
33: l_mod_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
34: l_del_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
27: l_new_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
28: l_new_menu_name_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
29: l_new_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
30: l_mod_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
31: l_mod_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
32: l_mod_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
33: l_mod_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
34: l_del_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
35: l_del_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
30: l_mod_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
31: l_mod_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
32: l_mod_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
33: l_mod_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
34: l_del_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
35: l_del_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
36: l_del_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
37:
38: l_status_level varchar2(30);
31: l_mod_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
32: l_mod_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
33: l_mod_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
34: l_del_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
35: l_del_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
36: l_del_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
37:
38: l_status_level varchar2(30);
39: l_count number;
212: p_msg_count out NOCOPY number,
213: p_msg_data out NOCOPY varchar2
214: ) is
215:
216: l_new_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
217: l_new_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
218: l_new_menu_name_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
219: l_new_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
220: l_mod_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
213: p_msg_data out NOCOPY varchar2
214: ) is
215:
216: l_new_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
217: l_new_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
218: l_new_menu_name_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
219: l_new_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
220: l_mod_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
221: l_mod_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
214: ) is
215:
216: l_new_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
217: l_new_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
218: l_new_menu_name_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
219: l_new_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
220: l_mod_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
221: l_mod_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
222: l_mod_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
216: l_new_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
217: l_new_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
218: l_new_menu_name_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
219: l_new_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
220: l_mod_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
221: l_mod_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
222: l_mod_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
223: l_mod_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
224: l_del_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
217: l_new_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
218: l_new_menu_name_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
219: l_new_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
220: l_mod_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
221: l_mod_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
222: l_mod_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
223: l_mod_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
224: l_del_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
225: l_del_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
220: l_mod_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
221: l_mod_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
222: l_mod_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
223: l_mod_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
224: l_del_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
225: l_del_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
226: l_del_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
227:
228: l_status_level varchar2(30);
221: l_mod_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
222: l_mod_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
223: l_mod_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
224: l_del_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
225: l_del_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
226: l_del_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
227:
228: l_status_level varchar2(30);
229: l_count number;
362: p_msg_count out NOCOPY number,
363: p_msg_data out NOCOPY varchar2
364: ) is
365:
366: l_new_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
367: l_new_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
368: l_new_menu_name_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
369: l_new_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
370: l_mod_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
363: p_msg_data out NOCOPY varchar2
364: ) is
365:
366: l_new_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
367: l_new_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
368: l_new_menu_name_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
369: l_new_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
370: l_mod_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
371: l_mod_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
364: ) is
365:
366: l_new_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
367: l_new_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
368: l_new_menu_name_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
369: l_new_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
370: l_mod_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
371: l_mod_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
372: l_mod_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
366: l_new_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
367: l_new_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
368: l_new_menu_name_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
369: l_new_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
370: l_mod_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
371: l_mod_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
372: l_mod_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
373: l_mod_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
374: l_del_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
367: l_new_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
368: l_new_menu_name_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
369: l_new_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
370: l_mod_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
371: l_mod_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
372: l_mod_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
373: l_mod_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
374: l_del_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
375: l_del_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
370: l_mod_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
371: l_mod_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
372: l_mod_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
373: l_mod_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
374: l_del_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
375: l_del_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
376: l_del_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
377:
378: l_status_level varchar2(30);
371: l_mod_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
372: l_mod_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
373: l_mod_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
374: l_del_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
375: l_del_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
376: l_del_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
377:
378: l_status_level varchar2(30);
379: l_count number;