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 dependencies on PER_CA_EE_REPORT_LINES

Line 99: per_ca_ee_report_lines where

95: declare
96: cursor cur_f5_n_total is
97: select
98: to_number(segment3) from
99: per_ca_ee_report_lines where
100: request_id = p_conc_request_id and
101: context = 'FORM5P' and
102: substr(f4_n_type,1,5) = 'FORM5' and
103: segment1 = 'NATIONAL' and

Line 124: per_ca_ee_report_lines where

120: declare
121: cursor cur_f5_n_total is
122: select
123: to_number(segment4) from
124: per_ca_ee_report_lines where
125: request_id = p_conc_request_id and
126: context = 'FORM5P' and
127: substr(f4_n_type,1,5) = 'FORM5' and
128: segment1 = 'NATIONAL' and

Line 149: per_ca_ee_report_lines where

145: declare
146: cursor cur_f5_n_total is
147: select
148: to_number(segment5) from
149: per_ca_ee_report_lines where
150: request_id = p_conc_request_id and
151: context = 'FORM5P' and
152: substr(f4_n_type,1,5) = 'FORM5' and
153: segment1 = 'NATIONAL' and

Line 174: per_ca_ee_report_lines where

170: declare
171: cursor cur_f5_n_total is
172: select
173: to_number(segment6) from
174: per_ca_ee_report_lines where
175: request_id = p_conc_request_id and
176: context = 'FORM5P' and
177: substr(f4_n_type,1,5) = 'FORM5' and
178: segment1 = 'NATIONAL' and

Line 199: per_ca_ee_report_lines where

195: declare
196: cursor cur_f5_n_total is
197: select
198: to_number(segment7) from
199: per_ca_ee_report_lines where
200: request_id = p_conc_request_id and
201: context = 'FORM5P' and
202: substr(f4_n_type,1,5) = 'FORM5' and
203: segment1 = 'NATIONAL' and

Line 224: per_ca_ee_report_lines where

220: declare
221: cursor cur_f5_n_total is
222: select
223: to_number(segment8) from
224: per_ca_ee_report_lines where
225: request_id = p_conc_request_id and
226: context = 'FORM5P' and
227: substr(f4_n_type,1,5) = 'FORM5' and
228: segment1 = 'NATIONAL' and

Line 249: per_ca_ee_report_lines where

245: declare
246: cursor cur_f5_n_total is
247: select
248: to_number(segment9) from
249: per_ca_ee_report_lines where
250: request_id = p_conc_request_id and
251: context = 'FORM5P' and
252: substr(f4_n_type,1,5) = 'FORM5' and
253: segment1 = 'NATIONAL' and

Line 274: per_ca_ee_report_lines where

270: declare
271: cursor cur_f5_n_total is
272: select
273: to_number(segment10) from
274: per_ca_ee_report_lines where
275: request_id = p_conc_request_id and
276: context = 'FORM5P' and
277: substr(f4_n_type,1,5) = 'FORM5' and
278: segment1 = 'NATIONAL' and

Line 299: per_ca_ee_report_lines where

295: declare
296: cursor cur_f5_n_total is
297: select
298: to_number(segment11) from
299: per_ca_ee_report_lines where
300: request_id = p_conc_request_id and
301: context = 'FORM5P' and
302: substr(f4_n_type,1,5) = 'FORM5' and
303: segment1 = 'NATIONAL' and

Line 324: per_ca_ee_report_lines where

320: declare
321: cursor cur_f5_n_total is
322: select
323: to_number(segment12) from
324: per_ca_ee_report_lines where
325: request_id = p_conc_request_id and
326: context = 'FORM5P' and
327: substr(f4_n_type,1,5) = 'FORM5' and
328: segment1 = 'NATIONAL' and

Line 349: per_ca_ee_report_lines where

345: declare
346: cursor cur_f5_n_total is
347: select
348: to_number(segment13) from
349: per_ca_ee_report_lines where
350: request_id = p_conc_request_id and
351: context = 'FORM5P' and
352: substr(f4_n_type,1,5) = 'FORM5' and
353: segment1 = 'NATIONAL' and

Line 374: per_ca_ee_report_lines where

370: declare
371: cursor cur_f5_n_total is
372: select
373: to_number(segment14) from
374: per_ca_ee_report_lines where
375: request_id = p_conc_request_id and
376: context = 'FORM5P' and
377: substr(f4_n_type,1,5) = 'FORM5' and
378: segment1 = 'NATIONAL' and

Line 399: per_ca_ee_report_lines where

395: declare
396: cursor cur_f5_n_total is
397: select
398: to_number(segment4) from
399: per_ca_ee_report_lines where
400: request_id = p_conc_request_id and
401: context = 'FORM5P' and
402: substr(f4_p_type,1,5) = 'FORM5' and
403: segment1 = 'PROVINCE' and

Line 425: per_ca_ee_report_lines where

421: declare
422: cursor cur_f5_n_total is
423: select
424: to_number(segment5) from
425: per_ca_ee_report_lines where
426: request_id = p_conc_request_id and
427: context = 'FORM5P' and
428: substr(f4_p_type,1,5) = 'FORM5' and
429: segment1 = 'PROVINCE' and

Line 451: per_ca_ee_report_lines where

447: declare
448: cursor cur_f5_n_total is
449: select
450: to_number(segment6) from
451: per_ca_ee_report_lines where
452: request_id = p_conc_request_id and
453: context = 'FORM5P' and
454: substr(f4_p_type,1,5) = 'FORM5' and
455: segment1 = 'PROVINCE' and

Line 477: per_ca_ee_report_lines where

473: declare
474: cursor cur_f5_n_total is
475: select
476: to_number(segment7) from
477: per_ca_ee_report_lines where
478: request_id = p_conc_request_id and
479: context = 'FORM5P' and
480: substr(f4_p_type,1,5) = 'FORM5' and
481: segment1 = 'PROVINCE' and

Line 503: per_ca_ee_report_lines where

499: declare
500: cursor cur_f5_n_total is
501: select
502: to_number(segment8) from
503: per_ca_ee_report_lines where
504: request_id = p_conc_request_id and
505: context = 'FORM5P' and
506: substr(f4_p_type,1,5) = 'FORM5' and
507: segment1 = 'PROVINCE' and

Line 529: per_ca_ee_report_lines where

525: declare
526: cursor cur_f5_n_total is
527: select
528: to_number(segment9) from
529: per_ca_ee_report_lines where
530: request_id = p_conc_request_id and
531: context = 'FORM5P' and
532: substr(f4_p_type,1,5) = 'FORM5' and
533: segment1 = 'PROVINCE' and

Line 555: per_ca_ee_report_lines where

551: declare
552: cursor cur_f5_n_total is
553: select
554: to_number(segment13) from
555: per_ca_ee_report_lines where
556: request_id = p_conc_request_id and
557: context = 'FORM5P' and
558: substr(f4_p_type,1,5) = 'FORM5' and
559: segment1 = 'PROVINCE' and

Line 581: per_ca_ee_report_lines where

577: declare
578: cursor cur_f5_n_total is
579: select
580: to_number(segment14) from
581: per_ca_ee_report_lines where
582: request_id = p_conc_request_id and
583: context = 'FORM5P' and
584: substr(f4_p_type,1,5) = 'FORM5' and
585: segment1 = 'PROVINCE' and

Line 607: per_ca_ee_report_lines where

603: declare
604: cursor cur_f5_n_total is
605: select
606: to_number(segment15) from
607: per_ca_ee_report_lines where
608: request_id = p_conc_request_id and
609: context = 'FORM5P' and
610: substr(f4_p_type,1,5) = 'FORM5' and
611: segment1 = 'PROVINCE' and

Line 633: per_ca_ee_report_lines where

629: declare
630: cursor cur_f5_n_total is
631: select
632: to_number(segment10) from
633: per_ca_ee_report_lines where
634: request_id = p_conc_request_id and
635: context = 'FORM5P' and
636: substr(f4_p_type,1,5) = 'FORM5' and
637: segment1 = 'PROVINCE' and

Line 659: per_ca_ee_report_lines where

655: declare
656: cursor cur_f5_n_total is
657: select
658: to_number(segment11) from
659: per_ca_ee_report_lines where
660: request_id = p_conc_request_id and
661: context = 'FORM5P' and
662: substr(f4_p_type,1,5) = 'FORM5' and
663: segment1 = 'PROVINCE' and

Line 685: per_ca_ee_report_lines where

681: declare
682: cursor cur_f5_n_total is
683: select
684: to_number(segment12) from
685: per_ca_ee_report_lines where
686: request_id = p_conc_request_id and
687: context = 'FORM5P' and
688: substr(f4_p_type,1,5) = 'FORM5' and
689: segment1 = 'PROVINCE' and

Line 725: /*SRW.DO_SQL('DELETE per_ca_ee_report_lines

721:
722: function AfterReport return boolean is
723: begin
724:
725: /*SRW.DO_SQL('DELETE per_ca_ee_report_lines
726: WHERE request_id = :p_conc_request_id');*/null;
727:
728:
729: --hr_standard.event('AFTER REPORT');