APPS.MSD_DP_SEEDED_DOCUMENT_PKG SQL Statements

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

Line: 17

 	 ,P_LAST_UPDATE_DATE  in varchar2
	 ,P_SUB_TYPE          in varchar2
         ,P_CUSTOM_MODE     in varchar2
	 )
is

l_demand_plan_id number;

Line: 25

f_ludate  date;    -- entity update date in file

Line: 27

db_ludate date;    -- entity update date in db

Line: 33

        select DEMAND_PLAN_ID
        into l_demand_plan_id
        from MSD_DEMAND_PLANS
        where DEMAND_PLAN_NAME = P_DEMAND_PLAN_NAME;

Line: 44

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

Line: 46

          select LAST_UPDATED_BY, LAST_UPDATE_DATE
          into db_luby, db_ludate
          from msd_dp_seeded_documents
          where DEMAND_PLAN_ID = l_demand_plan_id
          and DOCUMENT_NAME = P_DOCUMENT_NAME;

Line: 55

	    -- Update existing row
            update msd_dp_seeded_documents
	    set  description = p_description
	    ,type = p_type
            ,open_on_startup = p_open_on_startup
            ,script_cleanup = p_script_cleanup
            ,script_init = p_script_init
            ,script_prepage = p_script_prepage
            ,script_postpage = p_script_postpage
            ,valid_flag = p_valid_flag ,
	    sub_type = p_sub_type    ,
	    last_update_date = f_ludate            ,
	    last_updated_by = f_luby             ,
	    last_update_login = 0
            where demand_plan_id = l_demand_plan_id
            and document_name = p_document_name;

Line: 76

            insert into msd_dp_seeded_documents
            (DEMAND_PLAN_ID
	    ,DOCUMENT_ID
	    ,DOCUMENT_NAME
            ,DESCRIPTION
            ,TYPE
            ,OPEN_ON_STARTUP
            ,SCRIPT_CLEANUP
            ,SCRIPT_INIT
            ,SCRIPT_PREPAGE
            ,SCRIPT_POSTPAGE
            ,VALID_FLAG  ,
	    SUB_TYPE                  ,
            CREATION_DATE	       ,
            CREATED_BY                  ,
            LAST_UPDATE_DATE            ,
            LAST_UPDATED_BY             ,
            LAST_UPDATE_LOGIN
            )
            values
            (l_demand_plan_id
            ,msd_dp_seeded_doc_s.nextval
	    ,P_DOCUMENT_NAME
	    ,p_description
            ,p_type
            ,p_open_on_startup
            ,p_script_cleanup
            ,p_script_init
            ,p_script_prepage
            ,p_script_postpage
            ,p_valid_flag   ,
	    p_sub_type        ,
            f_ludate	       ,
	    f_luby                  ,
	    f_ludate            ,
	    f_luby             ,
	    0
	    );