1 Package ben_dpnt_elig_crit_val_bk2 AUTHID CURRENT_USER AS
2 /* $Header: beedvapi.pkh 120.2 2010/05/18 07:13:16 sgnanama noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |---------------------------< update_dpnt_eligy_crit_val_b >-----------------|
6 -- ----------------------------------------------------------------------------
7 --
8 procedure update_dpnt_eligy_crit_val_b
9 (
10 p_dpnt_eligy_crit_values_id In Number
11 ,p_dpnt_cvg_eligy_prfl_id In Number
12 ,p_eligy_criteria_dpnt_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_edc_attribute_category In Varchar2
23 ,p_edc_attribute1 In Varchar2
24 ,p_edc_attribute2 In Varchar2
25 ,p_edc_attribute3 In Varchar2
26 ,p_edc_attribute4 In Varchar2
27 ,p_edc_attribute5 In Varchar2
28 ,p_edc_attribute6 In Varchar2
29 ,p_edc_attribute7 In Varchar2
30 ,p_edc_attribute8 In Varchar2
31 ,p_edc_attribute9 In Varchar2
32 ,p_edc_attribute10 In Varchar2
33 ,p_edc_attribute11 In Varchar2
34 ,p_edc_attribute12 In Varchar2
35 ,p_edc_attribute13 In Varchar2
36 ,p_edc_attribute14 In Varchar2
37 ,p_edc_attribute15 In Varchar2
38 ,p_edc_attribute16 In Varchar2
39 ,p_edc_attribute17 In Varchar2
40 ,p_edc_attribute18 In Varchar2
41 ,p_edc_attribute19 In Varchar2
42 ,p_edc_attribute20 In Varchar2
43 ,p_edc_attribute21 In Varchar2
44 ,p_edc_attribute22 In Varchar2
45 ,p_edc_attribute23 In Varchar2
46 ,p_edc_attribute24 In Varchar2
47 ,p_edc_attribute25 In Varchar2
48 ,p_edc_attribute26 In Varchar2
49 ,p_edc_attribute27 In Varchar2
50 ,p_edc_attribute28 In Varchar2
51 ,p_edc_attribute29 In Varchar2
52 ,p_edc_attribute30 In Varchar2
53 ,p_object_version_number In Number
54 ,p_effective_date In Date
55 ,p_datetrack_mode In Varchar2
56 ,p_char_value3 In Varchar2
57 ,p_char_value4 In Varchar2
58 ,p_number_value3 In Number
59 ,p_number_value4 In Number
60 ,p_date_value3 In Date
61 ,p_date_value4 In Date
62 );
63 --
64 -- ----------------------------------------------------------------------------
65 -- |---------------------------< update_dpnt_eligy_crit_val_a >-----------------|
66 -- ----------------------------------------------------------------------------
67 --
68 procedure update_dpnt_eligy_crit_val_a
69 (
70 p_dpnt_eligy_crit_values_id In Number
71 ,p_dpnt_cvg_eligy_prfl_id In Number
72 ,p_eligy_criteria_dpnt_id In Number
73 ,p_ordr_num In Number
74 ,p_effective_start_date In Date
75 ,p_effective_end_date In Date
76 ,p_number_value1 In Number
77 ,p_number_value2 In Number
78 ,p_char_value1 In Varchar2
79 ,p_char_value2 In Varchar2
80 ,p_date_value1 In Date
81 ,p_date_value2 In Date
82 ,p_excld_flag In Varchar2
83 ,p_business_group_id In Number
84 ,p_edc_attribute_category In Varchar2
85 ,p_edc_attribute1 In Varchar2
86 ,p_edc_attribute2 In Varchar2
87 ,p_edc_attribute3 In Varchar2
88 ,p_edc_attribute4 In Varchar2
89 ,p_edc_attribute5 In Varchar2
90 ,p_edc_attribute6 In Varchar2
91 ,p_edc_attribute7 In Varchar2
92 ,p_edc_attribute8 In Varchar2
93 ,p_edc_attribute9 In Varchar2
94 ,p_edc_attribute10 In Varchar2
95 ,p_edc_attribute11 In Varchar2
96 ,p_edc_attribute12 In Varchar2
97 ,p_edc_attribute13 In Varchar2
98 ,p_edc_attribute14 In Varchar2
99 ,p_edc_attribute15 In Varchar2
100 ,p_edc_attribute16 In Varchar2
101 ,p_edc_attribute17 In Varchar2
102 ,p_edc_attribute18 In Varchar2
103 ,p_edc_attribute19 In Varchar2
104 ,p_edc_attribute20 In Varchar2
105 ,p_edc_attribute21 In Varchar2
106 ,p_edc_attribute22 In Varchar2
107 ,p_edc_attribute23 In Varchar2
108 ,p_edc_attribute24 In Varchar2
109 ,p_edc_attribute25 In Varchar2
110 ,p_edc_attribute26 In Varchar2
111 ,p_edc_attribute27 In Varchar2
112 ,p_edc_attribute28 In Varchar2
113 ,p_edc_attribute29 In Varchar2
114 ,p_edc_attribute30 In Varchar2
115 ,p_object_version_number In Number
116 ,p_effective_date In Date
117 ,p_datetrack_mode In Varchar2
118 ,p_char_value3 In Varchar2
119 ,p_char_value4 In Varchar2
120 ,p_number_value3 In Number
121 ,p_number_value4 In Number
122 ,p_date_value3 In Date
123 ,p_date_value4 In Date
124 );
125 --
126 end ben_dpnt_elig_crit_val_bk2;
[Home] [Help]