APPS.FPA_SECURITY_PVT dependencies on PA_PROJECT_ROLE_TYPES

Line 201: from pa_project_parties pp, pa_project_role_types_b rlt

197: BEGIN
198:
199: select
200: pp.resource_source_id into l_person_id
201: from pa_project_parties pp, pa_project_role_types_b rlt
202: where pp.object_type = 'PJP_PORTFOLIO'
203: and pp.object_id = p_portfolio_id
204: and PP.project_role_id = rlt.project_role_id
205: and rlt.project_role_type = G_OWNER;

Line 217: p_project_role_id IN PA_PROJECT_ROLE_TYPES.PROJECT_ROLE_ID%TYPE)

213:
214:
215:
216: FUNCTION Get_Role(
217: p_project_role_id IN PA_PROJECT_ROLE_TYPES.PROJECT_ROLE_ID%TYPE)
218: RETURN VARCHAR2 IS
219:
220: l_role VARCHAR2(200) := null;
221: BEGIN

Line 224: from pa_project_role_types_b

220: l_role VARCHAR2(200) := null;
221: BEGIN
222: select
223: project_role_type into l_role
224: from pa_project_role_types_b
225: where project_role_id = p_project_role_id;
226:
227: return l_role;
228: EXCEPTION

Line 234: p_project_role IN PA_PROJECT_ROLE_TYPES.PROJECT_ROLE_TYPE%TYPE)

230: return null;
231: END Get_Role;
232:
233: FUNCTION Get_Role_Id(
234: p_project_role IN PA_PROJECT_ROLE_TYPES.PROJECT_ROLE_TYPE%TYPE)
235: RETURN PA_PROJECT_ROLE_TYPES.PROJECT_ROLE_ID%TYPE IS
236:
237: l_role_id PA_PROJECT_ROLE_TYPES.PROJECT_ROLE_ID%TYPE := null;
238:

Line 235: RETURN PA_PROJECT_ROLE_TYPES.PROJECT_ROLE_ID%TYPE IS

231: END Get_Role;
232:
233: FUNCTION Get_Role_Id(
234: p_project_role IN PA_PROJECT_ROLE_TYPES.PROJECT_ROLE_TYPE%TYPE)
235: RETURN PA_PROJECT_ROLE_TYPES.PROJECT_ROLE_ID%TYPE IS
236:
237: l_role_id PA_PROJECT_ROLE_TYPES.PROJECT_ROLE_ID%TYPE := null;
238:
239: BEGIN

Line 237: l_role_id PA_PROJECT_ROLE_TYPES.PROJECT_ROLE_ID%TYPE := null;

233: FUNCTION Get_Role_Id(
234: p_project_role IN PA_PROJECT_ROLE_TYPES.PROJECT_ROLE_TYPE%TYPE)
235: RETURN PA_PROJECT_ROLE_TYPES.PROJECT_ROLE_ID%TYPE IS
236:
237: l_role_id PA_PROJECT_ROLE_TYPES.PROJECT_ROLE_ID%TYPE := null;
238:
239: BEGIN
240: select
241: project_role_id into l_role_id

Line 242: from pa_project_role_types_b

238:
239: BEGIN
240: select
241: project_role_id into l_role_id
242: from pa_project_role_types_b
243: where project_role_type = p_project_role;
244:
245: return l_role_id;
246: EXCEPTION

Line 662: p_project_role_id IN PA_PROJECT_ROLE_TYPES.PROJECT_ROLE_ID%TYPE,

658: p_api_version IN NUMBER,
659: p_init_msg_list IN VARCHAR2,
660: p_object_id IN PA_PROJECT_PARTIES.OBJECT_ID%TYPE,
661: p_instance_set_name IN VARCHAR2,
662: p_project_role_id IN PA_PROJECT_ROLE_TYPES.PROJECT_ROLE_ID%TYPE,
663: p_party_id IN NUMBER,
664: p_start_date_active IN DATE,
665: p_end_date_active IN DATE,
666: x_portfolio_party_id OUT NOCOPY PA_PROJECT_PARTIES.PROJECT_PARTY_ID%TYPE,

Line 850: p_project_role_id IN PA_PROJECT_ROLE_TYPES.PROJECT_ROLE_ID%TYPE,

846: (
847: p_api_version IN NUMBER,
848: p_init_msg_list IN VARCHAR2,
849: p_portfolio_party_id IN PA_PROJECT_PARTIES.PROJECT_PARTY_ID%TYPE,
850: p_project_role_id IN PA_PROJECT_ROLE_TYPES.PROJECT_ROLE_ID%TYPE,
851: p_start_date_active IN DATE,
852: p_end_date_active IN DATE,
853: x_return_status OUT NOCOPY VARCHAR2,
854: x_msg_count OUT NOCOPY NUMBER,

Line 1159: from pa_project_parties pp, pa_project_role_types_b rlt

1155: select
1156: pp.project_party_id,
1157: pp.resource_source_id,
1158: pp.project_role_id
1159: from pa_project_parties pp, pa_project_role_types_b rlt
1160: where pp.object_type = 'PJP_PORTFOLIO'
1161: and pp.object_id = p_portfolio_id
1162: and PP.project_role_id = rlt.project_role_id
1163: and rlt.project_role_type = G_OWNER;