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();
33: l_mod_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_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();
36: l_del_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_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();
36: l_del_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
37:
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;
40: l_menu_name varchar2(30);
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();
223: l_mod_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_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();
226: l_del_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_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();
226: l_del_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
227:
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;
230:
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();
373: l_mod_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_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();
376: l_del_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_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();
376: l_del_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
377:
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;
380: