PACKAGE: APPS.HRBEEBC

Source

1 PACKAGE hrbeebc AUTHID CURRENT_USER AS
2 /* $Header: pebenebc.pkh 115.0 99/07/17 18:46:37 porting ship $ */
3 --
4 --
5 -- Procedure/Function specifications
6 --
7 --
8 --
9 -- Name    hr_ben_chk_cobra_reference
10 --
11 -- Purpose
12 --
13 -- This is the pre-insert handler for the form
14 -- when inserting into PER_BENEFIT_CONTRIBUTIONS
15 --
16 -- Arguments
17 --
18 -- p_business_group_id
19 -- p_element_type_id
20 -- p_coverage_type
21 --
22 FUNCTION hr_ben_chk_cobra_reference (p_business_group_id NUMBER,
23                                      p_element_type_id   NUMBER,
24                                      p_coverage_type     VARCHAR2) RETURN BOOLEAN;
25 --
26 --
27 --
28 -- Name    hr_ben_bc_pre_insert
29 --
30 -- Purpose
31 --
32 -- This is the pre-insert handler for the form
33 -- when inserting into PER_BENEFIT_CONTRIBUTIONS
34 --
35 -- Arguments
36 --
37 -- p_benefit_contribution_id
38 -- p_element_type_id NUMBER,
39 -- p_coverage_type VARCHAR,
40 -- p_effective_start_date DATE,
41 -- p_effective_end_date DATE,
42 -- p_business_group_id NUMBER
43 --
44 --
45 PROCEDURE hr_ben_bc_pre_insert (p_benefit_contribution_id IN OUT NUMBER,
46                                 p_element_type_id NUMBER,
47                                 p_coverage_type VARCHAR,
48                                 p_effective_start_date DATE,
49                                 p_effective_end_date DATE,
50                                 p_business_group_id NUMBER );
51 --
52 --
53 --
54 -- Name    hr_ben_bc_pre_delete
55 --
56 -- Purpose
57 --
58 -- This is the pre-delete handler for the form
59 -- when deleting into BEN_BENEFIT_CONTRIBUTIONS
60 --
61 PROCEDURE hr_ben_bc_pre_delete (p_business_group_id NUMBER,
62                                 p_benefit_contribution_id NUMBER,
63                                 p_element_type_id NUMBER,
64 				p_iv_er_id NUMBER,
65                                 p_coverage_type VARCHAR2,
66                                 p_effective_end_date DATE,
67                                 p_session_date DATE,
68 				p_dt_delete_mode VARCHAR2,
69 				p_validation_start_date DATE,
70 				p_validation_end_date DATE,
71 				p_element_effective_start_date DATE);
72 --
73 --
74 --
75 --
76 --
77 --
78 -- Name    hr_ben_bc_pre_update
79 --
80 -- Purpose
81 --
82 -- This is the pre-update handler for the form
83 -- when updating BEN_BENEFIT_CONTRIBUTIONS
84 --
85 -- Arguments
86 --
87 -- p_benefit_contribution_id
88 -- p_element_type_id NUMBER,
89 -- p_coverage_type VARCHAR,
90 -- p_effective_start_date DATE,
91 -- p_effective_end_date DATE,
92 -- p_business_group_id NUMBER
93 --
94 --
95 PROCEDURE hr_ben_bc_pre_update (p_benefit_contribution_id IN OUT NUMBER,
96                                 p_element_type_id NUMBER,
97                                 p_coverage_type VARCHAR,
98                                 p_effective_start_date DATE,
99                                 p_effective_end_date DATE,
100                                 p_business_group_id NUMBER );
101 --
102 --
103 --
104 -- Name        hr_ben_get_coverage
105 --
106 -- Purpose
107 --
108 -- Retrieves the meaning of the coverage type
109 --
110 -- Arguments
111 --
112 -- p_coverage_type
113 --
114 -- Notes
115 --
116 -- Called from post-change of coverage_type
117 --
118 --
119 FUNCTION hr_ben_get_coverage ( p_coverage_type IN VARCHAR2 ) RETURN VARCHAR2;
120 --
121 --
122 --
123 END hrbeebc;