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:
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
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)
1768:
1769: -- -----------------------------------------------------
1770:
1771: insert
1772: into PJI_RBS_DENORM
1773: (
1774: struct_version_id,
1775: sup_id,
1776: subro_id,
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: