APPS.MSD_COLLECT_LEVEL_VALUES dependencies on MSD_BACKUP_LEVEL_VALUES

Line 1228: from msd_backup_level_values

1224: -- p_dest_table in varchar2) IS Bug# 4919130 - Always delete childless parents from staging table.
1225:
1226: CURSOR c_childless_parent is
1227: select level_id, sr_level_pk
1228: from msd_backup_level_values
1229: where instance = '-999' and level_pk = -999;
1230:
1231: l_count NUMBER(10) := 0;
1232: l_print_title BOOLEAN := TRUE;

Line 1236: /*----------------- Clear msd_backup_level_values table -------------------*/

1232: l_print_title BOOLEAN := TRUE;
1233:
1234: BEGIN
1235:
1236: /*----------------- Clear msd_backup_level_values table -------------------*/
1237: delete from msd_backup_level_values
1238: where instance = '-999' and level_pk = -999;
1239:
1240: /* For 2 step collection */

Line 1237: delete from msd_backup_level_values

1233:
1234: BEGIN
1235:
1236: /*----------------- Clear msd_backup_level_values table -------------------*/
1237: delete from msd_backup_level_values
1238: where instance = '-999' and level_pk = -999;
1239:
1240: /* For 2 step collection */
1241: /* Bug# 4919130 - Always delete childless parents from staging table.

Line 1245: insert into msd_backup_level_values (instance , level_id, sr_level_pk, level_pk )

1241: /* Bug# 4919130 - Always delete childless parents from staging table.
1242: IF (p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) THEN
1243: */
1244:
1245: insert into msd_backup_level_values (instance , level_id, sr_level_pk, level_pk )
1246: select '-999' , level_id, sr_level_pk, -999
1247: from msd_st_level_values
1248: where instance = p_instance_id and level_id = p_level_id
1249: minus

Line 1258: exists (select 1 from msd_backup_level_values b

1254: delete from msd_st_level_values a
1255: where
1256: instance = p_instance_id and
1257: level_id = p_level_id and
1258: exists (select 1 from msd_backup_level_values b
1259: where b.instance = '-999' and b.level_id = a.level_id and
1260: b.sr_level_pk = a.sr_level_pk and level_pk = -999);
1261:
1262: delete from msd_st_level_associations st_a

Line 1266: exists (select 1 from msd_backup_level_values st_b

1262: delete from msd_st_level_associations st_a
1263: where
1264: instance = p_instance_id and
1265: level_id = p_level_id and
1266: exists (select 1 from msd_backup_level_values st_b
1267: where st_b.instance = '-999' and st_b.level_id = st_a.level_id and
1268: st_b.sr_level_pk = st_a.sr_level_pk and level_pk = -999);
1269:
1270: /* For 1 step collection */

Line 1274: insert into msd_backup_level_values (instance , level_id, sr_level_pk, level_pk )

1270: /* For 1 step collection */
1271: /* Bug# 4919130 - Always delete childless parents from staging table.
1272: ELSIF (p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE) THEN
1273:
1274: insert into msd_backup_level_values (instance , level_id, sr_level_pk, level_pk )
1275: select '-999' , level_id, sr_level_pk, -999
1276: from msd_level_values
1277: where instance = p_instance_id and level_id = p_level_id
1278: minus

Line 1287: exists (select 1 from msd_backup_level_values b

1283: delete from msd_level_values a
1284: where
1285: instance = p_instance_id and
1286: level_id = p_level_id and
1287: exists (select 1 from msd_backup_level_values b
1288: where b.instance = '-999' and b.level_id = a.level_id and
1289: b.sr_level_pk = a.sr_level_pk and level_pk = -999);
1290:
1291: END IF;

Line 1315: /*------------------------- Clean up msd_backup_level_values table ---------------*/

1311: IF (l_count > 0) THEN
1312: fnd_file.put_line(fnd_file.log, l_count ||' childless level values deleted.' );
1313: END IF;
1314:
1315: /*------------------------- Clean up msd_backup_level_values table ---------------*/
1316: delete from msd_backup_level_values
1317: where level_pk = -999 and instance = '-999';
1318:
1319: EXCEPTION

Line 1316: delete from msd_backup_level_values

1312: fnd_file.put_line(fnd_file.log, l_count ||' childless level values deleted.' );
1313: END IF;
1314:
1315: /*------------------------- Clean up msd_backup_level_values table ---------------*/
1316: delete from msd_backup_level_values
1317: where level_pk = -999 and instance = '-999';
1318:
1319: EXCEPTION
1320: when others then