PACKAGE: APPS.HR_BEN_BENEFIT_CONTRIBUTIONS

Source

1 PACKAGE hr_ben_benefit_contributions AUTHID CURRENT_USER AS
2 /* $Header: pebenpbc.pkh 115.0 99/07/17 18:46:43 porting ship $ */
3 --
4 --
5 -- Change History
6 -- 27-MAY-94  G.Payton-McDowall  Added exit
7 -- gpaytonm  03-JUL-93  Added whenever sqlerror... and set verify off
8 -- gpaytonm  07-MAR-95  Modified hr_ben_ref_chk to cater for stricter Type A
9 --			benefit rules
10 -- jthuring  11-OCT-95  Removed spurious start of comment marker
11 -- ramurthy  15-JAN-96  Added parameter p_validation_end_date to procedure
12 --			hr_ben_ref_chk.
13 -- teyres    24-Jun-97  Changed as to is on create or replace line
14 -- teyres    25-Jun-97  110.1 and 70.7 are the same
15 --
16 -- Procedure/Function specifications
17 --
18 --
19 -- Name      hr_ben_chk_duplicate_cont
20 --
21 -- Purpose
22 --
23 -- Checks that the contribution recor being inserted does already exist or
24 -- overlap other contribution records
25 --
26 -- Arguments
27 --
28 -- p_benefit_contribution_id
29 -- p_element_type_id
30 -- p_coverage_type
31 -- p_effective_start_date
32 -- p_effective_end_date
33 -- p_business_group_id
34 --
35 --
36 -- Example
37 --
38 -- Notes
39 --
40 -- The benefit_contribution_id is passed in/out to avoid unecessary network traffic.
41 -- As this is called from insert/update we bundle, thus copyign the id across the network
42 -- is not a good idea
43 --
44 PROCEDURE hr_ben_chk_duplicate_cont ( p_benefit_contribution_id NUMBER,
45                                       p_element_type_id         NUMBER,
46                                       p_coverage_type           VARCHAR2,
47                                       p_effective_start_date    DATE,
48                                       p_effective_end_date      DATE,
49                                       p_business_group_id       NUMBER );
50 --
51 --
52 --
53 -- Name      hr_ben_benefit_contribution_id
54 --
55 -- Purpose
56 --
57 -- Retrieves surrogate key from the table's sequence
58 --
59 -- Arguments
60 --
61 -- p_benefit_contribution_id
62 --
63 PROCEDURE hr_ben_benefit_contribution_id ( p_benefit_contribution_id IN OUT NUMBER);
64 --
65 --
66 -- Name      hr_ben_bc_delrec
67 --
68 -- Purpose   Called from key-delrec to ensure no future contributions exist
69 --
70 -- Arguments
71 --
72 -- p_business_group_id
73 -- p_benefit_contribution_id
74 -- p_effective_end_date
75 --
76 PROCEDURE hr_ben_chk_future_conts ( p_business_group_id NUMBER,
77                                     p_benefit_contribution_id NUMBER,
78                                     p_effective_end_date DATE );
79 --
80 --
81 --
82 -- Name     hr_ben_ref_chk
83 --
84 -- Purpose
85 --
86 -- referential integrity change
87 --
88 -- Arguments
89 --
90 -- p_element_type_id NUMBER
91 -- p_iv_er_id        NUMBER
92 -- p_session_date    DATE
93 -- p_coverage_type   VARCHAR2
94 -- p_dt_delete_mode  VARCHAR2
95 -- p_validation_start_date DATE
96 -- p_validation_end_date DATE
97 -- p_element_effective_start_date DATE )
98 --
99 PROCEDURE hr_ben_ref_chk ( p_element_type_id NUMBER,
100 			   p_iv_er_id        NUMBER,
101                            p_session_date    DATE,
102 			   p_coverage_type   VARCHAR2,
103 			   p_dt_delete_mode  VARCHAR2,
104 			   p_validation_start_date DATE,
105 			   p_validation_end_date DATE,
106 			   p_element_effective_start_date DATE );
107 --
108 --
109 --
110 END hr_ben_benefit_contributions;