DBA Data[Home] [Help]

APPS.MSD_DEM_SOP dependencies on FND_GLOBAL

Line 940: EXECUTE IMMEDIATE x_sql USING fnd_global.user_id, fnd_global.user_id, fnd_global.login_id;

936: ' (datet, num_of_days, start_date, end_date, last_update_date, last_updated_by, creation_date, created_by, last_update_login) ' ||
937: ' SELECT datet, num_of_days, ' || x_start_date || x_end_date || ', ' ||
938: ' sysdate, :1, sysdate, :2, :3 ' ||
939: ' FROM ' || x_source_time_table;
940: EXECUTE IMMEDIATE x_sql USING fnd_global.user_id, fnd_global.user_id, fnd_global.login_id;
941:
942: x_sql := 'INSERT INTO msd_dem_day_dates' ||
943: ' (day_date, bucket_date, bucket_start_date, bucket_end_date, last_update_date, last_updated_by, creation_date, created_by, last_update_login) ' ||
944: ' with dem_dates as '||

Line 950: execute immediate x_sql using fnd_global.user_id, fnd_global.user_id, fnd_global.login_id;

946: ' FROM ' || x_source_time_table || ') ' ||
947: ' select start_date + i day_date, datet, start_date, end_date, sysdate, :1, sysdate, :2, :3 ' ||
948: ' from dem_dates, xmltable(''for $i in 0 to xs:int(D)-1 return $i'' passing xmlelement(d, num_of_days)
949: columns i integer path ''.'')' ;
950: execute immediate x_sql using fnd_global.user_id, fnd_global.user_id, fnd_global.login_id;
951: COMMIT;
952:
953: C_MSD_DEM_PUSH_TIME := 'N';
954: