205: 34, -- Bug 4710963
206: lv5.sr_level_pk, -- Bug 4710963
207: lv5.level_value, -- Bug 4710963
208: lv5.level_pk, -- Bug 4710963
209: fnd_global.user_id,
210: sysdate,
211: fnd_global.user_id,
212: sysdate,
213: fnd_global.login_id,
207: lv5.level_value, -- Bug 4710963
208: lv5.level_pk, -- Bug 4710963
209: fnd_global.user_id,
210: sysdate,
211: fnd_global.user_id,
212: sysdate,
213: fnd_global.login_id,
214: 'I',
215: l_new_refresh_Num,
209: fnd_global.user_id,
210: sysdate,
211: fnd_global.user_id,
212: sysdate,
213: fnd_global.login_id,
214: 'I',
215: l_new_refresh_Num,
216: l_new_refresh_Num
217: FROM msc_sup_dem_entries sd,
518: mcd.instance,
519: mcd.cs_definition_id,
520: mcd.cs_name,
521: sysdate,
522: fnd_global.user_id,
523: sysdate,
524: fnd_global.user_id,
525: fnd_global.login_id,
526: p_refresh_num
520: mcd.cs_name,
521: sysdate,
522: fnd_global.user_id,
523: sysdate,
524: fnd_global.user_id,
525: fnd_global.login_id,
526: p_refresh_num
527: from
528: (
521: sysdate,
522: fnd_global.user_id,
523: sysdate,
524: fnd_global.user_id,
525: fnd_global.login_id,
526: p_refresh_num
527: from
528: (
529: select distinct attribute_1 instance, cs_definition_id, cs_name
539:
540: update msd_cs_data_headers
541: set last_refresh_num = p_refresh_num,
542: last_update_date = sysdate,
543: last_updated_by = fnd_global.user_id,
544: last_update_login = fnd_global.login_id
545: where cs_definition_id = p_cs_definition_id
546: and cs_name = p_designator;
547:
540: update msd_cs_data_headers
541: set last_refresh_num = p_refresh_num,
542: last_update_date = sysdate,
543: last_updated_by = fnd_global.user_id,
544: last_update_login = fnd_global.login_id
545: where cs_definition_id = p_cs_definition_id
546: and cs_name = p_designator;
547:
548: end if;