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.FPA_SECURITY_PVT dependencies on PA_PROJECT_PARTIES

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 466: from pa_project_parties

462:
463: cursor parties_csr (p_project_role_id IN NUMBER,
464: p_party_id IN NUMBER) IS
465: select 'T'
466: from pa_project_parties
467: where project_role_id = p_project_role_id
468: and object_type = 'PJP_PORTFOLIO'
469: and resource_type_id = 101
470: and resource_source_id = p_party_id

Line 641: FROM PA_PROJECT_PARTIES

637: l_flag varchar2(1) := FND_API.G_FALSE;
638: cursor PORTFOLIO_USER_CSR(P_PERSON_ID IN VARCHAR2,
639: P_PORTFOLIO_ID IN NUMBER) is
640: SELECT 'T'
641: FROM PA_PROJECT_PARTIES
642: WHERE OBJECT_TYPE = 'PJP_PORTFOLIO'
643: AND OBJECT_ID = P_PORTFOLIO_ID
644: AND RESOURCE_SOURCE_ID = P_PERSON_ID;
645:

Line 660: p_object_id IN PA_PROJECT_PARTIES.OBJECT_ID%TYPE,

656:
657: PROCEDURE Create_Portfolio_User(
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,

Line 666: x_portfolio_party_id OUT NOCOPY PA_PROJECT_PARTIES.PROJECT_PARTY_ID%TYPE,

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,
667: x_return_status OUT NOCOPY VARCHAR2,
668: x_msg_count OUT NOCOPY NUMBER,
669: x_msg_data OUT NOCOPY VARCHAR2) IS
670:

Line 748: PA_PROJECT_PARTIES_PVT.Create_Project_Party(

744: l_msg_log := 'FPA_SEC_OWNER_ROLE_EXISTS'||p_project_role_id||','||p_object_id;
745: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
746: end if;
747:
748: PA_PROJECT_PARTIES_PVT.Create_Project_Party(
749: p_commit => FND_API.G_FALSE,
750: p_validate_only => FND_API.G_FALSE,
751: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
752: p_debug_Mode => 'N',

Line 849: p_portfolio_party_id IN PA_PROJECT_PARTIES.PROJECT_PARTY_ID%TYPE,

845: PROCEDURE Update_Portfolio_User
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,

Line 878: from pa_project_parties

874: end_date_active,
875: scheduled_flag,
876: record_version_number,
877: grant_id
878: from pa_project_parties
879: where project_party_id = p_project_party_id;
880:
881: l_wf_type VARCHAR2(250);
882: l_wf_item_type VARCHAR2(250);

Line 977: PA_PROJECT_PARTIES_PVT.UPDATE_PROJECT_PARTY(

973: PROFILE OPTION IF BELOW CALL WITH VALIDATIONS CAN BE USED.
974: */
975:
976: /*
977: PA_PROJECT_PARTIES_PVT.UPDATE_PROJECT_PARTY(
978: p_commit => FND_API.G_FALSE,
979: p_validate_only => FND_API.G_FALSE,
980: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
981: p_debug_mode => 'N',

Line 1016: pa_project_parties_utils.validate_project_party(

1012: end if;
1013: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
1014: */
1015:
1016: pa_project_parties_utils.validate_project_party(
1017: FND_API.G_VALID_LEVEL_FULL,
1018: 'N',
1019: l_object_id,
1020: l_object_type,

Line 1045: UPDATE pa_project_parties SET

1041: l_msg_log := p_portfolio_party_id||','||l_project_role_id;
1042: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1043: end if;
1044:
1045: UPDATE pa_project_parties SET
1046: project_role_id = p_project_role_id,
1047: start_date_active = l_start_date_active,
1048: end_date_active = l_end_date_active,
1049: last_update_date = sysdate,

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;

Line 1239: PA_PROJECT_PARTIES_PVT.UPDATE_PROJECT_PARTY(

1235: */
1236:
1237: /*
1238:
1239: PA_PROJECT_PARTIES_PVT.UPDATE_PROJECT_PARTY(
1240: p_commit => FND_API.G_FALSE,
1241: p_validate_only => FND_API.G_FALSE,
1242: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1243: p_debug_mode => 'N',

Line 1285: UPDATE pa_project_parties SET

1281: WHEN "PA_INSTALL.IS_PRM_LICENSED()" IS 'Y'. NEED TO FIND OUT DETAILS ON THE
1282: PROFILE OPTION IF ABOVE CALL WITH VALIDATIONS CAN BE USED.
1283: */
1284:
1285: UPDATE pa_project_parties SET
1286: resource_source_id = p_person_id
1287: WHERE project_party_id = l_project_party_id;
1288:
1289: Revoke_Role(p_api_version => l_api_version,

Line 1376: p_portfolio_party_id -> pa_project_parties.project_party_id.

1372:
1373: /* ***************************************************************
1374: Desc: Call to delete portfolio user and the the grant for the role.
1375: parameters:
1376: p_portfolio_party_id -> pa_project_parties.project_party_id.
1377: ***************************************************************** */
1378:
1379: PROCEDURE Delete_Portfolio_User
1380: (

Line 1383: p_portfolio_party_id IN PA_PROJECT_PARTIES.PROJECT_PARTY_ID%TYPE,

1379: PROCEDURE Delete_Portfolio_User
1380: (
1381: p_api_version IN NUMBER,
1382: p_init_msg_list IN VARCHAR2,
1383: p_portfolio_party_id IN PA_PROJECT_PARTIES.PROJECT_PARTY_ID%TYPE,
1384: p_instance_set_name IN VARCHAR2,
1385: x_return_status OUT NOCOPY VARCHAR2,
1386: x_msg_count OUT NOCOPY NUMBER,
1387: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 1391: FROM pa_project_parties

1387: x_msg_data OUT NOCOPY VARCHAR2) IS
1388:
1389: CURSOR project_parties_csr (p_portfolio_party_id in number) IS
1390: SELECT project_role_id, resource_source_id, object_id
1391: FROM pa_project_parties
1392: WHERE project_party_id = p_portfolio_party_id;
1393:
1394: CURSOR verify_delete_csr (p_portfolio_party_id in number) IS
1395: SELECT 'T'

Line 1396: FROM pa_project_parties

1392: WHERE project_party_id = p_portfolio_party_id;
1393:
1394: CURSOR verify_delete_csr (p_portfolio_party_id in number) IS
1395: SELECT 'T'
1396: FROM pa_project_parties
1397: WHERE project_party_id = p_portfolio_party_id;
1398:
1399:
1400: l_role_id number;

Line 1455: -- l_grant_id := pa_project_parties_utils.get_grant_id(

1451: l_msg_log := 'FPA_SEC_DELETE_FAILED'||p_portfolio_party_id;
1452: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1453: end if;
1454: close project_parties_csr;
1455: -- l_grant_id := pa_project_parties_utils.get_grant_id(
1456: -- p_project_party_id => p_portfolio_party_id);
1457:
1458: PA_PROJECT_PARTIES_PKG.Delete_Row(x_project_id => null,
1459: x_project_party_id => p_portfolio_party_id,

Line 1458: PA_PROJECT_PARTIES_PKG.Delete_Row(x_project_id => null,

1454: close project_parties_csr;
1455: -- l_grant_id := pa_project_parties_utils.get_grant_id(
1456: -- p_project_party_id => p_portfolio_party_id);
1457:
1458: PA_PROJECT_PARTIES_PKG.Delete_Row(x_project_id => null,
1459: x_project_party_id => p_portfolio_party_id,
1460: x_record_version_number => null);
1461:
1462: -- no return status verifying delete ?