APPS.PJI_PJP_SUM_DENORM dependencies on PA_RBS_DENORM

Line 1432: from PA_RBS_DENORM

1428: );
1429: end if;
1430:
1431: delete
1432: from PA_RBS_DENORM
1433: where 1=1
1434: and STRUCT_VERSION_ID = p_rbs_version_id;
1435:
1436: -- ----------------------------------------------

Line 1437: -- Repopulate PA_RBS_DENORM for specific struct_version_id

1433: where 1=1
1434: and STRUCT_VERSION_ID = p_rbs_version_id;
1435:
1436: -- ----------------------------------------------
1437: -- Repopulate PA_RBS_DENORM for specific struct_version_id
1438:
1439: cleanup_rbs_denorm(
1440: p_worker_id,
1441: 'ONLINE'

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

1505: then
1506:
1507:
1508:
1509: -- PA_RBS_DENORM is empty, populate from scratch
1510:
1511: --
1512: -- RBS normalization algorithm for all data in
1513: -- the structures tables.

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

1539: or
1540: l_extraction_type = 'RBS'
1541: )
1542: then
1543: -- PA_RBS_DENORM contains data, repopulate a portion of it
1544:
1545: delete
1546: from PA_RBS_DENORM
1547: where STRUCT_VERSION_ID in

Line 1546: from PA_RBS_DENORM

1542: then
1543: -- PA_RBS_DENORM contains data, repopulate a portion of it
1544:
1545: delete
1546: from PA_RBS_DENORM
1547: where STRUCT_VERSION_ID in
1548: (
1549: select EVENT_OBJECT
1550: from PJI_PA_PROJ_EVENTS_LOG

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

1618: -- procedure POPULATE_RBS_DENORM_UPGRADE
1619: -- -----------------------------------------------------
1620:
1621: --
1622: -- NOTE: Since this API updates both PA_RBS_DENORM and PJI_RBS_DENORM, it
1623: -- should only be used during upgrade since change context between
1624: -- PA_RBS_DENORM and PJI_RBS_DENORM is lost for the given RBS version.
1625: --
1626:

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

1620:
1621: --
1622: -- NOTE: Since this API updates both PA_RBS_DENORM and PJI_RBS_DENORM, it
1623: -- should only be used during upgrade since change context between
1624: -- PA_RBS_DENORM and PJI_RBS_DENORM is lost for the given RBS version.
1625: --
1626:
1627: -- 30-JUL-2004 jwhite Bug 3802762
1628: -- Because of savepoint issues with

Line 1674: from PA_RBS_DENORM

1670:
1671: -- -----------------------------------------------------
1672:
1673: delete
1674: from PA_RBS_DENORM
1675: where STRUCT_VERSION_ID = p_rbs_version_id;
1676:
1677: delete
1678: from PJI_RBS_DENORM

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

1678: from PJI_RBS_DENORM
1679: where STRUCT_VERSION_ID = p_rbs_version_id;
1680:
1681: -- -----------------------------------------------------
1682: -- Populate PA_RBS_DENORM for a single RBS version (should not commit)
1683:
1684: rbs_denorm(
1685: l_worker_id,
1686: 'UPGRADE',

Line 1740: from PA_RBS_DENORM

1736: l_last_updated_by,
1737: l_creation_date,
1738: l_created_by,
1739: l_last_update_login
1740: from PA_RBS_DENORM
1741: where STRUCT_VERSION_ID = p_rbs_version_id;
1742:
1743: -- -----------------------------------------------------
1744:

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

5583: -- 19-MAR-2004 aartola Created
5584: --
5585: --
5586: -- *** This procedure merges data from the denorm interim table
5587: -- (PJI_FP_AGGR_RBS) to the actual denorm table (PA_RBS_DENORM)
5588: --
5589: -- After calling this procedure, the contents of the interim table
5590: -- need to be deleted.
5591: --

Line 5636: into PA_RBS_DENORM

5632:
5633: then
5634:
5635: insert
5636: into PA_RBS_DENORM
5637: (
5638: struct_version_id,
5639: sup_id,
5640: subro_id,

Line 5665: PA_RBS_DENORM denorm

5661: l_creation_date,
5662: l_created_by,
5663: l_last_update_login
5664: from PJI_FP_AGGR_RBS interim,
5665: PA_RBS_DENORM denorm
5666: where 1=1
5667: and interim.worker_id = p_worker_id
5668: and nvl(interim.struct_version_id, -1) = nvl(denorm.struct_version_id (+), -1)
5669: and nvl(interim.sup_id, -1) = nvl(denorm.sup_id (+), -1)

Line 5684: into PA_RBS_DENORM

5680:
5681: then
5682:
5683: insert
5684: into PA_RBS_DENORM
5685: (
5686: struct_version_id,
5687: sup_id,
5688: subro_id,

Line 5720: into PA_RBS_DENORM

5716:
5717: else -- UPGRADE, PARTIAL, INCREMENTAL
5718:
5719: insert
5720: into PA_RBS_DENORM
5721: (
5722: struct_version_id,
5723: sup_id,
5724: subro_id,