[Home] [Help]
PACKAGE: APPS.OZF_PROMOTIONAL_OFFERS_PKG
Source
1 PACKAGE OZF_Promotional_Offers_PKG AS
2 /* $Header: ozftopos.pls 120.3 2006/04/05 14:47:38 rssharma noship $ */
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 -- End of Comments
20 -- ===============================================================
21
22 PROCEDURE Insert_Row(
23 px_offer_id IN OUT NOCOPY NUMBER,
24 p_qp_list_header_id NUMBER,
25 p_offer_type VARCHAR2,
26 p_offer_code VARCHAR2,
27 p_activity_media_id NUMBER,
28 p_reusable VARCHAR2,
29 p_user_status_id NUMBER,
30 p_owner_id NUMBER,
31 p_wf_item_key VARCHAR2,
32 p_customer_reference VARCHAR2,
33 p_buying_group_contact_id NUMBER,
34 p_last_update_date DATE,
35 p_last_updated_by NUMBER,
36 p_creation_date DATE,
37 p_created_by NUMBER,
38 p_last_update_login NUMBER,
39 px_object_version_number IN OUT NOCOPY NUMBER,
40 p_perf_date_from DATE,
41 p_perf_date_to DATE,
42 p_status_code VARCHAR2,
43 p_status_date DATE,
44 p_modifier_level_code VARCHAR2,
45 p_order_value_discount_type VARCHAR2,
46 p_offer_amount NUMBER,
47 p_lumpsum_amount NUMBER,
48 p_lumpsum_payment_type VARCHAR2,
49 p_custom_setup_id NUMBER,
50 p_security_group_id NUMBER,
51 p_budget_amount_tc NUMBER,
52 p_budget_amount_fc NUMBER,
53 p_transaction_currency_Code VARCHAR2,
54 p_functional_currency_code VARCHAR2,
55 p_distribution_type VARCHAR2,
56 p_qualifier_id NUMBER,
57 p_qualifier_type VARCHAR2,
58 p_account_closed_flag VARCHAR2,
59 p_budget_offer_yn VARCHAR2,
60 p_break_type VARCHAR2,
61 p_retroactive VARCHAR2,
62 p_volume_offer_type VARCHAR2,
63 p_confidential_flag VARCHAR2,
64 p_budget_source_type VARCHAR2,
65 p_budget_source_id NUMBER,
66 p_source_from_parent VARCHAR2,
67 p_buyer_name VARCHAR2,
68 p_last_recal_date DATE,
69 p_date_qualifier VARCHAR2,
70 p_autopay_flag VARCHAR2,
71 p_autopay_days NUMBER,
72 p_autopay_method VARCHAR2,
73 p_autopay_party_attr VARCHAR2,
74 p_autopay_party_id NUMBER,
75 p_tier_level VARCHAR2,
76 p_na_rule_header_id NUMBER,
77 p_beneficiary_account_id NUMBER,
78 p_sales_method_flag VARCHAR2,
79 p_org_id NUMBER,
80 p_fund_request_curr_code VARCHAR2
81 );
82
83 PROCEDURE Update_Row(
84 p_offer_id NUMBER,
85 p_qp_list_header_id NUMBER,
86 p_offer_type VARCHAR2,
87 p_offer_code VARCHAR2,
88 p_activity_media_id NUMBER,
89 p_reusable VARCHAR2,
90 p_user_status_id NUMBER,
91 p_owner_id NUMBER,
92 p_wf_item_key VARCHAR2,
93 p_customer_reference VARCHAR2,
94 p_buying_group_contact_id NUMBER,
95 p_last_update_date DATE,
96 p_last_updated_by NUMBER,
97 p_last_update_login NUMBER,
98 p_object_version_number NUMBER,
99 p_perf_date_from DATE,
100 p_perf_date_to DATE,
101 p_status_code VARCHAR2,
102 p_status_date DATE,
103 p_modifier_level_code VARCHAR2,
104 p_order_value_discount_type VARCHAR2,
105 p_offer_amount NUMBER,
106 p_lumpsum_amount NUMBER,
107 p_lumpsum_payment_type VARCHAR2,
108 p_custom_setup_id NUMBER,
109 p_security_group_id NUMBER,
110 p_budget_amount_tc NUMBER,
111 p_budget_amount_fc NUMBER,
112 p_transaction_currency_Code VARCHAR2,
113 p_functional_currency_code VARCHAR2,
114 p_distribution_type VARCHAR2,
115 p_qualifier_id NUMBER,
116 p_qualifier_type VARCHAR2,
117 p_account_closed_flag VARCHAR2,
118 p_budget_offer_yn VARCHAR2,
119 p_break_type VARCHAR2,
120 p_retroactive VARCHAR2,
121 p_volume_offer_type VARCHAR2,
122 p_confidential_flag VARCHAR2,
123 p_budget_source_type VARCHAR2,
124 p_budget_source_id NUMBER,
125 p_source_from_parent VARCHAR2,
126 p_buyer_name VARCHAR2,
127 p_last_recal_date DATE,
128 p_date_qualifier VARCHAR2,
129 p_autopay_flag VARCHAR2,
130 p_autopay_days NUMBER,
131 p_autopay_method VARCHAR2,
132 p_autopay_party_attr VARCHAR2,
133 p_autopay_party_id NUMBER,
134 p_tier_level VARCHAR2,
135 p_na_rule_header_id NUMBER,
136 p_beneficiary_account_id NUMBER,
137 p_sales_method_flag VARCHAR2,
138 p_org_id NUMBER,
139 p_start_date DATE
140 );
141
142 PROCEDURE Delete_Row(
143 p_OFFER_ID NUMBER);
144 PROCEDURE Lock_Row(
145 p_offer_id NUMBER,
146 p_qp_list_header_id NUMBER,
147 p_offer_type VARCHAR2,
148 p_offer_code VARCHAR2,
149 p_activity_media_id NUMBER,
150 p_reusable VARCHAR2,
151 p_user_status_id NUMBER,
152 p_owner_id NUMBER,
153 p_wf_item_key VARCHAR2,
154 p_customer_reference VARCHAR2,
155 p_buying_group_contact_id NUMBER,
156 p_last_update_date DATE,
157 p_last_updated_by NUMBER,
158 p_creation_date DATE,
159 p_created_by NUMBER,
160 p_last_update_login NUMBER,
161 p_object_version_number NUMBER,
162 p_perf_date_from DATE,
163 p_perf_date_to DATE,
164 p_status_code VARCHAR2,
165 p_status_date DATE,
166 p_modifier_level_code VARCHAR2,
167 p_order_value_discount_type VARCHAR2,
168 p_offer_amount NUMBER,
169 p_lumpsum_amount NUMBER,
170 p_lumpsum_payment_type VARCHAR2,
171 p_custom_setup_id NUMBER,
172 p_security_group_id NUMBER,
173 p_budget_amount_tc NUMBER,
174 p_budget_amount_fc NUMBER,
175 p_transaction_currency_Code VARCHAR2,
176 p_functional_currency_code VARCHAR2,
177 p_distribution_type VARCHAR2,
178 p_qualifier_id NUMBER,
179 p_qualifier_type VARCHAR2,
180 p_account_closed_flag VARCHAR2,
181 p_budget_offer_yn VARCHAR2,
182 p_break_type VARCHAR2,
183 p_retroactive VARCHAR2,
184 p_volume_offer_type VARCHAR2,
185 p_confidential_flag VARCHAR2,
186 p_source_from_parent VARCHAR2,
187 p_buyer_name VARCHAR2,
188 p_last_recal_date DATE,
189 p_autopay_flag VARCHAR2,
190 p_autopay_days NUMBER,
191 p_autopay_method VARCHAR2,
192 p_autopay_party_attr VARCHAR2,
193 p_autopay_party_id NUMBER,
194 p_tier_level VARCHAR2,
195 p_na_rule_header_id NUMBER,
196 p_beneficiary_account_id NUMBER,
197 p_sales_method_flag VARCHAR2,
198 p_org_id NUMBER
199 );
200
201 END OZF_Promotional_Offers_PKG;