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.

[Home] [Help]

APPS.PJI_PMV_ENGINE dependencies on PJI_PMV_ORGZ_DIM_TMP

Line 1225: --Bug 4599990. This procedure will insert into PJI_PMV_ORGZ_DIM_TMP all the organizations in the PJI

1221: END IF;
1222: RAISE;
1223: END Convert_Job_Level;
1224:
1225: --Bug 4599990. This procedure will insert into PJI_PMV_ORGZ_DIM_TMP all the organizations in the PJI
1226: --reporting organization hierarchy that fall under the organization selected in the user assignment
1227: --of the person logged in. This is a private procedure and will be called by all the
1228: --convert_organization procedures in this package.
1229: PROCEDURE insert_user_assignment_orgz

Line 1239: INSERT INTO PJI_PMV_ORGZ_DIM_TMP (ID, NAME)

1235: IF p_PA_DEBUG_MODE = 'Y' THEN
1236: Write2FWKLog('Entering insert_user_assignment_orgz...');
1237: END IF;
1238: l_user_id := fnd_global.user_id;
1239: INSERT INTO PJI_PMV_ORGZ_DIM_TMP (ID, NAME)
1240: SELECT sub_organization_id,
1241: org.name
1242: FROM pji_org_denorm orgd,
1243: hr_all_organization_units_tl org,

Line 1287: DELETE PJI_PMV_ORGZ_DIM_TMP;

1283: IF p_PA_DEBUG_MODE = 'Y' THEN
1284: Write2FWKLog('Entering Convert_Organization...','Convert_Organization (for Viewby reports)');
1285: END IF;
1286:
1287: DELETE PJI_PMV_ORGZ_DIM_TMP;
1288:
1289:
1290: IF p_View_BY = 'OG' THEN
1291: IF l_Security_Profile_ID IS NOT NULL THEN

Line 1318: INSERT INTO PJI_PMV_ORGZ_DIM_TMP (ID, NAME)

1314: IF l_View_All_Org_Flag = 'Y' THEN
1315: IF p_PA_DEBUG_MODE = 'Y' THEN
1316: Write2FWKLog('Before insert of immediate sub-org organizations (w/o security)...');
1317: END IF;
1318: INSERT INTO PJI_PMV_ORGZ_DIM_TMP (ID, NAME)
1319: SELECT sub_organization_id
1320: , org.name
1321: FROM pji_org_denorm orgd
1322: , hr_all_organization_units_tl org

Line 1338: INSERT INTO PJI_PMV_ORGZ_DIM_TMP (ID, NAME)

1334: END IF;
1335: --Bug 4599990. Insert if the top org is entered for the security profile.
1336: IF l_top_organization_id IS NOT NULL THEN
1337:
1338: INSERT INTO PJI_PMV_ORGZ_DIM_TMP (ID, NAME)
1339: SELECT sub_organization_id
1340: , org.name
1341: FROM pji_org_denorm orgd
1342: , per_organization_list sec

Line 1388: INSERT INTO PJI_PMV_ORGZ_DIM_TMP (ID, NAME)

1384: END IF;
1385:
1386:
1387: IF p_View_BY = 'OG' THEN
1388: INSERT INTO PJI_PMV_ORGZ_DIM_TMP (ID, NAME)
1389: VALUES (p_Top_Organization_ID, l_Organization_Name);
1390: ELSE
1391: INSERT INTO PJI_PMV_ORGZ_DIM_TMP (ID, NAME)
1392: VALUES (p_Top_Organization_ID, -1);

Line 1391: INSERT INTO PJI_PMV_ORGZ_DIM_TMP (ID, NAME)

1387: IF p_View_BY = 'OG' THEN
1388: INSERT INTO PJI_PMV_ORGZ_DIM_TMP (ID, NAME)
1389: VALUES (p_Top_Organization_ID, l_Organization_Name);
1390: ELSE
1391: INSERT INTO PJI_PMV_ORGZ_DIM_TMP (ID, NAME)
1392: VALUES (p_Top_Organization_ID, -1);
1393: END IF;
1394:
1395:

Line 1431: DELETE PJI_PMV_ORGZ_DIM_TMP;

1427: IF p_PA_DEBUG_MODE = 'Y' THEN
1428: Write2FWKLog('Entering Convert_Organization...','Convert_Organization (for detail reports)');
1429: END IF;
1430:
1431: DELETE PJI_PMV_ORGZ_DIM_TMP;
1432:
1433: IF p_PA_DEBUG_MODE = 'Y' THEN
1434: Write2FWKLog('Before insert of rollup organization...');
1435: END IF;

Line 1466: INSERT INTO PJI_PMV_ORGZ_DIM_TMP (ID, NAME)

1462: IF l_View_All_Org_Flag = 'Y' THEN
1463: IF p_PA_DEBUG_MODE = 'Y' THEN
1464: Write2FWKLog('Before insert of all sub-org organizations (w/o security)...');
1465: END IF;
1466: INSERT INTO PJI_PMV_ORGZ_DIM_TMP (ID, NAME)
1467: SELECT subro_organization_id
1468: , name
1469: FROM hri_cs_orghro_v orgd
1470: , hr_all_organization_units_tl org

Line 1490: INSERT INTO PJI_PMV_ORGZ_DIM_TMP (ID, NAME)

1486:
1487: --Bug 4599990. Insert if the top org is entered for the security profile.
1488: IF l_top_organization_id IS NOT NULL THEN
1489:
1490: INSERT INTO PJI_PMV_ORGZ_DIM_TMP (ID, NAME)
1491: SELECT subro_organization_id
1492: , name
1493: FROM hri_cs_orghro_v orgd
1494: , hr_all_organization_units_tl org

Line 1524: INSERT INTO PJI_PMV_ORGZ_DIM_TMP (ID, NAME)

1520: Write2FWKLog('Before insert of current organization...');
1521: END IF;
1522:
1523:
1524: INSERT INTO PJI_PMV_ORGZ_DIM_TMP (ID, NAME)
1525: SELECT organization_id, name
1526: FROM hr_all_organization_units_tl
1527: WHERE organization_id = p_Top_Organization_ID
1528: AND language = USERENV('LANG');

Line 1534: INSERT INTO PJI_PMV_ORGZ_DIM_TMP (ID, NAME)

1530: IF p_PA_DEBUG_MODE = 'Y' THEN
1531: Write2FWKLog('After insert of current organization...');
1532: END IF;
1533: ELSE
1534: INSERT INTO PJI_PMV_ORGZ_DIM_TMP (ID, NAME)
1535: VALUES (p_Top_Organization_ID,'-1');
1536: IF p_PA_DEBUG_MODE = 'Y' THEN
1537: Write2FWKLog('After insert of rollup organization...');
1538: END IF;

Line 1576: DELETE PJI_PMV_ORGZ_DIM_TMP;

1572: IF p_PA_DEBUG_MODE = 'Y' THEN
1573: Write2FWKLog('Entering Convert_Organization...','Convert_Organization (for discover reports)');
1574: END IF;
1575:
1576: DELETE PJI_PMV_ORGZ_DIM_TMP;
1577:
1578: IF p_PA_DEBUG_MODE = 'Y' THEN
1579: Write2FWKLog('Before insert of all sub organizations...');
1580: END IF;

Line 1619: INSERT INTO PJI_PMV_ORGZ_DIM_TMP (ID, NAME)

1615: IF l_View_All_Org_Flag = 'Y' THEN
1616: IF p_PA_DEBUG_MODE = 'Y' THEN
1617: Write2FWKLog('Before insert of all sub-org organizations (w/o security)...');
1618: END IF;
1619: INSERT INTO PJI_PMV_ORGZ_DIM_TMP (ID, NAME)
1620: SELECT org.organization_id, org.name
1621: FROM pji_org_denorm denorm
1622: , hr_all_organization_units_tl org
1623: WHERE

Line 1639: INSERT INTO PJI_PMV_ORGZ_DIM_TMP (ID, NAME)

1635:
1636: --Bug 4599990. Insert if the top org is entered for the security profile.
1637: IF l_sec_top_org_id IS NOT NULL THEN
1638:
1639: INSERT INTO PJI_PMV_ORGZ_DIM_TMP (ID, NAME)
1640: SELECT org.organization_id, org.name
1641: FROM pji_org_denorm denorm
1642: , hr_all_organization_units_tl org
1643: , per_organization_list seclist