APPS.FND_OAM_DSCFG_COMPILER_PKG dependencies on FND_OAM_DSCRAM_BUNDLES

Line 2005: INSERT INTO FND_OAM_DSCRAM_BUNDLES (BUNDLE_ID,

2001: --addressed to use the bundle_id. For now, just overwrite it.
2002: k := b_bundles.FIRST;
2003: WHILE k IS NOT NULL LOOP
2004: --do the insert, update weight later
2005: INSERT INTO FND_OAM_DSCRAM_BUNDLES (BUNDLE_ID,
2006: RUN_ID,
2007: BUNDLE_STATUS,
2008: TARGET_HOSTNAME,
2009: WORKERS_ALLOWED,

Line 2020: (FND_OAM_DSCRAM_BUNDLES_S.NEXTVAL,

2016: LAST_UPDATE_DATE,
2017: LAST_UPDATE_LOGIN
2018: )
2019: VALUES
2020: (FND_OAM_DSCRAM_BUNDLES_S.NEXTVAL,
2021: b_run.run_id,
2022: FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_UNPROCESSED,
2023: b_bundles(k).target_hostname,
2024: b_bundles(k).workers_allowed,

Line 3243: UPDATE fnd_oam_dscram_bundles

3239: l_weight := NVL(b_bundles(k).weight, b_bundles(k).assigned_physical_weight);
3240: --add this bundle's weight to the run's assigned_physical_weight
3241: b_run.assigned_physical_weight := b_run.assigned_physical_weight + l_weight;
3242: fnd_oam_debug.log(1, l_ctxt, 'Updating bundle_id('||b_bundles(k).bundle_id||') weight('||l_weight||')');
3243: UPDATE fnd_oam_dscram_bundles
3244: SET weight = l_weight
3245: WHERE bundle_id = b_bundles(k).bundle_id;
3246: k := b_bundles.NEXT(k);
3247: END LOOP;