DBA Data[Home] [Help]

APPS.PJI_PJP_SUM_DENORM dependencies on PJI_RBS_DENORM

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 1738: from PJI_RBS_DENORM

1734: from PA_RBS_DENORM
1735: where STRUCT_VERSION_ID = p_rbs_version_id;
1736:
1737: delete
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)

Line 1772: into PJI_RBS_DENORM

1768:
1769: -- -----------------------------------------------------
1770:
1771: insert
1772: into PJI_RBS_DENORM
1773: (
1774: struct_version_id,
1775: sup_id,
1776: subro_id,

Line 5451: update pji_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:
5451: update pji_rbs_denorm den set sub_leaf_flag='N'
5452: where den.struct_version_id = P_RBS_VERSION_ID
5453: and den.sub_id = l_rbs_temp_parent
5454: and den.subro_id = l_rbs_temp_parent;
5455: