The following lines contain the word 'select', 'insert', 'update' or 'delete':
p_insert_flag NUMBER,
p_partial_flag NUMBER,
p_err_message IN OUT NoCopy VARCHAR2)
RETURN NUMBER is
v_dummy NUMBER := 0;
mast_rec_insert mrp_atp_schedule_temp_typ;
' SELECT '||
' rowidtochar(rowid),'||
' sequence_number,'||
' firm_flag,'||
' order_line_number,'||
' option_number,'||
' shipment_number,'||
' item_desc,'||
' customer_name,'||
' customer_location,'||
' ship_set_name,'||
' arrival_set_name,'||
' old_line_schedule_date,'||
' old_source_organization_code,'||
' project_id,'||
' task_id,'||
' project_number,'||
' task_number '||
' FROM '||
' mrp_atp_schedule_temp'||l_dynstring||
' WHERE session_id = :x_session_id '||
' AND status_flag = 1';