902: lv_param_value varchar2(4000);
903:
904: CURSOR l_oa_getlineparam_csr IS
905: select parameter_value
906: from XDP_ORDER_LINEITEM_DETS
907: where
908: line_item_id = p_line_item_id AND
909: line_parameter_name = p_line_param_name;
910: BEGIN
912: /***
913: --skilaru 03/28/2001
914: --modified to use CURSOR
915: select parameter_value into lv_param_value
916: from XDP_ORDER_LINEITEM_DETS
917: where
918: line_item_id = p_line_item_id AND
919: line_parameter_name = p_line_param_name;
920: ***/