172: SELECT
173: USERENV('LANG')
174: INTO P_LANG
175: FROM
176: DUAL;
177: P_ORGANIZATION_ID := NVL(P_ORGANIZATION_ID
178: ,0);
179: IF (P_RETURN_LINE_TYPE IS NOT NULL) THEN
180: LP_RETURN_LINE_TYPE := 'and ltype.transaction_type_id = :p_return_line_type ';