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,
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,
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,
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,
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
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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,
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
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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);
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;
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;