88: IF p_inv_line_number IS NOT NULL THEN
89: BEGIN
90: SELECT customer_trx_line_id
91: INTO p_inv_customer_trx_line_id
92: FROM ra_customer_trx_lines
93: WHERE customer_trx_id = p_inv_customer_trx_id
94: AND line_number = p_inv_line_number
95: AND line_type = 'LINE';
96: EXCEPTION
105: IF p_inv_customer_trx_line_id IS NOT NULL THEN
106: BEGIN
107: SELECT customer_trx_id
108: INTO p_inv_customer_trx_id
109: FROM ra_customer_trx_lines
110: WHERE customer_trx_line_id = p_inv_customer_trx_line_id
111: AND line_type = 'LINE';
112: EXCEPTION
113: WHEN no_data_found THEN