APPS.MSD_COLLECT_LEVEL_VALUES dependencies on MSD_BACKUP_LEVEL_VALUES

Line 1145: from msd_backup_level_values

1141: -- p_dest_table in varchar2) IS Bug# 4919130 - Always delete childless parents from staging table.
1142:
1143: CURSOR c_childless_parent is
1144: select level_id, sr_level_pk
1145: from msd_backup_level_values
1146: where instance = '-999' and level_pk = -999;
1147:
1148: l_count NUMBER(10) := 0;
1149: l_print_title BOOLEAN := TRUE;

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

1149: l_print_title BOOLEAN := TRUE;
1150:
1151: BEGIN
1152:
1153: /*----------------- Clear msd_backup_level_values table -------------------*/
1154: delete from msd_backup_level_values
1155: where instance = '-999' and level_pk = -999;
1156:
1157: /* For 2 step collection */

Line 1154: delete from msd_backup_level_values

1150:
1151: BEGIN
1152:
1153: /*----------------- Clear msd_backup_level_values table -------------------*/
1154: delete from msd_backup_level_values
1155: where instance = '-999' and level_pk = -999;
1156:
1157: /* For 2 step collection */
1158: /* Bug# 4919130 - Always delete childless parents from staging table.

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

1158: /* Bug# 4919130 - Always delete childless parents from staging table.
1159: IF (p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) THEN
1160: */
1161:
1162: insert into msd_backup_level_values (instance , level_id, sr_level_pk, level_pk )
1163: select '-999' , level_id, sr_level_pk, -999
1164: from msd_st_level_values
1165: where instance = p_instance_id and level_id = p_level_id
1166: minus

Line 1175: exists (select 1 from msd_backup_level_values b

1171: delete from msd_st_level_values a
1172: where
1173: instance = p_instance_id and
1174: level_id = p_level_id and
1175: exists (select 1 from msd_backup_level_values b
1176: where b.instance = '-999' and b.level_id = a.level_id and
1177: b.sr_level_pk = a.sr_level_pk and level_pk = -999);
1178:
1179: /* For 1 step collection */

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

1179: /* For 1 step collection */
1180: /* Bug# 4919130 - Always delete childless parents from staging table.
1181: ELSIF (p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE) THEN
1182:
1183: insert into msd_backup_level_values (instance , level_id, sr_level_pk, level_pk )
1184: select '-999' , level_id, sr_level_pk, -999
1185: from msd_level_values
1186: where instance = p_instance_id and level_id = p_level_id
1187: minus

Line 1196: exists (select 1 from msd_backup_level_values b

1192: delete from msd_level_values a
1193: where
1194: instance = p_instance_id and
1195: level_id = p_level_id and
1196: exists (select 1 from msd_backup_level_values b
1197: where b.instance = '-999' and b.level_id = a.level_id and
1198: b.sr_level_pk = a.sr_level_pk and level_pk = -999);
1199:
1200: END IF;

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

1220: IF (l_count > 0) THEN
1221: fnd_file.put_line(fnd_file.log, l_count ||' childless level values deleted.' );
1222: END IF;
1223:
1224: /*------------------------- Clean up msd_backup_level_values table ---------------*/
1225: delete from msd_backup_level_values
1226: where level_pk = -999 and instance = '-999';
1227:
1228: EXCEPTION

Line 1225: delete from msd_backup_level_values

1221: fnd_file.put_line(fnd_file.log, l_count ||' childless level values deleted.' );
1222: END IF;
1223:
1224: /*------------------------- Clean up msd_backup_level_values table ---------------*/
1225: delete from msd_backup_level_values
1226: where level_pk = -999 and instance = '-999';
1227:
1228: EXCEPTION
1229: when others then