APPS.PA_SECURITY_PVT dependencies on PA_PROJECT_ROLE_TYPES

Line 389: pa_project_role_types roletypes

385: cursor c_role_sec_enabled is
386: select 'Y'
387: from fnd_user users,
388: pa_project_parties ppp,
389: pa_project_role_types roletypes
390: where decode (p_source_type, 'PERSON', users.employee_id,
391: 'HZ_PARTY', users.customer_id)
392: = ppp.resource_source_id
393: and ppp.resource_type_id= decode(p_source_type, 'PERSON', 101,

Line 440: --pa_project_role_types roletypes --bug 4004821

436: cursor c_unsecured_role is
437: select 'Y'
438: from fnd_user users,
439: pa_project_parties ppp,
440: --pa_project_role_types roletypes --bug 4004821
441: pa_project_role_types_b roletypes
442: where decode (p_source_type, 'PERSON', users.employee_id,
443: 'HZ_PARTY', users.person_party_id) -- Bug 4527617. Replaced customer_id with person_party_id.
444: = ppp.resource_source_id

Line 441: pa_project_role_types_b roletypes

437: select 'Y'
438: from fnd_user users,
439: pa_project_parties ppp,
440: --pa_project_role_types roletypes --bug 4004821
441: pa_project_role_types_b roletypes
442: where decode (p_source_type, 'PERSON', users.employee_id,
443: 'HZ_PARTY', users.person_party_id) -- Bug 4527617. Replaced customer_id with person_party_id.
444: = ppp.resource_source_id
445: and ppp.resource_type_id= decode(p_source_type,'PERSON',101,

Line 1648: --pa_project_role_types role

1644: begin
1645: select menu.menu_name
1646: into v_menu_name
1647: from fnd_menus menu,
1648: --pa_project_role_types role
1649: pa_project_role_types_b role --Bug 4867700
1650: where menu.menu_id=role.menu_id
1651: and role.project_role_id= p_project_role_id;
1652: return v_menu_name;

Line 1649: pa_project_role_types_b role --Bug 4867700

1645: select menu.menu_name
1646: into v_menu_name
1647: from fnd_menus menu,
1648: --pa_project_role_types role
1649: pa_project_role_types_b role --Bug 4867700
1650: where menu.menu_id=role.menu_id
1651: and role.project_role_id= p_project_role_id;
1652: return v_menu_name;
1653: exception

Line 1692: pa_project_role_types role

1688: begin
1689: select menu.menu_name
1690: into v_menu_name
1691: from fnd_menus menu,
1692: pa_project_role_types role
1693: where menu.menu_id=role.menu_id
1694: and role.meaning= p_project_role_name;
1695: return v_menu_name;
1696: exception

Line 1744: --from pa_project_role_types --bug 4004821

1740: v_menu_id number;
1741: l_api_name varchar2(30):='get_menu_id_for_role';
1742: begin
1743: select menu_id into v_menu_id
1744: --from pa_project_role_types --bug 4004821
1745: from pa_project_role_types_b
1746: where project_role_id =p_project_role_id;
1747: return v_menu_id;
1748: exception

Line 1745: from pa_project_role_types_b

1741: l_api_name varchar2(30):='get_menu_id_for_role';
1742: begin
1743: select menu_id into v_menu_id
1744: --from pa_project_role_types --bug 4004821
1745: from pa_project_role_types_b
1746: where project_role_id =p_project_role_id;
1747: return v_menu_id;
1748: exception
1749: when no_data_found then

Line 1770: from pa_project_role_types

1766: v_role_name varchar2(80);
1767: begin
1768: select meaning
1769: into v_role_name
1770: from pa_project_role_types
1771: where project_role_id =p_project_role_id;
1772: return v_role_name;
1773: exception
1774: when others then

Line 2518: p_status_level IN pa_project_role_types_b.status_level%TYPE,

2514: PROCEDURE update_status_based_sec
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,