APPS.PA_SECURITY_PVT dependencies on PA_PROJECT_ROLE_TYPES

Line 379: pa_project_role_types roletypes

375: cursor c_role_sec_enabled is
376: select 'Y'
377: from fnd_user users,
378: pa_project_parties ppp,
379: pa_project_role_types roletypes
380: where decode (p_source_type, 'PERSON', users.employee_id,
381: 'HZ_PARTY', users.customer_id)
382: = ppp.resource_source_id
383: and ppp.resource_type_id= decode(p_source_type, 'PERSON', 101,

Line 430: --pa_project_role_types roletypes --bug 4004821

426: cursor c_unsecured_role is
427: select 'Y'
428: from fnd_user users,
429: pa_project_parties ppp,
430: --pa_project_role_types roletypes --bug 4004821
431: pa_project_role_types_b roletypes
432: where decode (p_source_type, 'PERSON', users.employee_id,
433: 'HZ_PARTY', users.person_party_id) -- Bug 4527617. Replaced customer_id with person_party_id.
434: = ppp.resource_source_id

Line 431: pa_project_role_types_b roletypes

427: select 'Y'
428: from fnd_user users,
429: pa_project_parties ppp,
430: --pa_project_role_types roletypes --bug 4004821
431: pa_project_role_types_b roletypes
432: where decode (p_source_type, 'PERSON', users.employee_id,
433: 'HZ_PARTY', users.person_party_id) -- Bug 4527617. Replaced customer_id with person_party_id.
434: = ppp.resource_source_id
435: and ppp.resource_type_id= decode(p_source_type,'PERSON',101,

Line 1637: --pa_project_role_types role

1633: begin
1634: select menu.menu_name
1635: into v_menu_name
1636: from fnd_menus menu,
1637: --pa_project_role_types role
1638: pa_project_role_types_b role --Bug 4867700
1639: where menu.menu_id=role.menu_id
1640: and role.project_role_id= p_project_role_id;
1641: return v_menu_name;

Line 1638: pa_project_role_types_b role --Bug 4867700

1634: select menu.menu_name
1635: into v_menu_name
1636: from fnd_menus menu,
1637: --pa_project_role_types role
1638: pa_project_role_types_b role --Bug 4867700
1639: where menu.menu_id=role.menu_id
1640: and role.project_role_id= p_project_role_id;
1641: return v_menu_name;
1642: exception

Line 1681: pa_project_role_types role

1677: begin
1678: select menu.menu_name
1679: into v_menu_name
1680: from fnd_menus menu,
1681: pa_project_role_types role
1682: where menu.menu_id=role.menu_id
1683: and role.meaning= p_project_role_name;
1684: return v_menu_name;
1685: exception

Line 1733: --from pa_project_role_types --bug 4004821

1729: v_menu_id number;
1730: l_api_name varchar2(30):='get_menu_id_for_role';
1731: begin
1732: select menu_id into v_menu_id
1733: --from pa_project_role_types --bug 4004821
1734: from pa_project_role_types_b
1735: where project_role_id =p_project_role_id;
1736: return v_menu_id;
1737: exception

Line 1734: from pa_project_role_types_b

1730: l_api_name varchar2(30):='get_menu_id_for_role';
1731: begin
1732: select menu_id into v_menu_id
1733: --from pa_project_role_types --bug 4004821
1734: from pa_project_role_types_b
1735: where project_role_id =p_project_role_id;
1736: return v_menu_id;
1737: exception
1738: when no_data_found then

Line 1759: from pa_project_role_types

1755: v_role_name varchar2(80);
1756: begin
1757: select meaning
1758: into v_role_name
1759: from pa_project_role_types
1760: where project_role_id =p_project_role_id;
1761: return v_role_name;
1762: exception
1763: when others then

Line 2507: p_status_level IN pa_project_role_types_b.status_level%TYPE,

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