APPS.MSD_PURGE dependencies on MSD_CS_DATA_HEADERS

Line 14: * 2. When no date is specified the data from msd_cs_data_headers

10: * which information is deleted from the msd_cs_data table.
11: * Therfore, each header needs to be checked if a row
12: * exists in the msd_cs_data table that refers to it.
13: *
14: * 2. When no date is specified the data from msd_cs_data_headers
15: * can immediately be deleted.
16: */
17:
18: /* If given the name of a stream this provides the definition id.

Line 104: delete from msd_cs_data_headers

100: p_cs_name IN VARCHAR2) IS
101:
102: begin
103:
104: delete from msd_cs_data_headers
105: where instance = nvl(p_instance_id, instance)
106: and cs_definition_id = nvl(p_cs_def_id, cs_definition_id)
107: and cs_name = nvl(p_cs_name, cs_name);
108:

Line 133: from msd_cs_data_headers

129: and rownum = x_num_rows;
130:
131: cursor check_cs_data_headers is
132: select *
133: from msd_cs_data_headers
134: where instance = nvl(p_instance_id, instance)
135: and cs_definition_id = nvl(p_cs_def_id, cs_definition_id)
136: and cs_name = nvl(p_cs_name, cs_name)
137: and exists ( select 1

Line 139: where csd.cs_definition_id = msd_cs_data_headers.cs_definition_id

135: and cs_definition_id = nvl(p_cs_def_id, cs_definition_id)
136: and cs_name = nvl(p_cs_name, cs_name)
137: and exists ( select 1
138: from msd_cs_definitions csd
139: where csd.cs_definition_id = msd_cs_data_headers.cs_definition_id
140: and csd.system_flag = 'C' );
141:
142: x_count number := 0;
143:

Line 190: delete from msd_cs_data_headers

186: else
187:
188: /* Deletes directly from headers since no date filtering done. */
189:
190: delete from msd_cs_data_headers
191: where instance = nvl(p_instance_id, instance)
192: and cs_definition_id = nvl(p_cs_def_id, cs_definition_id)
193: and cs_name = nvl(p_cs_name, cs_name)
194: and exists ( select 1

Line 196: where csd.cs_definition_id = msd_cs_data_headers.cs_definition_id

192: and cs_definition_id = nvl(p_cs_def_id, cs_definition_id)
193: and cs_name = nvl(p_cs_name, cs_name)
194: and exists ( select 1
195: from msd_cs_definitions csd
196: where csd.cs_definition_id = msd_cs_data_headers.cs_definition_id
197: and csd.system_flag = 'C' );
198:
199: end if;
200:

Line 221: from msd_cs_data_headers

217: and rownum = x_num_rows;
218:
219: cursor check_cs_data_headers is
220: select *
221: from msd_cs_data_headers
222: where instance = nvl(p_instance_id, instance)
223: and cs_definition_id = nvl(p_cs_def_id, cs_definition_id)
224: and cs_name = nvl(p_cs_name, cs_name);
225:

Line 297: from msd_cs_data_headers

293: and rownum = x_num_rows;
294:
295: cursor check_cs_data_headers is
296: select *
297: from msd_cs_data_headers
298: where instance = nvl(p_instance_id, instance)
299: and cs_definition_id = p_cs_def_id
300: and cs_name = nvl(p_cs_name, cs_name);
301:

Line 350: delete from msd_cs_data_headers

346: else
347:
348: /* Deletes directly from headers since no date filtering done. */
349:
350: delete from msd_cs_data_headers
351: where instance = nvl(p_instance_id, instance)
352: and cs_definition_id = p_cs_def_id
353: and cs_name = nvl(p_cs_name, cs_name);
354: