1 Package ota_lp_category_bk2 as
2 /* $Header: otlciapi.pkh 120.1 2005/10/02 02:07:34 aroussel $ */
3 -- ----------------------------------------------------------------------------
4 -- |----------------< update_lp_cat_inclusion_b >----------------------------|
5 -- ----------------------------------------------------------------------------
6 procedure update_lp_cat_inclusion_b
7 (p_effective_date in date,
8 p_learning_path_id in number,
9 p_object_version_number in number,
10 p_attribute_category in varchar2,
11 p_attribute1 in varchar2,
12 p_attribute2 in varchar2,
13 p_attribute3 in varchar2,
14 p_attribute4 in varchar2,
15 p_attribute5 in varchar2,
16 p_attribute6 in varchar2,
17 p_attribute7 in varchar2,
18 p_attribute8 in varchar2,
19 p_attribute9 in varchar2,
20 p_attribute10 in varchar2,
21 p_attribute11 in varchar2,
22 p_attribute12 in varchar2,
23 p_attribute13 in varchar2,
24 p_attribute14 in varchar2,
25 p_attribute15 in varchar2,
26 p_attribute16 in varchar2,
27 p_attribute17 in varchar2,
28 p_attribute18 in varchar2,
29 p_attribute19 in varchar2,
30 p_attribute20 in varchar2,
31 p_start_date_active in date ,
32 p_end_date_active in date ,
33 p_primary_flag in varchar2 ,
34 p_category_usage_id in number
35 );
36
37 --
38 -- ----------------------------------------------------------------------------
39 -- |-------------------------< update_lp_cat_inclusion_a >-------------------------|
40 -- ----------------------------------------------------------------------------
41 --
42 procedure update_lp_cat_inclusion_a
43 (p_effective_date in date,
44 p_learning_path_id in number,
45 p_object_version_number in number,
46 p_attribute_category in varchar2,
47 p_attribute1 in varchar2,
48 p_attribute2 in varchar2,
49 p_attribute3 in varchar2,
50 p_attribute4 in varchar2,
51 p_attribute5 in varchar2,
52 p_attribute6 in varchar2,
53 p_attribute7 in varchar2,
54 p_attribute8 in varchar2,
55 p_attribute9 in varchar2,
56 p_attribute10 in varchar2,
57 p_attribute11 in varchar2,
58 p_attribute12 in varchar2,
59 p_attribute13 in varchar2,
60 p_attribute14 in varchar2,
61 p_attribute15 in varchar2,
62 p_attribute16 in varchar2,
63 p_attribute17 in varchar2,
64 p_attribute18 in varchar2,
65 p_attribute19 in varchar2,
66 p_attribute20 in varchar2,
67 p_start_date_active in date ,
68 p_end_date_active in date ,
69 p_primary_flag in varchar2 ,
70 p_category_usage_id in number
71 );
72
73 end ota_lp_category_bk2;