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.HR_PAY_INTERFACE_PKG dependencies on BEN_PRTT_ENRT_RSLT_F

Line 9: g_prtt_enrt_rslt_id ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE;

5: --
6: -- non split globals
7: g_eepyc_rec hr_pay_interface_oab_value_v%ROWTYPE;
8: g_erpyc_rec hr_pay_interface_oab_value_v%ROWTYPE;
9: g_prtt_enrt_rslt_id ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE;
10: TYPE g_coverage_type_typ IS TABLE OF ben_opt_f.name%TYPE INDEX BY BINARY_INTEGER;
11: g_coverage_type_tab g_coverage_type_typ;
12: --
13: -- split view globals

Line 16: g_split_prtt_enrt_rslt_id ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE;

12: --
13: -- split view globals
14: g_split_eepyc_rec hr_pay_interface_oab_value1_v%ROWTYPE;
15: g_split_erpyc_rec hr_pay_interface_oab_value2_v%ROWTYPE;
16: g_split_prtt_enrt_rslt_id ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE;
17: --
18: -- Procedures/functions for the non-split oab view
19: --
20: --

Line 72: ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,

68: RETURN(NULL);
69: END GET_COVERAGE_TYPE;
70: --
71: PROCEDURE select_rec(p_prtt_enrt_rslt_id IN
72: ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
73: p_effective_start_date IN DATE,
74: p_effective_end_date IN DATE) IS
75: CURSOR csr_pay_interface_oab_value_v(c_acty_typ_cd
76: ben_prtt_rt_val.acty_typ_cd%TYPE) IS

Line 114: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,

110: g_erpyc_rec.prtt_enrt_rslt_id := NULL;
111: END select_rec;
112: --
113: FUNCTION eepyc_erpyc_exist
114: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
115: p_effective_start_date IN DATE,
116: p_effective_end_date IN DATE) RETURN VARCHAR2 IS
117: --
118: CURSOR csr_pay_interface_oab_value_v IS

Line 147: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,

143: RETURN('N');
144: END eepyc_erpyc_exist;
145: --
146: FUNCTION get_eepyc_varchar2
147: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
148: p_column_name IN VARCHAR2,
149: p_effective_start_date IN DATE,
150: p_effective_end_date IN DATE) RETURN VARCHAR2 IS
151: --

Line 188: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,

184: END IF;
185: END get_eepyc_varchar2;
186: --
187: FUNCTION get_eepyc_number
188: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
189: p_column_name IN VARCHAR2,
190: p_effective_start_date IN DATE,
191: p_effective_end_date IN DATE) RETURN NUMBER IS
192: --

Line 235: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,

231: END IF;
232: END get_eepyc_number;
233: --
234: FUNCTION get_eepyc_date
235: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
236: p_column_name IN VARCHAR2,
237: p_effective_start_date IN DATE,
238: p_effective_end_date IN DATE) RETURN DATE IS
239: --

Line 284: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,

280: END IF;
281: END get_eepyc_date;
282: --
283: FUNCTION get_erpyc_varchar2
284: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
285: p_column_name IN VARCHAR2,
286: p_effective_start_date IN DATE,
287: p_effective_end_date IN DATE) RETURN VARCHAR2 IS
288: --

Line 325: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,

321: END IF;
322: END get_erpyc_varchar2;
323: --
324: FUNCTION get_erpyc_number
325: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
326: p_column_name IN VARCHAR2,
327: p_effective_start_date IN DATE,
328: p_effective_end_date IN DATE) RETURN NUMBER IS
329: --

Line 372: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,

368: END IF;
369: END get_erpyc_number;
370: --
371: FUNCTION get_erpyc_date
372: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
373: p_column_name IN VARCHAR2,
374: p_effective_start_date IN DATE,
375: p_effective_end_date IN DATE) RETURN DATE IS
376: --

Line 423: ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,

419: --
420: -- Procedure/Function for split views
421: --
422: PROCEDURE select_split_eepyc_rec(p_prtt_enrt_rslt_id IN
423: ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
424: p_effective_start_date IN DATE,
425: p_effective_end_date IN DATE) IS
426: CURSOR csr_pay_interface_oab_value_v IS
427: SELECT pi.*

Line 457: IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,

453: g_split_eepyc_rec.prtt_enrt_rslt_id := NULL;
454: END select_split_eepyc_rec;
455: --
456: PROCEDURE select_split_erpyc_rec(p_prtt_enrt_rslt_id
457: IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
458: p_effective_start_date IN DATE,
459: p_effective_end_date IN DATE) IS
460: CURSOR csr_pay_interface_oab_value_v IS
461: SELECT pi.*

Line 490: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,

486: g_split_erpyc_rec.prtt_enrt_rslt_id := NULL;
487: END select_split_erpyc_rec;
488: --
489: FUNCTION split_eepyc_exist
490: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
491: p_effective_start_date IN DATE,
492: p_effective_end_date IN DATE) RETURN VARCHAR2 IS
493: --
494: CURSOR csr_pay_interface_oab_value_v IS

Line 523: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,

519: RETURN('N');
520: END split_eepyc_exist;
521: --
522: FUNCTION split_erpyc_exist
523: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
524: p_effective_start_date IN DATE,
525: p_effective_end_date IN DATE) RETURN VARCHAR2 IS
526: --
527: CURSOR csr_pay_interface_oab_value_v IS

Line 556: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,

552: RETURN('N');
553: END split_erpyc_exist;
554: --
555: FUNCTION get_split_eepyc_varchar2
556: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
557: p_column_name IN VARCHAR2,
558: p_effective_start_date IN DATE,
559: p_effective_end_date IN DATE) RETURN VARCHAR2 IS
560: --

Line 597: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,

593: END IF;
594: END get_split_eepyc_varchar2;
595: --
596: FUNCTION get_split_eepyc_number
597: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
598: p_column_name IN VARCHAR2,
599: p_effective_start_date IN DATE,
600: p_effective_end_date IN DATE) RETURN NUMBER IS
601: --

Line 644: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,

640: END IF;
641: END get_split_eepyc_number;
642: --
643: FUNCTION get_split_eepyc_date
644: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
645: p_column_name IN VARCHAR2,
646: p_effective_start_date IN DATE,
647: p_effective_end_date IN DATE) RETURN DATE IS
648: --

Line 693: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,

689: END IF;
690: END get_split_eepyc_date;
691: --
692: FUNCTION get_split_erpyc_varchar2
693: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
694: p_column_name IN VARCHAR2,
695: p_effective_start_date IN DATE,
696: p_effective_end_date IN DATE) RETURN VARCHAR2 IS
697: --

Line 734: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,

730: END IF;
731: END get_split_erpyc_varchar2;
732: --
733: FUNCTION get_split_erpyc_number
734: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
735: p_column_name IN VARCHAR2,
736: p_effective_start_date IN DATE,
737: p_effective_end_date IN DATE) RETURN NUMBER IS
738: --

Line 781: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,

777: END IF;
778: END get_split_erpyc_number;
779: --
780: FUNCTION get_split_erpyc_date
781: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
782: p_column_name IN VARCHAR2,
783: p_effective_start_date IN DATE,
784: p_effective_end_date IN DATE) RETURN DATE IS
785: --