219: ) select
220: p_target_obj_def_id
221: ,output_dataset_code
222: ,calendar_id
223: ,nvl(p_created_by,FND_GLOBAL.user_id)
224: ,nvl(p_creation_date,sysdate)
225: ,FND_GLOBAL.user_id
226: ,sysdate
227: ,FND_GLOBAL.login_id
221: ,output_dataset_code
222: ,calendar_id
223: ,nvl(p_created_by,FND_GLOBAL.user_id)
224: ,nvl(p_creation_date,sysdate)
225: ,FND_GLOBAL.user_id
226: ,sysdate
227: ,FND_GLOBAL.login_id
228: ,1
229: from fem_ds_input_output_defs
223: ,nvl(p_created_by,FND_GLOBAL.user_id)
224: ,nvl(p_creation_date,sysdate)
225: ,FND_GLOBAL.user_id
226: ,sysdate
227: ,FND_GLOBAL.login_id
228: ,1
229: from fem_ds_input_output_defs
230: where dataset_io_obj_def_id = p_source_obj_def_id;
231:
281: ,absolute_cal_period_id
282: ,use_default_dim_grp_id_code
283: ,relative_dimension_group_id
284: ,relative_cal_period_offset
285: ,nvl(p_created_by,FND_GLOBAL.user_id)
286: ,nvl(p_creation_date,sysdate)
287: ,FND_GLOBAL.user_id
288: ,sysdate
289: ,FND_GLOBAL.login_id
283: ,relative_dimension_group_id
284: ,relative_cal_period_offset
285: ,nvl(p_created_by,FND_GLOBAL.user_id)
286: ,nvl(p_creation_date,sysdate)
287: ,FND_GLOBAL.user_id
288: ,sysdate
289: ,FND_GLOBAL.login_id
290: ,1
291: from fem_ds_input_lists
285: ,nvl(p_created_by,FND_GLOBAL.user_id)
286: ,nvl(p_creation_date,sysdate)
287: ,FND_GLOBAL.user_id
288: ,sysdate
289: ,FND_GLOBAL.login_id
290: ,1
291: from fem_ds_input_lists
292: where dataset_io_obj_def_id = p_source_obj_def_id;
293: