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 1046: l_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := null;

1042: l_grantee_key fnd_grants.grantee_key%TYPE;
1043: l_grant_exists VARCHAR2(1);
1044: l_status_level VARCHAR2(30);
1045: l_default_menu_name fnd_menus.menu_name%TYPE := null;
1046: l_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
1047: l_status_code_tbl SYSTEM.pa_varchar2_30_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';

Line 1047: l_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := null;

1043: l_grant_exists VARCHAR2(1);
1044: l_status_level VARCHAR2(30);
1045: l_default_menu_name fnd_menus.menu_name%TYPE := null;
1046: l_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
1047: l_status_code_tbl SYSTEM.pa_varchar2_30_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;

Line 1048: l_menu_name_tbl SYSTEM.pa_varchar2_30_tbl_type := null;

1044: l_status_level VARCHAR2(30);
1045: l_default_menu_name fnd_menus.menu_name%TYPE := null;
1046: l_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
1047: l_status_code_tbl SYSTEM.pa_varchar2_30_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;

Line 2265: l_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := null;

2261: l_grantee_key fnd_grants.grantee_key%TYPE;
2262: l_grant_exists VARCHAR2(1);
2263: l_status_level VARCHAR2(30);
2264: l_default_menu_name fnd_menus.menu_name%TYPE := null;
2265: l_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
2266: l_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
2267: l_menu_name_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
2268: l_exp_error varchar2(1) := 'F';
2269: l_unexp_error varchar2(1) := 'F';

Line 2266: l_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := null;

2262: l_grant_exists VARCHAR2(1);
2263: l_status_level VARCHAR2(30);
2264: l_default_menu_name fnd_menus.menu_name%TYPE := null;
2265: l_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
2266: l_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
2267: l_menu_name_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
2268: l_exp_error varchar2(1) := 'F';
2269: l_unexp_error varchar2(1) := 'F';
2270: l_parameter2 fnd_grants.parameter2%TYPE;

Line 2267: l_menu_name_tbl SYSTEM.pa_varchar2_30_tbl_type := null;

2263: l_status_level VARCHAR2(30);
2264: l_default_menu_name fnd_menus.menu_name%TYPE := null;
2265: l_status_type_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
2266: l_status_code_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
2267: l_menu_name_tbl SYSTEM.pa_varchar2_30_tbl_type := null;
2268: l_exp_error varchar2(1) := 'F';
2269: l_unexp_error varchar2(1) := 'F';
2270: l_parameter2 fnd_grants.parameter2%TYPE;
2271: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

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

2504: ( p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2505: p_debug_mode in varchar2 default 'N',
2506: p_project_role_id IN number,
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,

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

2505: p_debug_mode in varchar2 default 'N',
2506: p_project_role_id IN number,
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,

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

2506: p_project_role_id IN number,
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,

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

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,
2516: p_del_status_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := null,

Line 2513: p_mod_status_type_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,
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,

Line 2516: p_del_status_code_tbl IN SYSTEM.pa_varchar2_30_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
2520: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 2517: p_del_status_type_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
2520: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2521: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895