APPS.MSD_DP_SCENARIO_EVENT_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 11

                                 P_DELETEABLE_FLAG            in varchar2,
                                 P_LAST_UPDATE_DATE           in varchar2,
                                 P_ENABLE_NONSEED_FLAG             in VARCHAR2,
                                 P_CUSTOM_MODE             in VARCHAR2
                                 )
is

l_demand_plan_id number;

Line: 22

f_ludate  date;    -- entity update date in file

Line: 24

db_ludate date;    -- entity update date in db

Line: 29

        select DEMAND_PLAN_ID
        into l_demand_plan_id
        from MSD_DEMAND_PLANS
        where DEMAND_PLAN_NAME = P_DEMAND_PLAN_NAME;

Line: 34

        select SCENARIO_ID
	into l_scenario_id
	from MSD_DP_SCENARIOS
	where DEMAND_PLAN_ID = l_demand_plan_id
	and SCENARIO_NAME = P_SCENARIO_NAME;

Line: 40

	select EVENT_ID
	into l_event_id
	from MSD_EVENTS
	where EVENT_NAME = P_EVENT_NAME;

Line: 50

        f_ludate := nvl(to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);

Line: 52

          select LAST_UPDATED_BY, LAST_UPDATE_DATE
          into db_luby, db_ludate
          from msd_dp_scenario_events
          where DEMAND_PLAN_ID = l_demand_plan_id
          and SCENARIO_ID = l_scenario_id
	  and EVENT_ID = l_event_id;

Line: 62

	    -- Update existing row
            update msd_dp_scenario_events
	    set  event_association_priority = p_event_association_priority,
	    last_update_date = f_ludate            ,
            deleteable_flag = P_DELETEABLE_FLAG             ,
            enable_nonseed_flag = P_ENABLE_NONSEED_FLAG             ,
	    last_updated_by = f_luby             ,
	    last_update_login = 0
            where demand_plan_id = l_demand_plan_id
            and scenario_id = l_scenario_id
   	    and event_id = l_event_id;

Line: 78

            insert into msd_dp_scenario_events
            (DEMAND_PLAN_ID            ,
	    SCENARIO_ID ,
            EVENT_ID,
            EVENT_ASSOCIATION_PRIORITY               ,
            CREATION_DATE	       ,
            CREATED_BY                  ,
            LAST_UPDATE_DATE            ,
            LAST_UPDATED_BY             ,
            LAST_UPDATE_LOGIN           ,
	    ENABLE_NONSEED_FLAG ,
	    DELETEABLE_FLAG
            )
            values
            (l_demand_plan_id            ,
            l_scenario_id  ,
            l_event_id,
            p_event_association_priority               ,
            f_ludate	       ,
	    f_luby                  ,
	    f_ludate            ,
	    f_luby             ,
	    0           ,
	    P_ENABLE_NONSEED_FLAG ,
	    P_DELETEABLE_FLAG
	    );