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