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_VARCHAR2_30_TBL_TYPE

Line 1057: l_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := null;

1053: l_grantee_key fnd_grants.grantee_key%TYPE;
1054: l_grant_exists VARCHAR2(1);
1055: l_status_level VARCHAR2(30);
1056: l_default_menu_name fnd_menus.menu_name%TYPE := null;
1057: l_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
1058: l_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
1059: l_menu_name_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
1060: l_exp_error varchar2(1) := 'F';
1061: l_unexp_error varchar2(1) := 'F';

Line 1058: l_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := null;

1054: l_grant_exists VARCHAR2(1);
1055: l_status_level VARCHAR2(30);
1056: l_default_menu_name fnd_menus.menu_name%TYPE := null;
1057: l_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
1058: l_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
1059: l_menu_name_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
1060: l_exp_error varchar2(1) := 'F';
1061: l_unexp_error varchar2(1) := 'F';
1062: l_parameter2 fnd_grants.parameter2%TYPE;

Line 1059: l_menu_name_tbl SYSTEM.pa_varchar2_30_tbl_type := null;

1055: l_status_level VARCHAR2(30);
1056: l_default_menu_name fnd_menus.menu_name%TYPE := null;
1057: l_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
1058: l_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
1059: l_menu_name_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
1060: l_exp_error varchar2(1) := 'F';
1061: l_unexp_error varchar2(1) := 'F';
1062: l_parameter2 fnd_grants.parameter2%TYPE;
1063: l_role_status_menu_id_tbl SYSTEM.pa_num_tbl_type := null;

Line 2276: l_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := null;

2272: l_grantee_key fnd_grants.grantee_key%TYPE;
2273: l_grant_exists VARCHAR2(1);
2274: l_status_level VARCHAR2(30);
2275: l_default_menu_name fnd_menus.menu_name%TYPE := null;
2276: l_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
2277: l_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
2278: l_menu_name_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
2279: l_exp_error varchar2(1) := 'F';
2280: l_unexp_error varchar2(1) := 'F';

Line 2277: l_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := null;

2273: l_grant_exists VARCHAR2(1);
2274: l_status_level VARCHAR2(30);
2275: l_default_menu_name fnd_menus.menu_name%TYPE := null;
2276: l_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
2277: l_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
2278: l_menu_name_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
2279: l_exp_error varchar2(1) := 'F';
2280: l_unexp_error varchar2(1) := 'F';
2281: l_parameter2 fnd_grants.parameter2%TYPE;

Line 2278: l_menu_name_tbl SYSTEM.pa_varchar2_30_tbl_type := null;

2274: l_status_level VARCHAR2(30);
2275: l_default_menu_name fnd_menus.menu_name%TYPE := null;
2276: l_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
2277: l_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
2278: l_menu_name_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
2279: l_exp_error varchar2(1) := 'F';
2280: l_unexp_error varchar2(1) := 'F';
2281: l_parameter2 fnd_grants.parameter2%TYPE;
2282: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 2519: p_new_status_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,

2515: ( p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2516: p_debug_mode in varchar2 default 'N',
2517: p_project_role_id IN number,
2518: p_status_level IN pa_project_role_types_b.status_level%TYPE,
2519: p_new_status_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2520: p_new_status_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2521: p_new_menu_name_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2522: p_new_role_sts_menu_id_tbl IN SYSTEM.pa_num_tbl_type := null,
2523: p_mod_status_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,

Line 2520: p_new_status_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,

2516: p_debug_mode in varchar2 default 'N',
2517: p_project_role_id IN number,
2518: p_status_level IN pa_project_role_types_b.status_level%TYPE,
2519: p_new_status_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2520: p_new_status_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2521: p_new_menu_name_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2522: p_new_role_sts_menu_id_tbl IN SYSTEM.pa_num_tbl_type := null,
2523: p_mod_status_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2524: p_mod_status_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,

Line 2521: p_new_menu_name_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,

2517: p_project_role_id IN number,
2518: p_status_level IN pa_project_role_types_b.status_level%TYPE,
2519: p_new_status_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2520: p_new_status_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2521: p_new_menu_name_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2522: p_new_role_sts_menu_id_tbl IN SYSTEM.pa_num_tbl_type := null,
2523: p_mod_status_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2524: p_mod_status_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2525: p_mod_menu_id_tbl IN SYSTEM.pa_num_tbl_type := null,

Line 2523: p_mod_status_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,

2519: p_new_status_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2520: p_new_status_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2521: p_new_menu_name_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2522: p_new_role_sts_menu_id_tbl IN SYSTEM.pa_num_tbl_type := null,
2523: p_mod_status_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2524: p_mod_status_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2525: p_mod_menu_id_tbl IN SYSTEM.pa_num_tbl_type := null,
2526: p_mod_role_sts_menu_id_tbl IN SYSTEM.pa_num_tbl_type := null,
2527: p_del_status_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,

Line 2524: p_mod_status_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,

2520: p_new_status_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2521: p_new_menu_name_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2522: p_new_role_sts_menu_id_tbl IN SYSTEM.pa_num_tbl_type := null,
2523: p_mod_status_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2524: p_mod_status_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2525: p_mod_menu_id_tbl IN SYSTEM.pa_num_tbl_type := null,
2526: p_mod_role_sts_menu_id_tbl IN SYSTEM.pa_num_tbl_type := null,
2527: p_del_status_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2528: p_del_status_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,

Line 2527: p_del_status_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,

2523: p_mod_status_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2524: p_mod_status_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2525: p_mod_menu_id_tbl IN SYSTEM.pa_num_tbl_type := null,
2526: p_mod_role_sts_menu_id_tbl IN SYSTEM.pa_num_tbl_type := null,
2527: p_del_status_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2528: p_del_status_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2529: p_del_role_sts_menu_id_tbl IN SYSTEM.pa_num_tbl_type := null,
2530: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2531: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 2528: p_del_status_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,

2524: p_mod_status_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2525: p_mod_menu_id_tbl IN SYSTEM.pa_num_tbl_type := null,
2526: p_mod_role_sts_menu_id_tbl IN SYSTEM.pa_num_tbl_type := null,
2527: p_del_status_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2528: p_del_status_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,
2529: p_del_role_sts_menu_id_tbl IN SYSTEM.pa_num_tbl_type := null,
2530: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2531: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2532: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895