APPS.PJI_PMV_ENGINE dependencies on PER_SECURITY_PROFILES

Line 1281: l_top_organization_id per_security_profiles.organization_id%TYPE;

1277: l_Security_Profile_ID NUMBER:=fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL');
1278: l_View_All_Org_Flag VARCHAR2(30);
1279:
1280: --Bug 4599990.
1281: l_top_organization_id per_security_profiles.organization_id%TYPE;
1282: BEGIN
1283: IF p_PA_DEBUG_MODE = 'Y' THEN
1284: Write2FWKLog('Entering Convert_Organization...','Convert_Organization (for Viewby reports)');
1285: END IF;

Line 1296: --Bug 4599990. Selected other relavant data from the per_security_profiles.

1292: IF p_PA_DEBUG_MODE = 'Y' THEN
1293: Write2FWKLog('Before checking if view_all_organizations_flag is set...');
1294: END IF;
1295: BEGIN
1296: --Bug 4599990. Selected other relavant data from the per_security_profiles.
1297: SELECT view_all_organizations_flag,
1298: organization_id
1299: INTO l_View_All_Org_Flag,
1300: l_top_organization_id

Line 1301: FROM per_security_profiles

1297: SELECT view_all_organizations_flag,
1298: organization_id
1299: INTO l_View_All_Org_Flag,
1300: l_top_organization_id
1301: FROM per_security_profiles
1302: WHERE security_profile_id = l_Security_Profile_ID;
1303: IF p_PA_DEBUG_MODE = 'Y' THEN
1304: Write2FWKLog('view_all_organizations_flag is set...');
1305: END IF;

Line 1425: l_top_organization_id per_security_profiles.organization_id%TYPE;

1421: AS
1422: l_Security_Profile_ID NUMBER:=fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL');
1423: l_View_All_Org_Flag VARCHAR2(30);
1424: --Bug 4599990.
1425: l_top_organization_id per_security_profiles.organization_id%TYPE;
1426: BEGIN
1427: IF p_PA_DEBUG_MODE = 'Y' THEN
1428: Write2FWKLog('Entering Convert_Organization...','Convert_Organization (for detail reports)');
1429: END IF;

Line 1443: --Bug 4599990. Selected other relavant data from the per_security_profiles.

1439: IF p_PA_DEBUG_MODE = 'Y' THEN
1440: Write2FWKLog('Before checking if view_all_organizations_flag is set...');
1441: END IF;
1442: BEGIN
1443: --Bug 4599990. Selected other relavant data from the per_security_profiles.
1444: SELECT view_all_organizations_flag,
1445: organization_id
1446: INTO l_View_All_Org_Flag,
1447: l_top_organization_id

Line 1448: FROM per_security_profiles

1444: SELECT view_all_organizations_flag,
1445: organization_id
1446: INTO l_View_All_Org_Flag,
1447: l_top_organization_id
1448: FROM per_security_profiles
1449: WHERE security_profile_id = l_Security_Profile_ID;
1450: IF p_PA_DEBUG_MODE = 'Y' THEN
1451: Write2FWKLog('view_all_organizations_flag is set...');
1452: END IF;

Line 1569: l_sec_top_org_id per_security_profiles.organization_id%TYPE;

1565: l_View_All_Org_Flag VARCHAR2(30);
1566: l_Top_Organization_ID NUMBER:=p_Top_Organization_ID;
1567:
1568: --Bug 4599990.
1569: l_sec_top_org_id per_security_profiles.organization_id%TYPE;
1570:
1571: BEGIN
1572: IF p_PA_DEBUG_MODE = 'Y' THEN
1573: Write2FWKLog('Entering Convert_Organization...','Convert_Organization (for discover reports)');

Line 1596: --Bug 4599990.Selected other relavant data from the per_security_profiles.

1592: IF p_PA_DEBUG_MODE = 'Y' THEN
1593: Write2FWKLog('Before checking if view_all_organizations_flag is set...');
1594: END IF;
1595: BEGIN
1596: --Bug 4599990.Selected other relavant data from the per_security_profiles.
1597: SELECT view_all_organizations_flag,
1598: organization_id
1599: INTO l_View_All_Org_Flag,
1600: l_sec_top_org_id

Line 1601: FROM per_security_profiles

1597: SELECT view_all_organizations_flag,
1598: organization_id
1599: INTO l_View_All_Org_Flag,
1600: l_sec_top_org_id
1601: FROM per_security_profiles
1602: WHERE security_profile_id = l_Security_Profile_ID;
1603: IF p_PA_DEBUG_MODE = 'Y' THEN
1604: Write2FWKLog('view_all_organizations_flag is set...');
1605: END IF;

Line 1740: FROM per_security_profiles

1736: END IF;
1737: BEGIN
1738: SELECT view_all_organizations_flag
1739: INTO l_View_All_Org_Flag
1740: FROM per_security_profiles
1741: WHERE security_profile_id = l_Security_Profile_ID;
1742: IF p_PA_DEBUG_MODE = 'Y' THEN
1743: Write2FWKLog('view_all_organizations_flag is set...');
1744: END IF;