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.PJI_PJP_SUM_DENORM dependencies on PA_RBS_DENORM

Line 1434: from PA_RBS_DENORM

1430: end if;
1431:
1432: /* Commented for Bug 9099240
1433: delete
1434: from PA_RBS_DENORM
1435: where 1=1
1436: and STRUCT_VERSION_ID = p_rbs_version_id;
1437: */
1438: -- ----------------------------------------------

Line 1439: -- Repopulate PA_RBS_DENORM for specific struct_version_id

1435: where 1=1
1436: and STRUCT_VERSION_ID = p_rbs_version_id;
1437: */
1438: -- ----------------------------------------------
1439: -- Repopulate PA_RBS_DENORM for specific struct_version_id
1440:
1441: -- OLAP START
1442:
1443: PA_ppr_rollup_PVT.rbs_denorm ( p_rbs_version_id );

Line 1512: from PA_RBS_DENORM

1508: -- Bulk Full mode --
1509:
1510: select count(*) -- Added for bug 13839343
1511: into l_count
1512: from PA_RBS_DENORM
1513: where STRUCT_VERSION_ID in
1514: (
1515: select EVENT_OBJECT
1516: from PJI_PA_PROJ_EVENTS_LOG

Line 1529: -- PA_RBS_DENORM is empty, populate from scratch

1525: then
1526:
1527:
1528:
1529: -- PA_RBS_DENORM is empty, populate from scratch
1530:
1531: --
1532: -- RBS normalization algorithm for all data in
1533: -- the structures tables.

Line 1563: -- PA_RBS_DENORM contains data, repopulate a portion of it

1559: /*or
1560: l_extraction_type = 'RBS' commented for bug 10338478 */
1561: ) and l_count > 0 -- Bug 13839343
1562: then
1563: -- PA_RBS_DENORM contains data, repopulate a portion of it
1564:
1565: /* Commented for bug 9099240
1566: delete
1567: from PA_RBS_DENORM

Line 1567: from PA_RBS_DENORM

1563: -- PA_RBS_DENORM contains data, repopulate a portion of it
1564:
1565: /* Commented for bug 9099240
1566: delete
1567: from PA_RBS_DENORM
1568: where STRUCT_VERSION_ID in
1569: (
1570: select EVENT_OBJECT
1571: from PJI_PA_PROJ_EVENTS_LOG

Line 1608: -- PA_RBS_DENORM contains data, repopulate a portion of it

1604: );
1605: */
1606: /* Added for Bug 10338478 Start */
1607: elsif l_extraction_type = 'RBS' or l_count = 0 then -- bug 13839343 added l_count check
1608: -- PA_RBS_DENORM contains data, repopulate a portion of it
1609:
1610: delete
1611: from PA_RBS_DENORM
1612: where STRUCT_VERSION_ID in

Line 1611: from PA_RBS_DENORM

1607: elsif l_extraction_type = 'RBS' or l_count = 0 then -- bug 13839343 added l_count check
1608: -- PA_RBS_DENORM contains data, repopulate a portion of it
1609:
1610: delete
1611: from PA_RBS_DENORM
1612: where STRUCT_VERSION_ID in
1613: (
1614: select EVENT_OBJECT
1615: from PJI_PA_PROJ_EVENTS_LOG

Line 1682: -- NOTE: Since this API updates both PA_RBS_DENORM and PJI_RBS_DENORM, it

1678: -- procedure POPULATE_RBS_DENORM_UPGRADE
1679: -- -----------------------------------------------------
1680:
1681: --
1682: -- NOTE: Since this API updates both PA_RBS_DENORM and PJI_RBS_DENORM, it
1683: -- should only be used during upgrade since change context between
1684: -- PA_RBS_DENORM and PJI_RBS_DENORM is lost for the given RBS version.
1685: --
1686:

Line 1684: -- PA_RBS_DENORM and PJI_RBS_DENORM is lost for the given RBS version.

1680:
1681: --
1682: -- NOTE: Since this API updates both PA_RBS_DENORM and PJI_RBS_DENORM, it
1683: -- should only be used during upgrade since change context between
1684: -- PA_RBS_DENORM and PJI_RBS_DENORM is lost for the given RBS version.
1685: --
1686:
1687: -- 30-JUL-2004 jwhite Bug 3802762
1688: -- Because of savepoint issues with

Line 1734: from PA_RBS_DENORM

1730:
1731: -- -----------------------------------------------------
1732:
1733: delete
1734: from PA_RBS_DENORM
1735: where STRUCT_VERSION_ID = p_rbs_version_id;
1736:
1737: delete
1738: from PJI_RBS_DENORM

Line 1742: -- Populate PA_RBS_DENORM for a single RBS version (should not commit)

1738: from PJI_RBS_DENORM
1739: where STRUCT_VERSION_ID = p_rbs_version_id;
1740:
1741: -- -----------------------------------------------------
1742: -- Populate PA_RBS_DENORM for a single RBS version (should not commit)
1743:
1744: rbs_denorm(
1745: l_worker_id,
1746: 'UPGRADE',

Line 1800: from PA_RBS_DENORM

1796: l_last_updated_by,
1797: l_creation_date,
1798: l_created_by,
1799: l_last_update_login
1800: from PA_RBS_DENORM
1801: where STRUCT_VERSION_ID = p_rbs_version_id;
1802:
1803: -- -----------------------------------------------------
1804:

Line 4768: from pa_rbs_denorm den,

4764:
4765: /* Added for Bug 9099240 Start */
4766: begin
4767: select count(*) into l_rbs_exists1
4768: from pa_rbs_denorm den,
4769: (select distinct log1.event_object
4770: from PJI_PA_PROJ_EVENTS_LOG log1
4771: where 1=1
4772: and log1.event_type = 'PJI_RBS_CHANGE'

Line 4869: from pa_rbs_denorm den,

4865:
4866: /* Added for Bug 9099240 Start */
4867: begin
4868: select count(*) into l_rbs_exists2
4869: from pa_rbs_denorm den,
4870: (select distinct log1.event_object
4871: from PJI_PA_PROJ_EVENTS_LOG log1
4872: where 1=1
4873: and log1.event_type = 'PJI_RBS_CHANGE'

Line 4970: from pa_rbs_denorm den,

4966:
4967: /* Added for Bug 9099240 Start */
4968: begin
4969: select count(*) into l_rbs_exists3
4970: from pa_rbs_denorm den,
4971: (select distinct log1.event_object
4972: from PJI_PA_PROJ_EVENTS_LOG log1
4973: where 1=1
4974: and log1.event_type = 'PJI_RBS_CHANGE'

Line 5146: Select count(1) into l_denorm_count from pa_rbs_denorm where struct_version_id = p_rbs_version_id;

5142: l_rbs_exists3 := 0;
5143: /* Added for Bug 9099240 End */
5144: -- -----------------------------------------------------
5145: /* Added for bug 12360547 starts */
5146: Select count(1) into l_denorm_count from pa_rbs_denorm where struct_version_id = p_rbs_version_id;
5147: /* Added for bug 12360547 ends */
5148:
5149: -- Get deepest RBS node level --
5150:

Line 5296: from pa_rbs_denorm den

5292:
5293: /* Added for Bug 9099240 Start */
5294: begin
5295: select count(*) into l_rbs_exists1
5296: from pa_rbs_denorm den
5297: where den.struct_version_id = P_RBS_VERSION_ID
5298: and den.sup_id = RBS_NODE.rbs_element_id
5299: and den.sub_id = RBS_NODE.rbs_element_id
5300: and den.subro_id is null;

Line 5391: from pa_rbs_denorm den

5387:
5388: /* Added for Bug 9099240 Start */
5389: begin
5390: select count(*) into l_rbs_exists2
5391: from pa_rbs_denorm den
5392: where den.struct_version_id = P_RBS_VERSION_ID
5393: and den.sup_id = l_rbs_temp_parent
5394: and den.sub_id = RBS_NODE.rbs_element_id
5395: and den.subro_id = RBS_NODE.rbs_element_id;

Line 5435: from pa_rbs_denorm

5431:
5432: /* Added for Bug 13421956 Start */
5433: begin
5434: select sub_leaf_flag into l_rbs_leaf_flag1
5435: from pa_rbs_denorm
5436: where struct_version_id = P_RBS_VERSION_ID
5437: and sub_id = l_rbs_temp_parent
5438: and subro_id = l_rbs_temp_parent;
5439: exception

Line 5446: update pa_rbs_denorm den set sub_leaf_flag='N'

5442: end;
5443:
5444: if l_rbs_leaf_flag1='Y' then
5445:
5446: update pa_rbs_denorm den set sub_leaf_flag='N'
5447: where den.struct_version_id = P_RBS_VERSION_ID
5448: and den.sub_id = l_rbs_temp_parent
5449: and den.subro_id = l_rbs_temp_parent;
5450:

Line 5512: from pa_rbs_denorm den

5508:
5509: /* Added for Bug 9099240 Start */
5510: begin
5511: select count(*) into l_rbs_exists3
5512: from pa_rbs_denorm den
5513: where den.struct_version_id = P_RBS_VERSION_ID
5514: and den.sup_id = l_rbs_temp_parent
5515: and den.sub_id = RBS_CHILDREN_NODE.sub_id
5516: and den.subro_id = RBS_NODE.rbs_element_id

Line 5895: -- (PJI_FP_AGGR_RBS) to the actual denorm table (PA_RBS_DENORM)

5891: -- 19-MAR-2004 aartola Created
5892: --
5893: --
5894: -- *** This procedure merges data from the denorm interim table
5895: -- (PJI_FP_AGGR_RBS) to the actual denorm table (PA_RBS_DENORM)
5896: --
5897: -- After calling this procedure, the contents of the interim table
5898: -- need to be deleted.
5899: --

Line 5944: into PA_RBS_DENORM

5940:
5941: then
5942:
5943: insert
5944: into PA_RBS_DENORM
5945: (
5946: struct_version_id,
5947: sup_id,
5948: subro_id,

Line 5973: PA_RBS_DENORM denorm

5969: l_creation_date,
5970: l_created_by,
5971: l_last_update_login
5972: from PJI_FP_AGGR_RBS interim,
5973: PA_RBS_DENORM denorm
5974: where 1=1
5975: and interim.worker_id = p_worker_id
5976: and nvl(interim.struct_version_id, -1) = nvl(denorm.struct_version_id (+), -1)
5977: and nvl(interim.sup_id, -1) = nvl(denorm.sup_id (+), -1)

Line 5992: into PA_RBS_DENORM

5988:
5989: then
5990:
5991: insert
5992: into PA_RBS_DENORM
5993: (
5994: struct_version_id,
5995: sup_id,
5996: subro_id,

Line 6028: into PA_RBS_DENORM

6024:
6025: else -- UPGRADE, PARTIAL, INCREMENTAL
6026:
6027: insert
6028: into PA_RBS_DENORM
6029: (
6030: struct_version_id,
6031: sup_id,
6032: subro_id,