DBA Data[Home] [Help]

APPS.PA_ROLE_STATUS_MENU_PVT dependencies on PA_VARCHAR2_30_TBL_TYPE

Line 26: l_new_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

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

Line 27: l_new_status_type_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();

Line 28: l_new_menu_name_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();

Line 30: l_mod_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_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();

Line 31: l_mod_status_type_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();

Line 34: l_del_status_code_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);

Line 35: l_del_status_type_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);
39: l_count number;

Line 216: l_new_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

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

Line 217: l_new_status_type_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();

Line 218: l_new_menu_name_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();

Line 220: l_mod_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_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();

Line 221: l_mod_status_type_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();

Line 224: l_del_status_code_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);

Line 225: l_del_status_type_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);
229: l_count number;

Line 366: l_new_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

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

Line 367: l_new_status_type_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();

Line 368: l_new_menu_name_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();

Line 370: l_mod_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_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();

Line 371: l_mod_status_type_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();

Line 374: l_del_status_code_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);

Line 375: l_del_status_type_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);
379: l_count number;