eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_SECURITY_PVT dependencies on PA_NUM_TBL_TYPE

Line 1052: l_role_status_menu_id_tbl SYSTEM.pa_num_tbl_type := null;

1048: l_menu_name_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
1049: l_exp_error varchar2(1) := 'F';
1050: l_unexp_error varchar2(1) := 'F';
1051: l_parameter2 fnd_grants.parameter2%TYPE;
1052: l_role_status_menu_id_tbl SYSTEM.pa_num_tbl_type := null;
1053: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1054: l_error_message_code VARCHAR2(30);
1055:
1056: begin

Line 2274: l_role_status_menu_id_tbl SYSTEM.pa_num_tbl_type := null;

2270: l_parameter2 fnd_grants.parameter2%TYPE;
2271: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2272: l_error_message_code VARCHAR2(30);
2273: l_grant_guid fnd_grants.grant_guid%TYPE;
2274: l_role_status_menu_id_tbl SYSTEM.pa_num_tbl_type := null;
2275:
2276: cursor get_resources_on_role is
2277: select distinct ppp.resource_type_id,ppp.resource_source_id
2278: -- , wfr.name grantee_key

Line 2511: p_new_role_sts_menu_id_tbl IN SYSTEM.pa_num_tbl_type := null,

2507: p_status_level IN pa_project_role_types_b.status_level%TYPE,
2508: p_new_status_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2509: p_new_status_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2510: p_new_menu_name_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2511: p_new_role_sts_menu_id_tbl IN SYSTEM.pa_num_tbl_type := null,
2512: p_mod_status_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2513: p_mod_status_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2514: p_mod_menu_id_tbl IN SYSTEM.pa_num_tbl_type := null,
2515: p_mod_role_sts_menu_id_tbl IN SYSTEM.pa_num_tbl_type := null,

Line 2514: p_mod_menu_id_tbl IN SYSTEM.pa_num_tbl_type := null,

2510: p_new_menu_name_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2511: p_new_role_sts_menu_id_tbl IN SYSTEM.pa_num_tbl_type := null,
2512: p_mod_status_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2513: p_mod_status_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2514: p_mod_menu_id_tbl IN SYSTEM.pa_num_tbl_type := null,
2515: p_mod_role_sts_menu_id_tbl IN SYSTEM.pa_num_tbl_type := null,
2516: p_del_status_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2517: p_del_status_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2518: p_del_role_sts_menu_id_tbl IN SYSTEM.pa_num_tbl_type := null,

Line 2515: p_mod_role_sts_menu_id_tbl IN SYSTEM.pa_num_tbl_type := null,

2511: p_new_role_sts_menu_id_tbl IN SYSTEM.pa_num_tbl_type := null,
2512: p_mod_status_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2513: p_mod_status_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2514: p_mod_menu_id_tbl IN SYSTEM.pa_num_tbl_type := null,
2515: p_mod_role_sts_menu_id_tbl IN SYSTEM.pa_num_tbl_type := null,
2516: p_del_status_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2517: p_del_status_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2518: p_del_role_sts_menu_id_tbl IN SYSTEM.pa_num_tbl_type := null,
2519: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 2518: p_del_role_sts_menu_id_tbl IN SYSTEM.pa_num_tbl_type := null,

2514: p_mod_menu_id_tbl IN SYSTEM.pa_num_tbl_type := null,
2515: p_mod_role_sts_menu_id_tbl IN SYSTEM.pa_num_tbl_type := null,
2516: p_del_status_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2517: p_del_status_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2518: p_del_role_sts_menu_id_tbl IN SYSTEM.pa_num_tbl_type := null,
2519: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2520: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2521: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2522: ) is