APPS.AST_OFL_EVENT_ATTENDEES_PARAM SQL Statements

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

Line: 24

    SELECT fnd_date.date_to_chardate(SYSDATE)
      INTO v_date_time
      FROM DUAL;

Line: 42

    htp.tableData('' || htf.bold('Please specify the criteria and select OK.  ') || '', cAlign => 'center', cRowSpan => '2', cColSpan => '110', cAttributes => ' width=346');

Line: 57

      SELECT code, name
      FROM as_promotions_all
      WHERE type = 'E'
      ORDER BY 1;

Line: 100

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

Line: 101

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

Line: 102

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

Line: 103

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

Line: 104

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

Line: 105

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

Line: 178

	 htp.p('');

Line: 181

          htp.formSelectOption(LPAD(TO_CHAR(i), 2, '0'), cAttributes => ' value=' || LPAD(TO_CHAR(i), 2, '0'), cSelected => 'TRUE');

Line: 183

          htp.formSelectOption(LPAD(TO_CHAR(i), 2, '0'), cAttributes => ' value=' || LPAD(TO_CHAR(i), 2, '0'));

Line: 186

      htp.formSelectClose;

Line: 189

      htp.p('');

        htp.formSelectOption(day_data(i), cAttributes => ' value= ' || day_data(i), cSelected => 'TRUE');

      htp.FormSelectClose;

	 htp.p('');

Line: 197

      htp.FormSelectOption('JAN',cselected => 'TRUE');

Line: 198

	 htp.FormSelectOption('FEB');

Line: 199

	 htp.FormSelectOption('MAR');

Line: 200

	 htp.FormSelectOption('APR');

Line: 201

	 htp.FormSelectOption('MAY');

Line: 202

	 htp.FormSelectOption('JUN');

Line: 203

	 htp.FormSelectOption('JUL');

Line: 204

	 htp.FormSelectOption('AUG');

Line: 205

	 htp.FormSelectOption('SEP');

Line: 206

	 htp.FormSelectOption('OCT');

Line: 207

	 htp.FormSelectOption('NOV');

Line: 208

	 htp.FormSelectOption('DEC');

Line: 209

      htp.formSelectClose;

Line: 212

      htp.p('');

        htp.formSelectOption(year_data(i), cAttributes => ' value= ' || year_data(i));

      htp.formSelectClose;

      htp.p('');

Line: 224

        htp.formSelectOption(day_data(i), cAttributes => ' value= '||day_data(i), cSelected => 'TRUE');

Line: 226

      htp.formSelectClose;

Line: 230

      htp.p('');

          htp.formSelectOption(LPAD(TO_CHAR(i), 2, '0'), cAttributes => ' value=' || LPAD(TO_CHAR(i), 2, '0'), cSelected => 'TRUE');

          htp.formSelectOption(LPAD(TO_CHAR(i), 2, '0'), cAttributes => ' value=' || LPAD(TO_CHAR(i), 2, '0'));

      htp.formSelectClose;

	 htp.p('');

Line: 242

      htp.FormSelectOption('JAN',cselected => 'TRUE');

Line: 243

	 htp.FormSelectOption('FEB');

Line: 244

	 htp.FormSelectOption('MAR');

Line: 245

	 htp.FormSelectOption('APR');

Line: 246

	 htp.FormSelectOption('MAY');

Line: 247

	 htp.FormSelectOption('JUN');

Line: 248

	 htp.FormSelectOption('JUL');

Line: 249

	 htp.FormSelectOption('AUG');

Line: 250

	 htp.FormSelectOption('SEP');

Line: 251

	 htp.FormSelectOption('OCT');

Line: 252

	 htp.FormSelectOption('NOV');

Line: 253

	 htp.FormSelectOption('DEC');

Line: 254

      htp.formSelectClose;

Line: 257

      htp.p('');

        htp.formSelectOption(year_data(i), cAttributes => ' value= ' || year_data(i), cSelected => 'TRUE');

      htp.formSelectClose;

            p_selected_event_code IN VARCHAR2 DEFAULT NULL)
  IS
    CURSOR cur_promotion_code(p_e_c 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 p_e_c
	OR UPPER(event_offer_name) LIKE p_e_c
--      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(p_e_c 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 p_e_c
	OR UPPER(event_offer_name) LIKE p_e_c
--      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;