1 PACKAGE ARP_CTL_FREIGHT_PKG AUTHID CURRENT_USER AS
2 /* $Header: ARTCTLFS.pls 115.2 2002/11/15 03:31:40 anukumar ship $ */
3
4 PROCEDURE select_summary_freight(
5 p_customer_trx_id IN number,
6 p_amount_total OUT NOCOPY number,
7 p_amount_total_rtot_db OUT NOCOPY number);
8
9 PROCEDURE lock_compare_frt_cover(
10 p_customer_trx_line_id IN
11 ra_customer_trx_lines.customer_trx_line_id%type,
12 p_customer_trx_id IN
13 ra_customer_trx_lines.customer_trx_id%type,
14 p_link_to_cust_trx_line_id IN
15 ra_customer_trx_lines.link_to_cust_trx_line_id%type,
16 p_previous_customer_trx_id IN
17 ra_customer_trx_lines.previous_customer_trx_id%type,
18 p_previous_cust_trx_line_id IN
19 ra_customer_trx_lines.previous_customer_trx_line_id%type,
20 p_line_number IN ra_customer_trx_lines.line_number%type,
21 p_line_type IN ra_customer_trx_lines.line_type%type,
22 p_extended_amount IN ra_customer_trx_lines.extended_amount%type,
23 p_attribute_category IN
24 ra_customer_trx_lines.attribute_category%type,
25 p_attribute1 IN ra_customer_trx_lines.attribute1%type,
26 p_attribute2 IN ra_customer_trx_lines.attribute2%type,
27 p_attribute3 IN ra_customer_trx_lines.attribute3%type,
28 p_attribute4 IN ra_customer_trx_lines.attribute4%type,
29 p_attribute5 IN ra_customer_trx_lines.attribute5%type,
30 p_attribute6 IN ra_customer_trx_lines.attribute6%type,
31 p_attribute7 IN ra_customer_trx_lines.attribute7%type,
32 p_attribute8 IN ra_customer_trx_lines.attribute8%type,
33 p_attribute9 IN ra_customer_trx_lines.attribute9%type,
34 p_attribute10 IN ra_customer_trx_lines.attribute10%type,
35 p_attribute11 IN ra_customer_trx_lines.attribute11%type,
36 p_attribute12 IN ra_customer_trx_lines.attribute12%type,
37 p_attribute13 IN ra_customer_trx_lines.attribute13%type,
38 p_attribute14 IN ra_customer_trx_lines.attribute14%type,
39 p_attribute15 IN ra_customer_trx_lines.attribute15%type,
40 p_interface_line_context IN
41 ra_customer_trx_lines.interface_line_context%type,
42 p_interface_line_attribute1 IN
43 ra_customer_trx_lines.interface_line_attribute1%type,
44 p_interface_line_attribute2 IN
45 ra_customer_trx_lines.interface_line_attribute2%type,
46 p_interface_line_attribute3 IN
47 ra_customer_trx_lines.interface_line_attribute3%type,
48 p_interface_line_attribute4 IN
49 ra_customer_trx_lines.interface_line_attribute4%type,
50 p_interface_line_attribute5 IN
51 ra_customer_trx_lines.interface_line_attribute5%type,
52 p_interface_line_attribute6 IN
53 ra_customer_trx_lines.interface_line_attribute6%type,
54 p_interface_line_attribute7 IN
55 ra_customer_trx_lines.interface_line_attribute7%type,
56 p_interface_line_attribute8 IN
57 ra_customer_trx_lines.interface_line_attribute8%type,
58 p_interface_line_attribute9 IN
59 ra_customer_trx_lines.interface_line_attribute9%type,
60 p_interface_line_attribute10 IN
61 ra_customer_trx_lines.interface_line_attribute10%type,
62 p_interface_line_attribute11 IN
63 ra_customer_trx_lines.interface_line_attribute11%type,
64 p_interface_line_attribute12 IN
65 ra_customer_trx_lines.interface_line_attribute12%type,
66 p_interface_line_attribute13 IN
67 ra_customer_trx_lines.interface_line_attribute13%type,
68 p_interface_line_attribute14 IN
69 ra_customer_trx_lines.interface_line_attribute14%type,
70 p_interface_line_attribute15 IN
71 ra_customer_trx_lines.interface_line_attribute15%type,
72 p_default_ussgl_code_context IN
73 ra_customer_trx_lines.default_ussgl_trx_code_context%type,
74 p_default_ussgl_trx_code IN
75 ra_customer_trx_lines.default_ussgl_transaction_code%type);
76
77 END ARP_CTL_FREIGHT_PKG;