DBA Data[Home] [Help]

APPS.HR_PAY_INTERFACE_PKG dependencies on BEN_PRTT_ENRT_RSLT_F

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

9: FUNCTION GET_COVERAGE_TYPE(P_OIPL_ID IN NUMBER) RETURN VARCHAR2;
10: --
11: --
12: FUNCTION eepyc_erpyc_exist
13: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
14: p_effective_start_date IN DATE,
15: p_effective_end_date IN DATE) RETURN VARCHAR2;
16: --
17: --

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

15: p_effective_end_date IN DATE) RETURN VARCHAR2;
16: --
17: --
18: FUNCTION get_eepyc_varchar2
19: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
20: p_column_name IN VARCHAR2,
21: p_effective_start_date IN DATE,
22: p_effective_end_date IN DATE) RETURN VARCHAR2;
23: --

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

21: p_effective_start_date IN DATE,
22: p_effective_end_date IN DATE) RETURN VARCHAR2;
23: --
24: FUNCTION get_eepyc_number
25: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
26: p_column_name IN VARCHAR2,
27: p_effective_start_date IN DATE,
28: p_effective_end_date IN DATE) RETURN NUMBER;
29: --

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

27: p_effective_start_date IN DATE,
28: p_effective_end_date IN DATE) RETURN NUMBER;
29: --
30: FUNCTION get_eepyc_date
31: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
32: p_column_name IN VARCHAR2,
33: p_effective_start_date IN DATE,
34: p_effective_end_date IN DATE) RETURN DATE;
35: --

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

33: p_effective_start_date IN DATE,
34: p_effective_end_date IN DATE) RETURN DATE;
35: --
36: FUNCTION get_erpyc_varchar2
37: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
38: p_column_name IN VARCHAR2,
39: p_effective_start_date IN DATE,
40: p_effective_end_date IN DATE) RETURN VARCHAR2;
41: FUNCTION get_erpyc_number

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

38: p_column_name IN VARCHAR2,
39: p_effective_start_date IN DATE,
40: p_effective_end_date IN DATE) RETURN VARCHAR2;
41: FUNCTION get_erpyc_number
42: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
43: p_column_name IN VARCHAR2,
44: p_effective_start_date IN DATE,
45: p_effective_end_date IN DATE) RETURN NUMBER;
46: FUNCTION get_erpyc_date

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

43: p_column_name IN VARCHAR2,
44: p_effective_start_date IN DATE,
45: p_effective_end_date IN DATE) RETURN NUMBER;
46: FUNCTION get_erpyc_date
47: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
48: p_column_name IN VARCHAR2,
49: p_effective_start_date IN DATE,
50: p_effective_end_date IN DATE) RETURN DATE;
51:

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

54: -- split views
55: --
56: --
57: FUNCTION split_eepyc_exist
58: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
59: p_effective_start_date IN DATE,
60: p_effective_end_date IN DATE) RETURN VARCHAR2;
61: --
62: FUNCTION split_erpyc_exist

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

59: p_effective_start_date IN DATE,
60: p_effective_end_date IN DATE) RETURN VARCHAR2;
61: --
62: FUNCTION split_erpyc_exist
63: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
64: p_effective_start_date IN DATE,
65: p_effective_end_date IN DATE) RETURN VARCHAR2;
66: --
67: FUNCTION get_split_eepyc_varchar2

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

64: p_effective_start_date IN DATE,
65: p_effective_end_date IN DATE) RETURN VARCHAR2;
66: --
67: FUNCTION get_split_eepyc_varchar2
68: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
69: p_column_name IN VARCHAR2,
70: p_effective_start_date IN DATE,
71: p_effective_end_date IN DATE) RETURN VARCHAR2;
72: --

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

70: p_effective_start_date IN DATE,
71: p_effective_end_date IN DATE) RETURN VARCHAR2;
72: --
73: FUNCTION get_split_eepyc_number
74: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
75: p_column_name IN VARCHAR2,
76: p_effective_start_date IN DATE,
77: p_effective_end_date IN DATE) RETURN NUMBER;
78: --

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

76: p_effective_start_date IN DATE,
77: p_effective_end_date IN DATE) RETURN NUMBER;
78: --
79: FUNCTION get_split_eepyc_date
80: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
81: p_column_name IN VARCHAR2,
82: p_effective_start_date IN DATE,
83: p_effective_end_date IN DATE) RETURN DATE;
84: --

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

82: p_effective_start_date IN DATE,
83: p_effective_end_date IN DATE) RETURN DATE;
84: --
85: FUNCTION get_split_erpyc_varchar2
86: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
87: p_column_name IN VARCHAR2,
88: p_effective_start_date IN DATE,
89: p_effective_end_date IN DATE) RETURN VARCHAR2;
90: FUNCTION get_split_erpyc_number

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

87: p_column_name IN VARCHAR2,
88: p_effective_start_date IN DATE,
89: p_effective_end_date IN DATE) RETURN VARCHAR2;
90: FUNCTION get_split_erpyc_number
91: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
92: p_column_name IN VARCHAR2,
93: p_effective_start_date IN DATE,
94: p_effective_end_date IN DATE) RETURN NUMBER;
95: FUNCTION get_split_erpyc_date

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

92: p_column_name IN VARCHAR2,
93: p_effective_start_date IN DATE,
94: p_effective_end_date IN DATE) RETURN NUMBER;
95: FUNCTION get_split_erpyc_date
96: (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
97: p_column_name IN VARCHAR2,
98: p_effective_start_date IN DATE,
99: p_effective_end_date IN DATE) RETURN DATE;
100: