[Home] [Help]
PACKAGE BODY: APPS.PAY_RANGE_API
Source
1 Package Body pay_range_api as
2 /* $Header: pyranapi.pkb 120.0.12000000.2 2007/02/10 10:12:01 vetsrini noship $ */
3
4
5 procedure create_range
6 (
7 p_RANGE_TABLE_ID in NUMBER default NULL
8 ,P_LOW_BAND in NUMBER default NULL
9 ,P_HIGH_BAND in NUMBER default NULL
10 ,P_AMOUNT1 in NUMBER default NULL
11 ,P_AMOUNT2 in NUMBER default NULL
12 ,P_AMOUNT3 in NUMBER default NULL
13 ,P_AMOUNT4 in NUMBER default NULL
14 ,P_AMOUNT5 in NUMBER default NULL
15 ,P_AMOUNT6 in NUMBER default NULL
16 ,P_AMOUNT7 in NUMBER default NULL
17 ,P_AMOUNT8 in NUMBER default NULL
18 ,p_EFFECTIVE_START_DATE in DATE default NULL
19 ,p_EFFECTIVE_END_DATE in DATE default NULL
20 ,p_object_version_number OUT nocopy number
21 ,p_range_id OUT nocopy number
22 )
23
24 IS
25
26 l_object_version_number number;
27 l_range_id number;
28
29 BEGIN
30
31 l_object_version_number := 1;
32
33
34 pay_ran_ins.ins
35 (
36 p_RANGE_TABLE_ID => p_RANGE_TABLE_ID
37 ,P_LOW_BAND => P_LOW_BAND
38 ,P_HIGH_BAND => P_HIGH_BAND
39 ,P_AMOUNT1 => P_AMOUNT1
40 ,P_AMOUNT2 => P_AMOUNT2
41 ,P_AMOUNT3 => P_AMOUNT3
42 ,P_AMOUNT4 => P_AMOUNT4
43 ,P_AMOUNT5 => P_AMOUNT5
44 ,P_AMOUNT6 => P_AMOUNT6
45 ,P_AMOUNT7 => P_AMOUNT7
46 ,P_AMOUNT8 => P_AMOUNT8
47 ,p_EFFECTIVE_START_DATE => p_EFFECTIVE_START_DATE
48 ,p_EFFECTIVE_END_DATE => p_EFFECTIVE_END_DATE
49 ,p_OBJECT_VERSION_NUMBER => l_object_version_number
50 ,p_range_id => l_range_id
51 );
52
53
54 p_object_version_number := l_object_version_number;
55 p_range_id := l_range_id;
56
57
58
59 end create_range;
60
61
62 procedure update_range
63 ( p_range_id in number
64 ,p_object_version_number in out nocopy number
65 ,p_range_table_id in number default hr_api.g_number
66 ,p_low_band in number default hr_api.g_number
67 ,p_high_band in number default hr_api.g_number
68 ,p_amount1 in number default hr_api.g_number
69 ,p_amount2 in number default hr_api.g_number
70 ,p_amount3 in number default hr_api.g_number
71 ,p_amount4 in number default hr_api.g_number
72 ,p_amount5 in number default hr_api.g_number
73 ,p_amount6 in number default hr_api.g_number
74 ,p_amount7 in number default hr_api.g_number
75 ,p_amount8 in number default hr_api.g_number
76 ,p_effective_start_date in date default hr_api.g_date
77 ,p_effective_end_date in date default hr_api.g_date
78 )
79
80 IS
81
82 l_object_version_number number;
83
84
85 BEGIN
86
87 l_object_version_number := p_object_version_number;
88
89
90 pay_ran_upd.upd
91 (
92 p_range_id => p_range_id
93 ,p_RANGE_TABLE_ID => p_RANGE_TABLE_ID
94 ,P_LOW_BAND => P_LOW_BAND
95 ,P_HIGH_BAND => P_HIGH_BAND
96 ,P_AMOUNT1 => P_AMOUNT1
97 ,P_AMOUNT2 => P_AMOUNT2
98 ,P_AMOUNT3 => P_AMOUNT3
99 ,P_AMOUNT4 => P_AMOUNT4
100 ,P_AMOUNT5 => P_AMOUNT5
101 ,P_AMOUNT6 => P_AMOUNT6
102 ,P_AMOUNT7 => P_AMOUNT7
103 ,P_AMOUNT8 => P_AMOUNT8
104 ,p_EFFECTIVE_START_DATE => p_EFFECTIVE_START_DATE
105 ,p_EFFECTIVE_END_DATE => p_EFFECTIVE_END_DATE
106 ,p_OBJECT_VERSION_NUMBER => l_object_version_number
107 );
108
109
110 p_object_version_number := l_object_version_number;
111
112 end update_range;
113
114 procedure delete_range
115 ( p_range_id in number
116 ,p_object_version_number in number
117 )
118
119 IS
120
121
122 BEGIN
123
124
125 pay_ran_del.del
126 (
127 p_range_id => p_range_id
128 ,p_OBJECT_VERSION_NUMBER => p_object_version_number
129 );
130
131
132 end delete_range;
133
134
135 END pay_range_api;