108: v_col_value(1).P_REFRESH_NUMBER := l_org_selection ;
109: v_col_value(1).P_ORGANIZATION_SELECTION := 2 ;
110: v_col_value(1).P_COPY_PLAN := l_copy_plan ;
111: v_col_value(1).P_LAST_UPDATE_DATE := sysdate ;
112: v_col_value(1).P_LAST_UPDATED_BY := fnd_global.user_id ;
113: v_col_value(1).P_CREATION_DATE := sysdate ;
114: v_col_value(1).P_CREATED_BY := fnd_global.user_id ;
115: v_col_value(1).P_LAST_UPDATE_LOGIN := fnd_global.login_id ;
116:
110: v_col_value(1).P_COPY_PLAN := l_copy_plan ;
111: v_col_value(1).P_LAST_UPDATE_DATE := sysdate ;
112: v_col_value(1).P_LAST_UPDATED_BY := fnd_global.user_id ;
113: v_col_value(1).P_CREATION_DATE := sysdate ;
114: v_col_value(1).P_CREATED_BY := fnd_global.user_id ;
115: v_col_value(1).P_LAST_UPDATE_LOGIN := fnd_global.login_id ;
116:
117: inti_pl_sql_table(v_tab_Sql_Stmt);
118:
111: v_col_value(1).P_LAST_UPDATE_DATE := sysdate ;
112: v_col_value(1).P_LAST_UPDATED_BY := fnd_global.user_id ;
113: v_col_value(1).P_CREATION_DATE := sysdate ;
114: v_col_value(1).P_CREATED_BY := fnd_global.user_id ;
115: v_col_value(1).P_LAST_UPDATE_LOGIN := fnd_global.login_id ;
116:
117: inti_pl_sql_table(v_tab_Sql_Stmt);
118:
119: for var in 1..v_tab_Sql_Stmt.count
382: 'creation_date,' ||
383: 'created_by,' ||
384: 'last_update_login ';
385: v_select_who varchar2(4000):= ',sysdate,' ||
386: 'fnd_global.user_id,' ||
387: 'sysdate,' ||
388: 'fnd_global.user_id,' ||
389: 'fnd_global.user_id ';
390: v_sys_yes integer := 1;
384: 'last_update_login ';
385: v_select_who varchar2(4000):= ',sysdate,' ||
386: 'fnd_global.user_id,' ||
387: 'sysdate,' ||
388: 'fnd_global.user_id,' ||
389: 'fnd_global.user_id ';
390: v_sys_yes integer := 1;
391: v_planned_order number:= 5;
392: v_from_where varchar2(2000);
385: v_select_who varchar2(4000):= ',sysdate,' ||
386: 'fnd_global.user_id,' ||
387: 'sysdate,' ||
388: 'fnd_global.user_id,' ||
389: 'fnd_global.user_id ';
390: v_sys_yes integer := 1;
391: v_planned_order number:= 5;
392: v_from_where varchar2(2000);
393: v_statement varchar2(12000);