[Home] [Help]
PACKAGE: APPS.PV_PARTNER_PROGRAM_PKG
Source
1 PACKAGE PV_PARTNER_PROGRAM_PKG AUTHID CURRENT_USER as
2 /* $Header: pvxtprgs.pls 115.9 2003/08/27 19:45:54 pukken ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- PV_PARTNER_PROGRAM_PKG
7 -- Purpose
8 --
9 -- History
10 -- 28-FEB-2002 Ravi.Mikkilineni Created
11 -- 1-APR-2002 Peter.Nixon Modified
12 -- - MEMBERSHIP columns (4) made nullable
13 -- - removed SOURCE_LANG column
14 -- 22-APR-2002 Peter.Nixon Modified
15 -- - restored SOURCE_LANG column
16 -- - removed PROGRAM_SHORT_NAME column
17 -- - changed PROGRAM_SETUP_TYPE column to PROGRAM_TYPE_ID
18 -- - added CUSTOM_SETUP_ID column
19 -- - added ENABLED_FLAG column
20 -- - added ATTRIBUTE_CATEGORY column
21 -- - added ATTRIBUTE1 thru ATTRIBUTE15 columns
22 -- 26-Jun-2002 - pukken: added user_status_id column.
23 -- 28-Jun-2002 - added submit_child_nodes column
24 -- 09-Sep-2002 - added columns inventory_item_id ,inventory_item_org_id,
25 -- bus_user_resp_id ,admin_resp_id,no_fee_flag,qsnr_ttl_all_page_dsp_flag ,
26 -- qsnr_hdr_all_page_dsp_flag ,qsnr_ftr_all_page_dsp_flag ,allow_enrl_wout_chklst_flag,
27 -- qsnr_title ,qsnr_header,qsnr_footer
28 -- 10-Sep-2002 - removed columns membership_fees and membership_currency_names
29 -- 06/27/2003 pukken Code changes for 3 new columns for 11.5.10 enhancements
30 -- NOTE
31 --
32 -- Copyright (c) 2002 Oracle Corporation Redwood Shores, California, USA
33 -- All rights reserved.
34 --
35 -- End of Comments
36 -- ===============================================================
37
38
39 PROCEDURE Insert_Row(
40 px_program_id IN OUT NOCOPY NUMBER
41 ,p_PROGRAM_TYPE_ID NUMBER
42 ,p_custom_setup_id NUMBER
43 ,p_program_level_code VARCHAR2
44 ,p_program_parent_id NUMBER
45 ,p_program_owner_resource_id NUMBER
46 ,p_program_start_date DATE
47 ,p_program_end_date DATE
48 ,p_allow_enrl_until_date DATE
49 ,p_citem_version_id NUMBER
50 ,p_membership_valid_period NUMBER
51 ,p_membership_period_unit VARCHAR2
52 ,p_process_rule_id NUMBER
53 ,p_prereq_process_rule_Id NUMBER
54 ,p_program_status_code VARCHAR2
55 ,p_submit_child_nodes VARCHAR2
56 ,p_inventory_item_id NUMBER
57 ,p_inventory_item_org_id NUMBER
58 ,p_bus_user_resp_id NUMBER
59 ,p_admin_resp_id NUMBER
60 ,p_no_fee_flag VARCHAR2
61 ,p_vad_invite_allow_flag VARCHAR2
62 ,p_global_mmbr_reqd_flag VARCHAR2
63 ,p_waive_subsidiary_fee_flag VARCHAR2
64 ,p_qsnr_ttl_all_page_dsp_flag VARCHAR2
65 ,p_qsnr_hdr_all_page_dsp_flag VARCHAR2
66 ,p_qsnr_ftr_all_page_dsp_flag VARCHAR2
67 ,p_allow_enrl_wout_chklst_flag VARCHAR2
68 ,p_user_status_id NUMBER
69 ,p_enabled_flag VARCHAR2
70 ,p_attribute_category VARCHAR2
71 ,p_attribute1 VARCHAR2
72 ,p_attribute2 VARCHAR2
73 ,p_attribute3 VARCHAR2
74 ,p_attribute4 VARCHAR2
75 ,p_attribute5 VARCHAR2
76 ,p_attribute6 VARCHAR2
77 ,p_attribute7 VARCHAR2
78 ,p_attribute8 VARCHAR2
79 ,p_attribute9 VARCHAR2
80 ,p_attribute10 VARCHAR2
81 ,p_attribute11 VARCHAR2
82 ,p_attribute12 VARCHAR2
83 ,p_attribute13 VARCHAR2
84 ,p_attribute14 VARCHAR2
85 ,p_attribute15 VARCHAR2
86 ,p_last_update_date DATE
87 ,p_last_updated_by NUMBER
88 ,p_creation_date DATE
89 ,p_created_by NUMBER
90 ,p_last_update_login NUMBER
91 ,p_object_version_number NUMBER
92 ,p_program_name VARCHAR2
93 ,p_program_description VARCHAR2
94 ,p_source_lang VARCHAR2
95 ,p_qsnr_title VARCHAR2
96 ,p_qsnr_header VARCHAR2
97 ,p_qsnr_footer VARCHAR2
98 );
99
100 PROCEDURE Update_Row(
101 p_program_id NUMBER
102 ,p_PROGRAM_TYPE_ID NUMBER
103 ,p_custom_setup_id NUMBER
104 ,p_program_level_code VARCHAR2
105 ,p_program_parent_id NUMBER
106 ,p_program_owner_resource_id NUMBER
107 ,p_program_start_date DATE
108 ,p_program_end_date DATE
109 ,p_allow_enrl_until_date DATE
110 ,p_citem_version_id NUMBER
111 ,p_membership_valid_period NUMBER
112 ,p_membership_period_unit VARCHAR2
113 ,p_process_rule_id NUMBER
114 ,p_prereq_process_rule_Id NUMBER
115 ,p_program_status_code VARCHAR2
116 ,p_submit_child_nodes VARCHAR2
117 ,p_inventory_item_id NUMBER
118 ,p_inventory_item_org_id NUMBER
119 ,p_bus_user_resp_id NUMBER
120 ,p_admin_resp_id NUMBER
121 ,p_no_fee_flag VARCHAR2
122 ,p_vad_invite_allow_flag VARCHAR2
123 ,p_global_mmbr_reqd_flag VARCHAR2
124 ,p_waive_subsidiary_fee_flag VARCHAR2
125 ,p_qsnr_ttl_all_page_dsp_flag VARCHAR2
126 ,p_qsnr_hdr_all_page_dsp_flag VARCHAR2
127 ,p_qsnr_ftr_all_page_dsp_flag VARCHAR2
128 ,p_allow_enrl_wout_chklst_flag VARCHAR2
129 ,p_user_status_id NUMBER
130 ,p_enabled_flag VARCHAR2
131 ,p_attribute_category VARCHAR2
132 ,p_attribute1 VARCHAR2
133 ,p_attribute2 VARCHAR2
134 ,p_attribute3 VARCHAR2
135 ,p_attribute4 VARCHAR2
136 ,p_attribute5 VARCHAR2
137 ,p_attribute6 VARCHAR2
138 ,p_attribute7 VARCHAR2
139 ,p_attribute8 VARCHAR2
140 ,p_attribute9 VARCHAR2
141 ,p_attribute10 VARCHAR2
142 ,p_attribute11 VARCHAR2
143 ,p_attribute12 VARCHAR2
144 ,p_attribute13 VARCHAR2
145 ,p_attribute14 VARCHAR2
146 ,p_attribute15 VARCHAR2
147 ,p_last_update_date DATE
148 ,p_last_updated_by NUMBER
149 ,p_last_update_login NUMBER
150 ,p_object_version_number NUMBER
151 ,p_program_name VARCHAR2
152 ,p_program_description VARCHAR2
153 ,p_qsnr_title VARCHAR2
154 ,p_qsnr_header VARCHAR2
155 ,p_qsnr_footer VARCHAR2
156 );
157
158 PROCEDURE Delete_Row(
159 p_program_id NUMBER
160 ,p_object_version_number NUMBER
161 );
162
163 PROCEDURE Lock_Row(
164 px_program_id IN OUT NOCOPY NUMBER
165 ,p_PROGRAM_TYPE_ID NUMBER
166 ,p_custom_setup_id NUMBER
167 ,p_program_level_code VARCHAR2
168 ,p_program_parent_id NUMBER
169 ,p_program_owner_resource_id NUMBER
170 ,p_program_start_date DATE
171 ,p_program_end_date DATE
172 ,p_allow_enrl_until_date DATE
173 ,p_citem_version_id NUMBER
174 ,p_membership_valid_period NUMBER
175 ,p_membership_period_unit VARCHAR2
176 ,p_process_rule_id NUMBER
177 ,p_prereq_process_rule_Id NUMBER
178 ,p_program_status_code VARCHAR2
179 ,p_submit_child_nodes VARCHAR2
180 ,p_inventory_item_id NUMBER
181 ,p_inventory_item_org_id NUMBER
182 ,p_bus_user_resp_id NUMBER
183 ,p_admin_resp_id NUMBER
184 ,p_no_fee_flag VARCHAR2
185 ,p_vad_invite_allow_flag VARCHAR2
186 ,p_global_mmbr_reqd_flag VARCHAR2
187 ,p_waive_subsidiary_fee_flag VARCHAR2
188 ,p_qsnr_ttl_all_page_dsp_flag VARCHAR2
189 ,p_qsnr_hdr_all_page_dsp_flag VARCHAR2
190 ,p_qsnr_ftr_all_page_dsp_flag VARCHAR2
191 ,p_allow_enrl_wout_chklst_flag VARCHAR2
192 ,p_user_status_id NUMBER
193 ,p_enabled_flag VARCHAR2
194 ,p_attribute_category VARCHAR2
195 ,p_attribute1 VARCHAR2
196 ,p_attribute2 VARCHAR2
197 ,p_attribute3 VARCHAR2
198 ,p_attribute4 VARCHAR2
199 ,p_attribute5 VARCHAR2
200 ,p_attribute6 VARCHAR2
201 ,p_attribute7 VARCHAR2
202 ,p_attribute8 VARCHAR2
203 ,p_attribute9 VARCHAR2
204 ,p_attribute10 VARCHAR2
205 ,p_attribute11 VARCHAR2
206 ,p_attribute12 VARCHAR2
207 ,p_attribute13 VARCHAR2
208 ,p_attribute14 VARCHAR2
209 ,p_attribute15 VARCHAR2
210 ,p_last_update_date DATE
211 ,p_last_updated_by NUMBER
212 ,p_creation_date DATE
213 ,p_created_by NUMBER
214 ,p_last_update_login NUMBER
215 ,px_object_version_number IN OUT NOCOPY NUMBER
216 );
217
218 PROCEDURE Add_Language;
219
220 PROCEDURE Translate_Row(
221 px_program_id IN VARCHAR2
222 ,p_program_name IN VARCHAR2
223 ,p_program_description IN VARCHAR2
224 ,p_owner IN VARCHAR2
225 ,p_qsnr_title IN VARCHAR2
226 ,p_qsnr_header IN VARCHAR2
227 ,p_qsnr_footer IN VARCHAR2
228 );
229
230
231 END PV_PARTNER_PROGRAM_PKG;