DBA Data[Home] [Help]

APPS.AST_OFL_EVENT_INFO_PARAM SQL Statements

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

Line: 46

    SELECT TO_CHAR(SYSDATE, 'DD-MON-YYYY')
    INTO   v_date_time
    FROM   DUAL;
Line: 70

     htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK.  ') ||
                    '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
Line: 147

       htp.p('    var s_day = objform.p_sd_date.selectedIndex;');
Line: 148

       htp.p('    var s_month = objform.p_sm_date.selectedIndex;');
Line: 149

       htp.p('    var s_year = objform.p_sy_date.selectedIndex;');
Line: 150

       htp.p('    var e_day = objform.p_ed_date.selectedIndex;');
Line: 151

       htp.p('    var e_month = objform.p_em_date.selectedIndex;');
Line: 152

       htp.p('    var e_year = objform.p_ey_date.selectedIndex;');
Line: 218

       htp.p ('');
Line: 230

             htp.FormSelectOption(TO_CHAR(TO_DATE(i, 'MM'), 'MON'),
               cattributes => ' value='||lpad(to_char(i),2,'0'),
               cselected => 'TRUE' );
Line: 234

             htp.FormSelectOption(TO_CHAR(TO_DATE(i, 'MM'), 'MON'),
               cattributes => ' value='||lpad(to_char(i),2,'0'));
Line: 238

     htp.FormSelectClose;
Line: 241

     htp.p ('');
Line: 261

	           htp.FormSelectOption(day_data(i),
			cattributes => ' value= '||day_data(i),
			cselected => 'TRUE' );
Line: 265

       htp.FormSelectClose;
Line: 268

     htp.p ('');
Line: 285

	           htp.FormSelectOption(year_data(i),
			cattributes => ' value= '||year_data(i),
			cselected => 'TRUE' );
Line: 289

	      htp.FormSelectOption(year_data(i),
			cattributes => ' value= '||year_data(i));
Line: 293

       htp.FormSelectClose;
Line: 339

                           p_selected_event_code in varchar2 default null) is

   CURSOR cur_promotion_code(Event_Code VARCHAR2) is
-- RN 25/9/00
	SELECT event_offer_id code, event_offer_name name
	FROM ams_event_offers_vl
	WHERE event_offer_id LIKE NVL(UPPER(Event_Code), '%') || '%'
	OR UPPER(event_offer_name) LIKE NVL(UPPER(Event_Code), '%') || '%'
--     select code, name
--       from as_promotions_all
--      where type = 'E'
--      and (upper(code) like nvl(upper(p_event_code),'%')||'%' or upper(name) like nvl(upper(p_event_code),'%')||'%')
      order by 1;
Line: 423

                           p_selected_event_code in varchar2 default null) is

   CURSOR cur_promotion_code(Event_Code VARCHAR2) is
-- RN 25/9/00
	SELECT event_offer_id code, event_offer_name name
	FROM ams_event_offers_vl
	WHERE event_offer_id LIKE NVL(UPPER(Event_Code), '%') || '%'
	OR UPPER(event_offer_name) LIKE NVL(UPPER(Event_Code), '%') || '%'
--     select code, name
--       from as_promotions_all
--      where type = 'E'
--      and (upper(code) like nvl(upper(Event_Code),'%')||'%' or upper(name) like nvl(upper(Event_Code),'%')||'%')
      order by 1;