APPS.OE_HEADER_STATUS_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 28

SELECT cancelled_flag
INTO l_cancel_flag
FROM oe_order_headers_all
WHERE header_id = p_header_id;

Line: 77

     SELECT end_date
     INTO x_result_date
     FROM wf_item_activity_statuses wias, wf_process_activities wpa
     WHERE wias.item_type = OE_GLOBALS.G_WFI_HDR
     AND wias.item_key = to_char(p_header_id)
     AND wias.process_activity = wpa.instance_id
	AND wpa.activity_name = 'CLOSE_HEADER';

Line: 117

SELECT nvl(booked_flag, 'N')
INTO x_result
FROM oe_order_headers_all
WHERE header_id = p_header_id;

Line: 153

SELECT nvl(booked_flag, 'N'), booked_date
INTO x_result, x_result_date
FROM oe_order_headers_all
WHERE header_id = p_header_id;

Line: 189

SELECT nvl(open_flag, 'Y')
INTO l_open_flag
FROM oe_order_headers_all
WHERE header_id = p_header_id;

Line: 238

     SELECT end_date
     INTO x_result_date
     FROM wf_item_activity_statuses wias, wf_process_activities wpa
     WHERE wias.item_type = OE_GLOBALS.G_WFI_HDR
     AND wias.item_key = to_char(p_header_id)
     AND wias.process_activity = wpa.instance_id
     AND wpa.activity_name = 'CLOSE_HEADER';