1 Package ben_elig_obj_api as
2 /* $Header: bebeoapi.pkh 120.0 2005/05/28 00:38:32 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_ELIG_OBJ >------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --
11 -- Prerequisites:
12 --
13 procedure create_ELIG_OBJ
14 (
15 p_validate in boolean default false
16 ,p_elig_obj_id out nocopy number
17 ,p_effective_start_date out nocopy date
18 ,p_effective_end_date out nocopy date
19 ,p_business_group_id in number
20 ,p_table_name in varchar2
21 ,p_column_name in varchar2
22 ,p_column_value in varchar2
23 ,p_object_version_number out nocopy number
24 ,p_effective_date in date
25 );
26 -- ----------------------------------------------------------------------------
27 -- |------------------------< update_ELIG_OBJ >------------------------|
28 -- ----------------------------------------------------------------------------
29 --
30 procedure update_ELIG_OBJ
31 (
32 p_validate in boolean default false
33 ,p_elig_obj_id in number
34 ,p_effective_start_date out nocopy date
35 ,p_effective_end_date out nocopy date
36 ,p_business_group_id in number default hr_api.g_number
37 ,p_table_name in varchar2 default hr_api.g_varchar2
38 ,p_column_name in varchar2 default hr_api.g_varchar2
39 ,p_column_value in varchar2 default hr_api.g_varchar2
40 ,p_object_version_number in out nocopy number
41 ,p_effective_date in date
42 ,p_datetrack_mode in varchar2
43 );
44 --
45 -- ----------------------------------------------------------------------------
46 -- |------------------------< delete_ELIG_OBJ >------------------------|
47 -- ----------------------------------------------------------------------------
48 -- {Start Of Comments}
49 --
50 -- Description:
51 --
52 -- Prerequisites:
53 --
54 --
55 -- In Parameters:
56 -- Name Reqd Type Description
57 -- p_validate Yes boolean Commit or Rollback.
58 -- p_ELIG_OBJ_id Yes number PK of record
59 -- p_effective_date Yes date Session Date.
60 -- p_datetrack_mode Yes varchar2 Datetrack mode.
61 --
62 -- Post Success:
63 --
64 -- Name Type Description
65 -- p_effective_start_date Yes date Effective Start Date of Record
66 -- p_effective_end_date Yes date Effective End Date of Record
67 -- p_object_version_number No number OVN of record
68 --
69 -- Post Failure:
70 --
71 -- Access Status:
72 -- Public.
73 --
74 -- {End Of Comments}
75 --
76 procedure delete_ELIG_OBJ
77 (
78 p_validate in boolean default false
79 ,p_elig_obj_id in number
80 ,p_effective_start_date out nocopy date
81 ,p_effective_end_date out nocopy date
82 ,p_object_version_number in out nocopy number
83 ,p_effective_date in date
84 ,p_datetrack_mode in varchar2
85 );
86 --
87 -- ----------------------------------------------------------------------------
88 -- |----------------------------------< lck >---------------------------------|
89 -- ----------------------------------------------------------------------------
90 -- {Start Of Comments}
91 --
92 -- Description:
93 --
94 -- Prerequisites:
95 --
96 --
97 -- In Parameters:
98 -- Name Reqd Type Description
99 -- p_ELIG_OBJ_id Yes number PK of record
100 -- p_object_version_number Yes number OVN of record
101 -- p_effective_date Yes date Session Date.
102 -- p_datetrack_mode Yes varchar2 Datetrack mode.
103 --
104 -- Post Success:
105 --
106 -- Name Type Description
107 -- p_validation_start_date Yes Derived Effective Start Date.
108 -- p_validation_end_date Yes Derived Effective End Date.
109 --
110 -- Post Failure:
111 --
112 -- Access Status:
113 -- Public.
114 --
115 -- {End Of Comments}
116 --
117 procedure lck
118 (
119 p_elig_obj_id in number
120 ,p_object_version_number in number
121 ,p_effective_date in date
122 ,p_datetrack_mode in varchar2
123 ,p_validation_start_date out nocopy date
124 ,p_validation_end_date out nocopy date
125 );
126 --
127 end ben_elig_obj_api;
[Home] [Help]