169: x_entity_name VARCHAR2(40);
170: x_order_category VARCHAR2(30);
171: CURSOR c1 IS
172: SELECT order_category 173: FROM so_headers 174: WHERE header_id = p_header_id;
175: BEGIN
176:
177: -- Get order_category
Line 192: x_entity_name := 'SO_HEADERS';
188: ELSE
189: IF (p_line_id IS NOT NULL) THEN
190: x_entity_name := 'SO_LINES';
191: ELSE 192: x_entity_name := 'SO_HEADERS'; 193: END IF;
194: END IF;
195:
196: RETURN x_entity_name;