APPS.MSD_TRANSLATE_FACT_DATA dependencies on MSD_CS_DATA_HEADERS

Line 221: from msd_cs_data_headers

217:
218: Begin
219:
220: select 1 into v_ref_num
221: from msd_cs_data_headers
222: where cs_definition_id in (select cs_definition_id
223: from msd_cs_definitions
224: where name = 'MSD_SHIPMENT_HISTORY');
225:

Line 226: update msd_cs_data_headers

222: where cs_definition_id in (select cs_definition_id
223: from msd_cs_definitions
224: where name = 'MSD_SHIPMENT_HISTORY');
225:
226: update msd_cs_data_headers
227: set last_refresh_num = p_new_refresh_num
228: where cs_definition_id in (select cs_definition_id
229: from msd_cs_definitions
230: where name in ('MSD_SHIPMENT_HISTORY','MSD_SHIPMENT_ORIG_HISTORY'));

Line 449: from msd_cs_data_headers

445:
446: Begin
447:
448: select 1 into v_ref_num
449: from msd_cs_data_headers
450: where cs_definition_id in (select cs_definition_id
451: from msd_cs_definitions
452: where name = 'MSD_BOOKING_HISTORY');
453:

Line 454: update msd_cs_data_headers

450: where cs_definition_id in (select cs_definition_id
451: from msd_cs_definitions
452: where name = 'MSD_BOOKING_HISTORY');
453:
454: update msd_cs_data_headers
455: set last_refresh_num = p_new_refresh_num
456: where cs_definition_id in (select cs_definition_id
457: from msd_cs_definitions
458: where name in ('MSD_BOOKING_HISTORY','MSD_BOOKING_ORIG_HISTORY'));

Line 1170: delete from msd_cs_data_headers

1166: ' nvl(:p_fcst_desg, forecast_designator) ' ;
1167: EXECUTE IMMEDIATE v_sql_stmt USING p_fcst_desg ;
1168:
1169: /* Delete Cs Data Headers */
1170: delete from msd_cs_data_headers
1171: where cs_definition_id = x_cs_id
1172: and instance = p_instance_id
1173: and cs_name = p_fcst_desg;
1174:

Line 1216: INSERT INTO msd_cs_data_headers (

1212:
1213: EXECUTE IMMEDIATE v_sql_stmt USING p_fcst_desg ;
1214:
1215: if (p_dest_table = MSD_COMMON_UTILITIES.MFG_FCST_FACT_TABLE) then
1216: INSERT INTO msd_cs_data_headers (
1217: CS_DATA_HEADER_ID,
1218: INSTANCE,
1219: CS_DEFINITION_ID,
1220: CS_NAME,

Line 1228: VALUES ( msd_cs_data_headers_s.nextval,

1224: CREATED_BY,
1225: LAST_UPDATE_LOGIN,
1226: LAST_REFRESH_NUM
1227: )
1228: VALUES ( msd_cs_data_headers_s.nextval,
1229: p_instance_id,
1230: x_cs_id,
1231: p_fcst_desg,
1232: sysdate,

Line 2015: insert into msd_cs_data_headers

2011: close get_cs_id;
2012:
2013: if (x_cs_id is not null) then
2014:
2015: insert into msd_cs_data_headers
2016: ( cs_data_header_id,
2017: instance,
2018: cs_definition_id,
2019: cs_name,

Line 2027: select msd_cs_data_headers_s.nextval,

2023: created_by,
2024: last_update_login,
2025: last_refresh_num
2026: )
2027: select msd_cs_data_headers_s.nextval,
2028: p_instance,
2029: x_cs_id,
2030: 'SINGLE_STREAM',
2031: sysdate,