1 PACKAGE ARP_PROCESS_CREDIT AUTHID CURRENT_USER AS
2 /* $Header: ARTECMRS.pls 120.2.12010000.1 2008/07/24 16:55:40 appldev ship $ */
3
4 TYPE credit_lines_type IS TABLE OF
5 ra_customer_trx_lines.customer_trx_line_id%type
6 INDEX BY BINARY_INTEGER;
7
8 pg_num_credit_lines number;
9 pg_credit_lines credit_lines_type;
10
11
12 PROCEDURE insert_header(
13 p_form_name IN varchar2,
14 p_form_version IN number,
15 p_trx_rec IN ra_customer_trx%rowtype,
16 p_trx_class IN ra_cust_trx_types.type%type,
17 p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
18 p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
19 p_currency_code IN fnd_currencies.currency_code%type,
20 p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
21 p_line_percent IN number,
22 p_freight_pecent IN number,
23 p_line_amount IN ra_customer_trx_lines.extended_amount%type,
24 p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
25 p_compute_tax IN varchar2,
26 p_trx_number OUT NOCOPY ra_customer_trx.trx_number%type,
27 p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
28 p_tax_percent IN OUT NOCOPY number,
29 p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
30 p_status OUT NOCOPY varchar2,
31 p_submit_cm_dist IN varchar2 DEFAULT 'N');
32
33 PROCEDURE update_header(
34 p_form_name IN varchar2,
35 p_form_version IN number,
36 p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
37 p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,
38 p_trx_class IN ra_cust_trx_types.type%type,
39 p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
40 p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
41 p_currency_code IN fnd_currencies.currency_code%type,
42 p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
43 p_line_percent IN number,
44 p_freight_pecent IN number,
45 p_line_amount IN ra_customer_trx_lines.extended_amount%type,
46 p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
47 p_credit_amount IN ra_customer_trx_lines.extended_amount%type,
48 p_cr_txn_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
49 p_rederive_credit_info IN varchar2,
50 p_rerun_aa IN varchar2,
51 p_rerun_cm_module IN varchar2,
52 p_compute_tax IN varchar2,
53 p_tax_percent IN OUT NOCOPY number,
54 p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
55 p_status OUT NOCOPY varchar2);
56
57
58 PROCEDURE insert_line(
59 p_form_name IN varchar2,
60 p_form_version IN number,
61 p_credit_rec IN ra_customer_trx_lines%rowtype,
62 p_line_amount IN ra_customer_trx_lines.extended_amount%type,
63 p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
64 p_line_percent IN number,
65 p_freight_percent IN number,
66 p_memo_line_type IN ar_memo_lines.line_type%type,
67 p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
68 p_currency_code IN fnd_currencies.currency_code%type,
69 p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
70 p_compute_tax IN varchar2,
71 p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
72 p_prev_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
73 p_prev_customer_trx_line_id IN
74 ra_customer_trx_lines.customer_trx_line_id%type,
75 p_tax_percent IN OUT NOCOPY number,
76 p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
77 p_customer_trx_line_id OUT NOCOPY
78 ra_customer_trx_lines.customer_trx_line_id%type,
79 p_status OUT NOCOPY varchar2);
80
81 PROCEDURE update_line(
82 p_form_name IN varchar2,
83 p_form_version IN number,
84 p_credit_rec IN ra_customer_trx_lines%rowtype,
85 p_customer_trx_line_id IN
86 ra_customer_trx_lines.customer_trx_line_id%type,
87 p_line_amount IN ra_customer_trx_lines.extended_amount%type,
88 p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
89 p_line_percent IN number,
90 p_freight_percent IN number,
91 p_memo_line_type IN ar_memo_lines.line_type%type,
92 p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
93 p_currency_code IN fnd_currencies.currency_code%type,
94 p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
95 p_exchange_rate IN ra_customer_trx.exchange_rate%type,
96 p_rerun_aa IN varchar2,
97 p_recalculate_tax IN varchar2,
98 p_compute_tax IN varchar2,
99 p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
100 p_prev_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
101 p_prev_customer_trx_line_id IN
102 ra_customer_trx_lines.customer_trx_line_id%type,
103 p_tax_percent IN OUT NOCOPY number,
104 p_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
105 p_status OUT NOCOPY varchar2);
106
107 PROCEDURE freight_post_update(
108 p_frt_rec IN ra_customer_trx_lines%rowtype,
109 p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
110 p_frt_ccid IN
111 ra_cust_trx_line_gl_dist.code_combination_id%type);
112
113 PROCEDURE init;
114
115 END ARP_PROCESS_CREDIT;