1 PACKAGE ARP_PROCESS_FREIGHT_COVER AUTHID CURRENT_USER AS
2 /* $Header: ARTEFR2S.pls 115.2 2002/11/15 03:41:19 anukumar ship $ */
3
4 PROCEDURE insert_freight_cover(
5 p_form_name IN varchar2,
6 p_form_version IN number,
7 p_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
8 p_line_type IN ra_customer_trx_lines.line_type%type,
9 p_line_number IN ra_customer_trx_lines.line_number%type,
10 p_extended_amount IN ra_customer_trx_lines.extended_amount%type,
11 p_revenue_amount IN ra_customer_trx_lines.revenue_amount%type,
12 p_previous_customer_trx_id IN
13 ra_customer_trx_lines.previous_customer_trx_id%type,
14 p_previous_cust_trx_line_id IN
15 ra_customer_trx_lines.previous_customer_trx_line_id%type,
16 p_link_to_cust_trx_line_id IN
17 ra_customer_trx_lines.link_to_cust_trx_line_id%type,
18 p_attribute_category IN
19 ra_customer_trx_lines.attribute_category%type,
20 p_attribute1 IN ra_customer_trx_lines.attribute1%type,
21 p_attribute2 IN ra_customer_trx_lines.attribute2%type,
22 p_attribute3 IN ra_customer_trx_lines.attribute3%type,
23 p_attribute4 IN ra_customer_trx_lines.attribute4%type,
24 p_attribute5 IN ra_customer_trx_lines.attribute5%type,
25 p_attribute6 IN ra_customer_trx_lines.attribute6%type,
26 p_attribute7 IN ra_customer_trx_lines.attribute7%type,
27 p_attribute8 IN ra_customer_trx_lines.attribute8%type,
28 p_attribute9 IN ra_customer_trx_lines.attribute9%type,
29 p_attribute10 IN ra_customer_trx_lines.attribute10%type,
30 p_attribute11 IN ra_customer_trx_lines.attribute11%type,
31 p_attribute12 IN ra_customer_trx_lines.attribute12%type,
32 p_attribute13 IN ra_customer_trx_lines.attribute13%type,
33 p_attribute14 IN ra_customer_trx_lines.attribute14%type,
34 p_attribute15 IN ra_customer_trx_lines.attribute15%type,
35 p_interface_line_context IN
36 ra_customer_trx_lines.interface_line_context%type,
37 p_interface_line_attribute1 IN
38 ra_customer_trx_lines.interface_line_attribute1%type,
39 p_interface_line_attribute2 IN
40 ra_customer_trx_lines.interface_line_attribute2%type,
41 p_interface_line_attribute3 IN
42 ra_customer_trx_lines.interface_line_attribute3%type,
43 p_interface_line_attribute4 IN
44 ra_customer_trx_lines.interface_line_attribute4%type,
45 p_interface_line_attribute5 IN
46 ra_customer_trx_lines.interface_line_attribute5%type,
47 p_interface_line_attribute6 IN
48 ra_customer_trx_lines.interface_line_attribute6%type,
49 p_interface_line_attribute7 IN
50 ra_customer_trx_lines.interface_line_attribute7%type,
51 p_interface_line_attribute8 IN
52 ra_customer_trx_lines.interface_line_attribute8%type,
53 p_interface_line_attribute9 IN
54 ra_customer_trx_lines.interface_line_attribute9%type,
55 p_interface_line_attribute10 IN
56 ra_customer_trx_lines.interface_line_attribute10%type,
57 p_interface_line_attribute11 IN
58 ra_customer_trx_lines.interface_line_attribute11%type,
59 p_interface_line_attribute12 IN
60 ra_customer_trx_lines.interface_line_attribute12%type,
61 p_interface_line_attribute13 IN
62 ra_customer_trx_lines.interface_line_attribute13%type,
63 p_interface_line_attribute14 IN
64 ra_customer_trx_lines.interface_line_attribute14%type,
65 p_interface_line_attribute15 IN
66 ra_customer_trx_lines.interface_line_attribute15%type,
67 p_default_ussgl_code_context IN
68 ra_customer_trx_lines.default_ussgl_trx_code_context%type,
69 p_default_ussgl_trx_code IN
70 ra_customer_trx_lines.default_ussgl_transaction_code%type,
71 p_trx_class IN ra_cust_trx_types.type%type,
72 p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
73 p_frt_ccid IN
74 ra_cust_trx_line_gl_dist.code_combination_id%type,
75 p_customer_trx_line_id OUT NOCOPY
76 ra_customer_trx_lines.customer_trx_line_id%type,
77 p_status OUT NOCOPY varchar2);
78
79 PROCEDURE update_freight_cover(
80 p_form_name IN varchar2,
81 p_form_version IN number,
82 p_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
83 p_customer_trx_line_id IN
84 ra_customer_trx_lines.customer_trx_line_id%type,
85 p_line_type IN ra_customer_trx_lines.line_type%type,
86 p_line_number IN ra_customer_trx_lines.line_number%type,
87 p_extended_amount IN ra_customer_trx_lines.extended_amount%type,
88 p_revenue_amount IN ra_customer_trx_lines.revenue_amount%type,
89 p_previous_customer_trx_id IN
90 ra_customer_trx_lines.previous_customer_trx_id%type,
91 p_previous_cust_trx_line_id IN
92 ra_customer_trx_lines.previous_customer_trx_line_id%type,
93 p_link_to_cust_trx_line_id IN
94 ra_customer_trx_lines.link_to_cust_trx_line_id%type,
95 p_attribute_category IN
96 ra_customer_trx_lines.attribute_category%type,
97 p_attribute1 IN ra_customer_trx_lines.attribute1%type,
98 p_attribute2 IN ra_customer_trx_lines.attribute2%type,
99 p_attribute3 IN ra_customer_trx_lines.attribute3%type,
100 p_attribute4 IN ra_customer_trx_lines.attribute4%type,
101 p_attribute5 IN ra_customer_trx_lines.attribute5%type,
102 p_attribute6 IN ra_customer_trx_lines.attribute6%type,
103 p_attribute7 IN ra_customer_trx_lines.attribute7%type,
104 p_attribute8 IN ra_customer_trx_lines.attribute8%type,
105 p_attribute9 IN ra_customer_trx_lines.attribute9%type,
106 p_attribute10 IN ra_customer_trx_lines.attribute10%type,
107 p_attribute11 IN ra_customer_trx_lines.attribute11%type,
108 p_attribute12 IN ra_customer_trx_lines.attribute12%type,
109 p_attribute13 IN ra_customer_trx_lines.attribute13%type,
110 p_attribute14 IN ra_customer_trx_lines.attribute14%type,
111 p_attribute15 IN ra_customer_trx_lines.attribute15%type,
112 p_interface_line_context IN
113 ra_customer_trx_lines.interface_line_context%type,
114 p_interface_line_attribute1 IN
115 ra_customer_trx_lines.interface_line_attribute1%type,
116 p_interface_line_attribute2 IN
117 ra_customer_trx_lines.interface_line_attribute2%type,
118 p_interface_line_attribute3 IN
119 ra_customer_trx_lines.interface_line_attribute3%type,
120 p_interface_line_attribute4 IN
121 ra_customer_trx_lines.interface_line_attribute4%type,
122 p_interface_line_attribute5 IN
123 ra_customer_trx_lines.interface_line_attribute5%type,
124 p_interface_line_attribute6 IN
125 ra_customer_trx_lines.interface_line_attribute6%type,
126 p_interface_line_attribute7 IN
127 ra_customer_trx_lines.interface_line_attribute7%type,
128 p_interface_line_attribute8 IN
129 ra_customer_trx_lines.interface_line_attribute8%type,
130 p_interface_line_attribute9 IN
131 ra_customer_trx_lines.interface_line_attribute9%type,
132 p_interface_line_attribute10 IN
133 ra_customer_trx_lines.interface_line_attribute10%type,
134 p_interface_line_attribute11 IN
135 ra_customer_trx_lines.interface_line_attribute11%type,
136 p_interface_line_attribute12 IN
137 ra_customer_trx_lines.interface_line_attribute12%type,
138 p_interface_line_attribute13 IN
139 ra_customer_trx_lines.interface_line_attribute13%type,
140 p_interface_line_attribute14 IN
141 ra_customer_trx_lines.interface_line_attribute14%type,
142 p_interface_line_attribute15 IN
143 ra_customer_trx_lines.interface_line_attribute15%type,
144 p_default_ussgl_code_context IN
145 ra_customer_trx_lines.default_ussgl_trx_code_context%type,
146 p_default_ussgl_trx_code IN
147 ra_customer_trx_lines.default_ussgl_transaction_code%type,
148 p_trx_class IN ra_cust_trx_types.type%type,
149 p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
150 p_frt_ccid IN
151 ra_cust_trx_line_gl_dist.code_combination_id%type,
152 p_complete_flag IN varchar2,
153 p_open_rec_flag IN varchar2,
154 p_status OUT NOCOPY varchar2);
155
156 END ARP_PROCESS_FREIGHT_COVER;