[Home] [Help]
PACKAGE: APPS.OZF_PROMOTIONAL_OFFERS_PKG
Source
1 PACKAGE OZF_Promotional_Offers_PKG AUTHID CURRENT_USER AS
2 /* $Header: ozftopos.pls 120.5.12020000.2 2013/01/30 08:29:12 apyadav ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- OZF_Promotional_Offers_PKG
7 -- Purpose
8 --
9 -- History
10 -- MAY-17-2002 julou modified. See bug 2380113
11 -- removed created_by and creation_date from update api
12 --
13 -- NOTE
14 --
15 -- 17-Oct-2002 RSSHARMA added last_recal_date and buyer_name
16 -- 24-Oct-2002 RSSHARMA Added date_qualifier_profile_value
17 -- Wed Apr 05 2006:2/29 PM RSSHARMA Fixed bug # 5142859.Added fund_request_curr_code to insert_row
18 -- Tue May 03 2005:3/35 PM RSSHARMA Added sales_method_flag field
19 -- Thu Mar 03 2011 nirprasa ER # 11806714 Added percent_discount field
20 -- 30-JAN-2013 apyadav Bug 14138664 - GSIAV: COPY OFFER DO NOT HAVE FLEXIBILITY TO CHOOSE THE CURRENCY
21 -- End of Comments
22 -- ===============================================================
23
24 PROCEDURE Insert_Row(
25 px_offer_id IN OUT NOCOPY NUMBER,
26 p_qp_list_header_id NUMBER,
27 p_offer_type VARCHAR2,
28 p_offer_code VARCHAR2,
29 p_activity_media_id NUMBER,
30 p_reusable VARCHAR2,
31 p_user_status_id NUMBER,
32 p_owner_id NUMBER,
33 p_wf_item_key VARCHAR2,
34 p_customer_reference VARCHAR2,
35 p_buying_group_contact_id NUMBER,
36 p_last_update_date DATE,
37 p_last_updated_by NUMBER,
38 p_creation_date DATE,
39 p_created_by NUMBER,
40 p_last_update_login NUMBER,
41 px_object_version_number IN OUT NOCOPY NUMBER,
42 p_perf_date_from DATE,
43 p_perf_date_to DATE,
44 p_status_code VARCHAR2,
45 p_status_date DATE,
46 p_modifier_level_code VARCHAR2,
47 p_order_value_discount_type VARCHAR2,
48 p_offer_amount NUMBER,
49 p_lumpsum_amount NUMBER,
50 p_lumpsum_payment_type VARCHAR2,
51 p_custom_setup_id NUMBER,
52 p_security_group_id NUMBER,
53 p_budget_amount_tc NUMBER,
54 p_budget_amount_fc NUMBER,
55 p_transaction_currency_Code VARCHAR2,
56 p_functional_currency_code VARCHAR2,
57 p_distribution_type VARCHAR2,
58 p_qualifier_id NUMBER,
59 p_qualifier_type VARCHAR2,
60 p_account_closed_flag VARCHAR2,
61 p_budget_offer_yn VARCHAR2,
62 p_break_type VARCHAR2,
63 p_retroactive VARCHAR2,
64 p_volume_offer_type VARCHAR2,
65 p_confidential_flag VARCHAR2,
66 p_budget_source_type VARCHAR2,
67 p_budget_source_id NUMBER,
68 p_source_from_parent VARCHAR2,
69 p_buyer_name VARCHAR2,
70 p_last_recal_date DATE,
71 p_date_qualifier VARCHAR2,
72 p_autopay_flag VARCHAR2,
73 p_autopay_days NUMBER,
74 p_autopay_method VARCHAR2,
75 p_autopay_party_attr VARCHAR2,
76 p_autopay_party_id NUMBER,
77 p_tier_level VARCHAR2,
78 p_na_rule_header_id NUMBER,
79 p_beneficiary_account_id NUMBER,
80 p_sales_method_flag VARCHAR2,
81 p_org_id NUMBER,
82 p_fund_request_curr_code VARCHAR2,
83 p_percent_discount NUMBER
84 );
85
86 PROCEDURE Update_Row(
87 p_offer_id NUMBER,
88 p_qp_list_header_id NUMBER,
89 p_offer_type VARCHAR2,
90 p_offer_code VARCHAR2,
91 p_activity_media_id NUMBER,
92 p_reusable VARCHAR2,
93 p_user_status_id NUMBER,
94 p_owner_id NUMBER,
95 p_wf_item_key VARCHAR2,
96 p_customer_reference VARCHAR2,
97 p_buying_group_contact_id NUMBER,
98 p_last_update_date DATE,
99 p_last_updated_by NUMBER,
100 p_last_update_login NUMBER,
101 p_object_version_number NUMBER,
102 p_perf_date_from DATE,
103 p_perf_date_to DATE,
104 p_status_code VARCHAR2,
105 p_status_date DATE,
106 p_modifier_level_code VARCHAR2,
107 p_order_value_discount_type VARCHAR2,
108 p_offer_amount NUMBER,
109 p_lumpsum_amount NUMBER,
110 p_lumpsum_payment_type VARCHAR2,
111 p_custom_setup_id NUMBER,
112 p_security_group_id NUMBER,
113 p_budget_amount_tc NUMBER,
114 p_budget_amount_fc NUMBER,
115 p_transaction_currency_Code VARCHAR2,
116 p_functional_currency_code VARCHAR2,
117 p_distribution_type VARCHAR2,
118 p_qualifier_id NUMBER,
119 p_qualifier_type VARCHAR2,
120 p_account_closed_flag VARCHAR2,
121 p_budget_offer_yn VARCHAR2,
122 p_break_type VARCHAR2,
123 p_retroactive VARCHAR2,
124 p_volume_offer_type VARCHAR2,
125 p_confidential_flag VARCHAR2,
126 p_budget_source_type VARCHAR2,
127 p_budget_source_id NUMBER,
128 p_source_from_parent VARCHAR2,
129 p_buyer_name VARCHAR2,
130 p_last_recal_date DATE,
131 p_date_qualifier VARCHAR2,
132 p_autopay_flag VARCHAR2,
133 p_autopay_days NUMBER,
134 p_autopay_method VARCHAR2,
135 p_autopay_party_attr VARCHAR2,
136 p_autopay_party_id NUMBER,
137 p_tier_level VARCHAR2,
138 p_na_rule_header_id NUMBER,
139 p_beneficiary_account_id NUMBER,
140 p_sales_method_flag VARCHAR2,
141 p_org_id NUMBER,
142 p_start_date DATE,
143 p_percent_discount NUMBER,
144 p_fund_request_curr_code VARCHAR2 ----For Bug 14138664
145 );
146
147 PROCEDURE Delete_Row(
148 p_OFFER_ID NUMBER);
149 PROCEDURE Lock_Row(
150 p_offer_id NUMBER,
151 p_qp_list_header_id NUMBER,
152 p_offer_type VARCHAR2,
153 p_offer_code VARCHAR2,
154 p_activity_media_id NUMBER,
155 p_reusable VARCHAR2,
156 p_user_status_id NUMBER,
157 p_owner_id NUMBER,
158 p_wf_item_key VARCHAR2,
159 p_customer_reference VARCHAR2,
160 p_buying_group_contact_id NUMBER,
161 p_last_update_date DATE,
162 p_last_updated_by NUMBER,
163 p_creation_date DATE,
164 p_created_by NUMBER,
165 p_last_update_login NUMBER,
166 p_object_version_number NUMBER,
167 p_perf_date_from DATE,
168 p_perf_date_to DATE,
169 p_status_code VARCHAR2,
170 p_status_date DATE,
171 p_modifier_level_code VARCHAR2,
172 p_order_value_discount_type VARCHAR2,
173 p_offer_amount NUMBER,
174 p_lumpsum_amount NUMBER,
175 p_lumpsum_payment_type VARCHAR2,
176 p_custom_setup_id NUMBER,
177 p_security_group_id NUMBER,
178 p_budget_amount_tc NUMBER,
179 p_budget_amount_fc NUMBER,
180 p_transaction_currency_Code VARCHAR2,
181 p_functional_currency_code VARCHAR2,
182 p_distribution_type VARCHAR2,
183 p_qualifier_id NUMBER,
184 p_qualifier_type VARCHAR2,
185 p_account_closed_flag VARCHAR2,
186 p_budget_offer_yn VARCHAR2,
187 p_break_type VARCHAR2,
188 p_retroactive VARCHAR2,
189 p_volume_offer_type VARCHAR2,
190 p_confidential_flag VARCHAR2,
191 p_source_from_parent VARCHAR2,
192 p_buyer_name VARCHAR2,
193 p_last_recal_date DATE,
194 p_autopay_flag VARCHAR2,
195 p_autopay_days NUMBER,
196 p_autopay_method VARCHAR2,
197 p_autopay_party_attr VARCHAR2,
198 p_autopay_party_id NUMBER,
199 p_tier_level VARCHAR2,
200 p_na_rule_header_id NUMBER,
201 p_beneficiary_account_id NUMBER,
202 p_sales_method_flag VARCHAR2,
203 p_org_id NUMBER,
204 p_percent_discount NUMBER
205 );
206
207 END OZF_Promotional_Offers_PKG;