[Home] [Help]
PACKAGE: APPS.ARP_PROCESS_SALESCREDIT
Source
1 PACKAGE ARP_PROCESS_SALESCREDIT AUTHID CURRENT_USER AS
2 /* $Header: ARTETLSS.pls 115.3 2003/08/12 01:00:07 kmahajan ship $ */
3
4
5 PROCEDURE insert_salescredit(
6 p_form_name IN varchar2,
7 p_form_version IN number,
8 p_run_auto_accounting_flag IN boolean,
9 p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
10 p_cust_trx_line_salesrep_id OUT NOCOPY
11 ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
12 p_status OUT NOCOPY varchar2);
13
14 PROCEDURE create_line_salescredits(p_customer_trx_id IN
15 ra_customer_trx_lines.customer_trx_id%type,
16 p_customer_trx_line_id IN
17 ra_customer_trx_lines.customer_trx_line_id%type,
18 p_memo_line_type IN
19 ar_memo_lines.line_type%type,
20 p_delete_scredits_first_flag IN
21 varchar2,
22 p_run_autoaccounting_flag IN varchar2,
23 p_status OUT NOCOPY varchar2);
24
25 PROCEDURE update_salescredit(
26 p_form_name IN varchar2,
27 p_form_version IN number,
28 p_run_auto_accounting_flag IN boolean,
32 p_customer_trx_id IN
29 p_backout_flag IN boolean,
30 p_cust_trx_line_salesrep_id IN
31 ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
33 ra_customer_trx.customer_trx_id%type,
34 p_customer_trx_line_id IN
35 ra_customer_trx_lines.customer_trx_line_id%type,
36 p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
37 p_backout_done_flag OUT NOCOPY boolean,
38 p_status OUT NOCOPY varchar2 );
39
40 PROCEDURE delete_salescredit(
41 p_form_name IN varchar2,
42 p_form_version IN number,
43 p_run_auto_accounting_flag IN boolean,
44 p_cust_trx_line_salesrep_id IN
45 ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
46 p_customer_trx_id IN
47 ra_customer_trx.customer_trx_id%type,
48 p_customer_trx_line_id IN
49 ra_customer_trx_lines.customer_trx_line_id%type,
50 p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
51 p_backout_flag IN boolean DEFAULT FALSE,
52 p_backout_done_flag OUT NOCOPY boolean,
53 p_status OUT NOCOPY varchar2 );
54
55 PROCEDURE insert_salescredit_cover(
56 p_form_name IN varchar2,
57 p_form_version IN number,
58 p_run_auto_accounting_flag IN boolean,
59
60 p_customer_trx_id IN
61 ra_cust_trx_line_salesreps.customer_trx_id%type,
62 p_customer_trx_line_id IN
63 ra_cust_trx_line_salesreps.customer_trx_line_id%type,
64 p_salesrep_id IN
65 ra_cust_trx_line_salesreps.salesrep_id%type,
66 p_revenue_amount_split IN
67 ra_cust_trx_line_salesreps.revenue_amount_split%type,
68 p_non_revenue_amount_split IN
69 ra_cust_trx_line_salesreps.non_revenue_amount_split%type,
70 p_non_revenue_percent_split IN
71 ra_cust_trx_line_salesreps.non_revenue_percent_split%type,
72 p_revenue_percent_split IN
73 ra_cust_trx_line_salesreps.revenue_percent_split%type,
74 p_prev_cust_trx_line_srep_id IN
75 ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,
76 p_attribute_category IN
77 ra_cust_trx_line_salesreps.attribute_category%type,
78 p_attribute1 IN
79 ra_cust_trx_line_salesreps.attribute1%type,
80 p_attribute2 IN
81 ra_cust_trx_line_salesreps.attribute2%type,
82 p_attribute3 IN
83 ra_cust_trx_line_salesreps.attribute3%type,
84 p_attribute4 IN
85 ra_cust_trx_line_salesreps.attribute4%type,
86 p_attribute5 IN
87 ra_cust_trx_line_salesreps.attribute5%type,
88 p_attribute6 IN
89 ra_cust_trx_line_salesreps.attribute6%type,
90 p_attribute7 IN
91 ra_cust_trx_line_salesreps.attribute7%type,
92 p_attribute8 IN
93 ra_cust_trx_line_salesreps.attribute8%type,
94 p_attribute9 IN
95 ra_cust_trx_line_salesreps.attribute9%type,
96 p_attribute10 IN
97 ra_cust_trx_line_salesreps.attribute10%type,
98 p_attribute11 IN
99 ra_cust_trx_line_salesreps.attribute11%type,
100 p_attribute12 IN
101 ra_cust_trx_line_salesreps.attribute12%type,
102 p_attribute13 IN
103 ra_cust_trx_line_salesreps.attribute13%type,
104 p_attribute14 IN
105 ra_cust_trx_line_salesreps.attribute14%type,
106 p_attribute15 IN
107 ra_cust_trx_line_salesreps.attribute15%type,
108 p_cust_trx_line_salesrep_id OUT NOCOPY
109 ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
110 p_status OUT NOCOPY varchar2,
111 p_revenue_salesgroup_id IN
112 ra_cust_trx_line_salesreps.revenue_salesgroup_id%type DEFAULT null,
113 p_non_revenue_salesgroup_id IN
114 ra_cust_trx_line_salesreps.non_revenue_salesgroup_id%type DEFAULT null);
115
116 PROCEDURE update_salescredit_cover(
117 p_form_name IN varchar2,
118 p_form_version IN number,
119 p_run_auto_accounting_flag IN boolean,
120 p_backout_flag IN boolean,
121 p_cust_trx_line_salesrep_id IN
122 ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
126 ra_cust_trx_line_salesreps.customer_trx_line_id%type,
123 p_customer_trx_id IN
124 ra_cust_trx_line_salesreps.customer_trx_id%type,
125 p_customer_trx_line_id IN
127 p_salesrep_id IN
128 ra_cust_trx_line_salesreps.salesrep_id%type,
129 p_revenue_amount_split IN
130 ra_cust_trx_line_salesreps.revenue_amount_split%type,
131 p_non_revenue_amount_split IN
132 ra_cust_trx_line_salesreps.non_revenue_amount_split%type,
133 p_non_revenue_percent_split IN
134 ra_cust_trx_line_salesreps.non_revenue_percent_split%type,
135 p_revenue_percent_split IN
136 ra_cust_trx_line_salesreps.revenue_percent_split%type,
137 p_prev_cust_trx_line_srep_id IN
138 ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,
139 p_attribute_category IN
140 ra_cust_trx_line_salesreps.attribute_category%type,
141 p_attribute1 IN
142 ra_cust_trx_line_salesreps.attribute1%type,
143 p_attribute2 IN
144 ra_cust_trx_line_salesreps.attribute2%type,
145 p_attribute3 IN
146 ra_cust_trx_line_salesreps.attribute3%type,
147 p_attribute4 IN
148 ra_cust_trx_line_salesreps.attribute4%type,
149 p_attribute5 IN
150 ra_cust_trx_line_salesreps.attribute5%type,
151 p_attribute6 IN
152 ra_cust_trx_line_salesreps.attribute6%type,
153 p_attribute7 IN
154 ra_cust_trx_line_salesreps.attribute7%type,
155 p_attribute8 IN
156 ra_cust_trx_line_salesreps.attribute8%type,
157 p_attribute9 IN
158 ra_cust_trx_line_salesreps.attribute9%type,
159 p_attribute10 IN
160 ra_cust_trx_line_salesreps.attribute10%type,
161 p_attribute11 IN
162 ra_cust_trx_line_salesreps.attribute11%type,
163 p_attribute12 IN
164 ra_cust_trx_line_salesreps.attribute12%type,
165 p_attribute13 IN
166 ra_cust_trx_line_salesreps.attribute13%type,
167 p_attribute14 IN
168 ra_cust_trx_line_salesreps.attribute14%type,
169 p_attribute15 IN
170 ra_cust_trx_line_salesreps.attribute15%type,
171 p_backout_done_flag OUT NOCOPY boolean,
172 p_status OUT NOCOPY varchar2,
173 p_revenue_salesgroup_id IN
174 ra_cust_trx_line_salesreps.revenue_salesgroup_id%type DEFAULT null,
175 p_non_revenue_salesgroup_id IN
176 ra_cust_trx_line_salesreps.non_revenue_salesgroup_id%type DEFAULT null);
177
178 PROCEDURE delete_salescredit_cover(
179 p_form_name IN varchar2,
180 p_form_version IN number,
181 p_run_auto_accounting_flag IN boolean,
182 p_backout_flag IN boolean,
183 p_cust_trx_line_salesrep_id IN
184 ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
185 p_customer_trx_id IN
186 ra_cust_trx_line_salesreps.customer_trx_id%type,
187 p_customer_trx_line_id IN
188 ra_cust_trx_line_salesreps.customer_trx_line_id%type,
189 p_salesrep_id IN
190 ra_cust_trx_line_salesreps.salesrep_id%type,
191 p_revenue_amount_split IN
192 ra_cust_trx_line_salesreps.revenue_amount_split%type,
193 p_non_revenue_amount_split IN
194 ra_cust_trx_line_salesreps.non_revenue_amount_split%type,
195 p_non_revenue_percent_split IN
196 ra_cust_trx_line_salesreps.non_revenue_percent_split%type,
197 p_revenue_percent_split IN
198 ra_cust_trx_line_salesreps.revenue_percent_split%type,
199 p_prev_cust_trx_line_srep_id IN
200 ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,
201 p_attribute_category IN
202 ra_cust_trx_line_salesreps.attribute_category%type,
203 p_attribute1 IN
204 ra_cust_trx_line_salesreps.attribute1%type,
205 p_attribute2 IN
206 ra_cust_trx_line_salesreps.attribute2%type,
207 p_attribute3 IN
208 ra_cust_trx_line_salesreps.attribute3%type,
209 p_attribute4 IN
210 ra_cust_trx_line_salesreps.attribute4%type,
211 p_attribute5 IN
212 ra_cust_trx_line_salesreps.attribute5%type,
213 p_attribute6 IN
214 ra_cust_trx_line_salesreps.attribute6%type,
215 p_attribute7 IN
216 ra_cust_trx_line_salesreps.attribute7%type,
217 p_attribute8 IN
218 ra_cust_trx_line_salesreps.attribute8%type,
219 p_attribute9 IN
220 ra_cust_trx_line_salesreps.attribute9%type,
221 p_attribute10 IN
222 ra_cust_trx_line_salesreps.attribute10%type,
223 p_attribute11 IN
224 ra_cust_trx_line_salesreps.attribute11%type,
225 p_attribute12 IN
226 ra_cust_trx_line_salesreps.attribute12%type,
227 p_attribute13 IN
228 ra_cust_trx_line_salesreps.attribute13%type,
229 p_attribute14 IN
230 ra_cust_trx_line_salesreps.attribute14%type,
231 p_attribute15 IN
232 ra_cust_trx_line_salesreps.attribute15%type,
233 p_backout_done_flag OUT NOCOPY boolean,
234 p_status OUT NOCOPY varchar2,
235 p_revenue_salesgroup_id IN
236 ra_cust_trx_line_salesreps.revenue_salesgroup_id%type DEFAULT null,
237 p_non_revenue_salesgroup_id IN
238 ra_cust_trx_line_salesreps.non_revenue_salesgroup_id%type DEFAULT null);
239
240 END ARP_PROCESS_SALESCREDIT;