The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT TO_CHAR(SYSDATE, 'DD-MON-YYYY')
INTO v_date_time
FROM DUAL;
htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
'', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
htp.p(' var s_day = objform.p_sd_date.selectedIndex;');
htp.p(' var s_month = objform.p_sm_date.selectedIndex;');
htp.p(' var s_year = objform.p_sy_date.selectedIndex;');
htp.p(' var e_day = objform.p_ed_date.selectedIndex;');
htp.p(' var e_month = objform.p_em_date.selectedIndex;');
htp.p(' var e_year = objform.p_ey_date.selectedIndex;');
htp.p ('
htp.FormSelectOption(day_data(i),
cattributes => ' value= '||day_data(i),
cselected => 'TRUE' );
htp.FormSelectClose;
htp.p ('
htp.FormSelectOption(TO_CHAR(TO_DATE(i, 'MM'), 'MON'),
cattributes => ' value='||lpad(to_char(i),2,'0'),
cselected => 'TRUE' );
htp.FormSelectOption(TO_CHAR(TO_DATE(i, 'MM'), 'MON'),
cattributes => ' value='||lpad(to_char(i),2,'0'));
htp.FormSelectClose;
htp.p ('
htp.FormSelectOption(year_data(i),
cattributes => ' value= '||year_data(i),
cselected => 'TRUE' );
htp.FormSelectOption(year_data(i),
cattributes => ' value= '||year_data(i));
htp.FormSelectClose;
htp.p ('
htp.FormSelectOption(day_data(i),
cattributes => ' value= '||day_data(i),
cselected => 'TRUE' );
htp.FormSelectClose;
htp.p ('
htp.FormSelectOption(TO_CHAR(TO_DATE(i, 'MM'), 'MON'),
cattributes => ' value='||lpad(to_char(i),2,'0'),
cselected => 'TRUE' );
htp.FormSelectOption(TO_CHAR(TO_DATE(i, 'MM'), 'MON'),
cattributes => ' value='||lpad(to_char(i),2,'0'));
htp.FormSelectClose;
htp.p ('
htp.FormSelectOption(year_data(i),
cattributes => ' value= '||year_data(i),
cselected => 'TRUE' );
htp.FormSelectOption(year_data(i),
cattributes => ' value= '||year_data(i));
htp.FormSelectClose;
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;
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;