52:
53: PROCEDURE insert_freight_cover(
54: p_form_name IN varchar2,
55: p_form_version IN number,
56: p_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
57: p_line_type IN ra_customer_trx_lines.line_type%type,
58: p_line_number IN ra_customer_trx_lines.line_number%type,
59: p_extended_amount IN ra_customer_trx_lines.extended_amount%type,
60: p_revenue_amount IN ra_customer_trx_lines.revenue_amount%type,
53: PROCEDURE insert_freight_cover(
54: p_form_name IN varchar2,
55: p_form_version IN number,
56: p_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
57: p_line_type IN ra_customer_trx_lines.line_type%type,
58: p_line_number IN ra_customer_trx_lines.line_number%type,
59: p_extended_amount IN ra_customer_trx_lines.extended_amount%type,
60: p_revenue_amount IN ra_customer_trx_lines.revenue_amount%type,
61: p_previous_customer_trx_id IN
54: p_form_name IN varchar2,
55: p_form_version IN number,
56: p_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
57: p_line_type IN ra_customer_trx_lines.line_type%type,
58: p_line_number IN ra_customer_trx_lines.line_number%type,
59: p_extended_amount IN ra_customer_trx_lines.extended_amount%type,
60: p_revenue_amount IN ra_customer_trx_lines.revenue_amount%type,
61: p_previous_customer_trx_id IN
62: ra_customer_trx_lines.previous_customer_trx_id%type,
55: p_form_version IN number,
56: p_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
57: p_line_type IN ra_customer_trx_lines.line_type%type,
58: p_line_number IN ra_customer_trx_lines.line_number%type,
59: p_extended_amount IN ra_customer_trx_lines.extended_amount%type,
60: p_revenue_amount IN ra_customer_trx_lines.revenue_amount%type,
61: p_previous_customer_trx_id IN
62: ra_customer_trx_lines.previous_customer_trx_id%type,
63: p_previous_cust_trx_line_id IN
56: p_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
57: p_line_type IN ra_customer_trx_lines.line_type%type,
58: p_line_number IN ra_customer_trx_lines.line_number%type,
59: p_extended_amount IN ra_customer_trx_lines.extended_amount%type,
60: p_revenue_amount IN ra_customer_trx_lines.revenue_amount%type,
61: p_previous_customer_trx_id IN
62: ra_customer_trx_lines.previous_customer_trx_id%type,
63: p_previous_cust_trx_line_id IN
64: ra_customer_trx_lines.previous_customer_trx_line_id%type,
58: p_line_number IN ra_customer_trx_lines.line_number%type,
59: p_extended_amount IN ra_customer_trx_lines.extended_amount%type,
60: p_revenue_amount IN ra_customer_trx_lines.revenue_amount%type,
61: p_previous_customer_trx_id IN
62: ra_customer_trx_lines.previous_customer_trx_id%type,
63: p_previous_cust_trx_line_id IN
64: ra_customer_trx_lines.previous_customer_trx_line_id%type,
65: p_link_to_cust_trx_line_id IN
66: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
60: p_revenue_amount IN ra_customer_trx_lines.revenue_amount%type,
61: p_previous_customer_trx_id IN
62: ra_customer_trx_lines.previous_customer_trx_id%type,
63: p_previous_cust_trx_line_id IN
64: ra_customer_trx_lines.previous_customer_trx_line_id%type,
65: p_link_to_cust_trx_line_id IN
66: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
67: p_attribute_category IN
68: ra_customer_trx_lines.attribute_category%type,
62: ra_customer_trx_lines.previous_customer_trx_id%type,
63: p_previous_cust_trx_line_id IN
64: ra_customer_trx_lines.previous_customer_trx_line_id%type,
65: p_link_to_cust_trx_line_id IN
66: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
67: p_attribute_category IN
68: ra_customer_trx_lines.attribute_category%type,
69: p_attribute1 IN ra_customer_trx_lines.attribute1%type,
70: p_attribute2 IN ra_customer_trx_lines.attribute2%type,
64: ra_customer_trx_lines.previous_customer_trx_line_id%type,
65: p_link_to_cust_trx_line_id IN
66: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
67: p_attribute_category IN
68: ra_customer_trx_lines.attribute_category%type,
69: p_attribute1 IN ra_customer_trx_lines.attribute1%type,
70: p_attribute2 IN ra_customer_trx_lines.attribute2%type,
71: p_attribute3 IN ra_customer_trx_lines.attribute3%type,
72: p_attribute4 IN ra_customer_trx_lines.attribute4%type,
65: p_link_to_cust_trx_line_id IN
66: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
67: p_attribute_category IN
68: ra_customer_trx_lines.attribute_category%type,
69: p_attribute1 IN ra_customer_trx_lines.attribute1%type,
70: p_attribute2 IN ra_customer_trx_lines.attribute2%type,
71: p_attribute3 IN ra_customer_trx_lines.attribute3%type,
72: p_attribute4 IN ra_customer_trx_lines.attribute4%type,
73: p_attribute5 IN ra_customer_trx_lines.attribute5%type,
66: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
67: p_attribute_category IN
68: ra_customer_trx_lines.attribute_category%type,
69: p_attribute1 IN ra_customer_trx_lines.attribute1%type,
70: p_attribute2 IN ra_customer_trx_lines.attribute2%type,
71: p_attribute3 IN ra_customer_trx_lines.attribute3%type,
72: p_attribute4 IN ra_customer_trx_lines.attribute4%type,
73: p_attribute5 IN ra_customer_trx_lines.attribute5%type,
74: p_attribute6 IN ra_customer_trx_lines.attribute6%type,
67: p_attribute_category IN
68: ra_customer_trx_lines.attribute_category%type,
69: p_attribute1 IN ra_customer_trx_lines.attribute1%type,
70: p_attribute2 IN ra_customer_trx_lines.attribute2%type,
71: p_attribute3 IN ra_customer_trx_lines.attribute3%type,
72: p_attribute4 IN ra_customer_trx_lines.attribute4%type,
73: p_attribute5 IN ra_customer_trx_lines.attribute5%type,
74: p_attribute6 IN ra_customer_trx_lines.attribute6%type,
75: p_attribute7 IN ra_customer_trx_lines.attribute7%type,
68: ra_customer_trx_lines.attribute_category%type,
69: p_attribute1 IN ra_customer_trx_lines.attribute1%type,
70: p_attribute2 IN ra_customer_trx_lines.attribute2%type,
71: p_attribute3 IN ra_customer_trx_lines.attribute3%type,
72: p_attribute4 IN ra_customer_trx_lines.attribute4%type,
73: p_attribute5 IN ra_customer_trx_lines.attribute5%type,
74: p_attribute6 IN ra_customer_trx_lines.attribute6%type,
75: p_attribute7 IN ra_customer_trx_lines.attribute7%type,
76: p_attribute8 IN ra_customer_trx_lines.attribute8%type,
69: p_attribute1 IN ra_customer_trx_lines.attribute1%type,
70: p_attribute2 IN ra_customer_trx_lines.attribute2%type,
71: p_attribute3 IN ra_customer_trx_lines.attribute3%type,
72: p_attribute4 IN ra_customer_trx_lines.attribute4%type,
73: p_attribute5 IN ra_customer_trx_lines.attribute5%type,
74: p_attribute6 IN ra_customer_trx_lines.attribute6%type,
75: p_attribute7 IN ra_customer_trx_lines.attribute7%type,
76: p_attribute8 IN ra_customer_trx_lines.attribute8%type,
77: p_attribute9 IN ra_customer_trx_lines.attribute9%type,
70: p_attribute2 IN ra_customer_trx_lines.attribute2%type,
71: p_attribute3 IN ra_customer_trx_lines.attribute3%type,
72: p_attribute4 IN ra_customer_trx_lines.attribute4%type,
73: p_attribute5 IN ra_customer_trx_lines.attribute5%type,
74: p_attribute6 IN ra_customer_trx_lines.attribute6%type,
75: p_attribute7 IN ra_customer_trx_lines.attribute7%type,
76: p_attribute8 IN ra_customer_trx_lines.attribute8%type,
77: p_attribute9 IN ra_customer_trx_lines.attribute9%type,
78: p_attribute10 IN ra_customer_trx_lines.attribute10%type,
71: p_attribute3 IN ra_customer_trx_lines.attribute3%type,
72: p_attribute4 IN ra_customer_trx_lines.attribute4%type,
73: p_attribute5 IN ra_customer_trx_lines.attribute5%type,
74: p_attribute6 IN ra_customer_trx_lines.attribute6%type,
75: p_attribute7 IN ra_customer_trx_lines.attribute7%type,
76: p_attribute8 IN ra_customer_trx_lines.attribute8%type,
77: p_attribute9 IN ra_customer_trx_lines.attribute9%type,
78: p_attribute10 IN ra_customer_trx_lines.attribute10%type,
79: p_attribute11 IN ra_customer_trx_lines.attribute11%type,
72: p_attribute4 IN ra_customer_trx_lines.attribute4%type,
73: p_attribute5 IN ra_customer_trx_lines.attribute5%type,
74: p_attribute6 IN ra_customer_trx_lines.attribute6%type,
75: p_attribute7 IN ra_customer_trx_lines.attribute7%type,
76: p_attribute8 IN ra_customer_trx_lines.attribute8%type,
77: p_attribute9 IN ra_customer_trx_lines.attribute9%type,
78: p_attribute10 IN ra_customer_trx_lines.attribute10%type,
79: p_attribute11 IN ra_customer_trx_lines.attribute11%type,
80: p_attribute12 IN ra_customer_trx_lines.attribute12%type,
73: p_attribute5 IN ra_customer_trx_lines.attribute5%type,
74: p_attribute6 IN ra_customer_trx_lines.attribute6%type,
75: p_attribute7 IN ra_customer_trx_lines.attribute7%type,
76: p_attribute8 IN ra_customer_trx_lines.attribute8%type,
77: p_attribute9 IN ra_customer_trx_lines.attribute9%type,
78: p_attribute10 IN ra_customer_trx_lines.attribute10%type,
79: p_attribute11 IN ra_customer_trx_lines.attribute11%type,
80: p_attribute12 IN ra_customer_trx_lines.attribute12%type,
81: p_attribute13 IN ra_customer_trx_lines.attribute13%type,
74: p_attribute6 IN ra_customer_trx_lines.attribute6%type,
75: p_attribute7 IN ra_customer_trx_lines.attribute7%type,
76: p_attribute8 IN ra_customer_trx_lines.attribute8%type,
77: p_attribute9 IN ra_customer_trx_lines.attribute9%type,
78: p_attribute10 IN ra_customer_trx_lines.attribute10%type,
79: p_attribute11 IN ra_customer_trx_lines.attribute11%type,
80: p_attribute12 IN ra_customer_trx_lines.attribute12%type,
81: p_attribute13 IN ra_customer_trx_lines.attribute13%type,
82: p_attribute14 IN ra_customer_trx_lines.attribute14%type,
75: p_attribute7 IN ra_customer_trx_lines.attribute7%type,
76: p_attribute8 IN ra_customer_trx_lines.attribute8%type,
77: p_attribute9 IN ra_customer_trx_lines.attribute9%type,
78: p_attribute10 IN ra_customer_trx_lines.attribute10%type,
79: p_attribute11 IN ra_customer_trx_lines.attribute11%type,
80: p_attribute12 IN ra_customer_trx_lines.attribute12%type,
81: p_attribute13 IN ra_customer_trx_lines.attribute13%type,
82: p_attribute14 IN ra_customer_trx_lines.attribute14%type,
83: p_attribute15 IN ra_customer_trx_lines.attribute15%type,
76: p_attribute8 IN ra_customer_trx_lines.attribute8%type,
77: p_attribute9 IN ra_customer_trx_lines.attribute9%type,
78: p_attribute10 IN ra_customer_trx_lines.attribute10%type,
79: p_attribute11 IN ra_customer_trx_lines.attribute11%type,
80: p_attribute12 IN ra_customer_trx_lines.attribute12%type,
81: p_attribute13 IN ra_customer_trx_lines.attribute13%type,
82: p_attribute14 IN ra_customer_trx_lines.attribute14%type,
83: p_attribute15 IN ra_customer_trx_lines.attribute15%type,
84: p_interface_line_context IN
77: p_attribute9 IN ra_customer_trx_lines.attribute9%type,
78: p_attribute10 IN ra_customer_trx_lines.attribute10%type,
79: p_attribute11 IN ra_customer_trx_lines.attribute11%type,
80: p_attribute12 IN ra_customer_trx_lines.attribute12%type,
81: p_attribute13 IN ra_customer_trx_lines.attribute13%type,
82: p_attribute14 IN ra_customer_trx_lines.attribute14%type,
83: p_attribute15 IN ra_customer_trx_lines.attribute15%type,
84: p_interface_line_context IN
85: ra_customer_trx_lines.interface_line_context%type,
78: p_attribute10 IN ra_customer_trx_lines.attribute10%type,
79: p_attribute11 IN ra_customer_trx_lines.attribute11%type,
80: p_attribute12 IN ra_customer_trx_lines.attribute12%type,
81: p_attribute13 IN ra_customer_trx_lines.attribute13%type,
82: p_attribute14 IN ra_customer_trx_lines.attribute14%type,
83: p_attribute15 IN ra_customer_trx_lines.attribute15%type,
84: p_interface_line_context IN
85: ra_customer_trx_lines.interface_line_context%type,
86: p_interface_line_attribute1 IN
79: p_attribute11 IN ra_customer_trx_lines.attribute11%type,
80: p_attribute12 IN ra_customer_trx_lines.attribute12%type,
81: p_attribute13 IN ra_customer_trx_lines.attribute13%type,
82: p_attribute14 IN ra_customer_trx_lines.attribute14%type,
83: p_attribute15 IN ra_customer_trx_lines.attribute15%type,
84: p_interface_line_context IN
85: ra_customer_trx_lines.interface_line_context%type,
86: p_interface_line_attribute1 IN
87: ra_customer_trx_lines.interface_line_attribute1%type,
81: p_attribute13 IN ra_customer_trx_lines.attribute13%type,
82: p_attribute14 IN ra_customer_trx_lines.attribute14%type,
83: p_attribute15 IN ra_customer_trx_lines.attribute15%type,
84: p_interface_line_context IN
85: ra_customer_trx_lines.interface_line_context%type,
86: p_interface_line_attribute1 IN
87: ra_customer_trx_lines.interface_line_attribute1%type,
88: p_interface_line_attribute2 IN
89: ra_customer_trx_lines.interface_line_attribute2%type,
83: p_attribute15 IN ra_customer_trx_lines.attribute15%type,
84: p_interface_line_context IN
85: ra_customer_trx_lines.interface_line_context%type,
86: p_interface_line_attribute1 IN
87: ra_customer_trx_lines.interface_line_attribute1%type,
88: p_interface_line_attribute2 IN
89: ra_customer_trx_lines.interface_line_attribute2%type,
90: p_interface_line_attribute3 IN
91: ra_customer_trx_lines.interface_line_attribute3%type,
85: ra_customer_trx_lines.interface_line_context%type,
86: p_interface_line_attribute1 IN
87: ra_customer_trx_lines.interface_line_attribute1%type,
88: p_interface_line_attribute2 IN
89: ra_customer_trx_lines.interface_line_attribute2%type,
90: p_interface_line_attribute3 IN
91: ra_customer_trx_lines.interface_line_attribute3%type,
92: p_interface_line_attribute4 IN
93: ra_customer_trx_lines.interface_line_attribute4%type,
87: ra_customer_trx_lines.interface_line_attribute1%type,
88: p_interface_line_attribute2 IN
89: ra_customer_trx_lines.interface_line_attribute2%type,
90: p_interface_line_attribute3 IN
91: ra_customer_trx_lines.interface_line_attribute3%type,
92: p_interface_line_attribute4 IN
93: ra_customer_trx_lines.interface_line_attribute4%type,
94: p_interface_line_attribute5 IN
95: ra_customer_trx_lines.interface_line_attribute5%type,
89: ra_customer_trx_lines.interface_line_attribute2%type,
90: p_interface_line_attribute3 IN
91: ra_customer_trx_lines.interface_line_attribute3%type,
92: p_interface_line_attribute4 IN
93: ra_customer_trx_lines.interface_line_attribute4%type,
94: p_interface_line_attribute5 IN
95: ra_customer_trx_lines.interface_line_attribute5%type,
96: p_interface_line_attribute6 IN
97: ra_customer_trx_lines.interface_line_attribute6%type,
91: ra_customer_trx_lines.interface_line_attribute3%type,
92: p_interface_line_attribute4 IN
93: ra_customer_trx_lines.interface_line_attribute4%type,
94: p_interface_line_attribute5 IN
95: ra_customer_trx_lines.interface_line_attribute5%type,
96: p_interface_line_attribute6 IN
97: ra_customer_trx_lines.interface_line_attribute6%type,
98: p_interface_line_attribute7 IN
99: ra_customer_trx_lines.interface_line_attribute7%type,
93: ra_customer_trx_lines.interface_line_attribute4%type,
94: p_interface_line_attribute5 IN
95: ra_customer_trx_lines.interface_line_attribute5%type,
96: p_interface_line_attribute6 IN
97: ra_customer_trx_lines.interface_line_attribute6%type,
98: p_interface_line_attribute7 IN
99: ra_customer_trx_lines.interface_line_attribute7%type,
100: p_interface_line_attribute8 IN
101: ra_customer_trx_lines.interface_line_attribute8%type,
95: ra_customer_trx_lines.interface_line_attribute5%type,
96: p_interface_line_attribute6 IN
97: ra_customer_trx_lines.interface_line_attribute6%type,
98: p_interface_line_attribute7 IN
99: ra_customer_trx_lines.interface_line_attribute7%type,
100: p_interface_line_attribute8 IN
101: ra_customer_trx_lines.interface_line_attribute8%type,
102: p_interface_line_attribute9 IN
103: ra_customer_trx_lines.interface_line_attribute9%type,
97: ra_customer_trx_lines.interface_line_attribute6%type,
98: p_interface_line_attribute7 IN
99: ra_customer_trx_lines.interface_line_attribute7%type,
100: p_interface_line_attribute8 IN
101: ra_customer_trx_lines.interface_line_attribute8%type,
102: p_interface_line_attribute9 IN
103: ra_customer_trx_lines.interface_line_attribute9%type,
104: p_interface_line_attribute10 IN
105: ra_customer_trx_lines.interface_line_attribute10%type,
99: ra_customer_trx_lines.interface_line_attribute7%type,
100: p_interface_line_attribute8 IN
101: ra_customer_trx_lines.interface_line_attribute8%type,
102: p_interface_line_attribute9 IN
103: ra_customer_trx_lines.interface_line_attribute9%type,
104: p_interface_line_attribute10 IN
105: ra_customer_trx_lines.interface_line_attribute10%type,
106: p_interface_line_attribute11 IN
107: ra_customer_trx_lines.interface_line_attribute11%type,
101: ra_customer_trx_lines.interface_line_attribute8%type,
102: p_interface_line_attribute9 IN
103: ra_customer_trx_lines.interface_line_attribute9%type,
104: p_interface_line_attribute10 IN
105: ra_customer_trx_lines.interface_line_attribute10%type,
106: p_interface_line_attribute11 IN
107: ra_customer_trx_lines.interface_line_attribute11%type,
108: p_interface_line_attribute12 IN
109: ra_customer_trx_lines.interface_line_attribute12%type,
103: ra_customer_trx_lines.interface_line_attribute9%type,
104: p_interface_line_attribute10 IN
105: ra_customer_trx_lines.interface_line_attribute10%type,
106: p_interface_line_attribute11 IN
107: ra_customer_trx_lines.interface_line_attribute11%type,
108: p_interface_line_attribute12 IN
109: ra_customer_trx_lines.interface_line_attribute12%type,
110: p_interface_line_attribute13 IN
111: ra_customer_trx_lines.interface_line_attribute13%type,
105: ra_customer_trx_lines.interface_line_attribute10%type,
106: p_interface_line_attribute11 IN
107: ra_customer_trx_lines.interface_line_attribute11%type,
108: p_interface_line_attribute12 IN
109: ra_customer_trx_lines.interface_line_attribute12%type,
110: p_interface_line_attribute13 IN
111: ra_customer_trx_lines.interface_line_attribute13%type,
112: p_interface_line_attribute14 IN
113: ra_customer_trx_lines.interface_line_attribute14%type,
107: ra_customer_trx_lines.interface_line_attribute11%type,
108: p_interface_line_attribute12 IN
109: ra_customer_trx_lines.interface_line_attribute12%type,
110: p_interface_line_attribute13 IN
111: ra_customer_trx_lines.interface_line_attribute13%type,
112: p_interface_line_attribute14 IN
113: ra_customer_trx_lines.interface_line_attribute14%type,
114: p_interface_line_attribute15 IN
115: ra_customer_trx_lines.interface_line_attribute15%type,
109: ra_customer_trx_lines.interface_line_attribute12%type,
110: p_interface_line_attribute13 IN
111: ra_customer_trx_lines.interface_line_attribute13%type,
112: p_interface_line_attribute14 IN
113: ra_customer_trx_lines.interface_line_attribute14%type,
114: p_interface_line_attribute15 IN
115: ra_customer_trx_lines.interface_line_attribute15%type,
116: p_default_ussgl_code_context IN
117: ra_customer_trx_lines.default_ussgl_trx_code_context%type,
111: ra_customer_trx_lines.interface_line_attribute13%type,
112: p_interface_line_attribute14 IN
113: ra_customer_trx_lines.interface_line_attribute14%type,
114: p_interface_line_attribute15 IN
115: ra_customer_trx_lines.interface_line_attribute15%type,
116: p_default_ussgl_code_context IN
117: ra_customer_trx_lines.default_ussgl_trx_code_context%type,
118: p_default_ussgl_trx_code IN
119: ra_customer_trx_lines.default_ussgl_transaction_code%type,
113: ra_customer_trx_lines.interface_line_attribute14%type,
114: p_interface_line_attribute15 IN
115: ra_customer_trx_lines.interface_line_attribute15%type,
116: p_default_ussgl_code_context IN
117: ra_customer_trx_lines.default_ussgl_trx_code_context%type,
118: p_default_ussgl_trx_code IN
119: ra_customer_trx_lines.default_ussgl_transaction_code%type,
120: p_trx_class IN ra_cust_trx_types.type%type,
121: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
115: ra_customer_trx_lines.interface_line_attribute15%type,
116: p_default_ussgl_code_context IN
117: ra_customer_trx_lines.default_ussgl_trx_code_context%type,
118: p_default_ussgl_trx_code IN
119: ra_customer_trx_lines.default_ussgl_transaction_code%type,
120: p_trx_class IN ra_cust_trx_types.type%type,
121: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
122: p_frt_ccid IN
123: ra_cust_trx_line_gl_dist.code_combination_id%type,
121: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
122: p_frt_ccid IN
123: ra_cust_trx_line_gl_dist.code_combination_id%type,
124: p_customer_trx_line_id OUT NOCOPY
125: ra_customer_trx_lines.customer_trx_line_id%type,
126: p_status OUT NOCOPY varchar2)
127: IS
128:
129: l_frt_rec ra_customer_trx_lines%rowtype;
125: ra_customer_trx_lines.customer_trx_line_id%type,
126: p_status OUT NOCOPY varchar2)
127: IS
128:
129: l_frt_rec ra_customer_trx_lines%rowtype;
130: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
131:
132: BEGIN
133:
126: p_status OUT NOCOPY varchar2)
127: IS
128:
129: l_frt_rec ra_customer_trx_lines%rowtype;
130: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
131:
132: BEGIN
133:
134: IF PG_DEBUG in ('Y', 'C') THEN
305:
306: PROCEDURE update_freight_cover(
307: p_form_name IN varchar2,
308: p_form_version IN number,
309: p_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
310: p_customer_trx_line_id IN
311: ra_customer_trx_lines.customer_trx_line_id%type,
312: p_line_type IN ra_customer_trx_lines.line_type%type,
313: p_line_number IN ra_customer_trx_lines.line_number%type,
307: p_form_name IN varchar2,
308: p_form_version IN number,
309: p_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
310: p_customer_trx_line_id IN
311: ra_customer_trx_lines.customer_trx_line_id%type,
312: p_line_type IN ra_customer_trx_lines.line_type%type,
313: p_line_number IN ra_customer_trx_lines.line_number%type,
314: p_extended_amount IN ra_customer_trx_lines.extended_amount%type,
315: p_revenue_amount IN ra_customer_trx_lines.revenue_amount%type,
308: p_form_version IN number,
309: p_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
310: p_customer_trx_line_id IN
311: ra_customer_trx_lines.customer_trx_line_id%type,
312: p_line_type IN ra_customer_trx_lines.line_type%type,
313: p_line_number IN ra_customer_trx_lines.line_number%type,
314: p_extended_amount IN ra_customer_trx_lines.extended_amount%type,
315: p_revenue_amount IN ra_customer_trx_lines.revenue_amount%type,
316: p_previous_customer_trx_id IN
309: p_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
310: p_customer_trx_line_id IN
311: ra_customer_trx_lines.customer_trx_line_id%type,
312: p_line_type IN ra_customer_trx_lines.line_type%type,
313: p_line_number IN ra_customer_trx_lines.line_number%type,
314: p_extended_amount IN ra_customer_trx_lines.extended_amount%type,
315: p_revenue_amount IN ra_customer_trx_lines.revenue_amount%type,
316: p_previous_customer_trx_id IN
317: ra_customer_trx_lines.previous_customer_trx_id%type,
310: p_customer_trx_line_id IN
311: ra_customer_trx_lines.customer_trx_line_id%type,
312: p_line_type IN ra_customer_trx_lines.line_type%type,
313: p_line_number IN ra_customer_trx_lines.line_number%type,
314: p_extended_amount IN ra_customer_trx_lines.extended_amount%type,
315: p_revenue_amount IN ra_customer_trx_lines.revenue_amount%type,
316: p_previous_customer_trx_id IN
317: ra_customer_trx_lines.previous_customer_trx_id%type,
318: p_previous_cust_trx_line_id IN
311: ra_customer_trx_lines.customer_trx_line_id%type,
312: p_line_type IN ra_customer_trx_lines.line_type%type,
313: p_line_number IN ra_customer_trx_lines.line_number%type,
314: p_extended_amount IN ra_customer_trx_lines.extended_amount%type,
315: p_revenue_amount IN ra_customer_trx_lines.revenue_amount%type,
316: p_previous_customer_trx_id IN
317: ra_customer_trx_lines.previous_customer_trx_id%type,
318: p_previous_cust_trx_line_id IN
319: ra_customer_trx_lines.previous_customer_trx_line_id%type,
313: p_line_number IN ra_customer_trx_lines.line_number%type,
314: p_extended_amount IN ra_customer_trx_lines.extended_amount%type,
315: p_revenue_amount IN ra_customer_trx_lines.revenue_amount%type,
316: p_previous_customer_trx_id IN
317: ra_customer_trx_lines.previous_customer_trx_id%type,
318: p_previous_cust_trx_line_id IN
319: ra_customer_trx_lines.previous_customer_trx_line_id%type,
320: p_link_to_cust_trx_line_id IN
321: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
315: p_revenue_amount IN ra_customer_trx_lines.revenue_amount%type,
316: p_previous_customer_trx_id IN
317: ra_customer_trx_lines.previous_customer_trx_id%type,
318: p_previous_cust_trx_line_id IN
319: ra_customer_trx_lines.previous_customer_trx_line_id%type,
320: p_link_to_cust_trx_line_id IN
321: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
322: p_attribute_category IN
323: ra_customer_trx_lines.attribute_category%type,
317: ra_customer_trx_lines.previous_customer_trx_id%type,
318: p_previous_cust_trx_line_id IN
319: ra_customer_trx_lines.previous_customer_trx_line_id%type,
320: p_link_to_cust_trx_line_id IN
321: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
322: p_attribute_category IN
323: ra_customer_trx_lines.attribute_category%type,
324: p_attribute1 IN ra_customer_trx_lines.attribute1%type,
325: p_attribute2 IN ra_customer_trx_lines.attribute2%type,
319: ra_customer_trx_lines.previous_customer_trx_line_id%type,
320: p_link_to_cust_trx_line_id IN
321: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
322: p_attribute_category IN
323: ra_customer_trx_lines.attribute_category%type,
324: p_attribute1 IN ra_customer_trx_lines.attribute1%type,
325: p_attribute2 IN ra_customer_trx_lines.attribute2%type,
326: p_attribute3 IN ra_customer_trx_lines.attribute3%type,
327: p_attribute4 IN ra_customer_trx_lines.attribute4%type,
320: p_link_to_cust_trx_line_id IN
321: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
322: p_attribute_category IN
323: ra_customer_trx_lines.attribute_category%type,
324: p_attribute1 IN ra_customer_trx_lines.attribute1%type,
325: p_attribute2 IN ra_customer_trx_lines.attribute2%type,
326: p_attribute3 IN ra_customer_trx_lines.attribute3%type,
327: p_attribute4 IN ra_customer_trx_lines.attribute4%type,
328: p_attribute5 IN ra_customer_trx_lines.attribute5%type,
321: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
322: p_attribute_category IN
323: ra_customer_trx_lines.attribute_category%type,
324: p_attribute1 IN ra_customer_trx_lines.attribute1%type,
325: p_attribute2 IN ra_customer_trx_lines.attribute2%type,
326: p_attribute3 IN ra_customer_trx_lines.attribute3%type,
327: p_attribute4 IN ra_customer_trx_lines.attribute4%type,
328: p_attribute5 IN ra_customer_trx_lines.attribute5%type,
329: p_attribute6 IN ra_customer_trx_lines.attribute6%type,
322: p_attribute_category IN
323: ra_customer_trx_lines.attribute_category%type,
324: p_attribute1 IN ra_customer_trx_lines.attribute1%type,
325: p_attribute2 IN ra_customer_trx_lines.attribute2%type,
326: p_attribute3 IN ra_customer_trx_lines.attribute3%type,
327: p_attribute4 IN ra_customer_trx_lines.attribute4%type,
328: p_attribute5 IN ra_customer_trx_lines.attribute5%type,
329: p_attribute6 IN ra_customer_trx_lines.attribute6%type,
330: p_attribute7 IN ra_customer_trx_lines.attribute7%type,
323: ra_customer_trx_lines.attribute_category%type,
324: p_attribute1 IN ra_customer_trx_lines.attribute1%type,
325: p_attribute2 IN ra_customer_trx_lines.attribute2%type,
326: p_attribute3 IN ra_customer_trx_lines.attribute3%type,
327: p_attribute4 IN ra_customer_trx_lines.attribute4%type,
328: p_attribute5 IN ra_customer_trx_lines.attribute5%type,
329: p_attribute6 IN ra_customer_trx_lines.attribute6%type,
330: p_attribute7 IN ra_customer_trx_lines.attribute7%type,
331: p_attribute8 IN ra_customer_trx_lines.attribute8%type,
324: p_attribute1 IN ra_customer_trx_lines.attribute1%type,
325: p_attribute2 IN ra_customer_trx_lines.attribute2%type,
326: p_attribute3 IN ra_customer_trx_lines.attribute3%type,
327: p_attribute4 IN ra_customer_trx_lines.attribute4%type,
328: p_attribute5 IN ra_customer_trx_lines.attribute5%type,
329: p_attribute6 IN ra_customer_trx_lines.attribute6%type,
330: p_attribute7 IN ra_customer_trx_lines.attribute7%type,
331: p_attribute8 IN ra_customer_trx_lines.attribute8%type,
332: p_attribute9 IN ra_customer_trx_lines.attribute9%type,
325: p_attribute2 IN ra_customer_trx_lines.attribute2%type,
326: p_attribute3 IN ra_customer_trx_lines.attribute3%type,
327: p_attribute4 IN ra_customer_trx_lines.attribute4%type,
328: p_attribute5 IN ra_customer_trx_lines.attribute5%type,
329: p_attribute6 IN ra_customer_trx_lines.attribute6%type,
330: p_attribute7 IN ra_customer_trx_lines.attribute7%type,
331: p_attribute8 IN ra_customer_trx_lines.attribute8%type,
332: p_attribute9 IN ra_customer_trx_lines.attribute9%type,
333: p_attribute10 IN ra_customer_trx_lines.attribute10%type,
326: p_attribute3 IN ra_customer_trx_lines.attribute3%type,
327: p_attribute4 IN ra_customer_trx_lines.attribute4%type,
328: p_attribute5 IN ra_customer_trx_lines.attribute5%type,
329: p_attribute6 IN ra_customer_trx_lines.attribute6%type,
330: p_attribute7 IN ra_customer_trx_lines.attribute7%type,
331: p_attribute8 IN ra_customer_trx_lines.attribute8%type,
332: p_attribute9 IN ra_customer_trx_lines.attribute9%type,
333: p_attribute10 IN ra_customer_trx_lines.attribute10%type,
334: p_attribute11 IN ra_customer_trx_lines.attribute11%type,
327: p_attribute4 IN ra_customer_trx_lines.attribute4%type,
328: p_attribute5 IN ra_customer_trx_lines.attribute5%type,
329: p_attribute6 IN ra_customer_trx_lines.attribute6%type,
330: p_attribute7 IN ra_customer_trx_lines.attribute7%type,
331: p_attribute8 IN ra_customer_trx_lines.attribute8%type,
332: p_attribute9 IN ra_customer_trx_lines.attribute9%type,
333: p_attribute10 IN ra_customer_trx_lines.attribute10%type,
334: p_attribute11 IN ra_customer_trx_lines.attribute11%type,
335: p_attribute12 IN ra_customer_trx_lines.attribute12%type,
328: p_attribute5 IN ra_customer_trx_lines.attribute5%type,
329: p_attribute6 IN ra_customer_trx_lines.attribute6%type,
330: p_attribute7 IN ra_customer_trx_lines.attribute7%type,
331: p_attribute8 IN ra_customer_trx_lines.attribute8%type,
332: p_attribute9 IN ra_customer_trx_lines.attribute9%type,
333: p_attribute10 IN ra_customer_trx_lines.attribute10%type,
334: p_attribute11 IN ra_customer_trx_lines.attribute11%type,
335: p_attribute12 IN ra_customer_trx_lines.attribute12%type,
336: p_attribute13 IN ra_customer_trx_lines.attribute13%type,
329: p_attribute6 IN ra_customer_trx_lines.attribute6%type,
330: p_attribute7 IN ra_customer_trx_lines.attribute7%type,
331: p_attribute8 IN ra_customer_trx_lines.attribute8%type,
332: p_attribute9 IN ra_customer_trx_lines.attribute9%type,
333: p_attribute10 IN ra_customer_trx_lines.attribute10%type,
334: p_attribute11 IN ra_customer_trx_lines.attribute11%type,
335: p_attribute12 IN ra_customer_trx_lines.attribute12%type,
336: p_attribute13 IN ra_customer_trx_lines.attribute13%type,
337: p_attribute14 IN ra_customer_trx_lines.attribute14%type,
330: p_attribute7 IN ra_customer_trx_lines.attribute7%type,
331: p_attribute8 IN ra_customer_trx_lines.attribute8%type,
332: p_attribute9 IN ra_customer_trx_lines.attribute9%type,
333: p_attribute10 IN ra_customer_trx_lines.attribute10%type,
334: p_attribute11 IN ra_customer_trx_lines.attribute11%type,
335: p_attribute12 IN ra_customer_trx_lines.attribute12%type,
336: p_attribute13 IN ra_customer_trx_lines.attribute13%type,
337: p_attribute14 IN ra_customer_trx_lines.attribute14%type,
338: p_attribute15 IN ra_customer_trx_lines.attribute15%type,
331: p_attribute8 IN ra_customer_trx_lines.attribute8%type,
332: p_attribute9 IN ra_customer_trx_lines.attribute9%type,
333: p_attribute10 IN ra_customer_trx_lines.attribute10%type,
334: p_attribute11 IN ra_customer_trx_lines.attribute11%type,
335: p_attribute12 IN ra_customer_trx_lines.attribute12%type,
336: p_attribute13 IN ra_customer_trx_lines.attribute13%type,
337: p_attribute14 IN ra_customer_trx_lines.attribute14%type,
338: p_attribute15 IN ra_customer_trx_lines.attribute15%type,
339: p_interface_line_context IN
332: p_attribute9 IN ra_customer_trx_lines.attribute9%type,
333: p_attribute10 IN ra_customer_trx_lines.attribute10%type,
334: p_attribute11 IN ra_customer_trx_lines.attribute11%type,
335: p_attribute12 IN ra_customer_trx_lines.attribute12%type,
336: p_attribute13 IN ra_customer_trx_lines.attribute13%type,
337: p_attribute14 IN ra_customer_trx_lines.attribute14%type,
338: p_attribute15 IN ra_customer_trx_lines.attribute15%type,
339: p_interface_line_context IN
340: ra_customer_trx_lines.interface_line_context%type,
333: p_attribute10 IN ra_customer_trx_lines.attribute10%type,
334: p_attribute11 IN ra_customer_trx_lines.attribute11%type,
335: p_attribute12 IN ra_customer_trx_lines.attribute12%type,
336: p_attribute13 IN ra_customer_trx_lines.attribute13%type,
337: p_attribute14 IN ra_customer_trx_lines.attribute14%type,
338: p_attribute15 IN ra_customer_trx_lines.attribute15%type,
339: p_interface_line_context IN
340: ra_customer_trx_lines.interface_line_context%type,
341: p_interface_line_attribute1 IN
334: p_attribute11 IN ra_customer_trx_lines.attribute11%type,
335: p_attribute12 IN ra_customer_trx_lines.attribute12%type,
336: p_attribute13 IN ra_customer_trx_lines.attribute13%type,
337: p_attribute14 IN ra_customer_trx_lines.attribute14%type,
338: p_attribute15 IN ra_customer_trx_lines.attribute15%type,
339: p_interface_line_context IN
340: ra_customer_trx_lines.interface_line_context%type,
341: p_interface_line_attribute1 IN
342: ra_customer_trx_lines.interface_line_attribute1%type,
336: p_attribute13 IN ra_customer_trx_lines.attribute13%type,
337: p_attribute14 IN ra_customer_trx_lines.attribute14%type,
338: p_attribute15 IN ra_customer_trx_lines.attribute15%type,
339: p_interface_line_context IN
340: ra_customer_trx_lines.interface_line_context%type,
341: p_interface_line_attribute1 IN
342: ra_customer_trx_lines.interface_line_attribute1%type,
343: p_interface_line_attribute2 IN
344: ra_customer_trx_lines.interface_line_attribute2%type,
338: p_attribute15 IN ra_customer_trx_lines.attribute15%type,
339: p_interface_line_context IN
340: ra_customer_trx_lines.interface_line_context%type,
341: p_interface_line_attribute1 IN
342: ra_customer_trx_lines.interface_line_attribute1%type,
343: p_interface_line_attribute2 IN
344: ra_customer_trx_lines.interface_line_attribute2%type,
345: p_interface_line_attribute3 IN
346: ra_customer_trx_lines.interface_line_attribute3%type,
340: ra_customer_trx_lines.interface_line_context%type,
341: p_interface_line_attribute1 IN
342: ra_customer_trx_lines.interface_line_attribute1%type,
343: p_interface_line_attribute2 IN
344: ra_customer_trx_lines.interface_line_attribute2%type,
345: p_interface_line_attribute3 IN
346: ra_customer_trx_lines.interface_line_attribute3%type,
347: p_interface_line_attribute4 IN
348: ra_customer_trx_lines.interface_line_attribute4%type,
342: ra_customer_trx_lines.interface_line_attribute1%type,
343: p_interface_line_attribute2 IN
344: ra_customer_trx_lines.interface_line_attribute2%type,
345: p_interface_line_attribute3 IN
346: ra_customer_trx_lines.interface_line_attribute3%type,
347: p_interface_line_attribute4 IN
348: ra_customer_trx_lines.interface_line_attribute4%type,
349: p_interface_line_attribute5 IN
350: ra_customer_trx_lines.interface_line_attribute5%type,
344: ra_customer_trx_lines.interface_line_attribute2%type,
345: p_interface_line_attribute3 IN
346: ra_customer_trx_lines.interface_line_attribute3%type,
347: p_interface_line_attribute4 IN
348: ra_customer_trx_lines.interface_line_attribute4%type,
349: p_interface_line_attribute5 IN
350: ra_customer_trx_lines.interface_line_attribute5%type,
351: p_interface_line_attribute6 IN
352: ra_customer_trx_lines.interface_line_attribute6%type,
346: ra_customer_trx_lines.interface_line_attribute3%type,
347: p_interface_line_attribute4 IN
348: ra_customer_trx_lines.interface_line_attribute4%type,
349: p_interface_line_attribute5 IN
350: ra_customer_trx_lines.interface_line_attribute5%type,
351: p_interface_line_attribute6 IN
352: ra_customer_trx_lines.interface_line_attribute6%type,
353: p_interface_line_attribute7 IN
354: ra_customer_trx_lines.interface_line_attribute7%type,
348: ra_customer_trx_lines.interface_line_attribute4%type,
349: p_interface_line_attribute5 IN
350: ra_customer_trx_lines.interface_line_attribute5%type,
351: p_interface_line_attribute6 IN
352: ra_customer_trx_lines.interface_line_attribute6%type,
353: p_interface_line_attribute7 IN
354: ra_customer_trx_lines.interface_line_attribute7%type,
355: p_interface_line_attribute8 IN
356: ra_customer_trx_lines.interface_line_attribute8%type,
350: ra_customer_trx_lines.interface_line_attribute5%type,
351: p_interface_line_attribute6 IN
352: ra_customer_trx_lines.interface_line_attribute6%type,
353: p_interface_line_attribute7 IN
354: ra_customer_trx_lines.interface_line_attribute7%type,
355: p_interface_line_attribute8 IN
356: ra_customer_trx_lines.interface_line_attribute8%type,
357: p_interface_line_attribute9 IN
358: ra_customer_trx_lines.interface_line_attribute9%type,
352: ra_customer_trx_lines.interface_line_attribute6%type,
353: p_interface_line_attribute7 IN
354: ra_customer_trx_lines.interface_line_attribute7%type,
355: p_interface_line_attribute8 IN
356: ra_customer_trx_lines.interface_line_attribute8%type,
357: p_interface_line_attribute9 IN
358: ra_customer_trx_lines.interface_line_attribute9%type,
359: p_interface_line_attribute10 IN
360: ra_customer_trx_lines.interface_line_attribute10%type,
354: ra_customer_trx_lines.interface_line_attribute7%type,
355: p_interface_line_attribute8 IN
356: ra_customer_trx_lines.interface_line_attribute8%type,
357: p_interface_line_attribute9 IN
358: ra_customer_trx_lines.interface_line_attribute9%type,
359: p_interface_line_attribute10 IN
360: ra_customer_trx_lines.interface_line_attribute10%type,
361: p_interface_line_attribute11 IN
362: ra_customer_trx_lines.interface_line_attribute11%type,
356: ra_customer_trx_lines.interface_line_attribute8%type,
357: p_interface_line_attribute9 IN
358: ra_customer_trx_lines.interface_line_attribute9%type,
359: p_interface_line_attribute10 IN
360: ra_customer_trx_lines.interface_line_attribute10%type,
361: p_interface_line_attribute11 IN
362: ra_customer_trx_lines.interface_line_attribute11%type,
363: p_interface_line_attribute12 IN
364: ra_customer_trx_lines.interface_line_attribute12%type,
358: ra_customer_trx_lines.interface_line_attribute9%type,
359: p_interface_line_attribute10 IN
360: ra_customer_trx_lines.interface_line_attribute10%type,
361: p_interface_line_attribute11 IN
362: ra_customer_trx_lines.interface_line_attribute11%type,
363: p_interface_line_attribute12 IN
364: ra_customer_trx_lines.interface_line_attribute12%type,
365: p_interface_line_attribute13 IN
366: ra_customer_trx_lines.interface_line_attribute13%type,
360: ra_customer_trx_lines.interface_line_attribute10%type,
361: p_interface_line_attribute11 IN
362: ra_customer_trx_lines.interface_line_attribute11%type,
363: p_interface_line_attribute12 IN
364: ra_customer_trx_lines.interface_line_attribute12%type,
365: p_interface_line_attribute13 IN
366: ra_customer_trx_lines.interface_line_attribute13%type,
367: p_interface_line_attribute14 IN
368: ra_customer_trx_lines.interface_line_attribute14%type,
362: ra_customer_trx_lines.interface_line_attribute11%type,
363: p_interface_line_attribute12 IN
364: ra_customer_trx_lines.interface_line_attribute12%type,
365: p_interface_line_attribute13 IN
366: ra_customer_trx_lines.interface_line_attribute13%type,
367: p_interface_line_attribute14 IN
368: ra_customer_trx_lines.interface_line_attribute14%type,
369: p_interface_line_attribute15 IN
370: ra_customer_trx_lines.interface_line_attribute15%type,
364: ra_customer_trx_lines.interface_line_attribute12%type,
365: p_interface_line_attribute13 IN
366: ra_customer_trx_lines.interface_line_attribute13%type,
367: p_interface_line_attribute14 IN
368: ra_customer_trx_lines.interface_line_attribute14%type,
369: p_interface_line_attribute15 IN
370: ra_customer_trx_lines.interface_line_attribute15%type,
371: p_default_ussgl_code_context IN
372: ra_customer_trx_lines.default_ussgl_trx_code_context%type,
366: ra_customer_trx_lines.interface_line_attribute13%type,
367: p_interface_line_attribute14 IN
368: ra_customer_trx_lines.interface_line_attribute14%type,
369: p_interface_line_attribute15 IN
370: ra_customer_trx_lines.interface_line_attribute15%type,
371: p_default_ussgl_code_context IN
372: ra_customer_trx_lines.default_ussgl_trx_code_context%type,
373: p_default_ussgl_trx_code IN
374: ra_customer_trx_lines.default_ussgl_transaction_code%type,
368: ra_customer_trx_lines.interface_line_attribute14%type,
369: p_interface_line_attribute15 IN
370: ra_customer_trx_lines.interface_line_attribute15%type,
371: p_default_ussgl_code_context IN
372: ra_customer_trx_lines.default_ussgl_trx_code_context%type,
373: p_default_ussgl_trx_code IN
374: ra_customer_trx_lines.default_ussgl_transaction_code%type,
375: p_trx_class IN ra_cust_trx_types.type%type,
376: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
370: ra_customer_trx_lines.interface_line_attribute15%type,
371: p_default_ussgl_code_context IN
372: ra_customer_trx_lines.default_ussgl_trx_code_context%type,
373: p_default_ussgl_trx_code IN
374: ra_customer_trx_lines.default_ussgl_transaction_code%type,
375: p_trx_class IN ra_cust_trx_types.type%type,
376: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
377: p_frt_ccid IN
378: ra_cust_trx_line_gl_dist.code_combination_id%type,
380: p_open_rec_flag IN varchar2,
381: p_status OUT NOCOPY varchar2)
382: IS
383:
384: l_frt_rec ra_customer_trx_lines%rowtype;
385:
386: BEGIN
387:
388: IF PG_DEBUG in ('Y', 'C') THEN