1 Package ben_eligy_crit_values_bk2 AS
2 /* $Header: beecvapi.pkh 120.1 2005/07/29 09:50:47 rbingi noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |---------------------------< update_eligy_crit_values_b >-----------------|
6 -- ----------------------------------------------------------------------------
7 --
8 procedure update_eligy_crit_values_b
9 (
10 p_eligy_crit_values_id In Number
11 ,p_eligy_prfl_id In Number
12 ,p_eligy_criteria_id In Number
13 ,p_ordr_num In Number
14 ,p_number_value1 In Number
15 ,p_number_value2 In Number
16 ,p_char_value1 In Varchar2
17 ,p_char_value2 In Varchar2
18 ,p_date_value1 In Date
19 ,p_date_value2 In Date
20 ,p_excld_flag In Varchar2
21 ,p_business_group_id In Number
22 ,p_ecv_attribute_category In Varchar2
23 ,p_ecv_attribute1 In Varchar2
24 ,p_ecv_attribute2 In Varchar2
25 ,p_ecv_attribute3 In Varchar2
26 ,p_ecv_attribute4 In Varchar2
27 ,p_ecv_attribute5 In Varchar2
28 ,p_ecv_attribute6 In Varchar2
29 ,p_ecv_attribute7 In Varchar2
30 ,p_ecv_attribute8 In Varchar2
31 ,p_ecv_attribute9 In Varchar2
32 ,p_ecv_attribute10 In Varchar2
33 ,p_ecv_attribute11 In Varchar2
34 ,p_ecv_attribute12 In Varchar2
35 ,p_ecv_attribute13 In Varchar2
36 ,p_ecv_attribute14 In Varchar2
37 ,p_ecv_attribute15 In Varchar2
38 ,p_ecv_attribute16 In Varchar2
39 ,p_ecv_attribute17 In Varchar2
40 ,p_ecv_attribute18 In Varchar2
41 ,p_ecv_attribute19 In Varchar2
42 ,p_ecv_attribute20 In Varchar2
43 ,p_ecv_attribute21 In Varchar2
44 ,p_ecv_attribute22 In Varchar2
45 ,p_ecv_attribute23 In Varchar2
46 ,p_ecv_attribute24 In Varchar2
47 ,p_ecv_attribute25 In Varchar2
48 ,p_ecv_attribute26 In Varchar2
49 ,p_ecv_attribute27 In Varchar2
50 ,p_ecv_attribute28 In Varchar2
51 ,p_ecv_attribute29 In Varchar2
52 ,p_ecv_attribute30 In Varchar2
53 ,p_object_version_number In Number
54 ,p_effective_date In Date
55 ,p_datetrack_mode In Varchar2
56 ,p_criteria_score In Number
57 ,p_criteria_weight In Number
58 ,p_char_value3 In Varchar2
59 ,p_char_value4 In Varchar2
60 ,p_number_value3 In Number
61 ,p_number_value4 In Number
62 ,p_date_value3 In Date
63 ,p_date_value4 In Date
64 );
65 --
66 -- ----------------------------------------------------------------------------
67 -- |---------------------------< update_eligy_crit_values_a >-----------------|
68 -- ----------------------------------------------------------------------------
69 --
70 procedure update_eligy_crit_values_a
71 (
72 p_eligy_crit_values_id In Number
73 ,p_eligy_prfl_id In Number
74 ,p_eligy_criteria_id In Number
75 ,p_ordr_num In Number
76 ,p_effective_start_date In Date
77 ,p_effective_end_date In Date
78 ,p_number_value1 In Number
79 ,p_number_value2 In Number
80 ,p_char_value1 In Varchar2
81 ,p_char_value2 In Varchar2
82 ,p_date_value1 In Date
83 ,p_date_value2 In Date
84 ,p_excld_flag In Varchar2
85 ,p_business_group_id In Number
86 ,p_ecv_attribute_category In Varchar2
87 ,p_ecv_attribute1 In Varchar2
88 ,p_ecv_attribute2 In Varchar2
89 ,p_ecv_attribute3 In Varchar2
90 ,p_ecv_attribute4 In Varchar2
91 ,p_ecv_attribute5 In Varchar2
92 ,p_ecv_attribute6 In Varchar2
93 ,p_ecv_attribute7 In Varchar2
94 ,p_ecv_attribute8 In Varchar2
95 ,p_ecv_attribute9 In Varchar2
96 ,p_ecv_attribute10 In Varchar2
97 ,p_ecv_attribute11 In Varchar2
98 ,p_ecv_attribute12 In Varchar2
99 ,p_ecv_attribute13 In Varchar2
100 ,p_ecv_attribute14 In Varchar2
101 ,p_ecv_attribute15 In Varchar2
102 ,p_ecv_attribute16 In Varchar2
103 ,p_ecv_attribute17 In Varchar2
104 ,p_ecv_attribute18 In Varchar2
105 ,p_ecv_attribute19 In Varchar2
106 ,p_ecv_attribute20 In Varchar2
107 ,p_ecv_attribute21 In Varchar2
108 ,p_ecv_attribute22 In Varchar2
109 ,p_ecv_attribute23 In Varchar2
110 ,p_ecv_attribute24 In Varchar2
111 ,p_ecv_attribute25 In Varchar2
112 ,p_ecv_attribute26 In Varchar2
113 ,p_ecv_attribute27 In Varchar2
114 ,p_ecv_attribute28 In Varchar2
115 ,p_ecv_attribute29 In Varchar2
116 ,p_ecv_attribute30 In Varchar2
117 ,p_object_version_number In Number
118 ,p_effective_date In Date
119 ,p_datetrack_mode In Varchar2
120 ,p_criteria_score In Number
121 ,p_criteria_weight In Number
122 ,p_char_value3 In Varchar2
123 ,p_char_value4 In Varchar2
124 ,p_number_value3 In Number
125 ,p_number_value4 In Number
126 ,p_date_value3 In Date
127 ,p_date_value4 In Date
128 );
129 --
130 end ben_eligy_crit_values_bk2;
[Home] [Help]