APPS.BSC_SCORECARD_PVT dependencies on FND_GRANTS

Line 1340: l_grant_guid FND_GRANTS.grant_guid%TYPE;

1336: AND SYSDATE BETWEEN ur.Start_Date AND NVL(ur.End_Date, SYSDATE);
1337:
1338:
1339: l_count NUMBER;
1340: l_grant_guid FND_GRANTS.grant_guid%TYPE;
1341: l_success VARCHAR2(5);
1342: l_errorcode NUMBER;
1343: l_user_name VARCHAR2(256);
1344:

Line 1365: FND_GRANTS_PKG.GRANT_FUNCTION

1361: END IF;
1362:
1363: /*User name can never be null, so no need to check for null condition*/
1364:
1365: FND_GRANTS_PKG.GRANT_FUNCTION
1366: (
1367: p_api_version => 1.0
1368: ,p_menu_name => BSC_ADMIN_ACCESS
1369: ,p_object_name => BSC_OBJECT_NAME

Line 1382: --DBMS_OUTPUT.PUT_LINE('BSC_SCORECARD_PVT.Grant_Scorecard_Access Failed: at FND_GRANTS_DELETE_PKG.GRANT_FUNCTION );

1378: ,x_success => l_success
1379: ,x_errorcode => l_errorcode
1380: );
1381: IF (l_success <> FND_API.G_TRUE) THEN
1382: --DBMS_OUTPUT.PUT_LINE('BSC_SCORECARD_PVT.Grant_Scorecard_Access Failed: at FND_GRANTS_DELETE_PKG.GRANT_FUNCTION );
1383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1384: END IF;
1385:
1386: /****************************************************

Line 1395: FND_GRANTS_PKG.GRANT_FUNCTION

1391:
1392: FOR user_pool IN c_BscUserPool LOOP
1393: l_user_name := user_pool.user_name;
1394: IF(UPPER(l_user_name)<>UPPER(p_user_name)) THEN
1395: FND_GRANTS_PKG.GRANT_FUNCTION
1396: (
1397: p_api_version => 1.0
1398: ,p_menu_name => BSC_VIEWER_ACCESS
1399: ,p_object_name => BSC_OBJECT_NAME

Line 1412: --DBMS_OUTPUT.PUT_LINE('BSC_SCORECARD_PVT.Grant_Scorecard_Access Failed: at FND_GRANTS_DELETE_PKG.GRANT_FUNCTION );

1408: ,x_success => l_success
1409: ,x_errorcode => l_errorcode
1410: );
1411: IF (l_success <> FND_API.G_TRUE) THEN
1412: --DBMS_OUTPUT.PUT_LINE('BSC_SCORECARD_PVT.Grant_Scorecard_Access Failed: at FND_GRANTS_DELETE_PKG.GRANT_FUNCTION );
1413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1414: END IF;
1415: END IF;
1416: END LOOP;

Line 1447: This procedure Should be CALLED TO remove the records from FND_Grants table

1443:
1444: /************************************************************************************
1445: PROCEDURE Remove_Scorecard_Grants
1446: Description :
1447: This procedure Should be CALLED TO remove the records from FND_Grants table
1448: after the scorecard is deleted.
1449:
1450: Input : p_tab_id,
1451: p_user_name

Line 1481: FND_GRANTS_PKG.delete_grant

1477:
1478:
1479: /*FOR user_pool IN c_BscUserPool LOOP
1480:
1481: FND_GRANTS_PKG.delete_grant
1482: (
1483: p_grantee_type => BSC_GRANTEE_TYPE
1484: , p_object_name => BSC_OBJECT_NAME
1485: , p_grantee_key => upper(user_pool.user_name)

Line 1498: --DBMS_OUTPUT.PUT_LINE('BSC_SCORECARD_PVT.Remove_Scorecard_Grants Failed: at FND_GRANTS_DELETE_PKG.delete_grant );

1494: , x_errcode => l_errorcode
1495: );
1496:
1497: IF (l_success <> FND_API.G_TRUE) THEN
1498: --DBMS_OUTPUT.PUT_LINE('BSC_SCORECARD_PVT.Remove_Scorecard_Grants Failed: at FND_GRANTS_DELETE_PKG.delete_grant );
1499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1500: END IF;
1501: END LOOP; */
1502:

Line 1508: DELETE FROM FND_GRANTS

1504: INTO l_object_id
1505: FROM FND_OBJECTS
1506: WHERE OBJ_NAME = 'BSC_TAB';
1507:
1508: DELETE FROM FND_GRANTS
1509: WHERE OBJECT_ID = TO_CHAR(l_object_id)
1510: AND INSTANCE_TYPE = 'INSTANCE'
1511: AND INSTANCE_PK1_VALUE = TO_CHAR(p_tab_id)
1512: AND PROGRAM_NAME = 'BSC_PMD_GRANTS';

Line 1550: FND_GRANTS_PKG.REVOKE_GRANT( p_api_version => p_api_version

1546: WHILE (is_more( p_grant_uids => l_grant_guids
1547: , p_grant_uid => l_single_grant_guid)
1548: ) LOOP
1549: begin
1550: FND_GRANTS_PKG.REVOKE_GRANT( p_api_version => p_api_version
1551: , p_grant_guid => l_single_grant_guid
1552: , x_success => xa_success
1553: , x_errorcode => xa_errorcode
1554: );