1 Package ota_activity_version_bk2 AUTHID CURRENT_USER as
2 /* $Header: ottavapi.pkh 120.5 2009/08/11 13:01:22 smahanka ship $ */
3 -- ----------------------------------------------------------------------------
4 -- |----------------< update_activity_version_b >----------------------------|
5 -- ----------------------------------------------------------------------------
6 procedure update_activity_version_b
7 (p_effective_date in date,
8 p_activity_id in number,
9 p_superseded_by_act_version_id in number,
10 p_developer_organization_id in number,
11 p_object_version_number in number,
12 p_controlling_person_id in number,
13 p_version_name in varchar2,
14 p_comments in varchar2,
15 p_description in varchar2,
16 p_duration in number,
17 p_duration_units in varchar2,
18 p_end_date in date ,
19 p_intended_audience in varchar2,
20 p_language_id in number ,
21 p_maximum_attendees in number ,
22 p_minimum_attendees in number ,
23 p_objectives in varchar2,
24 p_start_date in date ,
25 p_success_criteria in varchar2,
26 p_user_status in varchar2,
27 p_vendor_id in number ,
28 p_actual_cost in number ,
29 p_budget_cost in number ,
30 p_budget_currency_code in varchar2,
31 p_expenses_allowed in varchar2,
32 p_professional_credit_type in varchar2,
33 p_professional_credits in number ,
34 p_maximum_internal_attendees in number ,
35 p_tav_information_category in varchar2,
36 p_tav_information1 in varchar2,
37 p_tav_information2 in varchar2,
38 p_tav_information3 in varchar2,
39 p_tav_information4 in varchar2,
40 p_tav_information5 in varchar2,
41 p_tav_information6 in varchar2,
42 p_tav_information7 in varchar2,
43 p_tav_information8 in varchar2,
44 p_tav_information9 in varchar2,
45 p_tav_information10 in varchar2,
46 p_tav_information11 in varchar2,
47 p_tav_information12 in varchar2,
48 p_tav_information13 in varchar2,
49 p_tav_information14 in varchar2,
50 p_tav_information15 in varchar2,
51 p_tav_information16 in varchar2,
52 p_tav_information17 in varchar2,
53 p_tav_information18 in varchar2,
54 p_tav_information19 in varchar2,
55 p_tav_information20 in varchar2,
56 p_inventory_item_id in number,
57 p_organization_id in number,
58 p_rco_id in number,
59 p_version_code in varchar2,
60 p_business_group_id in number,
61 p_data_source in varchar2,
62 p_activity_version_id in number
63 ,p_competency_update_level in varchar2
64
65 );
66
67 --
68 -- ----------------------------------------------------------------------------
69 -- |-------------------------< update_activity_version_a >--------------------|
70 -- ----------------------------------------------------------------------------
71 --
72 procedure update_activity_version_a
73 (p_effective_date in date,
74 p_activity_id in number,
75 p_object_version_number in number,
76 p_superseded_by_act_version_id in number,
77 p_developer_organization_id in number,
78 p_controlling_person_id in number,
79 p_version_name in varchar2,
80 p_comments in varchar2,
81 p_description in varchar2,
82 p_duration in number,
83 p_duration_units in varchar2,
84 p_end_date in date ,
85 p_intended_audience in varchar2,
86 p_language_id in number ,
87 p_maximum_attendees in number ,
88 p_minimum_attendees in number ,
89 p_objectives in varchar2,
90 p_start_date in date ,
91 p_success_criteria in varchar2,
92 p_user_status in varchar2,
93 p_vendor_id in number ,
94 p_actual_cost in number ,
95 p_budget_cost in number ,
96 p_budget_currency_code in varchar2,
97 p_expenses_allowed in varchar2,
98 p_professional_credit_type in varchar2,
99 p_professional_credits in number ,
100 p_maximum_internal_attendees in number ,
101 p_tav_information_category in varchar2,
102 p_tav_information1 in varchar2,
103 p_tav_information2 in varchar2,
104 p_tav_information3 in varchar2,
105 p_tav_information4 in varchar2,
106 p_tav_information5 in varchar2,
107 p_tav_information6 in varchar2,
108 p_tav_information7 in varchar2,
109 p_tav_information8 in varchar2,
110 p_tav_information9 in varchar2,
111 p_tav_information10 in varchar2,
112 p_tav_information11 in varchar2,
113 p_tav_information12 in varchar2,
114 p_tav_information13 in varchar2,
115 p_tav_information14 in varchar2,
116 p_tav_information15 in varchar2,
117 p_tav_information16 in varchar2,
118 p_tav_information17 in varchar2,
119 p_tav_information18 in varchar2,
120 p_tav_information19 in varchar2,
121 p_tav_information20 in varchar2,
122 p_inventory_item_id in number,
123 p_organization_id in number,
124 p_rco_id in number,
125 p_version_code in varchar2,
126 p_business_group_id in number,
127 p_data_source in varchar2,
128 p_activity_version_id in number
129 ,p_competency_update_level in varchar2
130
131 );
132
133 end ota_activity_version_bk2 ;