Dynamically pass the date or Year or month in pl/sql code in oracle

Code to Dynamically pass the date or Year or month in pl/sql code in oracle

Declare
 v_prev_year           VARCHAR2(10);
   v_prevdate            DATE;

    v_year                VARCHAR2 (2);

begin

SELECT TO_CHAR(ADD_MONTHS (SYSDATE, -12),'DD-MON-YY')--15-DEC-14
     INTO v_prevdate
     FROM DUAL;
   
  SELECT TO_CHAR(TO_DATE(v_prevdate,'DD-MON-YY'),'YY')
     INTO v_prev_year
     FROM DUAL;

SELECT TO_CHAR (v_prevdate, 'RR')
     INTO v_prev_year
     FROM DUAL;
   
  SELECT TO_CHAR (SYSDATE, 'RR')
     INTO v_year
     FROM DUAL;

SELECT column1,column2
    INTO ly2
    FROM table_name
    WHERE
TRUNC (creation_date) BETWEEN '01-FEB-' || v_prev_year AND '28-FEB-' || v_prev_year;
/*in this it dynamically passes the previous_year*/

SELECT column1,column2
    INTO ly2
    FROM table_name
    WHERE
TRUNC (creation_date) BETWEEN '01-FEB-' || v_yearAND '28-FEB-' || v_year;
/*in this it dynamically passes the year*/
end;

Add Printer from backend in oracle apps R12

we can add printer from backend in procedure,trigger or anonymous block in oracle.



lc_boolean := fnd_submit.set_print_options (printer      => 'Printer_name'
                                   ,style        => 'Landscape'
                                   ,copies       => 1
                                   );

lc_boolean1 :=fnd_request.add_printer (
                    printer => 'Printer_name',
                    copies  => 1);

Query for location of rtf template in bursting control file

select 'xdo://'||
       xtb.application_short_name||'.'||
         xtb.template_code ||'.'||
         xtb.default_language ||'.'||
         xtb.default_territory
  from   apps.xdo_templates_b xtb
 where   xtb.template_code ='template_name';