APPS.ARP_CTL_FREIGHT_PKG dependencies on RA_CUSTOMER_TRX_LINES

Line 50: FROM ra_customer_trx_lines

46: SELECT NVL( SUM( NVL(extended_amount, 0 ) ), 0),
47: NVL( SUM( NVL(extended_amount, 0 ) ), 0)
48: INTO p_amount_total,
49: p_amount_total_rtot_db
50: FROM ra_customer_trx_lines
51: WHERE customer_trx_id = p_customer_trx_id
52: AND line_type = 'FREIGHT';
53:
54: IF PG_DEBUG in ('Y', 'C') THEN

Line 111: ra_customer_trx_lines.customer_trx_line_id%type,

107: | |
108: +===========================================================================*/
109: PROCEDURE lock_compare_frt_cover(
110: p_customer_trx_line_id IN
111: ra_customer_trx_lines.customer_trx_line_id%type,
112: p_customer_trx_id IN
113: ra_customer_trx_lines.customer_trx_id%type,
114: p_link_to_cust_trx_line_id IN
115: ra_customer_trx_lines.link_to_cust_trx_line_id%type,

Line 113: ra_customer_trx_lines.customer_trx_id%type,

109: PROCEDURE lock_compare_frt_cover(
110: p_customer_trx_line_id IN
111: ra_customer_trx_lines.customer_trx_line_id%type,
112: p_customer_trx_id IN
113: ra_customer_trx_lines.customer_trx_id%type,
114: p_link_to_cust_trx_line_id IN
115: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
116: p_previous_customer_trx_id IN
117: ra_customer_trx_lines.previous_customer_trx_id%type,

Line 115: ra_customer_trx_lines.link_to_cust_trx_line_id%type,

111: ra_customer_trx_lines.customer_trx_line_id%type,
112: p_customer_trx_id IN
113: ra_customer_trx_lines.customer_trx_id%type,
114: p_link_to_cust_trx_line_id IN
115: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
116: p_previous_customer_trx_id IN
117: ra_customer_trx_lines.previous_customer_trx_id%type,
118: p_previous_cust_trx_line_id IN
119: ra_customer_trx_lines.previous_customer_trx_line_id%type,

Line 117: ra_customer_trx_lines.previous_customer_trx_id%type,

113: ra_customer_trx_lines.customer_trx_id%type,
114: p_link_to_cust_trx_line_id IN
115: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
116: p_previous_customer_trx_id IN
117: ra_customer_trx_lines.previous_customer_trx_id%type,
118: p_previous_cust_trx_line_id IN
119: ra_customer_trx_lines.previous_customer_trx_line_id%type,
120: p_line_number IN ra_customer_trx_lines.line_number%type,
121: p_line_type IN ra_customer_trx_lines.line_type%type,

Line 119: ra_customer_trx_lines.previous_customer_trx_line_id%type,

115: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
116: p_previous_customer_trx_id IN
117: ra_customer_trx_lines.previous_customer_trx_id%type,
118: p_previous_cust_trx_line_id IN
119: ra_customer_trx_lines.previous_customer_trx_line_id%type,
120: p_line_number IN ra_customer_trx_lines.line_number%type,
121: p_line_type IN ra_customer_trx_lines.line_type%type,
122: p_extended_amount IN ra_customer_trx_lines.extended_amount%type,
123: p_attribute_category IN

Line 120: p_line_number IN ra_customer_trx_lines.line_number%type,

116: p_previous_customer_trx_id IN
117: ra_customer_trx_lines.previous_customer_trx_id%type,
118: p_previous_cust_trx_line_id IN
119: ra_customer_trx_lines.previous_customer_trx_line_id%type,
120: p_line_number IN ra_customer_trx_lines.line_number%type,
121: p_line_type IN ra_customer_trx_lines.line_type%type,
122: p_extended_amount IN ra_customer_trx_lines.extended_amount%type,
123: p_attribute_category IN
124: ra_customer_trx_lines.attribute_category%type,

Line 121: p_line_type IN ra_customer_trx_lines.line_type%type,

117: ra_customer_trx_lines.previous_customer_trx_id%type,
118: p_previous_cust_trx_line_id IN
119: ra_customer_trx_lines.previous_customer_trx_line_id%type,
120: p_line_number IN ra_customer_trx_lines.line_number%type,
121: p_line_type IN ra_customer_trx_lines.line_type%type,
122: p_extended_amount IN ra_customer_trx_lines.extended_amount%type,
123: p_attribute_category IN
124: ra_customer_trx_lines.attribute_category%type,
125: p_attribute1 IN ra_customer_trx_lines.attribute1%type,

Line 122: p_extended_amount IN ra_customer_trx_lines.extended_amount%type,

118: p_previous_cust_trx_line_id IN
119: ra_customer_trx_lines.previous_customer_trx_line_id%type,
120: p_line_number IN ra_customer_trx_lines.line_number%type,
121: p_line_type IN ra_customer_trx_lines.line_type%type,
122: p_extended_amount IN ra_customer_trx_lines.extended_amount%type,
123: p_attribute_category IN
124: ra_customer_trx_lines.attribute_category%type,
125: p_attribute1 IN ra_customer_trx_lines.attribute1%type,
126: p_attribute2 IN ra_customer_trx_lines.attribute2%type,

Line 124: ra_customer_trx_lines.attribute_category%type,

120: p_line_number IN ra_customer_trx_lines.line_number%type,
121: p_line_type IN ra_customer_trx_lines.line_type%type,
122: p_extended_amount IN ra_customer_trx_lines.extended_amount%type,
123: p_attribute_category IN
124: ra_customer_trx_lines.attribute_category%type,
125: p_attribute1 IN ra_customer_trx_lines.attribute1%type,
126: p_attribute2 IN ra_customer_trx_lines.attribute2%type,
127: p_attribute3 IN ra_customer_trx_lines.attribute3%type,
128: p_attribute4 IN ra_customer_trx_lines.attribute4%type,

Line 125: p_attribute1 IN ra_customer_trx_lines.attribute1%type,

121: p_line_type IN ra_customer_trx_lines.line_type%type,
122: p_extended_amount IN ra_customer_trx_lines.extended_amount%type,
123: p_attribute_category IN
124: ra_customer_trx_lines.attribute_category%type,
125: p_attribute1 IN ra_customer_trx_lines.attribute1%type,
126: p_attribute2 IN ra_customer_trx_lines.attribute2%type,
127: p_attribute3 IN ra_customer_trx_lines.attribute3%type,
128: p_attribute4 IN ra_customer_trx_lines.attribute4%type,
129: p_attribute5 IN ra_customer_trx_lines.attribute5%type,

Line 126: p_attribute2 IN ra_customer_trx_lines.attribute2%type,

122: p_extended_amount IN ra_customer_trx_lines.extended_amount%type,
123: p_attribute_category IN
124: ra_customer_trx_lines.attribute_category%type,
125: p_attribute1 IN ra_customer_trx_lines.attribute1%type,
126: p_attribute2 IN ra_customer_trx_lines.attribute2%type,
127: p_attribute3 IN ra_customer_trx_lines.attribute3%type,
128: p_attribute4 IN ra_customer_trx_lines.attribute4%type,
129: p_attribute5 IN ra_customer_trx_lines.attribute5%type,
130: p_attribute6 IN ra_customer_trx_lines.attribute6%type,

Line 127: p_attribute3 IN ra_customer_trx_lines.attribute3%type,

123: p_attribute_category IN
124: ra_customer_trx_lines.attribute_category%type,
125: p_attribute1 IN ra_customer_trx_lines.attribute1%type,
126: p_attribute2 IN ra_customer_trx_lines.attribute2%type,
127: p_attribute3 IN ra_customer_trx_lines.attribute3%type,
128: p_attribute4 IN ra_customer_trx_lines.attribute4%type,
129: p_attribute5 IN ra_customer_trx_lines.attribute5%type,
130: p_attribute6 IN ra_customer_trx_lines.attribute6%type,
131: p_attribute7 IN ra_customer_trx_lines.attribute7%type,

Line 128: p_attribute4 IN ra_customer_trx_lines.attribute4%type,

124: ra_customer_trx_lines.attribute_category%type,
125: p_attribute1 IN ra_customer_trx_lines.attribute1%type,
126: p_attribute2 IN ra_customer_trx_lines.attribute2%type,
127: p_attribute3 IN ra_customer_trx_lines.attribute3%type,
128: p_attribute4 IN ra_customer_trx_lines.attribute4%type,
129: p_attribute5 IN ra_customer_trx_lines.attribute5%type,
130: p_attribute6 IN ra_customer_trx_lines.attribute6%type,
131: p_attribute7 IN ra_customer_trx_lines.attribute7%type,
132: p_attribute8 IN ra_customer_trx_lines.attribute8%type,

Line 129: p_attribute5 IN ra_customer_trx_lines.attribute5%type,

125: p_attribute1 IN ra_customer_trx_lines.attribute1%type,
126: p_attribute2 IN ra_customer_trx_lines.attribute2%type,
127: p_attribute3 IN ra_customer_trx_lines.attribute3%type,
128: p_attribute4 IN ra_customer_trx_lines.attribute4%type,
129: p_attribute5 IN ra_customer_trx_lines.attribute5%type,
130: p_attribute6 IN ra_customer_trx_lines.attribute6%type,
131: p_attribute7 IN ra_customer_trx_lines.attribute7%type,
132: p_attribute8 IN ra_customer_trx_lines.attribute8%type,
133: p_attribute9 IN ra_customer_trx_lines.attribute9%type,

Line 130: p_attribute6 IN ra_customer_trx_lines.attribute6%type,

126: p_attribute2 IN ra_customer_trx_lines.attribute2%type,
127: p_attribute3 IN ra_customer_trx_lines.attribute3%type,
128: p_attribute4 IN ra_customer_trx_lines.attribute4%type,
129: p_attribute5 IN ra_customer_trx_lines.attribute5%type,
130: p_attribute6 IN ra_customer_trx_lines.attribute6%type,
131: p_attribute7 IN ra_customer_trx_lines.attribute7%type,
132: p_attribute8 IN ra_customer_trx_lines.attribute8%type,
133: p_attribute9 IN ra_customer_trx_lines.attribute9%type,
134: p_attribute10 IN ra_customer_trx_lines.attribute10%type,

Line 131: p_attribute7 IN ra_customer_trx_lines.attribute7%type,

127: p_attribute3 IN ra_customer_trx_lines.attribute3%type,
128: p_attribute4 IN ra_customer_trx_lines.attribute4%type,
129: p_attribute5 IN ra_customer_trx_lines.attribute5%type,
130: p_attribute6 IN ra_customer_trx_lines.attribute6%type,
131: p_attribute7 IN ra_customer_trx_lines.attribute7%type,
132: p_attribute8 IN ra_customer_trx_lines.attribute8%type,
133: p_attribute9 IN ra_customer_trx_lines.attribute9%type,
134: p_attribute10 IN ra_customer_trx_lines.attribute10%type,
135: p_attribute11 IN ra_customer_trx_lines.attribute11%type,

Line 132: p_attribute8 IN ra_customer_trx_lines.attribute8%type,

128: p_attribute4 IN ra_customer_trx_lines.attribute4%type,
129: p_attribute5 IN ra_customer_trx_lines.attribute5%type,
130: p_attribute6 IN ra_customer_trx_lines.attribute6%type,
131: p_attribute7 IN ra_customer_trx_lines.attribute7%type,
132: p_attribute8 IN ra_customer_trx_lines.attribute8%type,
133: p_attribute9 IN ra_customer_trx_lines.attribute9%type,
134: p_attribute10 IN ra_customer_trx_lines.attribute10%type,
135: p_attribute11 IN ra_customer_trx_lines.attribute11%type,
136: p_attribute12 IN ra_customer_trx_lines.attribute12%type,

Line 133: p_attribute9 IN ra_customer_trx_lines.attribute9%type,

129: p_attribute5 IN ra_customer_trx_lines.attribute5%type,
130: p_attribute6 IN ra_customer_trx_lines.attribute6%type,
131: p_attribute7 IN ra_customer_trx_lines.attribute7%type,
132: p_attribute8 IN ra_customer_trx_lines.attribute8%type,
133: p_attribute9 IN ra_customer_trx_lines.attribute9%type,
134: p_attribute10 IN ra_customer_trx_lines.attribute10%type,
135: p_attribute11 IN ra_customer_trx_lines.attribute11%type,
136: p_attribute12 IN ra_customer_trx_lines.attribute12%type,
137: p_attribute13 IN ra_customer_trx_lines.attribute13%type,

Line 134: p_attribute10 IN ra_customer_trx_lines.attribute10%type,

130: p_attribute6 IN ra_customer_trx_lines.attribute6%type,
131: p_attribute7 IN ra_customer_trx_lines.attribute7%type,
132: p_attribute8 IN ra_customer_trx_lines.attribute8%type,
133: p_attribute9 IN ra_customer_trx_lines.attribute9%type,
134: p_attribute10 IN ra_customer_trx_lines.attribute10%type,
135: p_attribute11 IN ra_customer_trx_lines.attribute11%type,
136: p_attribute12 IN ra_customer_trx_lines.attribute12%type,
137: p_attribute13 IN ra_customer_trx_lines.attribute13%type,
138: p_attribute14 IN ra_customer_trx_lines.attribute14%type,

Line 135: p_attribute11 IN ra_customer_trx_lines.attribute11%type,

131: p_attribute7 IN ra_customer_trx_lines.attribute7%type,
132: p_attribute8 IN ra_customer_trx_lines.attribute8%type,
133: p_attribute9 IN ra_customer_trx_lines.attribute9%type,
134: p_attribute10 IN ra_customer_trx_lines.attribute10%type,
135: p_attribute11 IN ra_customer_trx_lines.attribute11%type,
136: p_attribute12 IN ra_customer_trx_lines.attribute12%type,
137: p_attribute13 IN ra_customer_trx_lines.attribute13%type,
138: p_attribute14 IN ra_customer_trx_lines.attribute14%type,
139: p_attribute15 IN ra_customer_trx_lines.attribute15%type,

Line 136: p_attribute12 IN ra_customer_trx_lines.attribute12%type,

132: p_attribute8 IN ra_customer_trx_lines.attribute8%type,
133: p_attribute9 IN ra_customer_trx_lines.attribute9%type,
134: p_attribute10 IN ra_customer_trx_lines.attribute10%type,
135: p_attribute11 IN ra_customer_trx_lines.attribute11%type,
136: p_attribute12 IN ra_customer_trx_lines.attribute12%type,
137: p_attribute13 IN ra_customer_trx_lines.attribute13%type,
138: p_attribute14 IN ra_customer_trx_lines.attribute14%type,
139: p_attribute15 IN ra_customer_trx_lines.attribute15%type,
140: p_interface_line_context IN

Line 137: p_attribute13 IN ra_customer_trx_lines.attribute13%type,

133: p_attribute9 IN ra_customer_trx_lines.attribute9%type,
134: p_attribute10 IN ra_customer_trx_lines.attribute10%type,
135: p_attribute11 IN ra_customer_trx_lines.attribute11%type,
136: p_attribute12 IN ra_customer_trx_lines.attribute12%type,
137: p_attribute13 IN ra_customer_trx_lines.attribute13%type,
138: p_attribute14 IN ra_customer_trx_lines.attribute14%type,
139: p_attribute15 IN ra_customer_trx_lines.attribute15%type,
140: p_interface_line_context IN
141: ra_customer_trx_lines.interface_line_context%type,

Line 138: p_attribute14 IN ra_customer_trx_lines.attribute14%type,

134: p_attribute10 IN ra_customer_trx_lines.attribute10%type,
135: p_attribute11 IN ra_customer_trx_lines.attribute11%type,
136: p_attribute12 IN ra_customer_trx_lines.attribute12%type,
137: p_attribute13 IN ra_customer_trx_lines.attribute13%type,
138: p_attribute14 IN ra_customer_trx_lines.attribute14%type,
139: p_attribute15 IN ra_customer_trx_lines.attribute15%type,
140: p_interface_line_context IN
141: ra_customer_trx_lines.interface_line_context%type,
142: p_interface_line_attribute1 IN

Line 139: p_attribute15 IN ra_customer_trx_lines.attribute15%type,

135: p_attribute11 IN ra_customer_trx_lines.attribute11%type,
136: p_attribute12 IN ra_customer_trx_lines.attribute12%type,
137: p_attribute13 IN ra_customer_trx_lines.attribute13%type,
138: p_attribute14 IN ra_customer_trx_lines.attribute14%type,
139: p_attribute15 IN ra_customer_trx_lines.attribute15%type,
140: p_interface_line_context IN
141: ra_customer_trx_lines.interface_line_context%type,
142: p_interface_line_attribute1 IN
143: ra_customer_trx_lines.interface_line_attribute1%type,

Line 141: ra_customer_trx_lines.interface_line_context%type,

137: p_attribute13 IN ra_customer_trx_lines.attribute13%type,
138: p_attribute14 IN ra_customer_trx_lines.attribute14%type,
139: p_attribute15 IN ra_customer_trx_lines.attribute15%type,
140: p_interface_line_context IN
141: ra_customer_trx_lines.interface_line_context%type,
142: p_interface_line_attribute1 IN
143: ra_customer_trx_lines.interface_line_attribute1%type,
144: p_interface_line_attribute2 IN
145: ra_customer_trx_lines.interface_line_attribute2%type,

Line 143: ra_customer_trx_lines.interface_line_attribute1%type,

139: p_attribute15 IN ra_customer_trx_lines.attribute15%type,
140: p_interface_line_context IN
141: ra_customer_trx_lines.interface_line_context%type,
142: p_interface_line_attribute1 IN
143: ra_customer_trx_lines.interface_line_attribute1%type,
144: p_interface_line_attribute2 IN
145: ra_customer_trx_lines.interface_line_attribute2%type,
146: p_interface_line_attribute3 IN
147: ra_customer_trx_lines.interface_line_attribute3%type,

Line 145: ra_customer_trx_lines.interface_line_attribute2%type,

141: ra_customer_trx_lines.interface_line_context%type,
142: p_interface_line_attribute1 IN
143: ra_customer_trx_lines.interface_line_attribute1%type,
144: p_interface_line_attribute2 IN
145: ra_customer_trx_lines.interface_line_attribute2%type,
146: p_interface_line_attribute3 IN
147: ra_customer_trx_lines.interface_line_attribute3%type,
148: p_interface_line_attribute4 IN
149: ra_customer_trx_lines.interface_line_attribute4%type,

Line 147: ra_customer_trx_lines.interface_line_attribute3%type,

143: ra_customer_trx_lines.interface_line_attribute1%type,
144: p_interface_line_attribute2 IN
145: ra_customer_trx_lines.interface_line_attribute2%type,
146: p_interface_line_attribute3 IN
147: ra_customer_trx_lines.interface_line_attribute3%type,
148: p_interface_line_attribute4 IN
149: ra_customer_trx_lines.interface_line_attribute4%type,
150: p_interface_line_attribute5 IN
151: ra_customer_trx_lines.interface_line_attribute5%type,

Line 149: ra_customer_trx_lines.interface_line_attribute4%type,

145: ra_customer_trx_lines.interface_line_attribute2%type,
146: p_interface_line_attribute3 IN
147: ra_customer_trx_lines.interface_line_attribute3%type,
148: p_interface_line_attribute4 IN
149: ra_customer_trx_lines.interface_line_attribute4%type,
150: p_interface_line_attribute5 IN
151: ra_customer_trx_lines.interface_line_attribute5%type,
152: p_interface_line_attribute6 IN
153: ra_customer_trx_lines.interface_line_attribute6%type,

Line 151: ra_customer_trx_lines.interface_line_attribute5%type,

147: ra_customer_trx_lines.interface_line_attribute3%type,
148: p_interface_line_attribute4 IN
149: ra_customer_trx_lines.interface_line_attribute4%type,
150: p_interface_line_attribute5 IN
151: ra_customer_trx_lines.interface_line_attribute5%type,
152: p_interface_line_attribute6 IN
153: ra_customer_trx_lines.interface_line_attribute6%type,
154: p_interface_line_attribute7 IN
155: ra_customer_trx_lines.interface_line_attribute7%type,

Line 153: ra_customer_trx_lines.interface_line_attribute6%type,

149: ra_customer_trx_lines.interface_line_attribute4%type,
150: p_interface_line_attribute5 IN
151: ra_customer_trx_lines.interface_line_attribute5%type,
152: p_interface_line_attribute6 IN
153: ra_customer_trx_lines.interface_line_attribute6%type,
154: p_interface_line_attribute7 IN
155: ra_customer_trx_lines.interface_line_attribute7%type,
156: p_interface_line_attribute8 IN
157: ra_customer_trx_lines.interface_line_attribute8%type,

Line 155: ra_customer_trx_lines.interface_line_attribute7%type,

151: ra_customer_trx_lines.interface_line_attribute5%type,
152: p_interface_line_attribute6 IN
153: ra_customer_trx_lines.interface_line_attribute6%type,
154: p_interface_line_attribute7 IN
155: ra_customer_trx_lines.interface_line_attribute7%type,
156: p_interface_line_attribute8 IN
157: ra_customer_trx_lines.interface_line_attribute8%type,
158: p_interface_line_attribute9 IN
159: ra_customer_trx_lines.interface_line_attribute9%type,

Line 157: ra_customer_trx_lines.interface_line_attribute8%type,

153: ra_customer_trx_lines.interface_line_attribute6%type,
154: p_interface_line_attribute7 IN
155: ra_customer_trx_lines.interface_line_attribute7%type,
156: p_interface_line_attribute8 IN
157: ra_customer_trx_lines.interface_line_attribute8%type,
158: p_interface_line_attribute9 IN
159: ra_customer_trx_lines.interface_line_attribute9%type,
160: p_interface_line_attribute10 IN
161: ra_customer_trx_lines.interface_line_attribute10%type,

Line 159: ra_customer_trx_lines.interface_line_attribute9%type,

155: ra_customer_trx_lines.interface_line_attribute7%type,
156: p_interface_line_attribute8 IN
157: ra_customer_trx_lines.interface_line_attribute8%type,
158: p_interface_line_attribute9 IN
159: ra_customer_trx_lines.interface_line_attribute9%type,
160: p_interface_line_attribute10 IN
161: ra_customer_trx_lines.interface_line_attribute10%type,
162: p_interface_line_attribute11 IN
163: ra_customer_trx_lines.interface_line_attribute11%type,

Line 161: ra_customer_trx_lines.interface_line_attribute10%type,

157: ra_customer_trx_lines.interface_line_attribute8%type,
158: p_interface_line_attribute9 IN
159: ra_customer_trx_lines.interface_line_attribute9%type,
160: p_interface_line_attribute10 IN
161: ra_customer_trx_lines.interface_line_attribute10%type,
162: p_interface_line_attribute11 IN
163: ra_customer_trx_lines.interface_line_attribute11%type,
164: p_interface_line_attribute12 IN
165: ra_customer_trx_lines.interface_line_attribute12%type,

Line 163: ra_customer_trx_lines.interface_line_attribute11%type,

159: ra_customer_trx_lines.interface_line_attribute9%type,
160: p_interface_line_attribute10 IN
161: ra_customer_trx_lines.interface_line_attribute10%type,
162: p_interface_line_attribute11 IN
163: ra_customer_trx_lines.interface_line_attribute11%type,
164: p_interface_line_attribute12 IN
165: ra_customer_trx_lines.interface_line_attribute12%type,
166: p_interface_line_attribute13 IN
167: ra_customer_trx_lines.interface_line_attribute13%type,

Line 165: ra_customer_trx_lines.interface_line_attribute12%type,

161: ra_customer_trx_lines.interface_line_attribute10%type,
162: p_interface_line_attribute11 IN
163: ra_customer_trx_lines.interface_line_attribute11%type,
164: p_interface_line_attribute12 IN
165: ra_customer_trx_lines.interface_line_attribute12%type,
166: p_interface_line_attribute13 IN
167: ra_customer_trx_lines.interface_line_attribute13%type,
168: p_interface_line_attribute14 IN
169: ra_customer_trx_lines.interface_line_attribute14%type,

Line 167: ra_customer_trx_lines.interface_line_attribute13%type,

163: ra_customer_trx_lines.interface_line_attribute11%type,
164: p_interface_line_attribute12 IN
165: ra_customer_trx_lines.interface_line_attribute12%type,
166: p_interface_line_attribute13 IN
167: ra_customer_trx_lines.interface_line_attribute13%type,
168: p_interface_line_attribute14 IN
169: ra_customer_trx_lines.interface_line_attribute14%type,
170: p_interface_line_attribute15 IN
171: ra_customer_trx_lines.interface_line_attribute15%type,

Line 169: ra_customer_trx_lines.interface_line_attribute14%type,

165: ra_customer_trx_lines.interface_line_attribute12%type,
166: p_interface_line_attribute13 IN
167: ra_customer_trx_lines.interface_line_attribute13%type,
168: p_interface_line_attribute14 IN
169: ra_customer_trx_lines.interface_line_attribute14%type,
170: p_interface_line_attribute15 IN
171: ra_customer_trx_lines.interface_line_attribute15%type,
172: p_default_ussgl_code_context IN
173: ra_customer_trx_lines.default_ussgl_trx_code_context%type,

Line 171: ra_customer_trx_lines.interface_line_attribute15%type,

167: ra_customer_trx_lines.interface_line_attribute13%type,
168: p_interface_line_attribute14 IN
169: ra_customer_trx_lines.interface_line_attribute14%type,
170: p_interface_line_attribute15 IN
171: ra_customer_trx_lines.interface_line_attribute15%type,
172: p_default_ussgl_code_context IN
173: ra_customer_trx_lines.default_ussgl_trx_code_context%type,
174: p_default_ussgl_trx_code IN
175: ra_customer_trx_lines.default_ussgl_transaction_code%type)

Line 173: ra_customer_trx_lines.default_ussgl_trx_code_context%type,

169: ra_customer_trx_lines.interface_line_attribute14%type,
170: p_interface_line_attribute15 IN
171: ra_customer_trx_lines.interface_line_attribute15%type,
172: p_default_ussgl_code_context IN
173: ra_customer_trx_lines.default_ussgl_trx_code_context%type,
174: p_default_ussgl_trx_code IN
175: ra_customer_trx_lines.default_ussgl_transaction_code%type)
176: IS
177: l_frt_rec ra_customer_trx_lines%rowtype;

Line 175: ra_customer_trx_lines.default_ussgl_transaction_code%type)

171: ra_customer_trx_lines.interface_line_attribute15%type,
172: p_default_ussgl_code_context IN
173: ra_customer_trx_lines.default_ussgl_trx_code_context%type,
174: p_default_ussgl_trx_code IN
175: ra_customer_trx_lines.default_ussgl_transaction_code%type)
176: IS
177: l_frt_rec ra_customer_trx_lines%rowtype;
178: BEGIN
179:

Line 177: l_frt_rec ra_customer_trx_lines%rowtype;

173: ra_customer_trx_lines.default_ussgl_trx_code_context%type,
174: p_default_ussgl_trx_code IN
175: ra_customer_trx_lines.default_ussgl_transaction_code%type)
176: IS
177: l_frt_rec ra_customer_trx_lines%rowtype;
178: BEGIN
179:
180: arp_util.debug('arp_ctl_pkg.lock_compare_frt_cover()+');
181: