DBA Data[Home] [Help]

APPS.PA_ROLE_STATUS_MENU_PVT dependencies on PA_NUM_TBL_TYPE

Line 29: l_new_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

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

Line 32: l_mod_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();

Line 33: l_mod_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:

Line 36: l_del_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_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;
40: l_menu_name varchar2(30);

Line 219: l_new_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

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

Line 222: l_mod_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();

Line 223: l_mod_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:

Line 226: l_del_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_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;
230:

Line 369: l_new_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

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

Line 372: l_mod_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();

Line 373: l_mod_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:

Line 376: l_del_role_sts_menu_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_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;
380: