43: * and implemented caching logic to get the values.
44: */
45: cursor c_fetch_shipment_line_info(p_shipment_line_id number) is
46: select destination_type_code from
47: rcv_shipment_lines
48: where shipment_line_id = p_shipment_line_id;
49:
50: v_destination_type_code rcv_shipment_lines.destination_type_code%type; --3655330
51:
46: select destination_type_code from
47: rcv_shipment_lines
48: where shipment_line_id = p_shipment_line_id;
49:
50: v_destination_type_code rcv_shipment_lines.destination_type_code%type; --3655330
51:
52: /* Bug 5243532. Added by Lakshmi Gopalsami
53: * Defined variable for implementing caching logic.
54: */