eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_PERCAEER_XMLP_PKG SQL Statements

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

Line: 71


ret := per_ca_ee_extract_pkg.update_rec(p_conc_request_id);

Line: 79


  cursor cur_data is select
   'TOTAL NO OF PROMOTIONS' from dual;

Line: 97


  select
    to_number(segment3) from
   per_ca_ee_report_lines where
   request_id = p_conc_request_id and
   context = 'FORM5P' and
   substr(f4_n_type,1,5) = 'FORM5' and
   segment1 = 'NATIONAL' and
   segment2 =decode(substr(f4_n_type,6,1),'A','FR','B','PR','C','PT');

Line: 122


  select
    to_number(segment4) from
   per_ca_ee_report_lines where
   request_id = p_conc_request_id and
   context = 'FORM5P' and
   substr(f4_n_type,1,5) = 'FORM5' and
   segment1 = 'NATIONAL' and
   segment2 =decode(substr(f4_n_type,6,1),'A','FR','B','PR','C','PT');

Line: 147


  select
    to_number(segment5) from
   per_ca_ee_report_lines where
   request_id = p_conc_request_id and
   context = 'FORM5P' and
   substr(f4_n_type,1,5) = 'FORM5' and
   segment1 = 'NATIONAL' and
   segment2 =decode(substr(f4_n_type,6,1),'A','FR','B','PR','C','PT');

Line: 172


  select
    to_number(segment6) from
   per_ca_ee_report_lines where
   request_id = p_conc_request_id and
   context = 'FORM5P' and
   substr(f4_n_type,1,5) = 'FORM5' and
   segment1 = 'NATIONAL' and
   segment2 =decode(substr(f4_n_type,6,1),'A','FR','B','PR','C','PT');

Line: 197


  select
    to_number(segment7) from
   per_ca_ee_report_lines where
   request_id = p_conc_request_id and
   context = 'FORM5P' and
   substr(f4_n_type,1,5) = 'FORM5' and
   segment1 = 'NATIONAL' and
   segment2 =decode(substr(f4_n_type,6,1),'A','FR','B','PR','C','PT');

Line: 222


  select
    to_number(segment8) from
   per_ca_ee_report_lines where
   request_id = p_conc_request_id and
   context = 'FORM5P' and
   substr(f4_n_type,1,5) = 'FORM5' and
   segment1 = 'NATIONAL' and
   segment2 =decode(substr(f4_n_type,6,1),'A','FR','B','PR','C','PT');

Line: 247


  select
    to_number(segment9) from
   per_ca_ee_report_lines where
   request_id = p_conc_request_id and
   context = 'FORM5P' and
   substr(f4_n_type,1,5) = 'FORM5' and
   segment1 = 'NATIONAL' and
   segment2 =decode(substr(f4_n_type,6,1),'A','FR','B','PR','C','PT');

Line: 272


  select
    to_number(segment10) from
   per_ca_ee_report_lines where
   request_id = p_conc_request_id and
   context = 'FORM5P' and
   substr(f4_n_type,1,5) = 'FORM5' and
   segment1 = 'NATIONAL' and
   segment2 =decode(substr(f4_n_type,6,1),'A','FR','B','PR','C','PT');

Line: 297


  select
    to_number(segment11) from
   per_ca_ee_report_lines where
   request_id = p_conc_request_id and
   context = 'FORM5P' and
   substr(f4_n_type,1,5) = 'FORM5' and
   segment1 = 'NATIONAL' and
   segment2 =decode(substr(f4_n_type,6,1),'A','FR','B','PR','C','PT');

Line: 322


  select
    to_number(segment12) from
   per_ca_ee_report_lines where
   request_id = p_conc_request_id and
   context = 'FORM5P' and
   substr(f4_n_type,1,5) = 'FORM5' and
   segment1 = 'NATIONAL' and
   segment2 =decode(substr(f4_n_type,6,1),'A','FR','B','PR','C','PT');

Line: 347


  select
    to_number(segment13) from
   per_ca_ee_report_lines where
   request_id = p_conc_request_id and
   context = 'FORM5P' and
   substr(f4_n_type,1,5) = 'FORM5' and
   segment1 = 'NATIONAL' and
   segment2 =decode(substr(f4_n_type,6,1),'A','FR','B','PR','C','PT');

Line: 372


  select
    to_number(segment14) from
   per_ca_ee_report_lines where
   request_id = p_conc_request_id and
   context = 'FORM5P' and
   substr(f4_n_type,1,5) = 'FORM5' and
   segment1 = 'NATIONAL' and
   segment2 =decode(substr(f4_n_type,6,1),'A','FR','B','PR','C','PT');

Line: 397


  select
    to_number(segment4) from
   per_ca_ee_report_lines where
   request_id = p_conc_request_id and
   context = 'FORM5P' and
   substr(f4_p_type,1,5) = 'FORM5' and
   segment1 = 'PROVINCE' and
   segment2 = f4_p_name1 and
   segment3 =decode(substr(f4_p_type,6,1),'A','FR','B','PR','C','PT');

Line: 423


  select
    to_number(segment5) from
   per_ca_ee_report_lines where
   request_id = p_conc_request_id and
   context = 'FORM5P' and
   substr(f4_p_type,1,5) = 'FORM5' and
   segment1 = 'PROVINCE' and
   segment2 = f4_p_name1 and
   segment3 =decode(substr(f4_p_type,6,1),'A','FR','B','PR','C','PT');

Line: 449


  select
    to_number(segment6) from
   per_ca_ee_report_lines where
   request_id = p_conc_request_id and
   context = 'FORM5P' and
   substr(f4_p_type,1,5) = 'FORM5' and
   segment1 = 'PROVINCE' and
   segment2 = f4_p_name1 and
   segment3 =decode(substr(f4_p_type,6,1),'A','FR','B','PR','C','PT');

Line: 475


  select
    to_number(segment7) from
   per_ca_ee_report_lines where
   request_id = p_conc_request_id and
   context = 'FORM5P' and
   substr(f4_p_type,1,5) = 'FORM5' and
   segment1 = 'PROVINCE' and
   segment2 = f4_p_name1 and
   segment3 =decode(substr(f4_p_type,6,1),'A','FR','B','PR','C','PT');

Line: 501


  select
    to_number(segment8) from
   per_ca_ee_report_lines where
   request_id = p_conc_request_id and
   context = 'FORM5P' and
   substr(f4_p_type,1,5) = 'FORM5' and
   segment1 = 'PROVINCE' and
   segment2 = f4_p_name1 and
   segment3 =decode(substr(f4_p_type,6,1),'A','FR','B','PR','C','PT');

Line: 527


  select
    to_number(segment9) from
   per_ca_ee_report_lines where
   request_id = p_conc_request_id and
   context = 'FORM5P' and
   substr(f4_p_type,1,5) = 'FORM5' and
   segment1 = 'PROVINCE' and
   segment2 = f4_p_name1 and
   segment3 =decode(substr(f4_p_type,6,1),'A','FR','B','PR','C','PT');

Line: 553


  select
    to_number(segment13) from
   per_ca_ee_report_lines where
   request_id = p_conc_request_id and
   context = 'FORM5P' and
   substr(f4_p_type,1,5) = 'FORM5' and
   segment1 = 'PROVINCE' and
   segment2 = f4_p_name1 and
   segment3 =decode(substr(f4_p_type,6,1),'A','FR','B','PR','C','PT');

Line: 579


  select
    to_number(segment14) from
   per_ca_ee_report_lines where
   request_id = p_conc_request_id and
   context = 'FORM5P' and
   substr(f4_p_type,1,5) = 'FORM5' and
   segment1 = 'PROVINCE' and
   segment2 = f4_p_name1 and
   segment3 =decode(substr(f4_p_type,6,1),'A','FR','B','PR','C','PT');

Line: 605


  select
    to_number(segment15) from
   per_ca_ee_report_lines where
   request_id = p_conc_request_id and
   context = 'FORM5P' and
   substr(f4_p_type,1,5) = 'FORM5' and
   segment1 = 'PROVINCE' and
   segment2 = f4_p_name1 and
   segment3 =decode(substr(f4_p_type,6,1),'A','FR','B','PR','C','PT');

Line: 631


  select
    to_number(segment10) from
   per_ca_ee_report_lines where
   request_id = p_conc_request_id and
   context = 'FORM5P' and
   substr(f4_p_type,1,5) = 'FORM5' and
   segment1 = 'PROVINCE' and
   segment2 = f4_p_name1 and
   segment3 =decode(substr(f4_p_type,6,1),'A','FR','B','PR','C','PT');

Line: 657


  select
    to_number(segment11) from
   per_ca_ee_report_lines where
   request_id = p_conc_request_id and
   context = 'FORM5P' and
   substr(f4_p_type,1,5) = 'FORM5' and
   segment1 = 'PROVINCE' and
   segment2 = f4_p_name1 and
   segment3 =decode(substr(f4_p_type,6,1),'A','FR','B','PR','C','PT');

Line: 683


  select
    to_number(segment12) from
   per_ca_ee_report_lines where
   request_id = p_conc_request_id and
   context = 'FORM5P' and
   substr(f4_p_type,1,5) = 'FORM5' and
   segment1 = 'PROVINCE' and
   segment2 = f4_p_name1 and
   segment3 =decode(substr(f4_p_type,6,1),'A','FR','B','PR','C','PT');

Line: 708


  cursor cur_data is select
   'TOTAL NUMBER OF PROMOTIONS' from dual;

Line: 725


  /*SRW.DO_SQL('DELETE per_ca_ee_report_lines
	      WHERE request_id = :p_conc_request_id');*/null;