1752: BEGIN
1753:
1754: IF (p_SHIP_SET_ID is not null) THEN
1755: select set_name into l_set_name
1756: from oe_sets
1757: where set_id=p_SHIP_SET_ID;
1758:
1759: RETURN l_set_name;
1760:
1779: BEGIN
1780:
1781: IF (p_ARRIVAL_SET_ID is not null) THEN
1782: select set_name into l_set_name
1783: from oe_sets
1784: where set_id=p_ARRIVAL_SET_ID;
1785:
1786: RETURN l_set_name;
1787: