eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_GTA_ARTRX_PROC dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 88: --| ra_customer_trx_lines_all, Change Change

84: --| l_item_inventry_id is not null in the
85: --| procedure Retrieve_AR_TRXs for bug 5224923
86: --| 12/06/2006 Shujuan Yan Modify the procedure
87: --| Retrieve_AR_TRXs, Get line_number from
88: --| ra_customer_trx_lines_all, Change Change
89: --| the token value by "fnd_message.set_token
90: --| ('NUM', l_customer_trx_line_number)"
91: --| instead of "fnd_message.set_token('NUM',
92: --| l_customer_trx_line_id)" for bug 5230712

Line 2106: l_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;

2102: l_rac_bill_to_customer_name Hz_Parties.PARTY_NAME%TYPE;
2103: l_rac_bill_to_customer_num Hz_Cust_Accounts.ACCOUNT_NUMBER%TYPE;
2104: l_bill_to_taxpayer_id Hz_Parties.JGZZ_FISCAL_CODE%TYPE;
2105:
2106: l_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;
2107: l_description ra_customer_trx_lines_all.description%TYPE;
2108: l_inventory_item_id ra_customer_trx_lines_all.inventory_item_id%TYPE;
2109: l_interface_line_context ra_customer_trx_lines_all.interface_line_context%TYPE;
2110: l_uom_code ra_customer_trx_lines_all.uom_code%TYPE;

Line 2107: l_description ra_customer_trx_lines_all.description%TYPE;

2103: l_rac_bill_to_customer_num Hz_Cust_Accounts.ACCOUNT_NUMBER%TYPE;
2104: l_bill_to_taxpayer_id Hz_Parties.JGZZ_FISCAL_CODE%TYPE;
2105:
2106: l_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;
2107: l_description ra_customer_trx_lines_all.description%TYPE;
2108: l_inventory_item_id ra_customer_trx_lines_all.inventory_item_id%TYPE;
2109: l_interface_line_context ra_customer_trx_lines_all.interface_line_context%TYPE;
2110: l_uom_code ra_customer_trx_lines_all.uom_code%TYPE;
2111: l_unit_of_measure mtl_units_of_measure_vl.unit_of_measure%TYPE;

Line 2108: l_inventory_item_id ra_customer_trx_lines_all.inventory_item_id%TYPE;

2104: l_bill_to_taxpayer_id Hz_Parties.JGZZ_FISCAL_CODE%TYPE;
2105:
2106: l_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;
2107: l_description ra_customer_trx_lines_all.description%TYPE;
2108: l_inventory_item_id ra_customer_trx_lines_all.inventory_item_id%TYPE;
2109: l_interface_line_context ra_customer_trx_lines_all.interface_line_context%TYPE;
2110: l_uom_code ra_customer_trx_lines_all.uom_code%TYPE;
2111: l_unit_of_measure mtl_units_of_measure_vl.unit_of_measure%TYPE;
2112: l_quantity_credited ra_customer_trx_lines_all.quantity_credited%TYPE;

Line 2109: l_interface_line_context ra_customer_trx_lines_all.interface_line_context%TYPE;

2105:
2106: l_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;
2107: l_description ra_customer_trx_lines_all.description%TYPE;
2108: l_inventory_item_id ra_customer_trx_lines_all.inventory_item_id%TYPE;
2109: l_interface_line_context ra_customer_trx_lines_all.interface_line_context%TYPE;
2110: l_uom_code ra_customer_trx_lines_all.uom_code%TYPE;
2111: l_unit_of_measure mtl_units_of_measure_vl.unit_of_measure%TYPE;
2112: l_quantity_credited ra_customer_trx_lines_all.quantity_credited%TYPE;
2113:

Line 2110: l_uom_code ra_customer_trx_lines_all.uom_code%TYPE;

2106: l_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;
2107: l_description ra_customer_trx_lines_all.description%TYPE;
2108: l_inventory_item_id ra_customer_trx_lines_all.inventory_item_id%TYPE;
2109: l_interface_line_context ra_customer_trx_lines_all.interface_line_context%TYPE;
2110: l_uom_code ra_customer_trx_lines_all.uom_code%TYPE;
2111: l_unit_of_measure mtl_units_of_measure_vl.unit_of_measure%TYPE;
2112: l_quantity_credited ra_customer_trx_lines_all.quantity_credited%TYPE;
2113:
2114: --12/06/2006 Added a parameter to instore the transaction line number

Line 2112: l_quantity_credited ra_customer_trx_lines_all.quantity_credited%TYPE;

2108: l_inventory_item_id ra_customer_trx_lines_all.inventory_item_id%TYPE;
2109: l_interface_line_context ra_customer_trx_lines_all.interface_line_context%TYPE;
2110: l_uom_code ra_customer_trx_lines_all.uom_code%TYPE;
2111: l_unit_of_measure mtl_units_of_measure_vl.unit_of_measure%TYPE;
2112: l_quantity_credited ra_customer_trx_lines_all.quantity_credited%TYPE;
2113:
2114: --12/06/2006 Added a parameter to instore the transaction line number
2115: --by Shujuan Yan for bug 5230712
2116: l_customer_trx_line_number ra_customer_trx_lines_all.line_number%TYPE;

Line 2116: l_customer_trx_line_number ra_customer_trx_lines_all.line_number%TYPE;

2112: l_quantity_credited ra_customer_trx_lines_all.quantity_credited%TYPE;
2113:
2114: --12/06/2006 Added a parameter to instore the transaction line number
2115: --by Shujuan Yan for bug 5230712
2116: l_customer_trx_line_number ra_customer_trx_lines_all.line_number%TYPE;
2117:
2118: l_amount ra_customer_trx_lines_all.taxable_amount%TYPE;
2119:
2120: -- for get bank info by customer id

Line 2118: l_amount ra_customer_trx_lines_all.taxable_amount%TYPE;

2114: --12/06/2006 Added a parameter to instore the transaction line number
2115: --by Shujuan Yan for bug 5230712
2116: l_customer_trx_line_number ra_customer_trx_lines_all.line_number%TYPE;
2117:
2118: l_amount ra_customer_trx_lines_all.taxable_amount%TYPE;
2119:
2120: -- for get bank info by customer id
2121: l_site_use_id hz_cust_site_uses.SITE_USE_ID%TYPE;
2122: l_cust_acct_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;

Line 2167: l_order_number ra_customer_trx_lines_all.interface_line_attribute1%TYPE;

2163: l_discount_amount ar_gta_trx_lines_all.discount_amount%TYPE;
2164: l_discount_tax_amount ar_gta_trx_lines_all.discount_tax_amount%TYPE;
2165: l_discount_rate ar_gta_trx_lines_all.discount_rate%TYPE;
2166: l_discount_tax_rate ar_gta_trx_lines_all.discount_rate%TYPE;
2167: l_order_number ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2168: l_om_line_id ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2169: l_discount_adjustment_id ra_customer_trx_lines_all.interface_line_attribute11%TYPE;
2170: l_price_adjustment_id ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2171: l_adjustment_type OE_PRICE_ADJUSTMENTS.list_line_type_code%TYPE;

Line 2168: l_om_line_id ra_customer_trx_lines_all.interface_line_attribute1%TYPE;

2164: l_discount_tax_amount ar_gta_trx_lines_all.discount_tax_amount%TYPE;
2165: l_discount_rate ar_gta_trx_lines_all.discount_rate%TYPE;
2166: l_discount_tax_rate ar_gta_trx_lines_all.discount_rate%TYPE;
2167: l_order_number ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2168: l_om_line_id ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2169: l_discount_adjustment_id ra_customer_trx_lines_all.interface_line_attribute11%TYPE;
2170: l_price_adjustment_id ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2171: l_adjustment_type OE_PRICE_ADJUSTMENTS.list_line_type_code%TYPE;
2172: l_discount_cust_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;

Line 2169: l_discount_adjustment_id ra_customer_trx_lines_all.interface_line_attribute11%TYPE;

2165: l_discount_rate ar_gta_trx_lines_all.discount_rate%TYPE;
2166: l_discount_tax_rate ar_gta_trx_lines_all.discount_rate%TYPE;
2167: l_order_number ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2168: l_om_line_id ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2169: l_discount_adjustment_id ra_customer_trx_lines_all.interface_line_attribute11%TYPE;
2170: l_price_adjustment_id ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2171: l_adjustment_type OE_PRICE_ADJUSTMENTS.list_line_type_code%TYPE;
2172: l_discount_cust_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;
2173: l_discount_flag ar_gta_trx_lines_all.discount_flag%TYPE;

Line 2170: l_price_adjustment_id ra_customer_trx_lines_all.interface_line_attribute1%TYPE;

2166: l_discount_tax_rate ar_gta_trx_lines_all.discount_rate%TYPE;
2167: l_order_number ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2168: l_om_line_id ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2169: l_discount_adjustment_id ra_customer_trx_lines_all.interface_line_attribute11%TYPE;
2170: l_price_adjustment_id ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2171: l_adjustment_type OE_PRICE_ADJUSTMENTS.list_line_type_code%TYPE;
2172: l_discount_cust_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;
2173: l_discount_flag ar_gta_trx_lines_all.discount_flag%TYPE;
2174: l_tax_amount ar_gta_trx_lines_all.tax_amount%TYPE;

Line 2172: l_discount_cust_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;

2168: l_om_line_id ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2169: l_discount_adjustment_id ra_customer_trx_lines_all.interface_line_attribute11%TYPE;
2170: l_price_adjustment_id ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2171: l_adjustment_type OE_PRICE_ADJUSTMENTS.list_line_type_code%TYPE;
2172: l_discount_cust_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;
2173: l_discount_flag ar_gta_trx_lines_all.discount_flag%TYPE;
2174: l_tax_amount ar_gta_trx_lines_all.tax_amount%TYPE;
2175: l_discount_amount_func_curr ar_gta_trx_lines_all.discount_amount%TYPE; --Yao add for bug#9132371
2176: -- Yao Modified for bug#8605196 to support discount line

Line 2180: l_attribute_category ra_customer_trx_lines_all.attribute_category%TYPE; --Add for bug 13367415

2176: -- Yao Modified for bug#8605196 to support discount line
2177: l_actual_unit_price NUMBER; --yao add for bug 9045187
2178: l_discount_on_invoice VARCHAR2(1); --Yao add for bug#9830678
2179:
2180: l_attribute_category ra_customer_trx_lines_all.attribute_category%TYPE; --Add for bug 13367415
2181:
2182: CURSOR c_ra_lines(l_header_id IN NUMBER) IS
2183: SELECT l.customer_trx_line_id,
2184: l.description,

Line 2199: FROM ra_customer_trx_lines_all l

2195: l.interface_line_attribute1, --order number
2196: l.interface_line_attribute6, --line id
2197: l.interface_line_attribute11 --price adjustment id
2198: --Add by Yao Zhang end for bug#8605196 to support Discount line
2199: FROM ra_customer_trx_lines_all l
2200: WHERE l.line_type = 'LINE'
2201: AND l.customer_trx_id = l_header_id;
2202: --Yao Zhang Add for bug#8605196 to support discount line
2203: --c_discount_lines used to query discount lines for ar transaction line.

Line 2451: FROM ra_customer_trx_lines_all l

2447: END IF;
2448:
2449: SELECT COUNT(*)
2450: INTO l_trx_line_num
2451: FROM ra_customer_trx_lines_all l
2452: WHERE l.customer_trx_id = l_customer_trx_id;
2453:
2454: IF l_trx_line_num = 0 THEN
2455: RAISE l_repeat_exception;

Line 2941: FROM ra_customer_trx_lines_all rctl, zx_lines tax

2937: rctl.customer_trx_line_id
2938: INTO l_discount_amount,
2939: l_discount_amount_func_curr,
2940: l_discount_cust_trx_line_id
2941: FROM ra_customer_trx_lines_all rctl, zx_lines tax
2942: WHERE rctl.customer_trx_id = l_customer_trx_id
2943: AND rctl.line_type = 'LINE'
2944: AND rctl.interface_line_attribute11 =
2945: l_discount_adjustment_id

Line 4076: -- the quantity stored in different column of ra_customer_trx_lines_all.

4072: 'get_inventory_item_number end ');
4073: END IF;
4074: -- end log
4075:
4076: -- the quantity stored in different column of ra_customer_trx_lines_all.
4077: IF l_ctt_class = 'CM' THEN
4078: l_trx_line.quantity := l_quantity_credited;
4079: ELSE
4080: l_trx_line.quantity := l_quantity_invoiced;

Line 4565: l_attribute1 ra_customer_trx_lines_all.Interface_Line_Attribute1%TYPE;

4561: l_procedure_name VARCHAR2(50) := 'get_ra_item_model';
4562:
4563:
4564: /* Bug 13367415. Replace the Interface Line Attribute with the Attribute/Global Attribute
4565: l_attribute1 ra_customer_trx_lines_all.Interface_Line_Attribute1%TYPE;
4566: l_attribute2 ra_customer_trx_lines_all.Interface_Line_Attribute2%TYPE;
4567: l_attribute3 ra_customer_trx_lines_all.Interface_Line_Attribute3%TYPE;
4568: l_attribute4 ra_customer_trx_lines_all.Interface_Line_Attribute4%TYPE;
4569: l_attribute5 ra_customer_trx_lines_all.Interface_Line_Attribute5%TYPE;

Line 4566: l_attribute2 ra_customer_trx_lines_all.Interface_Line_Attribute2%TYPE;

4562:
4563:
4564: /* Bug 13367415. Replace the Interface Line Attribute with the Attribute/Global Attribute
4565: l_attribute1 ra_customer_trx_lines_all.Interface_Line_Attribute1%TYPE;
4566: l_attribute2 ra_customer_trx_lines_all.Interface_Line_Attribute2%TYPE;
4567: l_attribute3 ra_customer_trx_lines_all.Interface_Line_Attribute3%TYPE;
4568: l_attribute4 ra_customer_trx_lines_all.Interface_Line_Attribute4%TYPE;
4569: l_attribute5 ra_customer_trx_lines_all.Interface_Line_Attribute5%TYPE;
4570: l_attribute6 ra_customer_trx_lines_all.Interface_Line_Attribute6%TYPE;

Line 4567: l_attribute3 ra_customer_trx_lines_all.Interface_Line_Attribute3%TYPE;

4563:
4564: /* Bug 13367415. Replace the Interface Line Attribute with the Attribute/Global Attribute
4565: l_attribute1 ra_customer_trx_lines_all.Interface_Line_Attribute1%TYPE;
4566: l_attribute2 ra_customer_trx_lines_all.Interface_Line_Attribute2%TYPE;
4567: l_attribute3 ra_customer_trx_lines_all.Interface_Line_Attribute3%TYPE;
4568: l_attribute4 ra_customer_trx_lines_all.Interface_Line_Attribute4%TYPE;
4569: l_attribute5 ra_customer_trx_lines_all.Interface_Line_Attribute5%TYPE;
4570: l_attribute6 ra_customer_trx_lines_all.Interface_Line_Attribute6%TYPE;
4571: l_attribute7 ra_customer_trx_lines_all.Interface_Line_Attribute7%TYPE;

Line 4568: l_attribute4 ra_customer_trx_lines_all.Interface_Line_Attribute4%TYPE;

4564: /* Bug 13367415. Replace the Interface Line Attribute with the Attribute/Global Attribute
4565: l_attribute1 ra_customer_trx_lines_all.Interface_Line_Attribute1%TYPE;
4566: l_attribute2 ra_customer_trx_lines_all.Interface_Line_Attribute2%TYPE;
4567: l_attribute3 ra_customer_trx_lines_all.Interface_Line_Attribute3%TYPE;
4568: l_attribute4 ra_customer_trx_lines_all.Interface_Line_Attribute4%TYPE;
4569: l_attribute5 ra_customer_trx_lines_all.Interface_Line_Attribute5%TYPE;
4570: l_attribute6 ra_customer_trx_lines_all.Interface_Line_Attribute6%TYPE;
4571: l_attribute7 ra_customer_trx_lines_all.Interface_Line_Attribute7%TYPE;
4572: l_attribute8 ra_customer_trx_lines_all.Interface_Line_Attribute8%TYPE;

Line 4569: l_attribute5 ra_customer_trx_lines_all.Interface_Line_Attribute5%TYPE;

4565: l_attribute1 ra_customer_trx_lines_all.Interface_Line_Attribute1%TYPE;
4566: l_attribute2 ra_customer_trx_lines_all.Interface_Line_Attribute2%TYPE;
4567: l_attribute3 ra_customer_trx_lines_all.Interface_Line_Attribute3%TYPE;
4568: l_attribute4 ra_customer_trx_lines_all.Interface_Line_Attribute4%TYPE;
4569: l_attribute5 ra_customer_trx_lines_all.Interface_Line_Attribute5%TYPE;
4570: l_attribute6 ra_customer_trx_lines_all.Interface_Line_Attribute6%TYPE;
4571: l_attribute7 ra_customer_trx_lines_all.Interface_Line_Attribute7%TYPE;
4572: l_attribute8 ra_customer_trx_lines_all.Interface_Line_Attribute8%TYPE;
4573: l_attribute9 ra_customer_trx_lines_all.Interface_Line_Attribute9%TYPE;

Line 4570: l_attribute6 ra_customer_trx_lines_all.Interface_Line_Attribute6%TYPE;

4566: l_attribute2 ra_customer_trx_lines_all.Interface_Line_Attribute2%TYPE;
4567: l_attribute3 ra_customer_trx_lines_all.Interface_Line_Attribute3%TYPE;
4568: l_attribute4 ra_customer_trx_lines_all.Interface_Line_Attribute4%TYPE;
4569: l_attribute5 ra_customer_trx_lines_all.Interface_Line_Attribute5%TYPE;
4570: l_attribute6 ra_customer_trx_lines_all.Interface_Line_Attribute6%TYPE;
4571: l_attribute7 ra_customer_trx_lines_all.Interface_Line_Attribute7%TYPE;
4572: l_attribute8 ra_customer_trx_lines_all.Interface_Line_Attribute8%TYPE;
4573: l_attribute9 ra_customer_trx_lines_all.Interface_Line_Attribute9%TYPE;
4574: l_attribute10 ra_customer_trx_lines_all.Interface_Line_Attribute10%TYPE;

Line 4571: l_attribute7 ra_customer_trx_lines_all.Interface_Line_Attribute7%TYPE;

4567: l_attribute3 ra_customer_trx_lines_all.Interface_Line_Attribute3%TYPE;
4568: l_attribute4 ra_customer_trx_lines_all.Interface_Line_Attribute4%TYPE;
4569: l_attribute5 ra_customer_trx_lines_all.Interface_Line_Attribute5%TYPE;
4570: l_attribute6 ra_customer_trx_lines_all.Interface_Line_Attribute6%TYPE;
4571: l_attribute7 ra_customer_trx_lines_all.Interface_Line_Attribute7%TYPE;
4572: l_attribute8 ra_customer_trx_lines_all.Interface_Line_Attribute8%TYPE;
4573: l_attribute9 ra_customer_trx_lines_all.Interface_Line_Attribute9%TYPE;
4574: l_attribute10 ra_customer_trx_lines_all.Interface_Line_Attribute10%TYPE;
4575: l_attribute11 ra_customer_trx_lines_all.Interface_Line_Attribute11%TYPE;

Line 4572: l_attribute8 ra_customer_trx_lines_all.Interface_Line_Attribute8%TYPE;

4568: l_attribute4 ra_customer_trx_lines_all.Interface_Line_Attribute4%TYPE;
4569: l_attribute5 ra_customer_trx_lines_all.Interface_Line_Attribute5%TYPE;
4570: l_attribute6 ra_customer_trx_lines_all.Interface_Line_Attribute6%TYPE;
4571: l_attribute7 ra_customer_trx_lines_all.Interface_Line_Attribute7%TYPE;
4572: l_attribute8 ra_customer_trx_lines_all.Interface_Line_Attribute8%TYPE;
4573: l_attribute9 ra_customer_trx_lines_all.Interface_Line_Attribute9%TYPE;
4574: l_attribute10 ra_customer_trx_lines_all.Interface_Line_Attribute10%TYPE;
4575: l_attribute11 ra_customer_trx_lines_all.Interface_Line_Attribute11%TYPE;
4576: l_attribute12 ra_customer_trx_lines_all.Interface_Line_Attribute12%TYPE;

Line 4573: l_attribute9 ra_customer_trx_lines_all.Interface_Line_Attribute9%TYPE;

4569: l_attribute5 ra_customer_trx_lines_all.Interface_Line_Attribute5%TYPE;
4570: l_attribute6 ra_customer_trx_lines_all.Interface_Line_Attribute6%TYPE;
4571: l_attribute7 ra_customer_trx_lines_all.Interface_Line_Attribute7%TYPE;
4572: l_attribute8 ra_customer_trx_lines_all.Interface_Line_Attribute8%TYPE;
4573: l_attribute9 ra_customer_trx_lines_all.Interface_Line_Attribute9%TYPE;
4574: l_attribute10 ra_customer_trx_lines_all.Interface_Line_Attribute10%TYPE;
4575: l_attribute11 ra_customer_trx_lines_all.Interface_Line_Attribute11%TYPE;
4576: l_attribute12 ra_customer_trx_lines_all.Interface_Line_Attribute12%TYPE;
4577: l_attribute13 ra_customer_trx_lines_all.Interface_Line_Attribute13%TYPE;

Line 4574: l_attribute10 ra_customer_trx_lines_all.Interface_Line_Attribute10%TYPE;

4570: l_attribute6 ra_customer_trx_lines_all.Interface_Line_Attribute6%TYPE;
4571: l_attribute7 ra_customer_trx_lines_all.Interface_Line_Attribute7%TYPE;
4572: l_attribute8 ra_customer_trx_lines_all.Interface_Line_Attribute8%TYPE;
4573: l_attribute9 ra_customer_trx_lines_all.Interface_Line_Attribute9%TYPE;
4574: l_attribute10 ra_customer_trx_lines_all.Interface_Line_Attribute10%TYPE;
4575: l_attribute11 ra_customer_trx_lines_all.Interface_Line_Attribute11%TYPE;
4576: l_attribute12 ra_customer_trx_lines_all.Interface_Line_Attribute12%TYPE;
4577: l_attribute13 ra_customer_trx_lines_all.Interface_Line_Attribute13%TYPE;
4578: l_attribute14 ra_customer_trx_lines_all.Interface_Line_Attribute14%TYPE;

Line 4575: l_attribute11 ra_customer_trx_lines_all.Interface_Line_Attribute11%TYPE;

4571: l_attribute7 ra_customer_trx_lines_all.Interface_Line_Attribute7%TYPE;
4572: l_attribute8 ra_customer_trx_lines_all.Interface_Line_Attribute8%TYPE;
4573: l_attribute9 ra_customer_trx_lines_all.Interface_Line_Attribute9%TYPE;
4574: l_attribute10 ra_customer_trx_lines_all.Interface_Line_Attribute10%TYPE;
4575: l_attribute11 ra_customer_trx_lines_all.Interface_Line_Attribute11%TYPE;
4576: l_attribute12 ra_customer_trx_lines_all.Interface_Line_Attribute12%TYPE;
4577: l_attribute13 ra_customer_trx_lines_all.Interface_Line_Attribute13%TYPE;
4578: l_attribute14 ra_customer_trx_lines_all.Interface_Line_Attribute14%TYPE;
4579: l_attribute15 ra_customer_trx_lines_all.Interface_Line_Attribute15%TYPE;*/

Line 4576: l_attribute12 ra_customer_trx_lines_all.Interface_Line_Attribute12%TYPE;

4572: l_attribute8 ra_customer_trx_lines_all.Interface_Line_Attribute8%TYPE;
4573: l_attribute9 ra_customer_trx_lines_all.Interface_Line_Attribute9%TYPE;
4574: l_attribute10 ra_customer_trx_lines_all.Interface_Line_Attribute10%TYPE;
4575: l_attribute11 ra_customer_trx_lines_all.Interface_Line_Attribute11%TYPE;
4576: l_attribute12 ra_customer_trx_lines_all.Interface_Line_Attribute12%TYPE;
4577: l_attribute13 ra_customer_trx_lines_all.Interface_Line_Attribute13%TYPE;
4578: l_attribute14 ra_customer_trx_lines_all.Interface_Line_Attribute14%TYPE;
4579: l_attribute15 ra_customer_trx_lines_all.Interface_Line_Attribute15%TYPE;*/
4580: l_attribute1 ra_customer_trx_lines_all.attribute1%TYPE;

Line 4577: l_attribute13 ra_customer_trx_lines_all.Interface_Line_Attribute13%TYPE;

4573: l_attribute9 ra_customer_trx_lines_all.Interface_Line_Attribute9%TYPE;
4574: l_attribute10 ra_customer_trx_lines_all.Interface_Line_Attribute10%TYPE;
4575: l_attribute11 ra_customer_trx_lines_all.Interface_Line_Attribute11%TYPE;
4576: l_attribute12 ra_customer_trx_lines_all.Interface_Line_Attribute12%TYPE;
4577: l_attribute13 ra_customer_trx_lines_all.Interface_Line_Attribute13%TYPE;
4578: l_attribute14 ra_customer_trx_lines_all.Interface_Line_Attribute14%TYPE;
4579: l_attribute15 ra_customer_trx_lines_all.Interface_Line_Attribute15%TYPE;*/
4580: l_attribute1 ra_customer_trx_lines_all.attribute1%TYPE;
4581: l_attribute2 ra_customer_trx_lines_all.attribute2%TYPE;

Line 4578: l_attribute14 ra_customer_trx_lines_all.Interface_Line_Attribute14%TYPE;

4574: l_attribute10 ra_customer_trx_lines_all.Interface_Line_Attribute10%TYPE;
4575: l_attribute11 ra_customer_trx_lines_all.Interface_Line_Attribute11%TYPE;
4576: l_attribute12 ra_customer_trx_lines_all.Interface_Line_Attribute12%TYPE;
4577: l_attribute13 ra_customer_trx_lines_all.Interface_Line_Attribute13%TYPE;
4578: l_attribute14 ra_customer_trx_lines_all.Interface_Line_Attribute14%TYPE;
4579: l_attribute15 ra_customer_trx_lines_all.Interface_Line_Attribute15%TYPE;*/
4580: l_attribute1 ra_customer_trx_lines_all.attribute1%TYPE;
4581: l_attribute2 ra_customer_trx_lines_all.attribute2%TYPE;
4582: l_attribute3 ra_customer_trx_lines_all.attribute3%TYPE;

Line 4579: l_attribute15 ra_customer_trx_lines_all.Interface_Line_Attribute15%TYPE;*/

4575: l_attribute11 ra_customer_trx_lines_all.Interface_Line_Attribute11%TYPE;
4576: l_attribute12 ra_customer_trx_lines_all.Interface_Line_Attribute12%TYPE;
4577: l_attribute13 ra_customer_trx_lines_all.Interface_Line_Attribute13%TYPE;
4578: l_attribute14 ra_customer_trx_lines_all.Interface_Line_Attribute14%TYPE;
4579: l_attribute15 ra_customer_trx_lines_all.Interface_Line_Attribute15%TYPE;*/
4580: l_attribute1 ra_customer_trx_lines_all.attribute1%TYPE;
4581: l_attribute2 ra_customer_trx_lines_all.attribute2%TYPE;
4582: l_attribute3 ra_customer_trx_lines_all.attribute3%TYPE;
4583: l_attribute4 ra_customer_trx_lines_all.attribute4%TYPE;

Line 4580: l_attribute1 ra_customer_trx_lines_all.attribute1%TYPE;

4576: l_attribute12 ra_customer_trx_lines_all.Interface_Line_Attribute12%TYPE;
4577: l_attribute13 ra_customer_trx_lines_all.Interface_Line_Attribute13%TYPE;
4578: l_attribute14 ra_customer_trx_lines_all.Interface_Line_Attribute14%TYPE;
4579: l_attribute15 ra_customer_trx_lines_all.Interface_Line_Attribute15%TYPE;*/
4580: l_attribute1 ra_customer_trx_lines_all.attribute1%TYPE;
4581: l_attribute2 ra_customer_trx_lines_all.attribute2%TYPE;
4582: l_attribute3 ra_customer_trx_lines_all.attribute3%TYPE;
4583: l_attribute4 ra_customer_trx_lines_all.attribute4%TYPE;
4584: l_attribute5 ra_customer_trx_lines_all.attribute5%TYPE;

Line 4581: l_attribute2 ra_customer_trx_lines_all.attribute2%TYPE;

4577: l_attribute13 ra_customer_trx_lines_all.Interface_Line_Attribute13%TYPE;
4578: l_attribute14 ra_customer_trx_lines_all.Interface_Line_Attribute14%TYPE;
4579: l_attribute15 ra_customer_trx_lines_all.Interface_Line_Attribute15%TYPE;*/
4580: l_attribute1 ra_customer_trx_lines_all.attribute1%TYPE;
4581: l_attribute2 ra_customer_trx_lines_all.attribute2%TYPE;
4582: l_attribute3 ra_customer_trx_lines_all.attribute3%TYPE;
4583: l_attribute4 ra_customer_trx_lines_all.attribute4%TYPE;
4584: l_attribute5 ra_customer_trx_lines_all.attribute5%TYPE;
4585: l_attribute6 ra_customer_trx_lines_all.attribute6%TYPE;

Line 4582: l_attribute3 ra_customer_trx_lines_all.attribute3%TYPE;

4578: l_attribute14 ra_customer_trx_lines_all.Interface_Line_Attribute14%TYPE;
4579: l_attribute15 ra_customer_trx_lines_all.Interface_Line_Attribute15%TYPE;*/
4580: l_attribute1 ra_customer_trx_lines_all.attribute1%TYPE;
4581: l_attribute2 ra_customer_trx_lines_all.attribute2%TYPE;
4582: l_attribute3 ra_customer_trx_lines_all.attribute3%TYPE;
4583: l_attribute4 ra_customer_trx_lines_all.attribute4%TYPE;
4584: l_attribute5 ra_customer_trx_lines_all.attribute5%TYPE;
4585: l_attribute6 ra_customer_trx_lines_all.attribute6%TYPE;
4586: l_attribute7 ra_customer_trx_lines_all.attribute7%TYPE;

Line 4583: l_attribute4 ra_customer_trx_lines_all.attribute4%TYPE;

4579: l_attribute15 ra_customer_trx_lines_all.Interface_Line_Attribute15%TYPE;*/
4580: l_attribute1 ra_customer_trx_lines_all.attribute1%TYPE;
4581: l_attribute2 ra_customer_trx_lines_all.attribute2%TYPE;
4582: l_attribute3 ra_customer_trx_lines_all.attribute3%TYPE;
4583: l_attribute4 ra_customer_trx_lines_all.attribute4%TYPE;
4584: l_attribute5 ra_customer_trx_lines_all.attribute5%TYPE;
4585: l_attribute6 ra_customer_trx_lines_all.attribute6%TYPE;
4586: l_attribute7 ra_customer_trx_lines_all.attribute7%TYPE;
4587: l_attribute8 ra_customer_trx_lines_all.attribute8%TYPE;

Line 4584: l_attribute5 ra_customer_trx_lines_all.attribute5%TYPE;

4580: l_attribute1 ra_customer_trx_lines_all.attribute1%TYPE;
4581: l_attribute2 ra_customer_trx_lines_all.attribute2%TYPE;
4582: l_attribute3 ra_customer_trx_lines_all.attribute3%TYPE;
4583: l_attribute4 ra_customer_trx_lines_all.attribute4%TYPE;
4584: l_attribute5 ra_customer_trx_lines_all.attribute5%TYPE;
4585: l_attribute6 ra_customer_trx_lines_all.attribute6%TYPE;
4586: l_attribute7 ra_customer_trx_lines_all.attribute7%TYPE;
4587: l_attribute8 ra_customer_trx_lines_all.attribute8%TYPE;
4588: l_attribute9 ra_customer_trx_lines_all.attribute9%TYPE;

Line 4585: l_attribute6 ra_customer_trx_lines_all.attribute6%TYPE;

4581: l_attribute2 ra_customer_trx_lines_all.attribute2%TYPE;
4582: l_attribute3 ra_customer_trx_lines_all.attribute3%TYPE;
4583: l_attribute4 ra_customer_trx_lines_all.attribute4%TYPE;
4584: l_attribute5 ra_customer_trx_lines_all.attribute5%TYPE;
4585: l_attribute6 ra_customer_trx_lines_all.attribute6%TYPE;
4586: l_attribute7 ra_customer_trx_lines_all.attribute7%TYPE;
4587: l_attribute8 ra_customer_trx_lines_all.attribute8%TYPE;
4588: l_attribute9 ra_customer_trx_lines_all.attribute9%TYPE;
4589: l_attribute10 ra_customer_trx_lines_all.attribute10%TYPE;

Line 4586: l_attribute7 ra_customer_trx_lines_all.attribute7%TYPE;

4582: l_attribute3 ra_customer_trx_lines_all.attribute3%TYPE;
4583: l_attribute4 ra_customer_trx_lines_all.attribute4%TYPE;
4584: l_attribute5 ra_customer_trx_lines_all.attribute5%TYPE;
4585: l_attribute6 ra_customer_trx_lines_all.attribute6%TYPE;
4586: l_attribute7 ra_customer_trx_lines_all.attribute7%TYPE;
4587: l_attribute8 ra_customer_trx_lines_all.attribute8%TYPE;
4588: l_attribute9 ra_customer_trx_lines_all.attribute9%TYPE;
4589: l_attribute10 ra_customer_trx_lines_all.attribute10%TYPE;
4590: l_attribute11 ra_customer_trx_lines_all.attribute11%TYPE;

Line 4587: l_attribute8 ra_customer_trx_lines_all.attribute8%TYPE;

4583: l_attribute4 ra_customer_trx_lines_all.attribute4%TYPE;
4584: l_attribute5 ra_customer_trx_lines_all.attribute5%TYPE;
4585: l_attribute6 ra_customer_trx_lines_all.attribute6%TYPE;
4586: l_attribute7 ra_customer_trx_lines_all.attribute7%TYPE;
4587: l_attribute8 ra_customer_trx_lines_all.attribute8%TYPE;
4588: l_attribute9 ra_customer_trx_lines_all.attribute9%TYPE;
4589: l_attribute10 ra_customer_trx_lines_all.attribute10%TYPE;
4590: l_attribute11 ra_customer_trx_lines_all.attribute11%TYPE;
4591: l_attribute12 ra_customer_trx_lines_all.attribute12%TYPE;

Line 4588: l_attribute9 ra_customer_trx_lines_all.attribute9%TYPE;

4584: l_attribute5 ra_customer_trx_lines_all.attribute5%TYPE;
4585: l_attribute6 ra_customer_trx_lines_all.attribute6%TYPE;
4586: l_attribute7 ra_customer_trx_lines_all.attribute7%TYPE;
4587: l_attribute8 ra_customer_trx_lines_all.attribute8%TYPE;
4588: l_attribute9 ra_customer_trx_lines_all.attribute9%TYPE;
4589: l_attribute10 ra_customer_trx_lines_all.attribute10%TYPE;
4590: l_attribute11 ra_customer_trx_lines_all.attribute11%TYPE;
4591: l_attribute12 ra_customer_trx_lines_all.attribute12%TYPE;
4592: l_attribute13 ra_customer_trx_lines_all.attribute13%TYPE;

Line 4589: l_attribute10 ra_customer_trx_lines_all.attribute10%TYPE;

4585: l_attribute6 ra_customer_trx_lines_all.attribute6%TYPE;
4586: l_attribute7 ra_customer_trx_lines_all.attribute7%TYPE;
4587: l_attribute8 ra_customer_trx_lines_all.attribute8%TYPE;
4588: l_attribute9 ra_customer_trx_lines_all.attribute9%TYPE;
4589: l_attribute10 ra_customer_trx_lines_all.attribute10%TYPE;
4590: l_attribute11 ra_customer_trx_lines_all.attribute11%TYPE;
4591: l_attribute12 ra_customer_trx_lines_all.attribute12%TYPE;
4592: l_attribute13 ra_customer_trx_lines_all.attribute13%TYPE;
4593: l_attribute14 ra_customer_trx_lines_all.attribute14%TYPE;

Line 4590: l_attribute11 ra_customer_trx_lines_all.attribute11%TYPE;

4586: l_attribute7 ra_customer_trx_lines_all.attribute7%TYPE;
4587: l_attribute8 ra_customer_trx_lines_all.attribute8%TYPE;
4588: l_attribute9 ra_customer_trx_lines_all.attribute9%TYPE;
4589: l_attribute10 ra_customer_trx_lines_all.attribute10%TYPE;
4590: l_attribute11 ra_customer_trx_lines_all.attribute11%TYPE;
4591: l_attribute12 ra_customer_trx_lines_all.attribute12%TYPE;
4592: l_attribute13 ra_customer_trx_lines_all.attribute13%TYPE;
4593: l_attribute14 ra_customer_trx_lines_all.attribute14%TYPE;
4594: l_attribute15 ra_customer_trx_lines_all.attribute15%TYPE;

Line 4591: l_attribute12 ra_customer_trx_lines_all.attribute12%TYPE;

4587: l_attribute8 ra_customer_trx_lines_all.attribute8%TYPE;
4588: l_attribute9 ra_customer_trx_lines_all.attribute9%TYPE;
4589: l_attribute10 ra_customer_trx_lines_all.attribute10%TYPE;
4590: l_attribute11 ra_customer_trx_lines_all.attribute11%TYPE;
4591: l_attribute12 ra_customer_trx_lines_all.attribute12%TYPE;
4592: l_attribute13 ra_customer_trx_lines_all.attribute13%TYPE;
4593: l_attribute14 ra_customer_trx_lines_all.attribute14%TYPE;
4594: l_attribute15 ra_customer_trx_lines_all.attribute15%TYPE;
4595:

Line 4592: l_attribute13 ra_customer_trx_lines_all.attribute13%TYPE;

4588: l_attribute9 ra_customer_trx_lines_all.attribute9%TYPE;
4589: l_attribute10 ra_customer_trx_lines_all.attribute10%TYPE;
4590: l_attribute11 ra_customer_trx_lines_all.attribute11%TYPE;
4591: l_attribute12 ra_customer_trx_lines_all.attribute12%TYPE;
4592: l_attribute13 ra_customer_trx_lines_all.attribute13%TYPE;
4593: l_attribute14 ra_customer_trx_lines_all.attribute14%TYPE;
4594: l_attribute15 ra_customer_trx_lines_all.attribute15%TYPE;
4595:
4596: l_global_attribute1 ra_customer_trx_lines_all.global_attribute1%TYPE;

Line 4593: l_attribute14 ra_customer_trx_lines_all.attribute14%TYPE;

4589: l_attribute10 ra_customer_trx_lines_all.attribute10%TYPE;
4590: l_attribute11 ra_customer_trx_lines_all.attribute11%TYPE;
4591: l_attribute12 ra_customer_trx_lines_all.attribute12%TYPE;
4592: l_attribute13 ra_customer_trx_lines_all.attribute13%TYPE;
4593: l_attribute14 ra_customer_trx_lines_all.attribute14%TYPE;
4594: l_attribute15 ra_customer_trx_lines_all.attribute15%TYPE;
4595:
4596: l_global_attribute1 ra_customer_trx_lines_all.global_attribute1%TYPE;
4597: l_global_attribute2 ra_customer_trx_lines_all.global_attribute2%TYPE;

Line 4594: l_attribute15 ra_customer_trx_lines_all.attribute15%TYPE;

4590: l_attribute11 ra_customer_trx_lines_all.attribute11%TYPE;
4591: l_attribute12 ra_customer_trx_lines_all.attribute12%TYPE;
4592: l_attribute13 ra_customer_trx_lines_all.attribute13%TYPE;
4593: l_attribute14 ra_customer_trx_lines_all.attribute14%TYPE;
4594: l_attribute15 ra_customer_trx_lines_all.attribute15%TYPE;
4595:
4596: l_global_attribute1 ra_customer_trx_lines_all.global_attribute1%TYPE;
4597: l_global_attribute2 ra_customer_trx_lines_all.global_attribute2%TYPE;
4598: l_global_attribute3 ra_customer_trx_lines_all.global_attribute3%TYPE;

Line 4596: l_global_attribute1 ra_customer_trx_lines_all.global_attribute1%TYPE;

4592: l_attribute13 ra_customer_trx_lines_all.attribute13%TYPE;
4593: l_attribute14 ra_customer_trx_lines_all.attribute14%TYPE;
4594: l_attribute15 ra_customer_trx_lines_all.attribute15%TYPE;
4595:
4596: l_global_attribute1 ra_customer_trx_lines_all.global_attribute1%TYPE;
4597: l_global_attribute2 ra_customer_trx_lines_all.global_attribute2%TYPE;
4598: l_global_attribute3 ra_customer_trx_lines_all.global_attribute3%TYPE;
4599: l_global_attribute4 ra_customer_trx_lines_all.global_attribute4%TYPE;
4600: l_global_attribute5 ra_customer_trx_lines_all.global_attribute5%TYPE;

Line 4597: l_global_attribute2 ra_customer_trx_lines_all.global_attribute2%TYPE;

4593: l_attribute14 ra_customer_trx_lines_all.attribute14%TYPE;
4594: l_attribute15 ra_customer_trx_lines_all.attribute15%TYPE;
4595:
4596: l_global_attribute1 ra_customer_trx_lines_all.global_attribute1%TYPE;
4597: l_global_attribute2 ra_customer_trx_lines_all.global_attribute2%TYPE;
4598: l_global_attribute3 ra_customer_trx_lines_all.global_attribute3%TYPE;
4599: l_global_attribute4 ra_customer_trx_lines_all.global_attribute4%TYPE;
4600: l_global_attribute5 ra_customer_trx_lines_all.global_attribute5%TYPE;
4601: l_global_attribute6 ra_customer_trx_lines_all.global_attribute6%TYPE;

Line 4598: l_global_attribute3 ra_customer_trx_lines_all.global_attribute3%TYPE;

4594: l_attribute15 ra_customer_trx_lines_all.attribute15%TYPE;
4595:
4596: l_global_attribute1 ra_customer_trx_lines_all.global_attribute1%TYPE;
4597: l_global_attribute2 ra_customer_trx_lines_all.global_attribute2%TYPE;
4598: l_global_attribute3 ra_customer_trx_lines_all.global_attribute3%TYPE;
4599: l_global_attribute4 ra_customer_trx_lines_all.global_attribute4%TYPE;
4600: l_global_attribute5 ra_customer_trx_lines_all.global_attribute5%TYPE;
4601: l_global_attribute6 ra_customer_trx_lines_all.global_attribute6%TYPE;
4602: l_global_attribute7 ra_customer_trx_lines_all.global_attribute7%TYPE;

Line 4599: l_global_attribute4 ra_customer_trx_lines_all.global_attribute4%TYPE;

4595:
4596: l_global_attribute1 ra_customer_trx_lines_all.global_attribute1%TYPE;
4597: l_global_attribute2 ra_customer_trx_lines_all.global_attribute2%TYPE;
4598: l_global_attribute3 ra_customer_trx_lines_all.global_attribute3%TYPE;
4599: l_global_attribute4 ra_customer_trx_lines_all.global_attribute4%TYPE;
4600: l_global_attribute5 ra_customer_trx_lines_all.global_attribute5%TYPE;
4601: l_global_attribute6 ra_customer_trx_lines_all.global_attribute6%TYPE;
4602: l_global_attribute7 ra_customer_trx_lines_all.global_attribute7%TYPE;
4603: l_global_attribute8 ra_customer_trx_lines_all.global_attribute8%TYPE;

Line 4600: l_global_attribute5 ra_customer_trx_lines_all.global_attribute5%TYPE;

4596: l_global_attribute1 ra_customer_trx_lines_all.global_attribute1%TYPE;
4597: l_global_attribute2 ra_customer_trx_lines_all.global_attribute2%TYPE;
4598: l_global_attribute3 ra_customer_trx_lines_all.global_attribute3%TYPE;
4599: l_global_attribute4 ra_customer_trx_lines_all.global_attribute4%TYPE;
4600: l_global_attribute5 ra_customer_trx_lines_all.global_attribute5%TYPE;
4601: l_global_attribute6 ra_customer_trx_lines_all.global_attribute6%TYPE;
4602: l_global_attribute7 ra_customer_trx_lines_all.global_attribute7%TYPE;
4603: l_global_attribute8 ra_customer_trx_lines_all.global_attribute8%TYPE;
4604: l_global_attribute9 ra_customer_trx_lines_all.global_attribute9%TYPE;

Line 4601: l_global_attribute6 ra_customer_trx_lines_all.global_attribute6%TYPE;

4597: l_global_attribute2 ra_customer_trx_lines_all.global_attribute2%TYPE;
4598: l_global_attribute3 ra_customer_trx_lines_all.global_attribute3%TYPE;
4599: l_global_attribute4 ra_customer_trx_lines_all.global_attribute4%TYPE;
4600: l_global_attribute5 ra_customer_trx_lines_all.global_attribute5%TYPE;
4601: l_global_attribute6 ra_customer_trx_lines_all.global_attribute6%TYPE;
4602: l_global_attribute7 ra_customer_trx_lines_all.global_attribute7%TYPE;
4603: l_global_attribute8 ra_customer_trx_lines_all.global_attribute8%TYPE;
4604: l_global_attribute9 ra_customer_trx_lines_all.global_attribute9%TYPE;
4605: l_global_attribute10 ra_customer_trx_lines_all.global_attribute10%TYPE;

Line 4602: l_global_attribute7 ra_customer_trx_lines_all.global_attribute7%TYPE;

4598: l_global_attribute3 ra_customer_trx_lines_all.global_attribute3%TYPE;
4599: l_global_attribute4 ra_customer_trx_lines_all.global_attribute4%TYPE;
4600: l_global_attribute5 ra_customer_trx_lines_all.global_attribute5%TYPE;
4601: l_global_attribute6 ra_customer_trx_lines_all.global_attribute6%TYPE;
4602: l_global_attribute7 ra_customer_trx_lines_all.global_attribute7%TYPE;
4603: l_global_attribute8 ra_customer_trx_lines_all.global_attribute8%TYPE;
4604: l_global_attribute9 ra_customer_trx_lines_all.global_attribute9%TYPE;
4605: l_global_attribute10 ra_customer_trx_lines_all.global_attribute10%TYPE;
4606: l_global_attribute11 ra_customer_trx_lines_all.global_attribute11%TYPE;

Line 4603: l_global_attribute8 ra_customer_trx_lines_all.global_attribute8%TYPE;

4599: l_global_attribute4 ra_customer_trx_lines_all.global_attribute4%TYPE;
4600: l_global_attribute5 ra_customer_trx_lines_all.global_attribute5%TYPE;
4601: l_global_attribute6 ra_customer_trx_lines_all.global_attribute6%TYPE;
4602: l_global_attribute7 ra_customer_trx_lines_all.global_attribute7%TYPE;
4603: l_global_attribute8 ra_customer_trx_lines_all.global_attribute8%TYPE;
4604: l_global_attribute9 ra_customer_trx_lines_all.global_attribute9%TYPE;
4605: l_global_attribute10 ra_customer_trx_lines_all.global_attribute10%TYPE;
4606: l_global_attribute11 ra_customer_trx_lines_all.global_attribute11%TYPE;
4607: l_global_attribute12 ra_customer_trx_lines_all.global_attribute12%TYPE;

Line 4604: l_global_attribute9 ra_customer_trx_lines_all.global_attribute9%TYPE;

4600: l_global_attribute5 ra_customer_trx_lines_all.global_attribute5%TYPE;
4601: l_global_attribute6 ra_customer_trx_lines_all.global_attribute6%TYPE;
4602: l_global_attribute7 ra_customer_trx_lines_all.global_attribute7%TYPE;
4603: l_global_attribute8 ra_customer_trx_lines_all.global_attribute8%TYPE;
4604: l_global_attribute9 ra_customer_trx_lines_all.global_attribute9%TYPE;
4605: l_global_attribute10 ra_customer_trx_lines_all.global_attribute10%TYPE;
4606: l_global_attribute11 ra_customer_trx_lines_all.global_attribute11%TYPE;
4607: l_global_attribute12 ra_customer_trx_lines_all.global_attribute12%TYPE;
4608: l_global_attribute13 ra_customer_trx_lines_all.global_attribute13%TYPE;

Line 4605: l_global_attribute10 ra_customer_trx_lines_all.global_attribute10%TYPE;

4601: l_global_attribute6 ra_customer_trx_lines_all.global_attribute6%TYPE;
4602: l_global_attribute7 ra_customer_trx_lines_all.global_attribute7%TYPE;
4603: l_global_attribute8 ra_customer_trx_lines_all.global_attribute8%TYPE;
4604: l_global_attribute9 ra_customer_trx_lines_all.global_attribute9%TYPE;
4605: l_global_attribute10 ra_customer_trx_lines_all.global_attribute10%TYPE;
4606: l_global_attribute11 ra_customer_trx_lines_all.global_attribute11%TYPE;
4607: l_global_attribute12 ra_customer_trx_lines_all.global_attribute12%TYPE;
4608: l_global_attribute13 ra_customer_trx_lines_all.global_attribute13%TYPE;
4609: l_global_attribute14 ra_customer_trx_lines_all.global_attribute14%TYPE;

Line 4606: l_global_attribute11 ra_customer_trx_lines_all.global_attribute11%TYPE;

4602: l_global_attribute7 ra_customer_trx_lines_all.global_attribute7%TYPE;
4603: l_global_attribute8 ra_customer_trx_lines_all.global_attribute8%TYPE;
4604: l_global_attribute9 ra_customer_trx_lines_all.global_attribute9%TYPE;
4605: l_global_attribute10 ra_customer_trx_lines_all.global_attribute10%TYPE;
4606: l_global_attribute11 ra_customer_trx_lines_all.global_attribute11%TYPE;
4607: l_global_attribute12 ra_customer_trx_lines_all.global_attribute12%TYPE;
4608: l_global_attribute13 ra_customer_trx_lines_all.global_attribute13%TYPE;
4609: l_global_attribute14 ra_customer_trx_lines_all.global_attribute14%TYPE;
4610: l_global_attribute15 ra_customer_trx_lines_all.global_attribute15%TYPE;

Line 4607: l_global_attribute12 ra_customer_trx_lines_all.global_attribute12%TYPE;

4603: l_global_attribute8 ra_customer_trx_lines_all.global_attribute8%TYPE;
4604: l_global_attribute9 ra_customer_trx_lines_all.global_attribute9%TYPE;
4605: l_global_attribute10 ra_customer_trx_lines_all.global_attribute10%TYPE;
4606: l_global_attribute11 ra_customer_trx_lines_all.global_attribute11%TYPE;
4607: l_global_attribute12 ra_customer_trx_lines_all.global_attribute12%TYPE;
4608: l_global_attribute13 ra_customer_trx_lines_all.global_attribute13%TYPE;
4609: l_global_attribute14 ra_customer_trx_lines_all.global_attribute14%TYPE;
4610: l_global_attribute15 ra_customer_trx_lines_all.global_attribute15%TYPE;
4611: l_global_attribute16 ra_customer_trx_lines_all.global_attribute16%TYPE;

Line 4608: l_global_attribute13 ra_customer_trx_lines_all.global_attribute13%TYPE;

4604: l_global_attribute9 ra_customer_trx_lines_all.global_attribute9%TYPE;
4605: l_global_attribute10 ra_customer_trx_lines_all.global_attribute10%TYPE;
4606: l_global_attribute11 ra_customer_trx_lines_all.global_attribute11%TYPE;
4607: l_global_attribute12 ra_customer_trx_lines_all.global_attribute12%TYPE;
4608: l_global_attribute13 ra_customer_trx_lines_all.global_attribute13%TYPE;
4609: l_global_attribute14 ra_customer_trx_lines_all.global_attribute14%TYPE;
4610: l_global_attribute15 ra_customer_trx_lines_all.global_attribute15%TYPE;
4611: l_global_attribute16 ra_customer_trx_lines_all.global_attribute16%TYPE;
4612: l_global_attribute17 ra_customer_trx_lines_all.global_attribute17%TYPE;

Line 4609: l_global_attribute14 ra_customer_trx_lines_all.global_attribute14%TYPE;

4605: l_global_attribute10 ra_customer_trx_lines_all.global_attribute10%TYPE;
4606: l_global_attribute11 ra_customer_trx_lines_all.global_attribute11%TYPE;
4607: l_global_attribute12 ra_customer_trx_lines_all.global_attribute12%TYPE;
4608: l_global_attribute13 ra_customer_trx_lines_all.global_attribute13%TYPE;
4609: l_global_attribute14 ra_customer_trx_lines_all.global_attribute14%TYPE;
4610: l_global_attribute15 ra_customer_trx_lines_all.global_attribute15%TYPE;
4611: l_global_attribute16 ra_customer_trx_lines_all.global_attribute16%TYPE;
4612: l_global_attribute17 ra_customer_trx_lines_all.global_attribute17%TYPE;
4613: l_global_attribute18 ra_customer_trx_lines_all.global_attribute18%TYPE;

Line 4610: l_global_attribute15 ra_customer_trx_lines_all.global_attribute15%TYPE;

4606: l_global_attribute11 ra_customer_trx_lines_all.global_attribute11%TYPE;
4607: l_global_attribute12 ra_customer_trx_lines_all.global_attribute12%TYPE;
4608: l_global_attribute13 ra_customer_trx_lines_all.global_attribute13%TYPE;
4609: l_global_attribute14 ra_customer_trx_lines_all.global_attribute14%TYPE;
4610: l_global_attribute15 ra_customer_trx_lines_all.global_attribute15%TYPE;
4611: l_global_attribute16 ra_customer_trx_lines_all.global_attribute16%TYPE;
4612: l_global_attribute17 ra_customer_trx_lines_all.global_attribute17%TYPE;
4613: l_global_attribute18 ra_customer_trx_lines_all.global_attribute18%TYPE;
4614: l_global_attribute19 ra_customer_trx_lines_all.global_attribute19%TYPE;

Line 4611: l_global_attribute16 ra_customer_trx_lines_all.global_attribute16%TYPE;

4607: l_global_attribute12 ra_customer_trx_lines_all.global_attribute12%TYPE;
4608: l_global_attribute13 ra_customer_trx_lines_all.global_attribute13%TYPE;
4609: l_global_attribute14 ra_customer_trx_lines_all.global_attribute14%TYPE;
4610: l_global_attribute15 ra_customer_trx_lines_all.global_attribute15%TYPE;
4611: l_global_attribute16 ra_customer_trx_lines_all.global_attribute16%TYPE;
4612: l_global_attribute17 ra_customer_trx_lines_all.global_attribute17%TYPE;
4613: l_global_attribute18 ra_customer_trx_lines_all.global_attribute18%TYPE;
4614: l_global_attribute19 ra_customer_trx_lines_all.global_attribute19%TYPE;
4615: l_global_attribute20 ra_customer_trx_lines_all.global_attribute20%TYPE;

Line 4612: l_global_attribute17 ra_customer_trx_lines_all.global_attribute17%TYPE;

4608: l_global_attribute13 ra_customer_trx_lines_all.global_attribute13%TYPE;
4609: l_global_attribute14 ra_customer_trx_lines_all.global_attribute14%TYPE;
4610: l_global_attribute15 ra_customer_trx_lines_all.global_attribute15%TYPE;
4611: l_global_attribute16 ra_customer_trx_lines_all.global_attribute16%TYPE;
4612: l_global_attribute17 ra_customer_trx_lines_all.global_attribute17%TYPE;
4613: l_global_attribute18 ra_customer_trx_lines_all.global_attribute18%TYPE;
4614: l_global_attribute19 ra_customer_trx_lines_all.global_attribute19%TYPE;
4615: l_global_attribute20 ra_customer_trx_lines_all.global_attribute20%TYPE;
4616:

Line 4613: l_global_attribute18 ra_customer_trx_lines_all.global_attribute18%TYPE;

4609: l_global_attribute14 ra_customer_trx_lines_all.global_attribute14%TYPE;
4610: l_global_attribute15 ra_customer_trx_lines_all.global_attribute15%TYPE;
4611: l_global_attribute16 ra_customer_trx_lines_all.global_attribute16%TYPE;
4612: l_global_attribute17 ra_customer_trx_lines_all.global_attribute17%TYPE;
4613: l_global_attribute18 ra_customer_trx_lines_all.global_attribute18%TYPE;
4614: l_global_attribute19 ra_customer_trx_lines_all.global_attribute19%TYPE;
4615: l_global_attribute20 ra_customer_trx_lines_all.global_attribute20%TYPE;
4616:
4617: BEGIN

Line 4614: l_global_attribute19 ra_customer_trx_lines_all.global_attribute19%TYPE;

4610: l_global_attribute15 ra_customer_trx_lines_all.global_attribute15%TYPE;
4611: l_global_attribute16 ra_customer_trx_lines_all.global_attribute16%TYPE;
4612: l_global_attribute17 ra_customer_trx_lines_all.global_attribute17%TYPE;
4613: l_global_attribute18 ra_customer_trx_lines_all.global_attribute18%TYPE;
4614: l_global_attribute19 ra_customer_trx_lines_all.global_attribute19%TYPE;
4615: l_global_attribute20 ra_customer_trx_lines_all.global_attribute20%TYPE;
4616:
4617: BEGIN
4618:

Line 4615: l_global_attribute20 ra_customer_trx_lines_all.global_attribute20%TYPE;

4611: l_global_attribute16 ra_customer_trx_lines_all.global_attribute16%TYPE;
4612: l_global_attribute17 ra_customer_trx_lines_all.global_attribute17%TYPE;
4613: l_global_attribute18 ra_customer_trx_lines_all.global_attribute18%TYPE;
4614: l_global_attribute19 ra_customer_trx_lines_all.global_attribute19%TYPE;
4615: l_global_attribute20 ra_customer_trx_lines_all.global_attribute20%TYPE;
4616:
4617: BEGIN
4618:
4619: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4741: FROM ra_customer_trx_lines_all l

4737: l_global_attribute17,
4738: l_global_attribute18,
4739: l_global_attribute19,
4740: l_global_attribute20
4741: FROM ra_customer_trx_lines_all l
4742: WHERE l.customer_trx_line_id = p_ra_line_id;
4743:
4744: EXCEPTION
4745: WHEN no_data_found THEN