[Home] [Help]
60:
61: if NVL(L_Temp_plan,'N') = 'N' then
62: select msc_designators_s.nextval
63: into v_designator_id
64: from dual;
65: L_designator_id := v_designator_id;
66: else
67: v_designator_id := L_designator_id;
68: end if;
75: 7,10,
76: 8,11,
77: 9,12)
78: into v_designator_type
79: from dual;
80:
81: select nvl(organization_selection,3),designator_id
82: into l_org_selection , v_prev_designator_id
83: from msc_designators
633: ,'LAST_UPDATE_DATE' ,''''||to_char(p_bind_var_col(1).P_LAST_UPDATE_DATE , 'DD-MON-RRRR')||''''
634: ,'LAST_UPDATED_BY' , nvl(to_char( p_bind_var_col(1).P_LAST_UPDATED_BY) ,'null')
635: ,'CREATION_DATE' , ''''||to_char(p_bind_var_col(1).P_CREATION_DATE , 'DD-MON-RRRR')||''''
636: ,'CREATED_BY' , nvl(to_char(p_bind_var_col(1).P_CREATED_BY),'null')
637: , p_column_name /* 'null' */ ) into l_temp from dual;
638:
639: elsif p_source_table = 'MSC_PLANS' then
640:
641: select decode(p_column_name ,'LAST_UPDATE_DATE' , ''''||to_char(p_bind_var_col(1).P_LAST_UPDATE_DATE , 'DD-MON-RRRR')||''''
653: ,'PLAN_START_DATE' , 'null'
654: ,'DATA_COMPLETION_DATE' , 'null'
655: ,'PLAN_RUN_DATE' , 'null'
656: ,'ORGANIZATION_SELECTION' , nvl(to_char(p_bind_var_col(1).P_REFRESH_NUMBER),'null')
657: , p_column_name) into l_temp from dual;
658:
659: elsif p_source_table in ('MSC_PLAN_SCHEDULES', 'MSC_PLAN_ORGANIZATIONS', 'MSC_SUB_INVENTORIES', 'MSC_PLANS_OTHER', 'MSC_PLAN_CATEGORIES' ) then
660:
661: select decode(p_column_name ,'LAST_UPDATE_DATE' ,''''||to_char(p_bind_var_col(1).P_LAST_UPDATE_DATE , 'DD-MON-RRRR')||''''
663: ,'CREATION_DATE' ,''''||to_char( p_bind_var_col(1).P_CREATION_DATE , 'DD-MON-RRRR')||''''
664: ,'CREATED_BY' , nvl(to_char(p_bind_var_col(1).P_CREATED_BY),'null')
665: ,'LAST_UPDATE_LOGIN' , nvl(to_char(p_bind_var_col(1).P_LAST_UPDATE_LOGIN),'null')
666: ,'PLAN_ID' , nvl(to_char(p_bind_var_col(1).P_DEST_PLAN_ID),'null')
667: , p_column_name) into l_temp from dual;
668:
669: end if;
670:
671: return l_temp ;